TRGR_3CS_FLD

(SQL Table)
 Index Back

Trigger Field

  • Parent record: TRGR_3CS_FLD_CB

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: PSRECDEFN

    3 TRGR_ACTION Character(1) VARCHAR2(1) NOT NULL Trigger Action
    C=Changed
    D=Deleted
    N=New
    4 TRGR_FLD_COMBO Number(3,0) SMALLINT NOT NULL Trigger field combination
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELD_VW

    6 TRGR_OPERATOR Character(2) VARCHAR2(2) NOT NULL Trigger Operator
    <=Less than
    <==Less than or equal to
    <>=Not Equal
    ==Equal to
    >=Greater than
    >==Greater than or equal to
    IN=In

    Default Value: =