HR PERSON EMPLOYEE YEAR END Table
View exposing employee master data as of year-end including identifiers, demographic attributes, and employment attributes used for year-end workforce reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
40 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
1 |
EMPLOYMENT_STATUS |
Column EMPLOYMENT_STATUS. |
VARCHAR2 |
30 |
EMPLOYMENT_STATUS_CODE |
Column EMPLOYMENT_STATUS_CODE. |
VARCHAR2 |
1 |
FIRST_NAME |
Column FIRST_NAME. |
VARCHAR2 |
40 |
FULL_NAME |
Column FULL_NAME. |
VARCHAR2 |
100 |
LAST_NAME |
Column LAST_NAME. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Column MIDDLE_NAME. |
VARCHAR2 |
40 |
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 |
Column PAYROLL_AREA. |
VARCHAR2 |
20 |
PAYROLL_AREA_CODE |
Column PAYROLL_AREA_CODE. |
VARCHAR2 |
2 |
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |
|
YEAR |
Column YEAR. |
VARCHAR2 |
4 |