PeopleSoft Learning

Find the resumes applicants based on the keywords.
Search the resumes in peoplesoft.

Recruiting > Administration > Build Applicant Index

An application engine program can be executed to run the Verity search Index to search the applicants.

under the applicants status select the group that needs to be indexed. select the index
C:\tmp for NT and /temp for UNIX scheduler.

execute the process HRS_SRCH_IDX to create the search index in the PS_HOME/data/search/HRS_ResumeText/

If the application servers and process schedulers are on separate boxes then additional steps need to be taken so that the application servers have access the files created under the PS_HOME\data\search\HRS_ResumeText\%DB NAME% directory

These files can be copied to app server as well.

To find the applicants

Recruiting > Find Applicants

In the Resume and Application Search section enter word that you are looking for in the resume in Enter Keywords field.

Refresh SJT_OPR_CLS and Refresh SJT_CLASS_ALL are Security process.

When to execute Refresh SJT_OPR_CLS process

On the Roles - Permission Lists page

• Add a permission list with data permission to a role that is already assigned to one or more users.
• Remove a permission list with data permission from a role that is already assigned to one or more users.

On the User Profile component

Add a row security permission list.
• Delete a row security permission list.
• Add a role with data permission.
• Delete a role with data permission.
• Clone an existing profile that has data permission through roles or a row security permission list.
• Deactivate a user.

You can refresh SJT_OPR_CLS in real-time by using the subscriptions on the USER_PROFILE and ROLE_MAINT messages or on demand using the SCRTY_OPRCLS app
engine process.

Run the Refresh SJT_CLASS_ALL process when

• Add a new department to a department security tree.
• Delete a department from a department security tree.
• Move a department to another parent node in a department security tree.
• Modify a department security tree.

Real-Time updates of the Transaction Security Join Tables.

One of the big enhancements for HRMS 8.9 is that the security join tables are updated in real-time instead just using an Application Engine process. This is accomplished by using a special subpage that contains the working fields that are needed. This subpage (SCRTY_SJT_UPD) needs to be put on a page that is in the components where the transaction records are updated. For the transaction record JOB, the subpage has been attached to the JOB_DATA1_WRK page. This page is included in all of the components where the JOB record is updated (either directly or as a component interface).

There are 2 type of Security Join tables

1)Transaction - Security Join Tables
2)User Side - Security Join Tables

Transaction security definitions are stored in one of the following four SJTs, depending on the kind of transaction data:
• SJT_PERSON (stores person-related transaction data)
• SJT_PERSON_USF (stores person-related transaction data for USF installations)
• SJT_DEPT (stores department-related transaction data)
• HRS_SJT_JO (stores job opening-related transaction data)

User security definitions are stored in the following two SJTs:
• SJT_CLASS_ALL The row security access assigned to a permission list (role-based or row security).
Contains the data permission information for all the permission lists that are given data access on the Security by Dept Tree page or Security by Permission List page.
Stores Data From 1)SCRTY_TBL_DEPT 2)SJT_CLASS
Following are keys
CLASSID , SCRTY_SET_CD , SCRTY_TYPE_CD , SCRTY_KEY1 , SCRTY_KEY2 , SCRTY_KEY3
• SJT_OPR_CLS Which user profiles are assigned which permission lists
Contains the user IDs of people with data permission and the permission lists with data permission that are assigned to them.
Stores Data From
1)PSOPRDEFN
2)PSROLEUSER
3)PSROLECLASS

PeopleSoft Application Engine programs use bind variables in the SQL statements, but these variables are just PeopleSoft specific. When the statement is passed to the database it sends the statement with literal values. The only way to tell the application engine program to send the bind variables is by specifying the Re-Used flag for that statement that needs to use the bind variable.

If any customizations are performed, it is recommended that the Reuse Flag be set to “Yes” for all program steps.
Before

AE Trace

After

AE Trace

You can get detailed AE Trace as shown above by appending the tace flags in the process definition > options page.

-TRACE 384 - will give you the detail timing of the SQL.

Text catalog in Peoplesoft

To set up a non-application specific text catalog
Set Up HRMS, Common Definitions, Text Catalog and Notepad menu.

Text Retrieval Delivered Function

FUNCLIB_HR.HR_SSTEXT_KEY1:FieldFormula –

GetHRSSText(&AppCode, &SubId, &TextId, &Effdt, &TargetLanguage, &Key1, &Key2, &Key3, &Key4, &ReturnedText, &S1, &S2, &S3, &S4, &S5);

It uses the substitute function to replace the bind value parameter in the text catalog.

You may decide to either:
1)Implement the generic API directly within your application’s code, or
2) Create an application-specific front-end to call the API.

How the Security views work

The security views work by joining together the security join tables along with the OPRID of the user accessing the view. All security views share some characteristics both in their structure and their view text.
Each view must include the OPRID as a key field, the keys for the transaction data, and any additional fields that are used as search or list box fields. Most core views also include other fields from the security join record that other views can enter where criteria against.
We are not including ROWSECCLASS as a key in the security views. This is because if we do, then we would have to require a ROWSECCLASS be entered for every OPRID. The reason for this is that when the join to PSOPRDEFN is done behind the scenes, it will put the value of PSOPRCLS into the field returned from PSOPRDEFN.ROWSECCLASS if the ROWSECCLASS is blank. If the PSOPRCLS is also blank, then the OPRID is returned. This makes it impossible to join to the SJT_CLASS_ALL table. Including the ROWSECCLASS as a non-key field in the security view is okay, but does not provide any benefit. You will still find it in some views because it was less risky to leave it there for now.
The core views need to join in PSOPRDEFN, SJT_CLASS_ALL, and the appropriate transaction SJT. For example, for People with Jobs and/or People without Jobs the SJT record is SJT_PERSON.

What is Security Set and Security Type ? How they are different ??

Security Set - a grouping of data that is being secured.
The sets differ by the origin of the transaction security data. For example, people of interest without jobs is a separate security set from people with jobs because the transaction data used to secure the access does not come from the JOB record, but from the PER_POI_SCRTY record.

Following the delivered security set

1) DEPT - Department - SJT_DEPT
2) PPLJOB - People with Jobs - SJT_PERSON
3) PPLPOI - People without Jobs - SJT_PERSON
4) PPLUSF - US Federal People with Jobs - SJT_PERSON_USF
5) RSOPN - Recruiting Job Openings. - HRS_SJT_JO

Security Types - SCRTY_TYPE_TBL

Security access types are different ways of securing the data within a security set. Each security set has a number of security access types that you can choose to enable. Among other things, security access types determine:
1) The security transaction data.
2) there is data security for future-dated rows.
3) If the access type uses a department security tree.

Few of the Delivered security types

Security set Type Descr Trans. Record Tree
DEPT 021 Departments by Tree DEPT_TBL DEPT_SECURITY
DEPT 022 Departments - non Tree DEPT_TBL
DEPT 023 Departments by Setid DEPT_TBL
PPLJOB 001 Job Department Tree JOB DEPT_SECURITY
PPLJOB 002 Job Location JOB
PPLJOB 003 Job Business Unit JOB
PPLJOB 004 Job Company JOB

Application Class Tester


Enterprise Componets > Component Configurations > Application Class Tester



Purpose of the component
1) PIA page that a user can use to test an Application class API
2) Component can test one application class and one method at a time.
3) Tester will be able to use pass parameter values for the methods. Data types for the parameters will be basic types only.
4)PSScripts can be generated to test the application class with less customization.

Description of the page fields

classpath :- the classpath to the application that needs to be tested.
Constructor parameters :- (Optional) constructor parameters.
Class method:- the method name in the application class that needs to be tested.
Method parameters:- method parameters if any.
submit :- executes the method call the results
Display only result edit box:- This box is for psscript. It is just a concatenation of the method and parameter return values. for the special data type return values gives class name like Record, Row, Rowset.

A data entry operator has five pieces of information for one employee that must be put into the system. Each action occurs on the same date and they are entered into the system as follows: 1 - February 14, 2003 - Reorganization 2 - February 14, 2003 - Promotion 3 - February 14, 2003 - Pay Rate Change 4 - February 14, 2003 - Data Change 5 - February 14, 2003 - Transfer. What is the fourth row that is displayed after the data entry is completed?

Data Change
Reorganization
Promotion (*)
Transfer
Pay Rate Change

When working on a conversion, what does PeopleSoft recommend you use as the initial effective dates on the Job Code Table?

use 01/01/1900 use the date of your conversion
accommodate your longest active tenured employee
accommodate your longest tenured employee (*)


You have just added a new department to the Department Table. It is active and its effective date is less than today's date. When you try to transfer an employee to that department on an inserted row with today's date, the new department is NOT showing up. How can you resolve this issue?


run the Refresh Employees Table Process
add the department to the active Department Security Tree (*)
run the Update Department Security Tree Process
manually type in the department in the Department field and select Save from the Icon menu
Change the effective date of the record to match the effective date of the new department


You are helping the Compensation department set up the Job Code Table. Which three tables are associated with the Job Code Table and therefore should be set up prior to setting up the Job Code Table? (Choose three.)

Salary Plan Table (*)
Job Function Table (*)
Job Description Table
SetID Table (*)
Job Hazard Table

What are four security solutions that are delivered with PeopleSoft? (Choose four.)

Fast Security 4
Fast Security 3 (*)
Location Security
Fast Security 2 (*)
Company Security
Department Security (*)
Fast Security 1 (*)

For the action of Short Term Disability, what is the resulting employee status?

Active
Termination
Leave of Absence (*)
Leave with Pay
Suspension


A company wants you to set the dependent age limit to 19 for all benefits. Which table should you use?

Benefit Plan Table
Calculation Rules Table
Dependent/Beneficiary Table
Benefit Program Table (*)


Which table has SetID as a high-level key?

Business Unit Table
Location Table (*)
Job Profile Table
Comp Rate Code Table
Company Table


Where do you enter default values that are specific to a PeopleSoft user?

Business Unit Options Defaults
Location Table
Installation Table
Org Defaults by Permission List (*)
User Profiles Component



A customer wants to set up a vacation plan and have the ability to track the vacation balances. Which three tables must be set up before you can track the vacation balances? (Choose three.)


Calculation Rules Table
Provider/Vendor Table (*)
Earnings Table (*)
Deduction Table
Benefit Program Table (*)



On the Job Earnings Distribution Page, what are three ways you can distribute the employee's compensation? (Choose three.)

to a different Company
to a different Department (*)
to a different Job Codes and/or Position (*)
to a different Pay Group
to a different General Ledger Type (*)


Which HRMS module does NOT use the Group Build functionality?


Payroll (*)
Training Administration
Total Compensation Reporting
Variable Compensation
Salary Planning


A customer asks you to set up a medical plan on the Benefit Plan Table. Which table must you set up first?

Flat Rate Table
Calculation Rules Table
Health Plan Table
Plan Specific Table
Provider/Vendor Table (*)


Which statement is true when processing benefits with multiple jobs?