TIME MONTH Table
View exposing enterprise time dimension data at the fiscal month level, including fiscal, calendar, academic, and financial aid attributes, period start and end dates, and current-period indicators used for cross-domain 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. |
VARCHAR2 |
1 |
IS_CURRENT_FISCAL_PERIOD |
Indicator identifying whether the period is the current fiscal period. |
VARCHAR2 |
1 |
IS_CURRENT_FISCAL_YEAR |
Indicator identifying whether the period is within the current fiscal year. |
VARCHAR2 |
1 |
IS_PREVIOUS_FISCAL_PERIOD |
Indicator identifying whether the period is the previous fiscal period. |
VARCHAR2 |
1 |
START_DATE |
Start date of the fiscal period. |
DATE |
|
TIME_MONTH_KEY |
Key identifier representing the fiscal month. |
VARCHAR2 |
6 |