EHSOSHA ABS CAMPUS LINCOLN Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ABSENCE_TYPE |
XXX |
VARCHAR2 |
25 |
ACTUAL_ABSENCE_HOURS |
XXX |
NUMBER |
18,2 |
EMPLOYEE_GROUP |
Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External |
VARCHAR2 |
40 |
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
30 |
LOCATION |
XXX |
VARCHAR2 |
7 |
PAYROLL_YEAR |
XXX |
VARCHAR2 |
4 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
30 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
YEAR_MONTH |
XXX |
VARCHAR2 |
10 |