RPM Purge Configuration Options
In ScopeTechnical: RPM_PURGE_CONFIG_OPTIONS | ID: OR-PRC-RPM_PURGE_CONFIG_OPTIONS-RPM_PURGE_CONFIGURATION_OPTIONS
This table hold system level configurations for data retention.
See how this object fits into Pricing & Promotions
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
- RPM_PURGE_CONFIG_OPTIONS
Field Definitions(5)
Rules & Considerations(20)
validation
constraint
Sample Load Data(4)
| _scenario | CREATE_IDR | CREATE_DATETIMER | CLEARANCE_HIST_MONTHSR | PROMOTION_HIST_MONTHSR | PRICE_EVENTS_REJECT_HOLD_DAYSR | LAST_UPDATE_ID | OBJECT_VERSION_ID | HIST_DATA_PURGE_DAYS | LAST_UPDATE_DATETIME | BATCH_PROCESS_HIST_DAYS | PRICE_CHANGE_HIST_MONTHS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 2026-01-01 | 1 | 1 | 1 | SAMPLE | 1 | 1 | 2026-01-01 | 1 | 1 |
| default | APP_USER_ID | 2026-01-03 | 3 | 3 | 3 | APP_USER_ID | 1000000003 | 3 | 2026-01-03 | 3 | 3 |
| default | USERENV | 2026-01-05 | 5 | 5 | 5 | USERENV | 1000000005 | 5 | 2026-01-05 | 5 | 5 |
Example values from field definitions
- CREATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- CLEARANCE_HIST_MONTHSR
- 1
- PROMOTION_HIST_MONTHSR
- 1
- PRICE_EVENTS_REJECT_HOLD_DAYSR
- 1
- LAST_UPDATE_ID
- SAMPLE
- OBJECT_VERSION_ID
- 1
- HIST_DATA_PURGE_DAYS
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- BATCH_PROCESS_HIST_DAYS
- 1
- PRICE_CHANGE_HIST_MONTHS
- 1
default
- CREATE_IDR
- APP_USER_ID
- CREATE_DATETIMER
- 2026-01-03
- CLEARANCE_HIST_MONTHSR
- 3
- PROMOTION_HIST_MONTHSR
- 3
- PRICE_EVENTS_REJECT_HOLD_DAYSR
- 3
- LAST_UPDATE_ID
- APP_USER_ID
- OBJECT_VERSION_ID
- 1000000003
- HIST_DATA_PURGE_DAYS
- 3
- LAST_UPDATE_DATETIME
- 2026-01-03
- BATCH_PROCESS_HIST_DAYS
- 3
- PRICE_CHANGE_HIST_MONTHS
- 3
default
- CREATE_IDR
- USERENV
- CREATE_DATETIMER
- 2026-01-05
- CLEARANCE_HIST_MONTHSR
- 5
- PROMOTION_HIST_MONTHSR
- 5
- PRICE_EVENTS_REJECT_HOLD_DAYSR
- 5
- LAST_UPDATE_ID
- USERENV
- OBJECT_VERSION_ID
- 1000000005
- HIST_DATA_PURGE_DAYS
- 5
- LAST_UPDATE_DATETIME
- 2026-01-05
- BATCH_PROCESS_HIST_DAYS
- 5
- PRICE_CHANGE_HIST_MONTHS
- 5
Rule Validation Summary
- Source Rule Count
- 25
- Governed Rule Count
- 20