SING TIME MONTH Table
View exposing Singapore time month reference records including fiscal and calendar period attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CALENDAR_MONTH |
Calendar month associated with the record. |
VARCHAR2 |
2 |
CALENDAR_MONTH_NAME |
Calendar month name associated with the record. |
VARCHAR2 |
10 |
CALENDAR_PERIOD |
Calendar period associated with the record. |
VARCHAR2 |
6 |
CALENDAR_PERIOD_DESCRIPTION |
Description of calendar period. |
VARCHAR2 |
30 |
CALENDAR_YEAR |
Calendar year associated with the record. |
VARCHAR2 |
4 |
END_DATE |
Date associated with end. |
DATE |
|
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
6 |
FISCAL_PERIOD_DESCRIPTION |
Description of fiscal period. |
VARCHAR2 |
30 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FISCAL_YEAR_QUARTER |
Fiscal year quarter associated with the record. |
VARCHAR2 |
17 |
IS_CURRENT_FISCAL_PERIOD |
Indicator identifying whether current fiscal period (Y/N). |
VARCHAR2 |
1 |
IS_PREVIOUS_FISCAL_PERIOD |
Indicator identifying whether previous fiscal period (Y/N). |
VARCHAR2 |
1 |
START_DATE |
Date associated with start. |
DATE |
|
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |