RPM Service Promo Id Helper (GTT)

Out of Scope

Technical: RPM_SVC_PROMO_ID_HELPER_GTT | ID: OR-PRC-RPM_SVC_PROMO_ID_HELPER_GTT-RPM_SVC_PROMO_ID_HELPER_GTT

This is a helper table to store all IDs for promotions table.

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: gtt

Target Structure

Load Approach: Table
Target Objects: RPM_SVC_PROMO_ID_HELPER_GTT

Field Definitions(5)

Rules & Considerations(8)

Sample Load Data(4)

_scenario	OFFER_ID	PROMO_ID	TEMPLATE_ID	OFFER_END_DATE	NEW_OFFER_BATCH	NEW_PROMO_BATCH	OFFER_REWARD_ID	OFFER_DISPLAY_ID	OFFER_START_DATE	PROMO_DISPLAY_ID
Example values from field definitions	1	1	1	2026-01-01	1	1	1	1	2026-01-01	1
default	1000000003	1000000003	100003	2026-01-03	3	3	1000000003	1000000003	2026-01-03	1000000003
default	1000000005	1000000005	100005	2026-01-05	5	5	1000000005	1000000005	2026-01-05	1000000005

Example values from field definitions

OFFER_ID: 1
PROMO_ID: 1
TEMPLATE_ID: 1
OFFER_END_DATE: 2026-01-01
NEW_OFFER_BATCH: 1
NEW_PROMO_BATCH: 1
OFFER_REWARD_ID: 1
OFFER_DISPLAY_ID: 1
OFFER_START_DATE: 2026-01-01
PROMO_DISPLAY_ID: 1

default

OFFER_ID: 1000000003
PROMO_ID: 1000000003
TEMPLATE_ID: 100003
OFFER_END_DATE: 2026-01-03
NEW_OFFER_BATCH: 3
NEW_PROMO_BATCH: 3
OFFER_REWARD_ID: 1000000003
OFFER_DISPLAY_ID: 1000000003
OFFER_START_DATE: 2026-01-03
PROMO_DISPLAY_ID: 1000000003

default

OFFER_ID: 1000000005
PROMO_ID: 1000000005
TEMPLATE_ID: 100005
OFFER_END_DATE: 2026-01-05
NEW_OFFER_BATCH: 5
NEW_PROMO_BATCH: 5
OFFER_REWARD_ID: 1000000005
OFFER_DISPLAY_ID: 1000000005
OFFER_START_DATE: 2026-01-05
PROMO_DISPLAY_ID: 1000000005

Rule Validation Summary

Source Rule Count: 11
Governed Rule Count: 8