RA_PROGRAMS_VW3(SQL View) |
Index Back |
---|---|
Marketing Programs - EVENTSsummary of all marketing EVENT programs, used in the calendar component |
SELECT A.BUSINESS_UNIT , B.RAE_EVENT_ID , A.RA_PROGRAM_TYPE , A.RA_ROLLUP_CMPGN_ID , B.RAE_EVENT_NAME , B.RAE_EVENTSTATUS_CD , B.RA_OBJECTIVE_CD , B.BO_ID_OWNER , B.START_DATE , B.END_DATE , 0 , 0 , %TrimSubstr(A.RA_ROLLUP_CMPGN_ID,1,15) %Concat A.RA_CAMPAIGN_ID FROM PS_RA_PROGRAM_TBL A , PS_RAE_EVENT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RAE_EVENT_ID |
# | 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_PROGRAM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Marketing Program type - field that contains valid program types used in marketing, such as Campaigns, Roll ups, Dialogs and Trade Promotions
CMP=Campaign DLG=Dialog EVT=Event RLU=Roll up |
4 | RA_ROLLUP_CMPGN_ID | Character(15) | VARCHAR2(15) NOT NULL | Campaign - Roll Up (Parent) Campaign Identification |
5 | RA_CMPGN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Name - field containing the name of the campaign. |
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 | RA_OBJECTIVE_CD | Character(4) | VARCHAR2(4) NOT NULL | Objective code of the campaign |
8 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL | Financial Account Business Object ID |
9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
10 | END_DATE | Date(10) | DATE | End date field to store an end date. |
11 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
12 | ROW_NUM | Number(3,0) | SMALLINT NOT NULL | This field is used to specify the row number. |
13 | SORTFIELD | Character(40) | VARCHAR2(40) NOT NULL | Sort Field |