Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL MBTA VAN DEDUCT DETAIL Table


View exposing payroll mbta van deduct detail data.


Field Name

Description

Data Type

Length

AMOUNT

Amount associated with the record.

NUMBER

PAYROLL_IN_PERIOD_KEY

Surrogate key identifying the payroll in period.

VARCHAR2

8

PAYROLL_WAGE_TYPE_KEY

Surrogate key identifying the payroll wage type.

VARCHAR2

4

PERSONNEL_KEY

Surrogate key identifying the personnel.

VARCHAR2

8

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE