2015年4月16日星期四

A quick overview of each of the PeopleSoft HRMS applications or modules

A quick overview of each of the PeopleSoft HRMS applications or modules

Following is a quick overview of each of the PeopleSoft HRMS applications or
modules available today:

Core HRMS The core PeopleSoft HRMS application, which includes
Manage Workforce, contains the basic functions to hire, transfer, promote,
and make job changes for an employee. This portion of the application contains the basic employee information, including history as well as
department, location, and job information. Concepts to support basic EEO,
affirmative action, labor relations, employment verifications, and basic HR
functions are contained in this module. With PeopleSoft 8, an additional
module, eProfile, allows employees themselves to update basic employee or
profile information.

Career Planning/Performance Management This functionality is
included as part of the core HRMS module. This area supports major
career planning processes such as competency planning, career management,
employee review processing, and succession planning. With People-
Soft 8, a new module, eDevelopment, is also available, providing manager
and employee features to help individuals manage their careers more
effectively over the Internet.
Recruiting This functionality is also included as part of the core HRMS
module. The recruiting function includes creation of job requisitions and job
search or skill search capabilities including applicant tracking, interviewing,
and hiring. This application integrates directly with the basic employee
information such that applicant data is transferred directly to employee
tables once an applicant is hired. A new module in PeopleSoft 8, eRecruit,
allows for full external recruiting capabilities enabled through Web
technology.

Position Management The Position Management functions support
budgeting and managing job positions within an organization. This functionality,
included in the core HRMS application, is typically used for governmental
or regulatory establishments that have a predefined budget and a set
of job positions that are authorized for employment. Companies that let each
manager determine job requirements, which are not tracked on a fixed job
basis, don’t implement this feature.

Training Administration The Training Administration module is also
included in the core HRMS product. Within this area, training programs
can be set up and sessions scheduled to enroll and track employee training.
Information on each course and session can be tracked, including instructors
and class requirements. Waiting-list features are included.
Pension Administration Pension Administration is a fairly new application
that provides the capability to track and manage pension deductions
and allocations, which are then passed to the plan provider. This module is
only U.S.-based at this time and doesn’t support pension requirements globally. It isn’t included as a part of the core HRMS product and must be
purchased separately.

Benefits Administration and Base Benefits Two types
of benefits processing are available with PeopleSoft. Base Benefits processing,
which is included in the core HRMS application, provides for the basic tracking
of benefit plans and links each plan to a payroll deduction. However, any
changes to the plan or enrollment processing is done manually. Benefits
Administration allows you to automate the benefits enrollment and change
process. This module is an add-on to the core package. With PeopleSoft 8,
a new module called eBenefits supports key employee self-service features,
allowing employees to enroll in their benefit plans and make changes to them.
It’s available at an additional price.

Salary Planning This function is included in the core HRMS application.
It features the ability to create salary plans, develop salary-increase
budgets by department, and process salary changes. Standard salary matrices
and review-rating distributions can be accomplished by leveraging this
functionality.

Variable/Total Compensation The features of this capability are part
of the core HRMS application. This module allows you to create variable
compensation plans and administer them to your staff using eligibility
criteria calculation methods, and provides specific payout options for your
employees (such as a special bonus check, an incentive payment, or a salary
increase). Incentive goals, both group and individual, can be set up as well.
A manager’s self-service module, eCompensation, is provided with People-
Soft 8; it allows managers to perform key compensation planning functions,
leveraging the Internet.

Payroll for North America This major application area for the U.S. and
Canada includes the processes that support the payroll and pay the employees,
including the processing of specific earnings and deductions as well as both
on- and off-cycle payrolls. In addition to these features, PeopleSoft 8, with
its new ePay module, allows paycheck presentation and electronic stub
review via the Internet.

Payroll Interface This feature includes processing to support the
calculations of benefits and deductions, which can be passed to a third-party
vendor for payroll purposes. It includes an interface generator that can create specific files that can integrate with payroll outsourcing vendors such
as ADP (Automatic Data Processing, Inc.).

Time and Labor The Time and Labor application has improved over the
past few PeopleSoft releases and now supports online (even Web-enabled)
time collection, including maintenance of schedules and pay or time rules
and retroactive processing. This application interfaces closely with the
Payroll module and passes “buckets” of time and expenses by pay period to
the pay sheets (found in the Payroll module) used to create the employee
paychecks. Another module, Time and Attendance, is also available but only
with the Asia/Pacific local version. In addition to this core functionality,
PeopleSoft 8 also includes a Web-based, employee self-service module
called eTime.

Stock Administration This is one of PeopleSoft’s newest HRMS modules.
It supports the tracking of employee stock programs and distributions,
including stock purchase plans, restricted stock payments, and stock options.

FSA Administration This module creates and tracks flexible spending
accounts (FSAs) for employees, including tracking deductions, contributions,
and reimbursements. Most companies outsource this service and therefore
do not need this module. The FSA deduction can be created and tracked
within the Payroll module without the use of this additional module.

Global Payroll This module is new with PeopleSoft 8 and provides a
global payroll engine that supports payroll processes for four countries
initially: the U.K., France, Germany, and Switzerland. Payroll for North
America is still available as well to support the requirements of the U.S.
and Canada.

In addition to those modules, there are specific modules that support the student
administration functions of an academic institution. This application,
called Student Administration, includes functionality that supports academic
advising, admissions, student records, advancement, financial aid, and student
financials.

Also, with the release of PeopleSoft 8, the Federal/Public Sector HR and
Benefits functionality is incorporated into the core HRMS application.

2015年4月15日星期三

Peoplesoft Technical Interview Questions and Answers

Peoplesoft Technical Interview Questions and Answers
Posted Under Peoplesoft-Interview-Questions

Interview questions on peoplesoft.

1. Explain briefly about record properties?
KEY: the record knows a field, which uniquely identifies each row, as a key.
1. According, to the key field, we will search and retrieve data from the database.
2. This will not allow duplicate and not null values.
3. It is a primary key
4. It allows multiple keys
5. Maximum keys allowed in a record is 15
6. It should be placed at the top of the record definition.

Duplicate Order Key:

1. It provides a way of ordering data in the table when the duplicate values are allowed.
2. It will create index for the column. However the index can be disabled.

Alternate Search key:

1. It identifies the field as a key that provides an alternative path into table data.
2. Due to alternate search key the system becomes slow, because database index will be created when SQL creates the tables, so it will consume the disk space.
3. It allows duplicate values.
4. Alternate search will be seen in the search dialog box when update/display mode is selected.

Descending order key:
It is used to retrieve data in the form of 3-2-1 or C-B-A and normally it is
used in Effective date.

2. What is ordering key?
The following way we have to arrange the fields
1. Field with primary key and search box.
2. Field with primary key
3. Field with duplicate order key.

3. Define Scroll? How many types of scrolls are there?
A Scroll is used to enter multiple rows and retrieve multiple row data. There are two types of scrolls:

1. Nested scrolls – For each repeating data and for each entry with other set of repeating set of data is called a nested scroll. Maximum 3 nested levels are allowed. The nested scrolls share same high-level keys.
2. Independent scrolls – At each scroll level a maximum of 15 screen be included.

4. Define Occurs Level?
Occurs level specifies the level of a scroll bar relative to any other scroll bars on a panel. The following are the occurs level at each nested scroll bar.
The primary scroll bar in a set of nested scroll bars has an occur level 1 A Secondary scroll bar has an occurs level of 2, which means it is subordinate to scroll bar 1.The third scroll bar has an occurs level of 3, which means it is subordinate to scroll bar 2.

5. What are the types of controls that can be placed on the panel?
There are three types of controls:
1. Aesthetic Control: It is used to organize the information on the panel and it is not associated with the database. There are 4 types of aesthetic contents. A) Text B)Frame C) Group box D) Static image.
2. Data entry control: It is used to offer different way to enter and maintain the information. There are 7 types of Data entry controls. A) Edit box B) Drop down list box C) Long edit box D) Check box E) Radio button F) Sub-panel image.
3. Function and data processing control: It adds command and maintains level of information on the command. There are 6 types of data processing controls
A) Command push button B) Process push button C) Secondary panel D)Scroll bar E) Grid control F) Tree.

6.Define Sub-panel and Secondary panel?
Sub-panel : It is a predefined, preside group control, which will appear in more than one panel. (Utility: if you have group of controls, such as address coasts, which you use on multiple panel definition, you can save those panel control groups on sub- panel)
Secondary Panel: An invisible control that associates a secondary panel with a primary panel. (Utility: Secondary panels are used to gather or display supplemental information related to the object that appears in a primary panel)

7. Explain about display control field and related display control field?
Display control field: It is controlling the field in some other record.
Related control field: display control field controls it.

8. What is panel group? Explain in brief about panel group?
Panel group is the bridge between panel and menu. A panel group is a set of panels
That should be processed as if it is one panel. The panel group represents a complete business transaction because all the Information goes together. The group must be stored in the database as a single Unit of work. At runtime, we are opening and saving panel group not individual Panels.

9.Define a Menu? How many types of Menus exist?
Menus are used to navigate the application (Menu is a window to the application)
There are two types of menus:

1. Standard menu: It appears in the menu bar of a Peoplesoft application.
2. Popup menu: Allows the user to navigate related information in other areas of application by right clicking on a panel or panel control.

39. How many types of securities are available in People soft?
There are 6 types of securities:
1. RDBMS Security 2. Network security 3.Operator security 4. Object security 5.Tree level security 6. Query security (row level security)

Peoplesoft Generic Interview Questions and Answers

Peoplesoft Generic Interview Questions and Answers
Posted Under Peoplesoft-Interview-Questions

Peoplesoft Interview Questions and Answers listed below.
1. What is an ERP?
It is a process of integrated flow of Information, which binds on the organization together.

2. What is an ERP system?
It is an integrated application software module providing operational, managerial and strategic Information for improving productivity, quality and quantity to improve competence.

3. Describe the Life Cycle of a Project (ERP Implementation)?
The Project passes through the following stages.
1. Analysis
2. Designing
3. Coding
4. Testing
5. Implementation
6. Maintenance.

4. Define People Tools?
A Collection of software programs, utility scripts and (reports, messages, Cobol SQL statements, database tables and data that provide the frame work for creating, using and modifying people soft applications. People tools provide built in business functionally and maintains the capability that directly increase productivity and simplify system design.

5. What does Application Designer mean?
It is an integrated development environment that is used to develop People soft applications.

6. Functionality of Application Designer?
The following are the uses of Application Designer.
1. Design and create database tables.
2. Design on-line panels
3. Controlling on-line processing flow.
4. Create application windows and menus
5. Providing security for the database.

7. Difference between Two-tier and Three-tier architecture?
Incase of three-tier architecture an application server is connected between the database server (Back end) and the client (front end).
Incase of two-tier architecture the server is directly connected to the client.

8. Advantages of three-tier architecture?
The advantages of three-tier configuration are…
1. Reduce the LAN traffic.
2. Built-in functionality
3. Increase the productivity.
4. No SQL at the client level.
5. Improved performance over WAN.
6. Increased Scalability. (regardless of the number of users connected you can maintain constant performance level)

9. What is a project?
User defined collection of related definitions (fields, records, panels, panelgroups and menus).

10. What are the steps for building an application?
The following are the steps to create application designer.
1. Defining an application.
2. Create field definition.
3. Create Record definition using the fields.
4. Create SQL table.
5. Create Panel.
6. Add panel to the panel group.
7. Add panel group to the Menu.
8. Authorize operators to access Pan.
9. Test.

Peoplesoft Component Interface Interview Questions and Answers

Peoplesoft Interview Questions - Component Interface Builder

1) What are the main elements in the component Interface ?
Main elements of component Interface
? Component interface name
? Keys
? Properties and collections
? Methods

2) Difference between Get keys, find keys and Create Keys ?
Get keys: - These are mapped to the fields marked as scrh in the component’s search record. Automatically “Search key” fields in search record become Get keys.
We cannot change it.

Find keys: - These are mapped to fields marked as Alt or Srch in the component search record. You may remove Find keys that you do not wish to make available for searching.
Create Keys: - It is generated from the key fields for the search record. If Add search record is present then its key fields are taken. We cannot change it.

3) How do you provide security for the component interface?
? Open the Permission list
? On the Component Interface tab
? Add row and select the newly created Component Interface
? Edit the permissions to give permission for the standard methods
? Get, Create, Save, cancel, find.

4) What the steps that you need to do in people code to invoke Component Interface?
? Establish a user section
? Get the component interface definition
? Populate the create keys
? Create an instance of the component interface
? Populate the required fields
? Save the component Interface.

&Session = GetSession();
&CI = &Session.GetcompIntfc(CompIntfc.INTERFACE_NAME)
&CI.KEY_FILED_NAME = ‘NEW’
If not &CI.Create () Then

Else
Populate other fields
End-if;

Populate the other fields

If not &CI.Save () Then
Else
End-if;

5) How do you test Component Interface?
? Using the Component Interface tester
? Give values in the tester for options
? Get Existing, Create new, Find and perform the operation from the CI Tester

6) Catching error message in the component Interface? Or
Use of PSMessages in the CI ?
This function needs to be called when ever methods like Find, Save, Create methods return false.
Error text and Error type can be printed in the log message for any other action in to the log messge.

Function CheckErrorCodes()

&PSMessages = &Session.PSMessages;
&ErrorCount = &PSMessages.Count;
For &i = 1 To &ErrorCount
&ErrorText = &PSMessages.Item(&i).Text;
&ErrorType = &PSMessages.Item(&i).Type;
End-For;

End-Function;

7) What is method? What are the different types of method?
Methods: - A method is an object that performs a very specific function on a component interface at run-time.
Standard methods and user-defined methods.
Standard methods: - Automatically generated upon the creation of a new component Interface in Application.
Apart from the Standard methods there are Standard methods available for the use with any collection.
User-Defined methods: - User-defined methods are those that you can create to meet the requirements of an individual component interface.

8) What are properties?
The Fields in the level 0 in the component are the properties of the component.

Standard properties User-Defined properties
Createkeyinfocollection Developer can further control the exposed Getkeyinfocollection field properties.
Findkeyinfocollection
Property Info collection
GetHistoryItems (Update/Display mode or Correction mode)
EditHistory Items
InteractiveMode.

9) Traversing the Collections in the Component Interface?
COLL_JOB – Collection
Coll_JOBItm – Row in the collection.
&COLL_JOBCol = &CI_JOB_DATA.COLL_JOB;
For &i = 1 to &COLL_JOBCol.Count
&COLL_JOBItm = &COLL_JOBCol.Item (&i);
&COLL_JOB_JRCol = &COLL_JOBItm.COLL_JOB_JR;
For &J = 1 to &COLL_JOB_JRCol.Count
&COLL_JOB_JRItm = &COLL_JOB_JRCol.Item (&j);
&COLL_JOB_JRItm.KEYPROP_EFFDT =;

10) How do you login in correction mode in the Component Interface?
Get History Items and Edit History items property to should be set to true.
Get History Items alone: - Update display all - modes will be used.

IBM Realtime Interview Questions on Peoplesoft

IBM Realtime Interview Questions on Peoplesoft

1. Advantages of People Code?

2. Why SQR is used and advantages of SQR?

3. How are you running your HRMS systems either by JOBCODE or by POSITION_NBR?

4. What is the challenging and complicated People code you have written?
Why do you think it is complicated?

5. What is the challenging and complicated SQR you have written why do you think it is complicated?

6. Steps involved in Data Conversion?

Extract data from the legacy system
Reconcile the extracted data
Identify the tables to be leaded with the new system
Data Mapping
Identify the tools (SQR or Import Manager or SQL Loader etc)
Write programs to perform conversion
Test the programs using test data
Check the data outline
Reconcile concerted data.

7. Why SQR is used?

Data conversion
Reports
Interface programs.

8. SQR Runtime flags?

9. Import SQC files?

10. How do you link SQR reports to process scheduler?

Create/modify/add run control table if you have any new fields
Create/modify/add run control panel if you have any program inputs
Create a menu definition (Note Menu group name: XYZ)
Give operator security
Create Process scheduler definition
Use-Process definition – process definition add
Give report name and report type
Give menu group name (XYZ)

11. How do you create operator classes / users?

12. What are variable types in SQR?

& Data base reference fields – Read only
$ Character (Same for Date)
# Numeric
{ } Variable in ASK or # define
[$ variable] Dynamic variable referencing

13. How do you format in PRINT (9,X, B, etc)?

14. How many types of display views are there in Data Designer?

15. What is a record definition?

16. What are the types of record definitions?

SQL Tables
SQL views
Dynamic views
Derived / Work Records
Sub Records
Query views

17. What is an Application Processor?

18. Types of People code?

Search
Field
Row
Save
Workflow

19. Field Edit Vs Field change?

20. Save edit Vs save pre change Vs save post change?

21. Scroll select Vs scroll select new?

22. SQL EXEC Vs Scroll select?

23. Scroll select Vs Row Scroll select?

24. Row scroll select Vs Row scroll select new?

25. Table loading Sequence (installation)?

Company table
Installation
Location
Department
Salary Plan
Salary step
Job code
Pay group
Benefit Programs

26. What are FUNCLIB* records?

PeopleSoft Admin Interview Questions

PeopleSoft Admin Interview Questions

Overview:PeopleSoft Administration Interview Questions covering important topics like Application Designer,Data Mover,Application Server/Process Scheduler,PeopleSoft Admin Interview Questions

How do you configure Report Repository?

What kind of tuning have you done? Explain.

Customization done in Dev DB, Which tool is used to move it to Prod DB?

What is the difference in logging into App Designer in 2-tier and 3-tier mode?

How do you compare two projects?

How do you clear App Designer cache?

How do you check whether you have logged into 2-tier or 3-tier?

When logging in “Invalid AccessID and password for signon” pops up. What is the issue?

What are the different modes you can login into Data Mover?

How do you login into BS mode?

Where does authentication take place in 2-Tier and 3-Tier modes?

What utility is used to Configure Application Server and Process Scheduler?

Where do you set Peoplecode trace? - Configuration Manager and application server

Where do one see the status of the process requested to be executed - Process monitor

Where is PeopleTools data is cached – App Server

How do you restart a Data Mover script?

How do you create a DMS using Data Mover?

What SQL statements are not valid in Data Mover?

Where is the App Server Configuration parameters defined?

Where do you define failover for clustering?

What are the file transfer modes supported by PeopleSoft?

Where do you check the status of processes/jobs run from PIA?

How do you start PIA configured for WebLogic?

What servers are needed for configuring PIA?

2015年4月13日星期一

How to close the Connection & Sys Info function

PeopleSoft provides a hotkey option (CTRL+J) to enable users and system administrators to view such system information for orientation and troubleshooting purposes. But the information displayed may not be suitable for end users. How to turned it off? You can navigate to PeopleTools > Web Profile > Web Profile Configuration, go to page Debugging, uncheck the  


Change Xlate Value Online

Change Xlate Value Online

Usually we are create/update the Xlate Field in Application Designer, but you can also create/update it online. To maintain translate values Navigate to PeopleTools > Utilities > Administration > Translate Values



Using Attachment Functions

Using Attachment Functions
https://psbooks.mycmsc.com/PSOL/hr90_849/eng/psbooks/tpcd/chapter.htm?File=tpcd/htm/tpcd11.htm%23H4015

To use the attachment functions:

Insert the subrecord FILE_ATTACH_SBR into a record used with your page.

Typically, this record is inserted as part of the primary database record.

To store the file in the database, insert the subrecord FILE_ATTDET_SBR into a record used with your page.

This record can be called anything, but it must have the FILE_ATTDET_SBR subrecord included in it, and have no additional fields in it. This is the record that you point to with the URL when specifying storing a file in a database table.

Add buttons to add, delete, and view attachments as needed.

You can either use the FILE_ATTACH_WRK record for the necessary record fields, or you can use your own work fields.

Set up the URL.

If you're using the FTP archive, suppose the system is fileserver.ps.com, the user account is joe, and the password is secret. The full URL is: ftp://joe:secret@fileserver.ps.com/.

You can either create an entry for this URL in the URL Maintenance page, or specify it in your PeopleCode.

If you specify the URL in your PeopleCode, you don't have to hard-code the username and password. You can dereference them using a variable or record field. This enables you to use encryption with the username and password.

If you're copying to a database table, you can either create an entry for this record (URL) in the URL Maintenance page, or specify it in your PeopleCode, as follows:

record://RESUMES_DB
Modify the PeopleCode to support your application.

If you use the supplied PeopleCode programs, you must specify the URL. You may also want to modify the extension of the expected files (the default is "", which is any file, or *.* You may want to indicate ".doc", ".xl", "*.html", "*.exe", and "*.tar".). Read the comments in ATTACHADD FieldChange program for instructions.

To use the FILE_ATTACH_WRK record for buttons, you may want to use component PeopleCode for your application-specific code. This enables you to keep the code in FILE_ATTACH_WRK generic. If you use your own work fields, you can write your own code and call the functions in FILE_ATTACH_WRK as needed.

See URL Maintenance.

Coding Considerations Using the Attachment Functions

All file attachments are performed using PeopleCode built-in functions, such as AddAttachment, ViewAttachment, GetAttachment, and so on. These functions move a file into and out of a file storage system, either the database or a file system. The file system movement is done using the FTP protocol.

Because these functions abstract the storage of the attachments, you can use either database or FTP file systems. The system to be used is determined by the URL passed as the first parameter in the attachment built-in function. The actual value of the URL is maintained on the URL Maintenance page. This means that the you don't know whether users will store attachments in a database or a file system.

The following PeopleCode functions are used with administration work:

DeleteAttachment deletes unwanted attachments.

There is no roll-back ability. For example, suppose a user selects to view an attachment, then cancels before the attachment is displayed. A copy of the attachment may still be in the user's temp directory.

CopyAttachments moves all of the attachments specified from one file storage system (database or FTP) to another (database or FTP).

CleanAttachments is an audit-like script that removes attachments that exist in the database that are not referenced by any record field.

If you only have a few files to copy using CopyAttachments, you may want to use the CopyFiles page (part of the PeopleTools Administration pages). The CleanAttachments function is also available from this page.

To schedule a regular job to clean up orphaned file attachments, you can use the Application Engine program CLEANATT84.

Store all references to attachments using the standard ATTACHSYSFILENAME field. Do not reuse this field to store incomplete or nonstandard versions of the name. For example, you should not store the full URL version of the attachment in this column and then use PeopleCode to parse the URL before invoking attachment commands. While this may work for get or put attachment calls, the Clean Attachments function deletes any file stored in a table that does not have a corresponding reference stored in ATTACHSYSFILENAME.

Copying Files Using the File Attachment Functions

The CopyAttachments function is used for moving a group of attachments from one archive to another, such as when you want to move files from one FTP server to another, or if you want to move all the files in a database record out onto an FTP server. It does not create new system file links.

If you want to create a new file attachment by making a copy of an existing file attachment (both the system file link and the file itself, ) do the following:

Use GetAttachmentto retrieve the file from the repository (either from the FTP server or from a database record) and place it on your application server (or process scheduler system if you are using PeopleSoft Application Engine.)

Use PutAttachment to move the file from the application server (or process scheduler system) and place it into the new archive location.

Save the new system file link that you passed as a parameter to PutAttachment so that you can subsequently use it. This is generally part of the page transaction when you save the record that has the FILE_ATTACH_SBR subrecord in it.

How to get the process/program run page path from PeopleSoft

How to get the process/program run page path from PeopleSoft

In PeopleSoft, the SQR, Application Engine are designed to run based a component. Then when we run the programs we need to know the component/page path first. But how to get the path? For a quick steps, you can create a view of fields prcsname, prcstype, pnlgrpname, descr, navigation, portal_descr254 based the following SQL. So you can get the program path easily from the view every time.

SELECT DP.PRCSNAME,
       DP.PRCSTYPE,
       DP.PNLGRPNAME,
       P.DESCR,
       lvl0.PORTAL_LABEL ||
       DECODE(NVL(lvl1.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_LABEL ||
       DECODE(NVL(lvl2.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_LABEL ||
       DECODE(NVL(lvl3.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_LABEL ||
       DECODE(NVL(lvl4.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_LABEL "Navigation",
       lvl0.PORTAL_OBJNAME ||
       DECODE(NVL(lvl1.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_OBJNAME ||
       DECODE(NVL(lvl2.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_OBJNAME ||
       DECODE(NVL(lvl3.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_OBJNAME ||
       DECODE(NVL(lvl4.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_OBJNAME "Navigate_Component"
  FROM PSPRSMDEFN     lvl0,
       PSPRSMDEFN     lvl1,
       PSPRSMDEFN     lvl2,
       PSPRSMDEFN     lvl3,
       PSPRSMDEFN     lvl4,
       PS_PRCSDEFN    P,
       PS_PRCSDEFNPNL DP
 WHERE lvl0.PORTAL_NAME = 'EMPLOYEE'
   AND lvl0.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'
   AND lvl1.PORTAL_NAME = lvl0.PORTAL_NAME    /* e.g. 'EMPLOYEE' */
   AND lvl2.PORTAL_NAME(+) = lvl1.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl3.PORTAL_NAME(+) = lvl2.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl4.PORTAL_NAME(+) = lvl3.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl1.PORTAL_PRNTOBJNAME = lvl0.PORTAL_OBJNAME
   AND lvl2.PORTAL_PRNTOBJNAME(+) = lvl1.PORTAL_OBJNAME
   AND lvl3.PORTAL_PRNTOBJNAME(+) = lvl2.PORTAL_OBJNAME
   AND lvl4.PORTAL_PRNTOBJNAME(+) = lvl3.PORTAL_OBJNAME
   AND (lvl0.PORTAL_SEQ_NUM < 1000    /* 1000 Employee Self-Service */
       OR lvl0.PORTAL_SEQ_NUM = 9110  /* 9110 Set Up Financials/Supply Chain */
       OR lvl0.PORTAL_SEQ_NUM = 9955) /* 9955 PeopleTools */ /* User folder + "Set Up Financials/Supply Chain" */
   AND P.PRCSNAME = DP.PRCSNAME
   AND DP.PNLGRPNAME IN (lvl4.PORTAL_URI_SEG2,
                         lvl3.PORTAL_URI_SEG2,
                         lvl2.PORTAL_URI_SEG2,
                         lvl1.PORTAL_URI_SEG2)
UNION /* JOBS */
SELECT DJ.PRCSJOBNAME,
       J.PRCSTYPE,
       DJ.PNLGRPNAME,
       J.DESCR,
       lvl0.PORTAL_LABEL ||
       DECODE(NVL(lvl1.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_LABEL ||
       DECODE(NVL(lvl2.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_LABEL ||
       DECODE(NVL(lvl3.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_LABEL ||
       DECODE(NVL(lvl4.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_LABEL "Navigation",
       lvl0.PORTAL_OBJNAME ||
       DECODE(NVL(lvl1.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_OBJNAME ||
       DECODE(NVL(lvl2.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_OBJNAME ||
       DECODE(NVL(lvl3.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_OBJNAME ||
       DECODE(NVL(lvl4.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_OBJNAME "Navigate_Component"
  FROM PSPRSMDEFN     lvl0,
       PSPRSMDEFN     lvl1,
       PSPRSMDEFN     lvl2,
       PSPRSMDEFN     lvl3,
       PSPRSMDEFN     lvl4,
       PS_PRCSJOBDEFN J,
       PS_PRCSJOBPNL  DJ
 WHERE lvl0.PORTAL_NAME = 'EMPLOYEE'
   AND lvl0.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'
   AND lvl1.PORTAL_NAME = lvl0.PORTAL_NAME    /* e.g. 'EMPLOYEE' */
   AND lvl2.PORTAL_NAME(+) = lvl1.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl3.PORTAL_NAME(+) = lvl2.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl4.PORTAL_NAME(+) = lvl3.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl1.PORTAL_PRNTOBJNAME = lvl0.PORTAL_OBJNAME
   AND lvl2.PORTAL_PRNTOBJNAME(+) = lvl1.PORTAL_OBJNAME
   AND lvl3.PORTAL_PRNTOBJNAME(+) = lvl2.PORTAL_OBJNAME
   AND lvl4.PORTAL_PRNTOBJNAME(+) = lvl3.PORTAL_OBJNAME
   AND (lvl0.PORTAL_SEQ_NUM < 1000    /* 1000 Employee Self-Service */
       OR lvl0.PORTAL_SEQ_NUM = 9110  /* 9110 Set Up Financials/Supply Chain */
       OR lvl0.PORTAL_SEQ_NUM = 9955) /* 9955 PeopleTools */ /* User folder + "Set Up Financials/Supply Chain" */
   AND J.PRCSJOBNAME = DJ.PRCSJOBNAME
   AND DJ.PNLGRPNAME IN (lvl4.PORTAL_URI_SEG2,
                         lvl3.PORTAL_URI_SEG2,
                         lvl2.PORTAL_URI_SEG2,
                         lvl1.PORTAL_URI_SEG2)
 ORDER BY 1 /* ORDER BY DP.PRCSNAME, lvl0.PORTAL_SEQ_NUM, lvl0.PORTAL_OBJNAME , lvl1.PORTAL_SEQ_NUM, lvl1.PORTAL_OBJNAME , lvl2.PORTAL_SEQ_NUM, lvl2.PORTAL_OBJNAME , lvl3.PORTAL_SEQ_NUM, lvl3.PORTAL_OBJNAME , lvl4.PORTAL_SEQ_NUM, lvl4.PORTAL_OBJNAME*/

How to get the Xlate value


How to get the xlate value.

SELECT FIELDNAME, FIELDVALUE || ' - ' || XLATSHORTNAME, XLATLONGNAME
  FROM PSXLATITEM
 WHERE FIELDNAME = 'XLATEFIELD'
 ORDER BY FIELDNAME, FIELDVALUE;

2015年4月12日星期日

Oprid to page security

Oprid to page security

select rolluser.oprid oprid,
       rolluser.rolename rolename,
       roledefn.roletype roletype,
       roledefn.descr roledes,
       roledefn.rolestatus rolestatus,
       rlclass.classid permissionlist,
       classdefn.classdefndesc listdesc,
       menudefn.menuname menuname,
       menudefn.menulabel menulabel,
       menudefn.descr descr,
       m_c_p.pnlgrpname component,
       component.pnlname page,
       component.itemlabel pagename
  from psroleuser_vw rolluser,
       psroledefn    roledefn,
       psroleclass   rlclass,
       psclassdefn   classdefn,
       ps_psaclmenu_vw2 clmenu,
       psmenudefn menudefn,
       ps_aclcomponent_v2 m_c_p,
       pspnlgroup component
 where rolluser.rolename = roledefn.rolename
   and rolluser.rolename = rlclass.rolename
   and rlclass.classid = classdefn.classid
   and clmenu.classid = rlclass.classid
   and clmenu.menuname = menudefn.menuname
   and component.pnlgrpname = m_c_p.pnlgrpname
   and oprid = 'OPRID'
   and classdefn.classid = 'PERMISSIONLIST'

PeopleCode Examples for Traversing Level 0 to Level 3

PeopleCode Examples for Traversing Level 0 to Level 3
0Publish On June 2, 2013 In PeopleCode
Here is the Example Code , Please do modifications based on your requirements.

/*** Demo Code For Traversing Level 0 to Level 3 ***/

Local Rowset &rsLevel0, &rsLevel1, &rsLevel2, &rsLevel3;
Local Row &rowLevel0, &rowLevel1, &rowLevel2, &rowLevel3;
Local Field &fldLevel0, &fldLevel1, &fldLevel2, &fldLevel3;
Local integer &i, &j, &k;

&rsLevel0 = GetLevel0();

/** Get Level 0 Field **/
&fldLevel0 = &rsLevel0.GetRow(1).GetRecord(Record.L0_REC).GetField(Field.L0_FLD);
/** Get Level 0 Field Value **/
&Level0FldValue = &fldLevel0.Value;

&rowLevel0 = &rsLevel0.GetRow(1);
&rsLevel1 = &rowLevel0.GetRowset(Scroll.LEVEL1_RECORD);
For &i = 1 To &rsLevel1.ActiveRowCount

   /** Get Level 1 Field **/
   &fldLevel1 = &rsLevel1.GetRow(&i).GetRecord(Record.L1_REC).GetField(Field.L1_FLD);
   /** Get Level 1 Field Value **/
   &Level1FldValue = &fldLevel1.Value;

   &rowLevel1 = &rsLevel1.GetRow(&i);
   &rsLevel2 = &rowLevel1.GetRowset(Scroll.LEVEL2_RECORD);
   For &j = 1 To &rsLevel2.ActiveRowCount

      /** Get Level 2 Field **/
      &fldLevel2 = &rsLevel2.GetRow(&j).GetRecord(Record.L2_REC).GetField(Field.L2_FLD);
      /** Get Level 2 Field Value **/
      &Level2FldValue = &fldLevel2.Value;

      &rowLevel2 = &rsLevel2.GetRow(&j);
      &rsLevel3 = &rowLevel2.GetRowset(Scroll.LEVEL3_RECORD);
      For &k = 1 To &rs_level3.ActiveRowCount

         /** Get Level 3 Field **/
         &fldLevel3 = &rsLevel3.GetRow(&k).GetRecord(Record.L3_REC).GetField(Field.L3_FLD);
         /** Get Level 3 Field Value **/
         &Level3FldValue = &fldLevel3.Value;
         &rowLevel3 = &rsLevel3.GetRow(&k);

         /* Do Processing  **/
         /* If Any Summation Calculation */
         /* &sum = &sum + &Level3FldValue */

      End-For;
   End-For;
End-For;

ASCII编码-控制字符

ASCII编码-控制字符
ASCII编码 控制字符(ASCII control characters)
二进制
十进制
十六进制
控制字符
转义字符
说明
000 0000
0
00
NUL
\0
Null character(空字符)
000 0001
1
01
SOH

Start of Header(标题开始)
000 0010
2
02
STX

Start of Text(正文开始)
000 0011
3
03
ETX

End of Text(正文结束)
000 0100
4
04
EOT

End of Transmission(传输结束)
000 0101
5
05
ENQ

Enquiry(请求)
000 0110
6
06
ACK

Acknowledgment(收到通知)
000 0111
7
07
BEL
\a
Bell(响铃)
000 1000
8
08
BS
\b
Backspace(退格)
000 1001
9
09
HT
\t
Horizontal Tab(水平制表符)
000 1010
10
0A
LF
\n
Line feed(换行键)
000 1011
11
0B
VT
\v
Vertical Tab(垂直制表符)
000 1100
12
0C
FF
\f
Form feed(换页键)
000 1101
13
0D
CR
\r
Carriage return(回车键)
000 1110
14
0E
SO

Shift Out(不用切换)
000 1111
15
0F
SI

Shift In(启用切换)
001 0000
16
10
DLE

Data Link Escape(数据链路转义)
001 0001
17
11
DC1

Device Control 1(设备控制1)
001 0010
18
12
DC2

Device Control 2(设备控制2)
001 0011
19
13
DC3

Device Control 3(设备控制3)
001 0100
20
14
DC4

Device Control 4(设备控制4)
001 0101
21
15
NAK

Negative Acknowledgement(拒绝接收)
001 0110
22
16
SYN

Synchronous Idle(同步空闲)
001 0111
23
17
ETB

End of Trans the Block(传输块结束)
001 1000
24
18
CAN

Cancel(取消)
001 1001
25
19
EM

End of Medium(介质中断)
001 1010
26
1A
SUB

Substitute(替补)
001 1011
27
1B
ESC
\e
Escape(溢出)
001 1100
28
1C
FS

File Separator(文件分割符)
001 1101
29
1D
GS

Group Separator(分组符)
001 1110
30
1E
RS

Record Separator(记录分离符)
001 1111
31
1F
US

Unit Separator(单元分隔符)
ASCII编码-可打印字符
ASCII编码 可打印字符(ASCII printable characters)
二进制
十进制
十六进制
字符
010 0000
32
20
Space(空格)
010 0001
33
21
!
010 0010
34
22
"
010 0011
35
23
#
010 0100
36
24
$
010 0101
37
25
%
010 0110
38
26
&
010 0111
39
27
'
010 1000
40
28
(
010 1001
41
29
)
010 1010
42
2A
*
010 1011
43
2B
+
010 1100
44
2C
,
010 1101
45
2D
-
010 1110
46
2E
.
010 1111
47
2F
/
011 0000
48
30
0
011 0001
49
31
1
011 0010
50
32
2
011 0011
51
33
3
011 0100
52
34
4
011 0101
53
35
5
011 0110
54
36
6
011 0111
55
37
7
011 1000
56
38
8
011 1001
57
39
9
011 1010
58
3A
:
011 1011
59
3B
;
011 1100
60
3C
< 
011 1101
61
3D
=
011 1110
62
3E
> 
011 1111
63
3F
?
100 0000
64
40
@
100 0001
65
41
A
100 0010
66
42
B
100 0011
67
43
C
100 0100
68
44
D
100 0101
69
45
E
100 0110
70
46
F
100 0111
71
47
G
100 1000
72
48
H
100 1001
73
49
I
100 1010
74
4A
J
100 1011
75
4B
K
100 1100
76
4C
L
100 1101
77
4D
M
100 1110
78
4E
N
100 1111
79
4F
O
101 0000
80
50
P
101 0001
81
51
Q
101 0010
82
52
R
101 0011
83
53
S
101 0100
84
54
T
101 0101
85
55
U
101 0110
86
56
V
101 0111
87
57
W
101 1000
88
58
X
101 1001
89
59
Y
101 1010
90
5A
Z
101 1011
91
5B
[
101 1100
92
5C
\
101 1101
93
5D
]
101 1110
94
5E
^
101 1111
95
5F
_
110 0000
96
60
`
110 0001
97
61
a
110 0010
98
62
b
110 0011
99
63
c
110 0100
100
64
d
110 0101
101
65
e
110 0110
102
66
f
110 0111
103
67
g
110 1000
104
68
h
110 1001
105
69
i
110 1010
106
6A
j
110 1011
107
6B
k
110 1100
108
6C
l
110 1101
109
6D
m
110 1110
110
6E
n
110 1111
111
6F
o
111 0000
112
70
p
111 0001
113
71
q
111 0010
114
72
r
111 0011
115
73
s
111 0100
116
74
t
111 0101
117
75
u
111 0110
118
76
v
111 0111
119
77
w
111 1000
120
78
x
111 1001
121
79
y
111 1010
122
7A
z
111 1011
123
7B
{
111 1100
124
7C
|
111 1101
125
7D
}
111 1110
126
7E
~
ASCII编码-扩展字符
ASCII编码 扩展字符
二进制
十进制
十六进制
0111 1111
127
7f
1000 0000
128
80
1000 0001
129
81
1000 0010
130
82
1000 0011
131
83
1000 0100
132
84
1000 0101
133
85
1000 0110
134
86
1000 0111
135
87
1000 1000
136
88
1000 1001
137
89
1000 1010
138
8a
1000 1011
139
8b
1000 1100
140
8c
1000 1101
141
8d
1000 1110
142
8e
1000 1111
143
8f
1001 0000
144
90
1001 0001
145
91
1001 0010
146
92
1001 0011
147
93
1001 0100
148
94
1001 0101
149
95
1001 0110
150
96
1001 0111
151
97
1001 1000
152
98
1001 1001
153
99
1001 1010
154
9a
1001 1011
155
9b
1001 1100
156
9c
1001 1101
157
9d
1001 1110
158
9e
1001 1111
159
9f
1010 0000
160
a0
1010 0001
161
a1
1010 0010
162
a2
1010 0011
163
a3
1010 0100
164
a4
1010 0101
165
a5
1010 0110
166
a6
1010 0111
167
a7
1010 1000
168
a8
1010 1001
169
a9
1010 1010
170
aa
1010 1011
171
ab
1010 1100
172
ac
1010 1101
173
ad
1010 1110
174
ae
1010 1111
175
af
1011 0000
176
b0
1011 0001
177
b1
1011 0010
178
b2
1011 0011
179
b3
1011 0100
180
b4
1011 0101
181
b5
1011 0110
182
b6
1011 0111
183
b7
1011 1000
184
b8
1011 1001
185
b9
1011 1010
186
ba
1011 1011
187
bb
1011 1100
188
bc
1011 1101
189
bd
1011 1110
190
be
1011 1111
191
bf
1100 0000
192
c0
1100 0001
193
c1
1100 0010
194
c2
1100 0011
195
c3
1100 0100
196
c4
1100 0101
197
c5
1100 0110
198
c6
1100 0111
199
c7
1100 1000
200
c8
1100 1001
201
c9
1100 1010
202
ca
1100 1011
203
cb
1100 1100
204
cc
1100 1101
205
cd
1100 1110
206
ce
1100 1111
207
cf
1101 0000
208
d0
1101 0001
209
d1
1101 0010
210
d2
1101 0011
211
d3
1101 0100
212
d4
1101 0101
213
d5
1101 0110
214
d6
1101 0111
215
d7
1101 1000
216
d8
1101 1001
217
d9
1101 1010
218
da
1101 1011
219
db
1101 1100
220
dc
1101 1101
221
dd
1101 1110
222
de
1101 1111
223
df
1110 0000
224
e0
1110 0001
225
e1
1110 0010
226
e2
1110 0011
227
e3
1110 0100
228
e4
1110 0101
229
e5
1110 0110
230
e6
1110 0111
231
e7
1110 1000
232
e8
1110 1001
233
e9
1110 1010
234
ea
1110 1011
235
eb
1110 1100
236
ec
1110 1101
237
ed
1110 1110
238
ee
1110 1111
239
ef
1111 0000
240
f0
1111 0001
241
f1
1111 0010
242
f2
1111 0011
243
f3
1111 0100
244
f4
1111 0101
245
f5
1111 0110
246
f6
1111 0111
247
f7
1111 1000
248
f8
1111 1001
249
f9
1111 1010
250
fa
1111 1011
251
fb
1111 1100
252
fc
1111 1101
253
fd
1111 1110
254
fe
1111 1111
255
ff