PAYROLL EDACCA CERT SCHED Table
This is a time dimension table for e-DACCA Certification which contains the fiscal year data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
FISCAL_YEAR_QUARTER |
The fiscal year and quarter in yyyyqq format, e.g., 200804 is 4th quarter of fiscal year 2008. |
VARCHAR2 |
6 |
PAYROLL_EDACCA_CERT_SCHED_KEY |
Key field used to link payroll_edacca_cert_detail and payroll_edacca_cert_sched tables. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |