RA_TRIGGER_VW1

(SQL View)
 Index Back

Marketing Trigger View 1

View of Trigger records on campaigns whose status is EXEC whose campaign wave status is not (OPEN or IREV) and whose START DATE of the trigger is less than or equal to the current date View was designed originally for use by App Engine program to process campaign management triggers.

SELECT DISTINCT A.BUSINESS_UNIT ,A.RA_CAMPAIGN_ID ,A.RA_TRIGGER_ID ,A.RA_TRIGGER_NAME ,A.RA_TRG_ACT_TYPE ,A.RA_TRG_MTMT_M1 ,A.RA_TRG_MTMT_OPR ,A.RA_TRG_MTMT_M2 ,A.RA_TRG_MTMT_CMP1 ,A.RA_TRG_MTMT_WAV1 ,A.RA_TRG_MTMT_CMP2 ,A.RA_TRG_MTMT_WAV2 ,A.RA_TRG_MTVL_M1 ,A.RA_TRG_MTVL_OPR ,A.RA_TRG_MTVL_VALX ,A.RA_TRG_MTVL_CMP1 ,A.RA_TRG_MTVL_WAV1 ,A.RA_TRG_DATE_DT ,A.RA_TRG_DATE_TM ,A.RA_TRG_MECA_SQL ,A.RA_TRG_ACT_EXEC_SW ,A.RA_TRG_ACT_EXEC_ID ,A.RA_TRG_ACT_EXECWID ,A.RA_EXEC_DONE_FLAG ,A.RA_TRG_ACT_STOP_SW ,A.RA_TRG_ACT_STOP_ID ,A.RA_TRG_ACT_STOPWID ,A.RA_STOP_DONE_FLAG ,A.RA_TRG_ACT_SEND_SW ,A.RA_TRG_ACT_SEND_ID ,A.RA_SEND_DONE_FLAG ,A.RA_TRG_ACT_LIST_SW ,A.RA_TRG_ACT_LIST_ID ,A.RA_LIST_DONE_FLAG ,A.START_DATE ,A.END_DATE ,A.SCHEDULE ,A.DONE_FLAG ,A.BO_ID ,A.BO_ROLE_TYPE_ID ,A.RA_EXEC_COUNT ,A.RA_LAST_EXEC_DT ,A.RA_REOCCURS_SW FROM PS_RA_TRIGGER A , PS_RA_CAMPAIGN B , PS_RA_CMPGN_WAVE C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND A.START_DATE <= %CurrentDateIn AND %CurrentDateIn <= A.END_DATE AND A.DONE_FLAG <> 'Y' AND A.RA_LAST_EXEC_DT < %CurrentDateIn AND B.RA_CMPGN_STATUS_CD ='EXEC' AND B.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_ID AND C.RA_CMPGN_STATUS_CD <> 'NEW' AND C.RA_CMPGN_STATUS_CD <> 'IREV'

# 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_TRIGGER_ID Character(15) VARCHAR2(15) NOT NULL Trigger ID
4 RA_TRIGGER_NAME Character(50) VARCHAR2(50) NOT NULL Trigger Name
5 RA_TRG_ACT_TYPE Character(4) VARCHAR2(4) NOT NULL Campaign - trigger type
DATE=Date and Time
MTMT=Metric to Metric
MTVL=Metric to Value
6 RA_TRG_MTMT_M1 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 1
7 RA_TRG_MTMT_OPR Character(4) VARCHAR2(4) NOT NULL Triggers, Metric to Metric Operator
*=Multiply
+=Plus
-=Minus
/=Divide
<=Less than
<==Less than or Equal to
<>=Not Equal to
==Equal to
>=Greater than
>==Greater than or Equal to
8 RA_TRG_MTMT_M2 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 2
9 RA_TRG_MTMT_CMP1 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 1 campaign
10 RA_TRG_MTMT_WAV1 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 1 campaign wave
11 RA_TRG_MTMT_CMP2 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 2 campaign
12 RA_TRG_MTMT_WAV2 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 2 campaign wave
13 RA_TRG_MTVL_M1 Character(15) VARCHAR2(15) NOT NULL Metric to value trigger, metric 1
14 RA_TRG_MTVL_OPR Character(4) VARCHAR2(4) NOT NULL Triggers, Metric to Value Operator
*=Multiply
+=Plus
-=Minus
/=Divide
<=Less than
<==Less than or Equal to
<>=Not Equal to
==Equal to
>=Greater than
>==Greater than or Equal to
15 RA_TRG_MTVL_VALX Character(15) VARCHAR2(15) NOT NULL Trigger - Metric to Value Value holder. This value can be character, numeric or percentage. Numeric noted by nnnnn. Percentage noted by nn%.
16 RA_TRG_MTVL_CMP1 Character(15) VARCHAR2(15) NOT NULL Metric to value trigger, metric 1 campaign
17 RA_TRG_MTVL_WAV1 Character(15) VARCHAR2(15) NOT NULL Metric to Value trigger, metric 1 campaign wave
18 RA_TRG_DATE_DT Date(10) DATE Trigger - type Metric Date
19 RA_TRG_DATE_TM Time(15) TIMESTAMP Triggers - type Date - time field
20 RA_TRG_MECA_SQL Character(254) VARCHAR2(254) NOT NULL SQL or Calculation
21 RA_TRG_ACT_EXEC_SW Character(1) VARCHAR2(1) NOT NULL Trigger Action - exec Campaign Switch
22 RA_TRG_ACT_EXEC_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - exec Campaign ID
23 RA_TRG_ACT_EXECWID Character(15) VARCHAR2(15) NOT NULL Trigger Action - exec Campaign Wave ID
24 RA_EXEC_DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Trigger EXEC Action - done flag
25 RA_TRG_ACT_STOP_SW Character(1) VARCHAR2(1) NOT NULL Trigger Action - stop Campaign Switch
26 RA_TRG_ACT_STOP_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - stop Campaign ID
27 RA_TRG_ACT_STOPWID Character(15) VARCHAR2(15) NOT NULL Trigger Action - stop Campaign Wave ID
28 RA_STOP_DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Trigger STOP Action - done flag
29 RA_TRG_ACT_SEND_SW Character(1) VARCHAR2(1) NOT NULL Trigger Action -send Notification Switch
30 RA_TRG_ACT_SEND_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - send Notification ID
31 RA_SEND_DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Trigger SEND Action - done flag
32 RA_TRG_ACT_LIST_SW Character(1) VARCHAR2(1) NOT NULL Trigger Action -list Generation Switch
33 RA_TRG_ACT_LIST_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - list Generate ID
34 RA_LIST_DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Trigger LIST Action - done flag
35 START_DATE Date(10) DATE Start Date for Gen Standing PO
36 END_DATE Date(10) DATE End date field to store an end date.
37 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.
38 DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag

Default Value: N

39 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
40 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID
41 RA_EXEC_COUNT Number(5,0) INTEGER NOT NULL Marketing Triggers total executed count
42 RA_LAST_EXEC_DT Date(10) DATE Marketing Trigger Last Executed on date field
43 RA_REOCCURS_SW Character(1) VARCHAR2(1) NOT NULL Marketing Triggers Reoccurs switch
N=No
Y=Yes