Campaign
In ScopeTechnical: RPM_PROMO_CAMPAIGN | ID: OR-PRC-RPM_PROMO_CAMPAIGN-RPM_PROMO_CAMPAIGN
This table is used to store all campaign.
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_PROMO_CAMPAIGN
Field Definitions(5)
Rules & Considerations(15)
validation
constraint
Sample Load Data(4)
| _scenario | CREATE_IDR | CAMPAIGN_IDRPK | CAMPAIGN_DESCR | CAMPAIGN_NAMER | CREATE_DATETIMER | LAST_UPDATE_ID | OBJECT_VERSION_ID | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1 | 2026-01-01 |
| default | APP_USER_ID | 1000000003 | RPM Promo Campaign-002-ALT | RPM Promo Campaign Secondary | 2026-01-03 | APP_USER_ID | 1000000003 | 2026-01-03 |
| default | USERENV | 1000000005 | RPM Promo Campaign-003-EDGE | RPM Promo Campaign Core | 2026-01-05 | USERENV | 1000000005 | 2026-01-05 |
Example values from field definitions
- CREATE_IDR
- SAMPLE
- CAMPAIGN_IDRPK
- 1
- CAMPAIGN_DESCR
- SAMPLE
- CAMPAIGN_NAMER
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- OBJECT_VERSION_ID
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- CREATE_IDR
- APP_USER_ID
- CAMPAIGN_IDRPK
- 1000000003
- CAMPAIGN_DESCR
- RPM Promo Campaign-002-ALT
- CAMPAIGN_NAMER
- RPM Promo Campaign Secondary
- CREATE_DATETIMER
- 2026-01-03
- LAST_UPDATE_ID
- APP_USER_ID
- OBJECT_VERSION_ID
- 1000000003
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- CREATE_IDR
- USERENV
- CAMPAIGN_IDRPK
- 1000000005
- CAMPAIGN_DESCR
- RPM Promo Campaign-003-EDGE
- CAMPAIGN_NAMER
- RPM Promo Campaign Core
- CREATE_DATETIMER
- 2026-01-05
- LAST_UPDATE_ID
- USERENV
- OBJECT_VERSION_ID
- 1000000005
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 20
- Governed Rule Count
- 15