Important Hrms Tables

Human Resources Information foundations tables:

JOB -- Contains job records along with other data. Effective dated someone's job history will be stored in this table.

Key Fields:

EMPLID

EMPL_RCD

EFFDT

EFFSEQ

DEPT_TBL -- 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.

Key Fields:

SETID

DEPTID

EFFDT

JOBCODE_TBL -- This table holds job codes, descriptions and related data such as FLSA classification, pay plan, grade and structure information.

Key Fields:

SETID

JOBCODE

EFFDT

EMPLOYEES –

Key Fields:

EMPLID

EMPL_RCD

EMPLOYMENT-- General employment data, such as various service dates, etc.

Key Fields:

EMPLID

EMPL_RCD#

COMPANY_TBL --

Key Fields:

COMPANY

EFFDT

PERSONAL_DATA – Contains the Personal Data of employees

Key Fields:

EMPLID

PERS_NID –

Key Fields:

EMPLID

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 enrollment 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.

BENEF_PLAN_TBL

BENEFIT_VW

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

GENL_DED_CD

ADDL_PAY_EFFDT

ADDL_PAY_DATA

ADDL_PAY_ERNCD

DIRECT_DEPOSIT

DIR_DEP_DISTRIB

Position Data:

POSITION_DATA—identifies position data for each business unit.

Tenure Data:

EG_TENURE Data

How many types of records are there?
There are six types of records
1. SQL table - Corresponding physical SQL table in the database we create with build option.
2. SQL View – It is not a physical SQL table on the database, it gives the replicate of joined tables. It is used for security and faster access.
3. Dynamic View – It is actually stored in the form of SQL view text and is executed at runtime. It uses the built in indexes. Whereas normal view is executed and stored in the database.
4. Derived/Work record - It is a temporary workspace to be used during on line panel processing and is not stored in the database, therefore derived work records are not built. They cannot be seen in the update/display mode. Once the panel is cancelled it is removed from the buffer.
5. Sub Records – A group of fields commonly used in multiple records.
6. Query View – A Query view is a view constructed using People soft Query tool.

What are the two Processing Modes?

Interactive Mode:

In interactive mode (formerly called standard), when the user exits a field that has a field-level event (for example, FieldChange, FieldEdit, RowInsert PeopleCode, prompt validation, related display, and so on):

• A transmission to the application server is performed to run that field-level event.
• The page is displayed again.

Deferred Mode:

Deferred mode enables you to defer many of the conditions that need server processing until running them on the application server is required or requested. For example, when a user exits a field that has a field-level event (like FieldChange or FieldEdit PeopleCode, prompt validation, related display, and so on), that event is not run until the next transmission to the application server. When the next transmission to the server occurs, PeopleTools determines which fields have changed since the last transmission. Logic on