PAYROLL EDACCA CERT DETAIL Table
This table contains e-DACCA Certification detail information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CERTIFICATION_DATE |
XXX |
VARCHAR2 |
8 |
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 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
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 |
20 |
PAYROLL_EDACCA_CERT_SCHED_KEY |
Key field used to link payroll_edacca_cert_detail and payroll_edacca_cert_sched tables. |
VARCHAR2 |
6 |
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 |