Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID PAY DIST TYPE Table


View exposing reference values describing payroll distribution types used in financial aid work-study programs.


Field Name

Description

Data Type

Length

DISTRIBUTION_TYPE

Distribution type associated with the record.

VARCHAR2

40

PAYROLL_SYSTEM

Payroll system associated with the record.

VARCHAR2

40

PAY_DIST_TYPE_KEY

Surrogate key identifying the pay dist type.

VARCHAR2

6

PERSONNEL_RANK

Personnel rank associated with the record.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE