HCM/HRMS Tables for the PS QUERY - Querying HCM/HRMS table in peoplesoft

HCM/HRMS Query reporting

The following are the main tables used to query HR related data

Human Resources Information/ Personal Data:


PERSONAL_DATA, PERS_NID
 
Employment Data:


EMPLOYMENT- general employment data, such as various service dates, etc.
 
Department Inforamation
 
DEPT_TBL --This is one of foundation tables in HR. You will rarely query against it directly; more


likely you will join to it to get the description or short description. Department codes in PeopleSoft are

different from what was used in HRS/Legacy, and department data is effective dated.
 
Job code information
 
JOBCODE_TBL --This is also a foundation table. This table holds job codes, descriptions and related


data such as FLSA classification, pay plan, grade and structure information.
 
Job Data:


JOB-- Job (roughly equates to assignment records in legacy). Contains job records along with other

data. Effective dated someone's job history will be stored in this table. Remember, Empl Records

refer to an employee's job record(s). The existence of multiple Empl Records means that they have

had or are currently holding multiple jobs Empl Records start with 0, and their benefits are tied to

Empl Record #0.
 
Benefits Data :


BEN_PROG_PARTIC – Stores the Benefit Program to which the employee is assigned.

LEAVE_PLAN – Stores enrollment in leave plans.

HEALTH_BENEFIT – Stores e nrollment in health insurance plans

SAVINGS_PLAN -- Stores enrollment in TDA, ORP and Deferred Compensation

LIFE_ADD_BEN -- Stores enrollment in life insurance plans.

RTRMNT_PLAN – Stores TRS enrollment.

DISABILITY_BEN – Stores enrollment in disability plans.
 
 
Tax Data:


FED_TAX_DATA – Contains federal tax data, including nonresident alien data

STATE_TAX_DATA – Although there is no state withholding in Texas, this record is necessary to

maintain state of residence and unemployment jurisdiction.
 
Payroll Data:


Payroll processing check data (records used by the payroll process to store check history)

PAY_CALENDAR

PAY_CHECK

PAY_LINE

PAY_CHECK

PAY_EARNINGS

PAY_OTH_EARNS

PAY_DEDUCTION

PAY_TAX
 
Payroll funding distribution data (records that tie funding to payroll actuals):


PAY_ERN_DIST

PAY_DED_DIST

PAY_TAX_DIST
 
Other employee level payroll data:


GENL_DEDUCTION - Genearl deduction.

GENL_DED_CD        - General deduction code.

ADDL_PAY_EFFDT -  additional pay effdt.

ADDL_PAY_DATA   - additional pay data.

ADDL_PAY_ERNCD - additional pay earn code.

DIRECT_DEPOSIT  - Direct deposit.

DIR_DEP_DISTRIB - Direct deposit distribution.
 
Position Data:


POSITION_DATA—identifies position data for each business unit.

Tenure Data:

EG_TENURE  Tenure Data.
 
Hints:-
 
Use the Employees table whenever possible. Queries using this table will generally have better


performance for several reasons. This tables has name, Empl ID, empl records, job title, job code,

dept title, dept code, location code, comp rate, comp frequency, position number, standard hours,

etc., data for active employees. Two fields that it does not have are Empl Class and FTE. This table

is not a transactional table, meaning that records are not actively written to it throughout the day.

Rather, it is refreshed nightly on process scheduler. There may be a one-day lag time for new data to

hit the table, but for most reporting this is acceptable

Peoplesoft HCM Process - Scheduled process.

HR_PERSDATA Application Engine - Updates the PERSONAL_DATA snapshot table with future dated entries as they become effective.

NAME_DISPLAY Application Engine - Refreshes the NAME_DISPLAY and NAME_FORMAL fields in all records with the NAME_GBL_SBR. Use when the criteria used to change these fields is changed.

PER099 Application Engine - Fill EMPLOYEES Table.

PTAF_NEM Application Engine - PTAF_NEM - Approval Framework Escalation App Engine.           AWE Workflow escalation process.

SCRTY_OPRCLS Application Engine - SCRTY_OPRCLS - Updates the SJT_OPR_CLS security Join Table.

SCRTY_SJTDLY Application Engine -  Nightly update for SJT Records -  Update of all effdt rows that have become current as of this data.

HRS_AM Application Engine - Applicant Search Auto-Match -Recruiter Applicant Search auto-match process.

HRS_DUPE_PRC Application Engine - Find Applicant Duplicates - Finds applicant duplicates given certain criteria.

HRS_JOB_AGNT Application Engine - Job Agent - Run the Job Posting Search Agent process.

HRS_JSCH_IDX Application Engine -Verity based Job Posting Index build process.

HRS035 SQR Report - Application Analysis (USA).

PER506 SQR Report - Department Tbl & Departmental - This report lists any departments that you have created in the Department Tree but have not yet added to the departmental security tree, It also lists any changes in departments since the effective date of the current security tree.

PER900 SQR Report - Core HR Data Integrity Audit. - Audit of the CORE HR Tables for Data Relationship Integrity.

PSBARUN - Cobal Job - For the Benefit Administration - scheduled to run twice each night with some custom pre and post processes. 

Implementing CAPTCHA using ReCaptcha in PeopleSoft

You can use this for the forgot password component , carrer login page (applicant login) or any other similar pages strighat way.

Following are modified steps from the reCAPTCHA website for the PeopleSoft Implementation.

First, go to the reCAPTCHA web site and create an account. As part of that account creation process you'll have to specify the domain your reCAPTCHA will be protecting. The reCAPTCHA site will will give you a key pair for that domain. The key pair allows you to authenticate your reCAPTCHA requests to the reCAPTCHA servers

Second, Create the HTML Area in the PeopleSoft page where you want the ReCaptcha to apper
in the HTML Defination add the follwing Java script code, you need to enclose it with form tags.
make sure you replace   - with the public key from the key pair created in reCaptcha website.

Download the Java API library in the following location

http://code.google.com/p/recaptcha/downloads/list?q=label:java-Latest - Place the jar file in the class path/folder for the java in the appserver.

Add button on the page, similar to submit button for the page, on field change of the button you can write the code as below.

PS: Make sure you replace the private in code with the private key generated by reCaptcha for your domain.
Hope this will be helpfull.

Paperless Office with PeopleSoft Forms & Approval Builder 

PeopleSoft applications are helping to make paper and email-based forms a thing of the past so that you will know what was submitted, when it was submitted, and who approved it. We recently released Forms and Approval Builder as a part of Common Components 9.1. Forms and Approval Builder allows you to build electronic forms that are configurable by business analysts, enabled with approval workflows, and immediately deployable and auditable to enable you to replace paper and email-based forms. Forms and Approval Builder is currently available, at no additional charge, to all PeopleSoft 9.1 customers. It was part of the FSCM Feature Pack March 2011, and it is also available in the Enterprise Components 9.1 Common Objects Bundle 1 2011 for use in any PeopleSoft 9.1 Pillar, including, of course, HCM. It does require PeopleTools 8.51.03 or greater.

Form Design

PeopleSoft Forms and Approval Builder enables business analysts to create electronic, routable forms without having to use PeopleSoft Application Designer. A typical form can be designed and in use within 30 minutes and requires no writing of code.

The intuitive wizard guides you step by step through establishing a form. Options include adding instructions to the form, similar to what you would find on the back of a paper form; adding attachments to the form for users to read, submit, or both; and being able to create your own fields on the form. These fields can be plain text, numbers, date and time, yes/no, fields that prompt against existing PeopleSoft records, and code fields. The code field type enables you to build a list of items on the fly that a person who is filling in the form can select from when perusing the drop-down list. You can create these user prompt values in the code fields without having to enter them in a standard PeopleSoft record beforehand.

Main Menu > Forms > Design a Form

Fields can be organized into one or two columns on the page, and every field on the form has the option of being made required to ensure that users thoroughly complete the form.


You specify the location of the form in the PeopleSoft Main Menu through an easy-to-navigate folder hierarchy, and you select the flow of approvers that the form will follow using the approvers from within the Approval Workflow Engine.

There is also the ability to make forms available for limited periods of time.

Efficient and Effective Forms Management for your Organization

Knowing how many of each type of form are in the system and their approval status is essential in monitoring your business processes. PeopleSoft Forms and Approval Builder comes with its own summarization table, enabling you to see at a glance how many forms of each type have been created and how many forms are in each approval status. This central Form Management repository also enables you to activate and deactivate your forms within the system in one place, eliminating the need to go back into the design of each form and activate it.

The ability to find a particular form in an instant is also important in supporting efficient operations. Forms are searchable by subject, form type, priority, due date, and approval status to eliminate the need for searching through piles of paperwork.


Easy to Navigate Forms Available to Your Users When they Need Them

Any given form may be accessed through either the central forms repository or the link you designate for it in within the PeopleSoft Menu navigation. Users open a blank form; enter the required information; download, read, fill in, and upload attachments; and submit their form for approval.

Forms are available to the approver instantly, and approvals are also available as soon as they are granted.

Finally, because the Forms and Approval Builder utilizes the existing infrastructure of the Approval Workflow Engine and the Supplemental Data Framework, your forms and approvals are migrated like all other application data during an upgrade between PeopleSoft Releases.