RA_TRIGGER

(SQL Table)
 Index Back

Marketing Trigger Record

Marketing Trigger Record containing action and criteria

  • Parent record: RA_CMPGN_WAVE

  • Audit Record: RA_CMPGN_AUDIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RA_NONVW

    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.

    Prompt Table: RA_CAMPAIGN

    3 RA_TRIGGER_ID Character(15) VARCHAR2(15) NOT NULL Trigger ID

    Default Value: NEXT

    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

    Prompt Table: RA_METRIC_VW

    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

    Prompt Table: RA_METRIC_VW

    9 RA_TRG_MTMT_CMP1 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 1 campaign

    Prompt Table: RA_CAMPAIGN

    10 RA_TRG_MTMT_WAV1 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 1 campaign wave

    Prompt Table: RA_CMM1_WAVE_VW

    11 RA_TRG_MTMT_CMP2 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 2 campaign

    Prompt Table: RA_CAMPAIGN

    12 RA_TRG_MTMT_WAV2 Character(15) VARCHAR2(15) NOT NULL Metric to Metric trigger, metric 2 campaign wave

    Prompt Table: RA_CMM2_WAVE_VW

    13 RA_TRG_MTVL_M1 Character(15) VARCHAR2(15) NOT NULL Metric to value trigger, metric 1

    Prompt Table: RA_METRIC_VW

    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

    Prompt Table: RA_CAMPAIGN

    17 RA_TRG_MTVL_WAV1 Character(15) VARCHAR2(15) NOT NULL Metric to Value trigger, metric 1 campaign wave

    Prompt Table: RA_CMV1_WAVE_VW

    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

    Y/N Table Edit

    22 RA_TRG_ACT_EXEC_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - exec Campaign ID

    Prompt Table: RA_CAMPAIGN

    23 RA_TRG_ACT_EXECWID Character(15) VARCHAR2(15) NOT NULL Trigger Action - exec Campaign Wave ID

    Prompt Table: RA_EXEC_WAVE_VW

    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

    Y/N Table Edit

    26 RA_TRG_ACT_STOP_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - stop Campaign ID

    Prompt Table: RA_CAMPAIGN

    27 RA_TRG_ACT_STOPWID Character(15) VARCHAR2(15) NOT NULL Trigger Action - stop Campaign Wave ID

    Prompt Table: RA_STOP_WAVE_VW

    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

    Y/N Table Edit

    30 RA_TRG_ACT_SEND_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - send Notification ID

    Prompt Table: RB_PRSN_P_NM_VW

    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

    Y/N Table Edit

    33 RA_TRG_ACT_LIST_ID Character(15) VARCHAR2(15) NOT NULL Trigger Action - list Generate ID

    Prompt Table: RA_LIST

    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.

    Prompt Table: RA_SCHEDULE_TBL

    38 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    39 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    40 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    41 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    42 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    43 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    44 DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag

    Y/N Table Edit

    Default Value: N

    45 RA_TRIGGER_DESC Character(100) VARCHAR2(100) NOT NULL Trigger result from App Engine process
    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

    Default Value: N

    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