Imp HR and Payroll Tables - Part III

>> HR_ORGANIZATION_UNITS

This table holds the definitions that identify business groups and the organization units within a single business group. Additional information about classifications and information types for each organization is held in HR_ORGANIZATION_INFORMATION

>> PAY_PEOPLE_GROUPS

The table contains the people group flexfield segment values for individual employee assignments. The segments of the group flexfield are user–defined and are used to identify specific groups of employees for element link rules, for analysis and reporting. Groups are also used to determine the sorting of pay advice and checks/cheques. GROUP_NAME contains the concatenation of SEGMENT1 to SEGMENT30.

>> PER_GRADES

Table stores grade definitions. The NAME is the concatenation of key flexfield segments and is generated when the grade is defined. Grades are used to show the level or rank of an employee in an assignment, and may be related to job or position by the definition of valid grades. They are often used to specify element eligibility rules. The DATE_FROM and DATE_TO columns define the date limits for using grades in the system.

>> HR_ALL_POSITIONS_F

It is a datetracked table holding position definitions. A position is defined as the unique occurrence of a job in one organization. There can be many different positions that share the same JOB_ID and ORGANIZATION_ID, but each position is uniquely identified by the POSITION_ID and by the NAME. The position name is a concatenation of flexfield segments stored in the PER_POSITION_DEFINITIONS table

>> PER_JOBS

Table holds jobs that have been defined for a Business Group. The NAME is a concatenation of key flexfield segments, held in PER_JOB_DEFINITIONS. Jobs define the role that an employee can perform in the business group, and they are independent of specific organizations.

>> HR_LOCATIONS_ALL

Table holds information about specific work locations defined for an enterprise, including address details.

>> PAY_ALL_PAYROLLS_F

A DateTracked table that holds payroll definitions, a payroll defines a group of employees who share the same frequency of processing and payment, defined by the payroll calendar in PER_TIME_PERIODS. The definition of the payroll includes the default processing information for consolidation sets, payment types, cost allocation, and offset dates

PREVIOUS POST || NEXT POST