AAP PLAN YEAR CALENDAR Table
Stores calendar attributes and plan-year date ranges used to map AAP plan years to calendar periods and month keys, including indicators for current/previous fiscal periods and fiscal year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AAP_PLAN_END_DATE |
End date of the AAP plan year. |
DATE |
|
AAP_PLAN_START_DATE |
Start date of the AAP plan year. |
DATE |
|
AAP_PLAN_YEAR |
AAP plan year associated with the calendar mapping. Format typically YYYY. |
VARCHAR2 |
4 |
CALENDAR_MONTH |
Calendar month number for the period. Format: MM. |
VARCHAR2 |
2 |
CALENDAR_MONTH_NAME |
Calendar month name for the period. |
VARCHAR2 |
10 |
CALENDAR_PERIOD |
Calendar period identifier used for reporting (e.g., month/period label). |
VARCHAR2 |
9 |
CALENDAR_PERIOD_DESCRIPTION |
Human-readable description of the calendar period. |
VARCHAR2 |
30 |
CALENDAR_YEAR |
Calendar year for the period. Format: YYYY. |
VARCHAR2 |
4 |
END_DATE |
End date of the calendar period. |
DATE |
|
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 year is 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 calendar period. |
DATE |
|
TIME_MONTH_KEY |
Month key used for joining to time/month dimensions or facts. Format typically YYYYMM. |
VARCHAR2 |
6 |