RPM Price Event Payload
In ScopeTechnical: RPM_PRICE_EVENT_PAYLOAD | ID: OR-PRC-RPM_PRICE_EVENT_PAYLOAD-RPM_PRICE_EVENT_PAYLOAD
table to hold all base payload information table is populated for every payload.
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_PRICE_EVENT_PAYLOAD
Field Definitions(5)
Rules & Considerations(25)
constraint
validation
Sample Load Data(4)
| _scenario | MSG_TYPER | MSG_FAMILYR | PUBLISH_STATUSR | PRICE_EVENT_PAYLOAD_IDRPK | RIB_TYPE | RIB_FAMILY | PUBLISH_DATE | BULK_CC_PE_ID | THREAD_NUMBER | TRANSACTION_ID | JSON_CACHED_DATE | RDE_EXTRACT_DATE | JSON_CACHED_STATUS | RDE_EXTRACT_STATUS | SIOCS_EXTRACT_DATE | PARENT_THREAD_NUMBER | SIOCS_EXTRACT_STATUS | FLAT_FILE_EXTRACT_DATE | FLAT_FILE_EXTRACT_STATUS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 2026-01-01 | 1 | 1 | 1 | 2026-01-01 | 2026-01-01 | 1 | 1 | 2026-01-01 | 1 | 1 | 2026-01-01 | 1 |
| default | RPM Price Event Payload-002-AL | RPM Price Event Payload-002-AL | 3 | 1000000003 | — | — | 2026-01-03 | 1000000003 | 3 | — | 2026-01-03 | 2026-01-03 | 3 | 3 | 2026-01-03 | 3 | 3 | 2026-01-03 | 1 |
| default | RPM Price Event Payload-003-ED | RPM Price Event Payload-003-ED | 5 | 1000000005 | — | — | 2026-01-05 | 1000000005 | 5 | — | 2026-01-05 | 2026-01-05 | 5 | 5 | 2026-01-05 | 5 | 5 | 2026-01-05 | 0 |
Example values from field definitions
- MSG_TYPER
- SAMPLE
- MSG_FAMILYR
- SAMPLE
- PUBLISH_STATUSR
- 1
- PRICE_EVENT_PAYLOAD_IDRPK
- 1
- RIB_TYPE
- SAMPLE
- RIB_FAMILY
- SAMPLE
- PUBLISH_DATE
- 2026-01-01
- BULK_CC_PE_ID
- 1
- THREAD_NUMBER
- 1
- TRANSACTION_ID
- 1
- JSON_CACHED_DATE
- 2026-01-01
- RDE_EXTRACT_DATE
- 2026-01-01
- JSON_CACHED_STATUS
- 1
- RDE_EXTRACT_STATUS
- 1
- SIOCS_EXTRACT_DATE
- 2026-01-01
- PARENT_THREAD_NUMBER
- 1
- SIOCS_EXTRACT_STATUS
- 1
- FLAT_FILE_EXTRACT_DATE
- 2026-01-01
- FLAT_FILE_EXTRACT_STATUS
- 1
default
- MSG_TYPER
- RPM Price Event Payload-002-AL
- MSG_FAMILYR
- RPM Price Event Payload-002-AL
- PUBLISH_STATUSR
- 3
- PRICE_EVENT_PAYLOAD_IDRPK
- 1000000003
- RIB_TYPE
- —
- RIB_FAMILY
- —
- PUBLISH_DATE
- 2026-01-03
- BULK_CC_PE_ID
- 1000000003
- THREAD_NUMBER
- 3
- TRANSACTION_ID
- —
- JSON_CACHED_DATE
- 2026-01-03
- RDE_EXTRACT_DATE
- 2026-01-03
- JSON_CACHED_STATUS
- 3
- RDE_EXTRACT_STATUS
- 3
- SIOCS_EXTRACT_DATE
- 2026-01-03
- PARENT_THREAD_NUMBER
- 3
- SIOCS_EXTRACT_STATUS
- 3
- FLAT_FILE_EXTRACT_DATE
- 2026-01-03
- FLAT_FILE_EXTRACT_STATUS
- 1
default
- MSG_TYPER
- RPM Price Event Payload-003-ED
- MSG_FAMILYR
- RPM Price Event Payload-003-ED
- PUBLISH_STATUSR
- 5
- PRICE_EVENT_PAYLOAD_IDRPK
- 1000000005
- RIB_TYPE
- —
- RIB_FAMILY
- —
- PUBLISH_DATE
- 2026-01-05
- BULK_CC_PE_ID
- 1000000005
- THREAD_NUMBER
- 5
- TRANSACTION_ID
- —
- JSON_CACHED_DATE
- 2026-01-05
- RDE_EXTRACT_DATE
- 2026-01-05
- JSON_CACHED_STATUS
- 5
- RDE_EXTRACT_STATUS
- 5
- SIOCS_EXTRACT_DATE
- 2026-01-05
- PARENT_THREAD_NUMBER
- 5
- SIOCS_EXTRACT_STATUS
- 5
- FLAT_FILE_EXTRACT_DATE
- 2026-01-05
- FLAT_FILE_EXTRACT_STATUS
- 0
Rule Validation Summary
- Source Rule Count
- 29
- Governed Rule Count
- 25