FUNDS REPORTING YEARS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CALENDAR_PERIOD_DESCRIPTION |
Text associated with CALENDAR_PERIOD (Example: January 1996, October 1999). |
VARCHAR2 |
30 |
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
6 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |