BUSINESS_UNITRA_CAMPAIGN_IDRA_CMPGN_WAVE_IDRA_CMPACTNTE_VW(SQL View) |
Index Back |
|---|---|
Activity NoteCampaign Activity Note View used on campaign activtiy detail page |
| SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , B.NOTE_SEQ_NBR , A.RA_WAVE_NAME , B.RA_NOTE_SUMMARY ,B.ROW_ADDED_OPRID ,B.ROW_ADDED_DTTM ,C.BO_NAME_DISPLAY FROM PS_RA_CMPGN_WAVE A , PS_RA_CMPGN_NOTE B , PS_RD_PERSON_NAME C , PSOPRALIAS D WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID=B.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID =B.RA_CMPGN_WAVE_ID AND RA_TYPE='WAVE' AND B.ROW_ADDED_OPRID=D.OPRID AND D.PERSON_ID=C.PERSON_ID AND C.PRIMARY_IND='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
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 | NOTE_SEQ_NBR | Number(6,0) | INTEGER NOT NULL | Note ID |
| 5 | 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. |
| 6 | RA_NOTE_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Note summary field |
| 7 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 8 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 9 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |