HRBAIRS Data Dictionary -

The rate / frequency at which this component of pay is paid (e.g., per MONTH, HOURLY, SEMI-monthly, 11/12).

The last date/time this row of Compensation table data was updated. This field is updated when any change is made to the row, including changes made in PeopleSoft's "correction mode."

This value is "Y" if the Compensation row represented by this row of Data Warehouse data was manually added by an HRMS user. If the value of this flag is "N" the Compensation row was originally added and populated by the HRMS system. While a user can change the values of fields in this row, s/he may not delete it (even if other Compensation rows have been added manually). This row -- the one for which MANUAL_ROW_FLAG = "N" -- is the row of Compensation data for which HRMS system edits enforce data integrity.

Explanatory code if this component of pay is "off or above the published scale." Valid values of these codes can be found on the HCM: Off/Above Scales page.

Employee ID. The key field used to uniquely identifying employees and non-employees in HRMS. Values auto-generated by HRMS upon hire.

Amount of change in salary from its most recent previous value. This amount is calculated only for "add to base" type components of pay.

Percentage change of salary compared to its most recent previous value. This percentage is calculated only for "add to base" type components of pay.

Amount of periodic payment, expressed at a rate described by a related Compensation Rate code and disbursed at the frequency specified by a related Compensation Frequency field.

In the COMPENSATION view, the amount associated with this component of pay.

In the JOB_EARNS_DIST view, the rate or amount from which pay is to be calculated for a row of Job Earnings Distribution data.

For example, if the DIST_PERCENT is 10.0000%, and the COMP_RATE is $3,000.00, this row describes an earnings distribution of $300.00. Where Earnings Codes are not based on a percentage of time (e.g., stipends or housing allowances), the earnings distribution described by the row is based on the COMPRATE only.

The frequency at which the job-level pay described in the COMPRATE field is paid.

In the COMPENSATION view, the frequency at which a component of pay, described by the row of data in question, is disbursed to the employee.

A system-generated key field that distinguishes one concurrent job from another for those employees who hold multiple jobs simultaneously.

When multiple jobs are held simultaneously, concurrently-effective rows with different EMPL_RCD_NO (Employment Record Number) values will exist. Different jobs held sequentially will generally re-use the same EMPL_RCD_NO value; a new EMPL_RCD_NO is generated for an employee when an ADD ADDITIONAL JOB action occurs. More information is available on the HR web site about HCM: Concurrent Jobs.

The date on which a row of job (appointment) data took effect, often called "effective date." Job data pertains to a job held by an employee, rather than to the employee her/himself or to earnings-distribution or component-of-pay (compensation) data. Examples of "job-level" data include: job code, action code, Org_Node, and personnel program code.

In HRMS, the effective date and the date of data-entry often differ.

In the COMPENSATION view, this field contains the effective date of the Job row of which the Compensation row is a child.

In the JOB_EARNS_DIST view, this field contains the effective date of the Job row of which the Job Earnings Distribution row is a child.

When multiple job rows exist that are effective on a single date, this field indicates the sequence in which they were entered. The lowest, default value, zero, indicates first row entered on the effective date in question. Rows with higher sequence numbers supercede rows with lower sequence numbers on a given date. Effective sequence numbers are meaningful only in conjunction with the effective date of the row in which they occur.

In the COMPENSATION view, this indicates the effective sequence number of the Job row of which the Compensation row is a child.

In the JOB_EARNS_DIST table, this indicates the Effective Sequence number of the Job row of which the Job Earnings Distribution row is a child.