RSF_RA_PROD_VW(SQL View) |
Index Back |
|---|---|
Product GroupsA view of all Product Groups for Campaign Activity |
| SELECT C.BUSINESS_UNIT , C.RA_CAMPAIGN_ID , C.RA_CMPGN_WAVE_ID , B.SETID ,B.PRODUCT_ID FROM PS_RA_OFFER A , PS_RA_OFFER_PRODCT B , PS_RA_CMPGN_WAVE C WHERE A.SETID = B.SETID AND A.RA_OFFER_ID = B.RA_OFFER_ID AND A.RA_OFFER_ID = C.RA_OFFER_ID AND A.RA_OFFER_STATUS <> 'DECL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RA | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RA_CAMPAIGN_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
| 3 | RA_CMPGN_WAVE_ID | Character(15) | VARCHAR2(15) NOT NULL | Used to uniquely identify a Marketing - Campaign Activity (wave) ID |
| 4 | PROD_SETID | Character(5) | VARCHAR2(5) NOT NULL | Product SET ID |
| 5 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |