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 |