BUSINESS_UNIT_RARA_CAMPAIGN_IDDefault Value: NEXT
APPR=Approved
ARCH=Archived
CMPL=Completed
DCLN=Declined
EXEC=Executing
IREV=In Review
NEW=New
STOP=Stop
TRIG=Trigger Approved
Default Value: OPEN
Prompt Table: RA_UD_CPGN_STAT
RSF_CAMPAIGN_VW(SQL View) |
Index Back |
|---|---|
Marketing Campaign Record |
| SELECT BUSINESS_UNIT , RA_CAMPAIGN_ID , RA_CMPGN_NAME , RA_CMPGN_STATUS_CD , START_DATE , END_DATE FROM PS_RA_CAMPAIGN WHERE START_DATE <= %CurrentDateIn AND END_DATE >= %CurrentDateIn AND RA_CMPGN_STATUS_CD IN ('EXEC', 'CMPL', 'STOP') |
| # | 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.
Default Value: NEXT |
| 3 | RA_CMPGN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Name - field containing the name of the campaign. |
| 4 | 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 Default Value: OPEN Prompt Table: RA_UD_CPGN_STAT |
| 5 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 6 | END_DATE | Date(10) | DATE | End date field to store an end date. |