Day Level Calendar
In ScopeTechnical: DAY_LEVEL_CALENDAR | ID: OR-FND-DAY_LEVEL_CALENDAR-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- DAY_LEVEL_CALENDAR
Field Definitions(5)
Rules & Considerations(25)
constraint
validation
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1 | 1 | 2026-01-01 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1 | 1 | 2026-01-01 | 1 | 1 | 1 | 2026-01-01 |
| default | 2026-02-09 | 2026-01-03 | 2026-01-03 | 3 | 3 | 2026-01-03 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Day Level Calendar S | 3 | 3 | 3 | 3 | 3 | 3 | 2026-02-09 | 3 | 3 | 3 | 2026-02-09 |
| default | 2026-03-12 | 2026-01-05 | 2026-01-05 | 5 | 5 | 2026-01-05 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Day Level Calendar C | 5 | 5 | 5 | 5 | 5 | 5 | 2026-03-12 | 5 | 5 | 5 | 2026-03-12 |
Example values from field definitions
- DAYRPK
- 2026-01-01
- EOM_DATER
- 2026-01-01
- EOW_DATER
- 2026-01-01
- DATE_KEY
- 1
- MCAL_QTR
- 1
- SOW_DATE
- 2026-01-01
- WEEK_KEY
- 1
- MCAL_YEAR
- 1
- PERIOD_KEY
- 1
- MCAL_PERIOD
- 1
- QUARTER_KEY
- 1
- NUMBER_OF_WEEKS
- 1
- DAY_DATE_454_DAY
- 1
- EOM_DATE_454_DAY
- 1
- EOW_DATE_454_DAY
- 1
- MCAL_PERIOD_NAME
- SAMPLE
- DAY_DATE_454_WEEK
- 1
- DAY_DATE_454_YEAR
- 1
- EOM_DATE_454_WEEK
- 1
- EOM_DATE_454_YEAR
- 1
- EOW_DATE_454_WEEK
- 1
- EOW_DATE_454_YEAR
- 1
- MCAL_PERIOD_ST_DT
- 2026-01-01
- DAY_DATE_454_MONTH
- 1
- EOM_DATE_454_MONTH
- 1
- EOW_DATE_454_MONTH
- 1
- MCAL_PERIOD_END_DT
- 2026-01-01
default
- DAYRPK
- 2026-02-09
- EOM_DATER
- 2026-01-03
- EOW_DATER
- 2026-01-03
- DATE_KEY
- 3
- MCAL_QTR
- 3
- SOW_DATE
- 2026-01-03
- WEEK_KEY
- 3
- MCAL_YEAR
- 3
- PERIOD_KEY
- 3
- MCAL_PERIOD
- 3
- QUARTER_KEY
- 3
- NUMBER_OF_WEEKS
- 3
- DAY_DATE_454_DAY
- 3
- EOM_DATE_454_DAY
- 3
- EOW_DATE_454_DAY
- 3
- MCAL_PERIOD_NAME
- Day Level Calendar S
- DAY_DATE_454_WEEK
- 3
- DAY_DATE_454_YEAR
- 3
- EOM_DATE_454_WEEK
- 3
- EOM_DATE_454_YEAR
- 3
- EOW_DATE_454_WEEK
- 3
- EOW_DATE_454_YEAR
- 3
- MCAL_PERIOD_ST_DT
- 2026-02-09
- DAY_DATE_454_MONTH
- 3
- EOM_DATE_454_MONTH
- 3
- EOW_DATE_454_MONTH
- 3
- MCAL_PERIOD_END_DT
- 2026-02-09
default
- DAYRPK
- 2026-03-12
- EOM_DATER
- 2026-01-05
- EOW_DATER
- 2026-01-05
- DATE_KEY
- 5
- MCAL_QTR
- 5
- SOW_DATE
- 2026-01-05
- WEEK_KEY
- 5
- MCAL_YEAR
- 5
- PERIOD_KEY
- 5
- MCAL_PERIOD
- 5
- QUARTER_KEY
- 5
- NUMBER_OF_WEEKS
- 5
- DAY_DATE_454_DAY
- 5
- EOM_DATE_454_DAY
- 5
- EOW_DATE_454_DAY
- 5
- MCAL_PERIOD_NAME
- Day Level Calendar C
- DAY_DATE_454_WEEK
- 5
- DAY_DATE_454_YEAR
- 5
- EOM_DATE_454_WEEK
- 5
- EOM_DATE_454_YEAR
- 5
- EOW_DATE_454_WEEK
- 5
- EOW_DATE_454_YEAR
- 5
- MCAL_PERIOD_ST_DT
- 2026-03-12
- DAY_DATE_454_MONTH
- 5
- EOM_DATE_454_MONTH
- 5
- EOW_DATE_454_MONTH
- 5
- MCAL_PERIOD_END_DT
- 2026-03-12
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 25