Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL STUB PRINT DETAIL Table


XXX


Field Name

Description

Data Type

Length

IS_PAYSTUB_PRINTED

XXX

VARCHAR2

1

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

PAYSTUB_PRINT_END_DATE

XXX

DATE

PAYSTUB_PRINT_START_DATE

XXX

DATE

PERSONNEL_KEY

Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE