Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHSOSHA HOURLY STUDENT Table


View exposing OSHA hourly-student summary by payroll year and month period including headcount and hours worked.


Field Name

Description

Data Type

Length

HEADCOUNT

Headcount associated with the record.

NUMBER

19

HOURS_WORKED

Hours worked associated with the record.

NUMBER

18,2

MONTH_PERIOD

Month period associated with the record.

VARCHAR2

10

PAYROLL_YEAR

Payroll year associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE