RA_OFFER_ADD(SQL View) |
Index Back |
---|---|
View for Offer AddInclude the offer type in Offer Add from Marketing Campaign process |
SELECT O.SETID , O.RA_OFFER_ID , O.RA_OFFER_TYPE FROM PS_RA_OFFER O |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
2 | RA_OFFER_ID | Character(15) | VARCHAR2(15) NOT NULL |
Marketing Offer ID
Default Value: NEXT |
3 | RA_OFFER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Offer type is used to differentiate between Communication and Promotional Discount offers
C=Communication P=Promotional Discount |