Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL STUB PRINT DETAIL Table


View exposing payroll stub print detail data.


Field Name

Description

Data Type

Length

IS_PAYSTUB_PRINTED

Indicator identifying whether paystub printed (Y/N).

VARCHAR2

1

LAST_UPDATE_DATE

Date associated with last update.

DATE

LAST_UPDATE_USER

Last update user associated with the record.

VARCHAR2

12

PAYSTUB_PRINT_END_DATE

Date associated with paystub print end.

DATE

PAYSTUB_PRINT_START_DATE

Date associated with paystub print start.

DATE

PERSONNEL_KEY

Surrogate key identifying the personnel.

VARCHAR2

8

RECORD_COUNTER

Record counter associated with the record.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE