TIME MONTH Table
Monthly calendar information. For use in joining tables to include a time dimension to the report. Use the Time_Month_Key to join.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERM |
The code of the academic term into which the fiscal period falls. Examples: 2003FA (Fall Term 2002-2003), 2003SP (Spring term 2002-2003). |
VARCHAR2 |
6 |
ACADEMIC_TERM_DESCRIPTION |
The description of the academic term into which the fiscal period falls. Examples: "Fall Term 2002-2003" (2003FA), "Spring Term 2002-2003" (2003SP). |
VARCHAR2 |
30 |
ACADEMIC_YEAR |
Academic year |
VARCHAR2 |
4 |
CALENDAR_MONTH |
2 digit month (Example: 02, 12). |
VARCHAR2 |
2 |
CALENDAR_MONTH_NAME |
Long text name of the month (Example: February, December.) |
VARCHAR2 |
10 |
CALENDAR_PERIOD |
Four digit year plus two digit month (Example: 199601, 199910). |
VARCHAR2 |
6 |
CALENDAR_PERIOD_DESCRIPTION |
Text associated with CALENDAR_PERIOD (Example: January 1996, October 1999). |
VARCHAR2 |
30 |
CALENDAR_YEAR |
Four digit year (Example: 1996, 2000). |
VARCHAR2 |
4 |
END_DATE |
Specific to HR_POSITION_DETAIL: For filled positions, End Date equals Appointment End Date. For open-ended appointments, this date is usually 12/31/2999. For Closed Positions, the End Date is the delimit date on the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the latest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the end of the term. For STIP, this is set to the latest date for this account in the term in the stipend distribution section in the RPAGAAID form in MITSIS. UNMATCHED payroll has this set to the latest date in the unmatched Payroll records. In all other tables, END DATE is the thru date of the transaction. |
DATE |
8 |
FINANCIAL_AID_YEAR |
The financial aid year |
VARCHAR2 |
4 |
FINANCIAL_AID_YEAR_DESC |
Description of the financial aid year |
VARCHAR2 |
30 |
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
6 |
FISCAL_PERIOD_DESCRIPTION |
Long text for the fiscal period. (Example: FY 1997 period 9). |
VARCHAR2 |
30 |
FISCAL_PERIOD_SELECTOR |
XXX |
VARCHAR2 |
33 |
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 |
FY_QUARTER_CODE |
XXX |
VARCHAR2 |
10 |
IS_CLOSING_PERIOD |
XXX |
VARCHAR2 |
1 |
IS_CURRENT_FISCAL_PERIOD |
This field is set to "Y" for the current fiscal period, and to "N" for all others. For example, in September 2003, the current fiscal period will be '200403'. Please note that in July, only fiscal period '01' is flagged as current, and not the concurrent closing periods. |
VARCHAR2 |
1 |
IS_CURRENT_FISCAL_YEAR |
XXX |
VARCHAR2 |
1 |
IS_PREVIOUS_FISCAL_PERIOD |
This field is set to "Y" for the fiscal period immediately preceding the current one, and to "N" for all others. For example, in September 2003, the previous fiscal period will be '200402' (August 2003). Please note that closing periods are never marked with "Y". |
VARCHAR2 |
1 |
START_DATE |
The first day of the fiscal period. Specific to HR_POSITION_DETAIL: If the Position is filled, this value equals the appointment begin date of the person filling that position. If the position is unfilled, this value is either the date the last person vacated the position. For new positions that have never been filled, this date is the start date assigned to the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the earliest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the beginning of the term. For STIP, this is set to the earliest date for this account in the term in the stipend distribution section in the RPAGAAID form. UNMATCHED payroll has this set to the earliest date in the unmatched Payroll records. |
DATE |
8 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |