PERSON_IDBUSINESS_UNITRA_CAMPAIGN_IDRA_CMPGN_WAVE_IDRC_OB_CWAGT_VW(SQL View) |
Index Back |
|---|---|
Outbound Call Cmpgn Wave TeamOutbound Marketing - Outbound call campaign activity team |
| SELECT DISTINCT(B.PERSON_ID) , A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , B.SETID , D.BO_NAME , 0 , 0 FROM PS_RA_CMPGN_WAVE A , PS_RF_GRP_MEMBER B , PS_SET_CNTRL_REC C , PS_BO_NAME D , PS_RD_PERSON E , PS_RA_UD_CHNL_TYPE G , PS_SET_CNTRL_REC SC WHERE A.RA_CMPGN_STATUS_CD = 'EXEC' AND SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.RECNAME = 'RA_UD_CHNL_TYPE' AND G.SETID = SC.SETID AND A.RA_CHANNEL_TYPE = G.RA_CHANNEL_TYPE AND G.RA_CHNL_EXECUTION = '010' AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'RF_GRP_MEMBER' AND C.SETID = B.SETID AND E.PERSON_ID = B.PERSON_ID AND E.BO_ID = D.BO_ID AND D.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | 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. |
| 4 | RA_CMPGN_WAVE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to uniquely identify a Marketing - Campaign Activity (wave) ID |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 6 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 7 | RC_COMPLETED_CALL | Number(8,0) | INTEGER NOT NULL | Outbound Marketing |
| 8 | RC_CALLS_LEFT | Number(8,0) | INTEGER NOT NULL | Calls Remaining |