One Row For Each Geographic Region
In ScopeTechnical: REGION | ID: OR-FND-REGION-REGION
Stores one row for each geographic region within the company.
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
- REGION
Field Definitions(5)
Rules & Considerations(20)
constraint
validation
Sample Load Data(4)
| _scenario | AREAR | REGIONRPK | REGION_NAMER | MGR_NAME | CREATE_ID | CURRENCY_CODE | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | 103 | 203 | Region Secondary | Region Secondary | APP_USER_ID | ALT | APP_USER_ID | 2026-01-03 | 2026-01-03 |
| default | 105 | 205 | Region Core | Region Core | USERENV | EDG | USERENV | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- AREAR
- 1
- REGIONRPK
- 1
- REGION_NAMER
- SAMPLE
- MGR_NAME
- SAMPLE
- CREATE_ID
- SAMPLE
- CURRENCY_CODE
- SAM
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- AREAR
- 103
- REGIONRPK
- 203
- REGION_NAMER
- Region Secondary
- MGR_NAME
- Region Secondary
- CREATE_ID
- APP_USER_ID
- CURRENCY_CODE
- ALT
- LAST_UPDATE_ID
- APP_USER_ID
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- AREAR
- 105
- REGIONRPK
- 205
- REGION_NAMER
- Region Core
- MGR_NAME
- Region Core
- CREATE_ID
- USERENV
- CURRENCY_CODE
- EDG
- LAST_UPDATE_ID
- USERENV
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 33
- Governed Rule Count
- 20