Calendar Mapping
The calendar hierarchy data is loaded from the CALENDAR.csv file or from RMFCS. The calendar must be a
fiscal calendar (such as 4-4-5 or 4-5-4). The primary data warehouse table having day-level data is W_MCAL_DAY_D. AIF DATA jobs automatically generate the calendar using the start/end dates for the fiscal periods in the input file. AIF
DATA jobs also generate an internal Gregorian calendar at the same time the fiscal calendar is loaded, and this data is exported
alongside the fiscal calendar for extensions and customizations.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
Day Date |
W_PDS_CALENDAR_D |
DAY |
W_MCAL_DAY_D.MCAL_DAY_DT |
|
Week Ending Date |
W_PDS_CALENDAR_D |
WEEK |
W_MCAL_DAY_D.MCAL_WEEK_END_DT |
|
Month Number |
W_PDS_CALENDAR_D |
MONTH |
W_MCAL_DAY_D.MCAL_PERIOD |
|
Quarter Number |
W_PDS_CALENDAR_D |
QUARTER |
W_MCAL_DAY_D.MCAL_QTR |
|
Half Year Number |
W_PDS_CALENDAR_D |
HALF |
CASE WHEN W_MCAL_DAY_D.MCAL_QTR <= 2 THEN 1 ELSE 2 END |
|
Year Number |
W_PDS_CALENDAR_D |
YEAR |
W_MCAL_DAY_D.MCAL_YEAR |
|
Week of Year |
W_PDS_CALENDAR_D |
WEEK_OF_YEAR |
W_MCAL_DAY_D.MCAL_WEEK_OF_YEAR |
|
Day of Week |
W_PDS_CALENDAR_D |
DAY_OF_WEEK |
W_MCAL_DAY_D.MCAL_DAY_OF_WEEK |
|
Gregorian Day of Week |
W_PDS_CALENDAR_D |
GREG_DAY_OF_WEEK |
W_MCAL_DAY_D.CAL_DAY_OF_THE_WEEK_CODE |
|
Gregorian Day of Month |
W_PDS_CALENDAR_D |
GREG_DAY_OF_MONTH |
W_MCAL_DAY_D.CAL_DAY_OF_MONTH |
|
Gregorian Day of Year |
W_PDS_CALENDAR_D |
GREG_DAY_OF_YEAR |
W_MCAL_DAY_D.CAL_DAY_OF_YEAR |
|
Gregorian Week ID |
W_PDS_CALENDAR_D |
GREG_WEEK_ID |
W_MCAL_DAY_D.CAL_WEEK_WID |
|
Gregorian Week Ending Date |
W_PDS_CALENDAR_D |
GREG_WEEK_END_DT |
W_MCAL_DAY_D.CAL_WEEK_END_DT |
|
Gregorian Week Name |
W_PDS_CALENDAR_D |
GREG_WEEK_NAME |
W_MCAL_DAY_D.CAL_WEEK_NAME |
|
GregorianMonth ID |
W_PDS_CALENDAR_D |
GREG_MONTH_ID |
W_MCAL_DAY_D.CAL_MONTH_WID |
|
Gregorian Month of Year |
W_PDS_CALENDAR_D |
GREG_MONTH |
W_MCAL_DAY_D.CAL_MONTH |
|
Gregorian Month Ending Date |
W_PDS_CALENDAR_D |
GREG_MONTH_END_DT |
W_MCAL_DAY_D.CAL_MONTH_END_DT |
|
Gregorian Month Name |
W_PDS_CALENDAR_D |
GREG_MONTH_NAME |
W_MCAL_DAY_D.W_CAL_MONTH_CODE |
|
Gregorian Quarter ID |
W_PDS_CALENDAR_D |
GREG_QTR_ID |
W_MCAL_DAY_D.CAL_QTR_WID |
|
Gregorian Quarter of Year |
W_PDS_CALENDAR_D |
GREG_QTR |
W_MCAL_DAY_D.CAL_QTR |
|
Gregorian Quarter Ending Date |
W_PDS_CALENDAR_D |
GREG_QTR_END_DT |
W_MCAL_DAY_D.CAL_QTR_END_DT |
|
Gregorian Quarter Name |
W_PDS_CALENDAR_D |
GREG_QTR_NAME |
W_MCAL_DAY_D.CAL_QTR_NAME |
|
Gregorian Half of Year |
W_PDS_CALENDAR_D |
GREG_HALF |
W_MCAL_DAY_D.CAL_HALF |
|
Gregorian Half Name |
W_PDS_CALENDAR_D |
GREG_HALF_NAME |
W_MCAL_DAY_D.CAL_HALF_NAME |
|
Gregorian Year |
W_PDS_CALENDAR_D |
GREG_YEAR |
W_MCAL_DAY_D.CAL_YEAR |
|
Gregorian Year Ending Date |
W_PDS_CALENDAR_D |
GREG_YEAR_END_DT |
W_MCAL_DAY_D.CAL_YEAR_END_DT |
|
Gregorian Half of Year ID |
W_PDS_CALENDAR_D |
GREG_HALF_ID |
W_MCAL_DAY_D.CAL_YEAR || W_MCAL_DAY_D.CAL_HALF |