EHSOSHA APPT GROSS HOURS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CAMPUS_VS_LINCOLN |
XXX |
VARCHAR2 |
7 |
EMPLOYEE_GROUP |
Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External |
VARCHAR2 |
20 |
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
30 |
HEADCOUNT |
XXX |
NUMBER |
19 |
HR_APPT_SUBTYPE |
This field contains the description of the appointment subtype, Examples: Academic Appointment (MNT1), Academic Appointment--MAP (MAP1), etc.. |
VARCHAR2 |
100 |
IS_GRAD_STUDENT |
XXX |
VARCHAR2 |
1 |
MONTH |
XXX |
VARCHAR2 |
10 |
PAYROLL_YEAR |
XXX |
VARCHAR2 |
4 |
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 |
SAP_APPT_TYPE |
XXX |
VARCHAR2 |
30 |
TOTAL_FTE |
XXX |
NUMBER |
34 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |