Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL EDACCA CERT Table


This table contains e-DACCA Certification information.


Field Name

Description

Data Type

Length

CERT_APPROVER_FULL_NAME

The name (Lastname, First Name Initial) of the person who certified the eDACCA electronically- can be either the eDACCA certifier or a proxy (eDACCA administrator)

VARCHAR2

100

CERT_APPROVER_MIT_ID

MIT ID of the person who certified the eDACCA electronically

VARCHAR2

9

PAYROLL_EDACCA_CERT_KEY

Key field used to join the Payroll Edacca Cert table to Payroll Edacca Detail. This field should only be used for joining data, NOT for reporting.

VARCHAR2

19

WAREHOUSE_LOAD_DATE

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

DATE