EHSOSHA TMP WRK HRS INVOICE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CALENDAR_PERIOD |
Four digit year plus two digit month (Example: 199601, 199910). |
VARCHAR2 |
9 |
HEADCOUNT |
XXX |
NUMBER |
19 |
TOTAL_HOURS |
The total hours works (for both regular and premium pay rates) in the pay period. |
NUMBER |
34 |
VENDOR_KEY |
Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
11 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |