PAYROLL EDACCA CERT DETAIL Table
View exposing payroll edacca cert detail data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CERTIFICATION_DATE |
Date associated with certification. |
DATE |
|
CERT_APPROVER_FULL_NAME |
Cert approver full name associated with the record. |
VARCHAR2 |
100 |
CERT_APPROVER_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
17 |
PAYROLL_EDACCA_CERT_KEY |
Surrogate key identifying the payroll edacca cert. |
VARCHAR2 |
19 |
PAYROLL_EDACCA_CERT_SCHED_KEY |
Surrogate key identifying the payroll edacca cert sched. |
VARCHAR2 |
6 |
PAYROLL_EDACCA_CERT_STATUS_KEY |
Surrogate key identifying the payroll edacca cert status. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |