SETIDRA_CHNL_EXECUTION010=TeleSales
010=TeleSales
020=Online Dialog
030=Order Capture
040=Fax Correspondence
050=Mail Correspondence
060=Sales Force
070=Advisor
080=Direct Mail
090=Cross Sell
RA_OFFER_IDRA_OFFER_CHN_VW(SQL View) |
Index Back |
|---|---|
Offer by channelView of Offers by channels, used by marketing program campaigns |
| SELECT A.SETID , B.RA_CHNL_EXECUTION , A.RA_OFFER_ID , A.RA_OFFER_NAME FROM PS_RA_OFFER A , PS_RA_OFFER_CHNLS B WHERE A.SETID=B.SETID AND A.RA_OFFER_ID=B.RA_OFFER_ID |
| # | 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. |
| 2 | RA_CHNL_EXECUTION |
Character(3) | VARCHAR2(3) NOT NULL |
Marketing Channel Execution
010=TeleSales 010=TeleSales 020=Online Dialog 030=Order Capture 040=Fax Correspondence 050=Mail Correspondence 060=Sales Force 070=Advisor 080=Direct Mail 090=Cross Sell |
| 3 | RA_OFFER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Marketing Offer ID |
| 4 | RA_OFFER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Marketing Offer Name |