Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL EDACCA CERT STATUS Table


This table contains information that describes the e-DACCA certification status.


Field Name

Description

Data Type

Length

CERTIFICATION_STATUS

The certification status in the eDACCA system: "Certified" - electronically certified by the eDACCA certifier, "Certified as proxy" - electronically certified by an eDACCA administrator, or "Not certified".

VARCHAR2

30

IS_CERTIFIED

A flag (Y/N) that indicates whether the eDACCA has been electronically certified

VARCHAR2

1

PAYROLL_EDACCA_CERT_STATUS_KEY

key to link tables payroll_edacca_cert_status and payroll_cert_status_detail

VARCHAR2

1

WAREHOUSE_LOAD_DATE

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

DATE

8