Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL EDACCA CERT Table


View exposing payroll edacca cert data.


Field Name

Description

Data Type

Length

CERT_APPROVER_FULL_NAME

Cert approver full name associated with the record.

VARCHAR2

100

CERT_APPROVER_MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

PAYROLL_EDACCA_CERT_KEY

Surrogate key identifying the payroll edacca cert.

VARCHAR2

19

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE