EHSOSHA APPT GROSS HOURS Table
View exposing OSHA appointment gross-hours summary by campus or Lincoln status, employee grouping, appointment type, month, and payroll year including FTE and headcount measures.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CAMPUS_VS_LINCOLN |
Campus vs lincoln associated with the record. |
VARCHAR2 |
7 |
EMPLOYEE_GROUP |
Employee group associated with the record. |
VARCHAR2 |
20 |
EMPLOYEE_TYPE |
Employee type associated with the record. |
VARCHAR2 |
30 |
HEADCOUNT |
Headcount associated with the record. |
NUMBER |
19 |
HR_APPT_SUBTYPE |
Hr appt subtype associated with the record. |
VARCHAR2 |
100 |
IS_GRAD_STUDENT |
Indicator identifying whether grad student (Y/N). |
VARCHAR2 |
1 |
MONTH |
Month associated with the record. |
VARCHAR2 |
10 |
PAYROLL_YEAR |
Payroll year associated with the record. |
VARCHAR2 |
4 |
PERSONNEL_SUBAREA |
Personnel subarea associated with the record. |
VARCHAR2 |
20 |
SAP_APPT_TYPE |
Sap appt type associated with the record. |
VARCHAR2 |
30 |
TOTAL_FTE |
Total fte associated with the record. |
NUMBER |
34 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |