SCC_RULE_TRIG

(SQL Table)
 Index Back

Rules Engine Trigger Record

This record is used to define a trigger used in the rules engine.

  • Related Language Record: SCC_RULE_TRG_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_RULE_TRIG_ID Character(40) VARCHAR2(40) NOT NULL Trigger ID
    2 SCC_RULE_TRIG_NAME Character(80) VARCHAR2(80) NOT NULL Trigger Name
    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: SCC_RTRIG_C_PT

    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: SCC_RTRIG_R2_PT

    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: SCC_RTRIG_F_PT

    6 SCC_COMP_EVENT Character(3) VARCHAR2(3) NOT NULL Event
    10=SavePreChange
    20=SavePostChange
    30=FieldChange
    40=FieldEdit
    7 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine

    Prompt Table: SCC_RTR_CAT_VW

    8 SCC_RULE_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule ID for rules used in the Rules Engine

    Prompt Table: SCC_RULE_PT

    9 SCC_RULE_TRIG_DESC Long Character CLOB Trigger Description