TIME MONTH Table
Stores time dimension data at the fiscal month level, including fiscal, calendar, academic, and financial aid attributes, as well as period indicators used for reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERM |
Academic term code associated with the period. |
VARCHAR2 |
6 |
ACADEMIC_TERM_DESCRIPTION |
Description of the academic term. |
VARCHAR2 |
30 |
ACADEMIC_YEAR |
Academic year associated with the period. |
VARCHAR2 |
4 |
CALENDAR_MONTH |
Numeric month within the calendar year. |
VARCHAR2 |
2 |
CALENDAR_MONTH_NAME |
Name of the calendar month. |
VARCHAR2 |
10 |
CALENDAR_PERIOD |
Calendar period identifier (YYYYMM format). |
VARCHAR2 |
9 |
CALENDAR_PERIOD_DESCRIPTION |
Description of the calendar period. |
VARCHAR2 |
30 |
CALENDAR_YEAR |
Calendar year associated with the period. |
VARCHAR2 |
4 |
END_DATE |
End date of the fiscal period. |
DATE |
|
FINANCIAL_AID_YEAR |
Financial aid year associated with the period. |
VARCHAR2 |
4 |
FINANCIAL_AID_YEAR_DESC |
Description of the financial aid year. |
VARCHAR2 |
30 |
FISCAL_PERIOD |
Fiscal period identifier (YYYYPP format). |
VARCHAR2 |
6 |
FISCAL_PERIOD_DESCRIPTION |
Description of the fiscal period. |
VARCHAR2 |
30 |
FISCAL_PERIOD_SELECTOR |
Concatenated label used for fiscal period selection in reporting. |
VARCHAR2 |
33 |
FISCAL_YEAR |
Fiscal year associated with the period. |
VARCHAR2 |
4 |
FISCAL_YEAR_QUARTER |
Fiscal year and quarter designation. |
VARCHAR2 |
17 |
FY_QUARTER_CODE |
Code identifying the fiscal year and quarter. |
VARCHAR2 |
8 |
IS_CLOSING_PERIOD |
Indicator identifying whether the period is a closing period (Y/N). |
VARCHAR2 |
1 |
IS_CURRENT_FISCAL_PERIOD |
Indicator identifying whether the period is the current fiscal period (Y/N). |
VARCHAR2 |
1 |
IS_CURRENT_FISCAL_YEAR |
Indicator identifying whether the period is within the current fiscal year (Y/N). |
VARCHAR2 |
1 |
IS_PREVIOUS_FISCAL_PERIOD |
Indicator identifying whether the period is the previous fiscal period (Y/N). |
VARCHAR2 |
1 |
START_DATE |
Start date of the fiscal period. |
DATE |
|
TIME_MONTH_KEY |
Key identifier representing the fiscal month. |
VARCHAR2 |
6 |