RI_CMPN_STAT_VW(SQL View) |
Index Back |
|---|---|
Campaign viewThis view return all the campaign waves that are displayed on 360-Degree view node. |
| SELECT CASE WHEN A.ROLE_TYPE_ID = 8 THEN A.BO_ID_COMPANY ELSE A.BO_ID END AS BO_ID_CUST ,CASE WHEN A.ROLE_TYPE_ID = 8 THEN 2 ELSE A.ROLE_TYPE_ID END AS ROLE_TYPE_ID_CUST ,CASE WHEN A.ROLE_TYPE_ID = 8 THEN A.BO_ID ELSE 0 END AS BO_ID_CONTACT ,CASE WHEN A.ROLE_TYPE_ID = 8 THEN A.ROLE_TYPE_ID ELSE 0 END AS ROLE_TYPE_ID_CNTCT ,0 ,B.RA_CMPGN_STATUS_CD ,B.BUSINESS_UNIT ,B.RA_CAMPAIGN_ID ,B.RA_CMPGN_WAVE_ID ,B.RA_WAVE_NAME ,B.RA_PRIORITY ,D.DESCR ,S.OPRID ,0 ,0 ,0 ,0 , %subrec(RB_AUDIT_SBR,B) FROM PS_RA_LIST_REC A , PS_RA_CMPGN_WAVE B , PS_SET_CNTRL_REC C , PS_RA_UD_CPGN_STAT D , PS_RA_CMP_SCRTY_VW S WHERE B.RA_CMPGN_STATUS_CD = D.RA_CMPGN_STATUS_CD AND D.SETID= A.SETID AND A.RA_LIST_ID = B.RA_LIST_ID AND A.SETID = C.SETID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.RECNAME = 'RA_LIST_REC' AND B.RA_CMPGN_STATUS_CD = 'EXEC' AND A.DELETED_FLG = 'N' AND B.BUSINESS_UNIT = S.BUSINESS_UNIT AND B.RA_CAMPAIGN_ID=S.RA_CAMPAIGN_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID_CUST |
Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 2 | ROLE_TYPE_ID_CUST |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 3 | BO_ID_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 4 | ROLE_TYPE_ID_CNTCT |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 5 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 6 | RA_CMPGN_STATUS_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Valid Campaign and Wave Status Codes
APPR=Approved ARCH=Archived CMPL=Completed DCLN=Declined EXEC=Executing IREV=In Review NEW=New STOP=Stop TRIG=Trigger Approved |
| 7 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | 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. |
| 9 | RA_CMPGN_WAVE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to uniquely identify a Marketing - Campaign Activity (wave) ID |
| 10 | RA_WAVE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry. |
| 11 | RA_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Marketing - campaign wave content task priority
1=High Priority 2=Medium Priority 3=Low Priority |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 14 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 15 | ROLE_TYPE_ID_PART | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner |
| 16 | BO_ID_PART_CONT | Signed Number(32,0) | DECIMAL(31) NOT NULL | This is the business object identifier for the partner contact. |
| 17 | ROLE_TYPE_ID_PARTC | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner contact |
| 18 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 19 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 20 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 21 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 22 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 23 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |