PAYROLL EDACCA CERT Table
This table contains e-DACCA Certification information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CERTIFICATION_TYPE |
XXX |
VARCHAR2 |
30 |
CERTIFICATION_TYPE_CODE |
XXX |
VARCHAR2 |
1 |
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_KRB_NAME |
Kerberos ID of the person who certified the eDACCA electronically |
VARCHAR2 |
12 |
CERT_APPROVER_MIT_ID |
MIT ID of the person who certified the eDACCA electronically |
VARCHAR2 |
9 |
CERT_DATE |
The date the eDACCA was certified in the eDACCA system |
DATE |
8 |
CERT_TIME |
XXX |
VARCHAR2 |
6 |
COST_OBJECT |
a seven digit number used to categorize the costs and revenues associated with a particular project or activity at MIT; The terms cost object and cost collector are used interchangeably. |
VARCHAR2 |
12 |
COST_OBJECT_TYPE |
The type of SAP cost object: cost center, internal order, or WBS element |
VARCHAR2 |
1 |
EDACCA_PERIOD |
XXX |
VARCHAR2 |
6 |
EDACCA_YEAR |
XXX |
VARCHAR2 |
4 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |