Job Earnings Distributions views contain child-records to rows available in the EMPLOYEE_DIM views. Fields include chartstring components (such as Account_Code and Fund_Code); and Distribution Percentage, Earnings Code, and Budgeted FTE. Job-level rows represented in the EMPLOYEE_DIM views can have zero or more corresponding rows in the JOB_EARNS_DIST views, depending on whether and from which funding sources an employee is paid; all JOB_EARNS_DIST rows have a parent row in the EMPLOYEE_DIM views. Multiple variants of these views exist, to provide appropriate security options.
Published in:- HRBAIRS .wd
Contains fields:
EMPL_ID |
Employee ID. The key field used to uniquely identifying employees and non-employees in HRMS. Values auto-generated by HRMS upon hire. |
COMPRATE |
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. |
EMPL_RCD_NO |
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. |
PS_EMP_APPT_EFF_DT |
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. |
PS_EMP_APPT_EFF_SEQ |
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. |
ACCOUNT_CODE |
The Account portion of a GL chartstring. |
BUDGETED_FTE |
A decimal value representing the fraction of this job's FTE for which centrally budgeted funding is allocated from the GL chartstring described by this row of data. The values of Budgeted_FTE in JOB_EARNS_DIST rows that correspond to a single row of Job data may add up to no more than 1.00. |
BUSINESS_UNIT_CODE |
The General Ledger Business Unit (e.g., 1 - UCB; J - UCOP). |
DIST_NO |
The PPS distribution number to which this row of data may correspond. This field is not meaningful in HRMS reporting, because PPS appointment numbers are determined and recalculated independent of the data rules that keep HRMS data meaningful, and may differ in PPS from the values stored in HRMS. |
DIST_PERCENT |
The percentage of FTE to be paid from the GL chart string described in this row. Note that the sum of distribution percent values from certain rows on the JOB_EARNS_DIST level - those on which the Earnings Code (ERN_CD in the data warehouse) is euql to REC, REG, REN, RG1, SLN, SLR, or TAP - equals the value of FTE on the Job level (enforced by HRMS application editing rules). |
ERN_CD |
An Earnings Code describes the type of Earnings Distribution a row of data represents. Examples include: REG, WOS, BYA, STP. A full list of codes may be viewed on the HCM: Earnings Codes page. |
FLEXFIELD_CODE |
The Flex (Flex Field) portion of the GL chartstring associated with this Job Earnings Distribution row. |
FUND_CODE |
The Fund portion of the GL chartstring encoded in a a row of data. |
LASTUPDDTTM_DIST |
The date and time this row of Job Earnings Distribution data was last updated in HRMS. |
ORG_CODE |
The Org portion of the GL chartstring associated with this Job Earnings Distribution row (in BFS, known as the Org or Organization code). |
PAY_BEGIN_DT |
The date at which the earnings distribution represented by this row of data begins (or began). |
PAY_END_DT |
The date at which the earnings distribution represented by this row of data ends (or ended). |
PROGRAM_CODE |
The Program portion of the GL chartstring associated with this Job Earnings Distribution row. |
PROJECT_NO |
The Project portion of the GL chartstring associated with this Job Earnings Distribution row. |
WORK_STUDY_PGM_CD |
Type of Work Study program. This field is blank for employees who are not work study students. |