RA_TRIGGER_AET(SQL Table) |
Index Back |
|---|---|
Marketing Trigger RecordTrigger work for App Engine Processing on Triggers |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 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_TRIGGER_ID | Character(15) | VARCHAR2(15) NOT NULL | Trigger ID |
| 5 | RA_TRIGGER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Trigger Name |
| 6 | 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 |
| 7 | RA_TRG_MTMT_M1 | Character(15) | VARCHAR2(15) NOT NULL | Metric to Metric trigger, metric 1 |
| 8 | 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 |
| 9 | RA_TRG_MTMT_M2 | Character(15) | VARCHAR2(15) NOT NULL | Metric to Metric trigger, metric 2 |
| 10 | RA_TRG_MTMT_CMP1 | Character(15) | VARCHAR2(15) NOT NULL | Metric to Metric trigger, metric 1 campaign |
| 11 | RA_TRG_MTMT_WAV1 | Character(15) | VARCHAR2(15) NOT NULL | Metric to Metric trigger, metric 1 campaign wave |
| 12 | RA_TRG_MTMT_CMP2 | Character(15) | VARCHAR2(15) NOT NULL | Metric to Metric trigger, metric 2 campaign |
| 13 | RA_TRG_MTMT_WAV2 | Character(15) | VARCHAR2(15) NOT NULL | Metric to Metric trigger, metric 2 campaign wave |
| 14 | RA_TRG_MTVL_M1 | Character(15) | VARCHAR2(15) NOT NULL | Metric to value trigger, metric 1 |
| 15 | 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 |
| 16 | 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%. |
| 17 | RA_TRG_MTVL_CMP1 | Character(15) | VARCHAR2(15) NOT NULL | Metric to value trigger, metric 1 campaign |
| 18 | RA_TRG_MTVL_WAV1 | Character(15) | VARCHAR2(15) NOT NULL | Metric to Value trigger, metric 1 campaign wave |
| 19 | RA_TRG_DATE_DT | Date(10) | DATE | Trigger - type Metric Date |
| 20 | RA_TRG_DATE_TM | Time(15) | TIMESTAMP | Triggers - type Date - time field |
| 21 | RA_TRG_MECA_SQL | Character(254) | VARCHAR2(254) NOT NULL | SQL or Calculation |
| 22 | RA_TRG_ACT_EXEC_SW | Character(1) | VARCHAR2(1) NOT NULL | Trigger Action - exec Campaign Switch |
| 23 | RA_TRG_ACT_EXEC_ID | Character(15) | VARCHAR2(15) NOT NULL | Trigger Action - exec Campaign ID |
| 24 | RA_TRG_ACT_EXECWID | Character(15) | VARCHAR2(15) NOT NULL | Trigger Action - exec Campaign Wave ID |
| 25 | RA_EXEC_DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Trigger EXEC Action - done flag |
| 26 | RA_TRG_ACT_STOP_SW | Character(1) | VARCHAR2(1) NOT NULL | Trigger Action - stop Campaign Switch |
| 27 | RA_TRG_ACT_STOP_ID | Character(15) | VARCHAR2(15) NOT NULL | Trigger Action - stop Campaign ID |
| 28 | RA_TRG_ACT_STOPWID | Character(15) | VARCHAR2(15) NOT NULL | Trigger Action - stop Campaign Wave ID |
| 29 | RA_STOP_DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Trigger STOP Action - done flag |
| 30 | RA_TRG_ACT_SEND_SW | Character(1) | VARCHAR2(1) NOT NULL | Trigger Action -send Notification Switch |
| 31 | RA_TRG_ACT_SEND_ID | Character(15) | VARCHAR2(15) NOT NULL | Trigger Action - send Notification ID |
| 32 | RA_SEND_DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Trigger SEND Action - done flag |
| 33 | RA_TRG_ACT_LIST_SW | Character(1) | VARCHAR2(1) NOT NULL | Trigger Action -list Generation Switch |
| 34 | RA_TRG_ACT_LIST_ID | Character(15) | VARCHAR2(15) NOT NULL | Trigger Action - list Generate ID |
| 35 | RA_LIST_DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Trigger LIST Action - done flag |
| 36 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 37 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 38 | SCHEDULE | Character(10) | VARCHAR2(10) NOT NULL | Schedule for integration with Contracts. |
| 39 | DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Done Flag |
| 40 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 41 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 42 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
Default Value: N |
| 43 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |
| 44 | RA_METRIC1_VAL | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Used by RA_TRIGGER_AET Trigger App Engine to pass Metric1 value |
| 45 | RA_METRIC2_VAL | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Used by RA_TRIGGER_AET Trigger App Engine to pass Metric2 value |
| 46 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 47 | BO_ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | BO_ROLE_TYPE_ID |
| 48 | RA_REOCCURS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Marketing Triggers Reoccurs switch
N=No Y=Yes |
| 49 | RA_LAST_EXEC_DT | Date(10) | DATE | Marketing Trigger Last Executed on date field |
| 50 | RA_EXEC_COUNT | Number(5,0) | INTEGER NOT NULL | Marketing Triggers total executed count |