Day Level Calendar
In ScopeTechnical: DAY_LEVEL_CALENDAR | ID: OR-MFCS-DAY_LEVEL_CALENDAR
Table used as reference to help with determining where a transaction fits into the fiscal calendar.
See how this object fits into Foundation Data
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- DAY_LEVEL_CALENDAR
Field Definitions(27)
Rules & Considerations(7)
Sample Load Data(4)
| _scenario | DAYRPK | EOM_DATER | EOW_DATER | DATE_KEY | MCAL_QTR | SOW_DATE | WEEK_KEY | MCAL_YEAR | PERIOD_KEY | MCAL_PERIOD | QUARTER_KEY | NUMBER_OF_WEEKS | DAY_DATE_454_DAY | EOM_DATE_454_DAY | EOW_DATE_454_DAY | MCAL_PERIOD_NAME | DAY_DATE_454_WEEK | DAY_DATE_454_YEAR | EOM_DATE_454_WEEK | EOM_DATE_454_YEAR | EOW_DATE_454_WEEK | EOW_DATE_454_YEAR | MCAL_PERIOD_ST_DT | DAY_DATE_454_MONTH | EOM_DATE_454_MONTH | EOW_DATE_454_MONTH | MCAL_PERIOD_END_DT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2026-01-06 | 2026-01-01 | 2026-01-01 | 1 | 01 | 2026-01-01 | 1 | 00001 | 1 | 1 | 1 | 1 | 01 | 01 | 01 | Day Level Calendar Primary | 01 | 0001 | 01 | 0001 | 01 | 0001 | 2026-01-06 | 01 | 01 | 01 | 2026-01-06 |
default
- DAYRPK
- 2026-01-06
- EOM_DATER
- 2026-01-01
- EOW_DATER
- 2026-01-01
- DATE_KEY
- 1
- MCAL_QTR
- 01
- SOW_DATE
- 2026-01-01
- WEEK_KEY
- 1
- MCAL_YEAR
- 00001
- PERIOD_KEY
- 1
- MCAL_PERIOD
- 1
- QUARTER_KEY
- 1
- NUMBER_OF_WEEKS
- 1
- DAY_DATE_454_DAY
- 01
- EOM_DATE_454_DAY
- 01
- EOW_DATE_454_DAY
- 01
- MCAL_PERIOD_NAME
- Day Level Calendar Primary
- DAY_DATE_454_WEEK
- 01
- DAY_DATE_454_YEAR
- 0001
- EOM_DATE_454_WEEK
- 01
- EOM_DATE_454_YEAR
- 0001
- EOW_DATE_454_WEEK
- 01
- EOW_DATE_454_YEAR
- 0001
- MCAL_PERIOD_ST_DT
- 2026-01-06
- DAY_DATE_454_MONTH
- 01
- EOM_DATE_454_MONTH
- 01
- EOW_DATE_454_MONTH
- 01
- MCAL_PERIOD_END_DT
- 2026-01-06