HR PERSON EMPLOYEE YEAR END Table
This table contains annual snapshots of HR_PERSON_EMPLOYEE table (only relevant fields are represented). It is used by HR-Payroll for government reporting
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYEE_GROUP |
Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External |
VARCHAR2 |
30 |
EMPLOYEE_GROUP_CODE |
Code identifying an employee grouping: E for Exempt, N for Non-Exempt, X for External. |
VARCHAR2 |
1 |
EMPLOYMENT_STATUS |
Identifies the most recent status of an employee, eg, Active, Leave, Retiree, Terminated, Deceased. NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record. |
VARCHAR2 |
30 |
EMPLOYMENT_STATUS_CODE |
Code to identify the status. |
VARCHAR2 |
1 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PAYROLL_AREA |
A field indicating whether the person is monthly paid, weekly, paid, non-paid or terminated |
VARCHAR2 |
30 |
PAYROLL_AREA_CODE |
ZM for monthly paid, ZW for weekly paid, ZB for retired, ZN for non-paid or ZT for terminated |
VARCHAR2 |
2 |
PERSONNEL_KEY |
Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
YEAR |
In KRB_PERSON, YEAR is a one-character field identifying the students year of degree (or current year); eg.: 1, 2, 3, 4, G, U. In TIP_MATERIAL YEAR is a Year when a Title was published |
VARCHAR2 |
1 |