TRGR_3CS_FLD_VL

(SQL Table)
Index Back

Trigger Field Value

  • Parent record: TRGR_3CS_FLD
  • # 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

    6 TRGR_FLD_VL_NBR Number(3,0) SMALLINT NOT NULL Trigger field value number
    7 TRGR_FIELD_VALUE Character(250) VARCHAR2(250) NOT NULL Trigger field value

    Prompt Table: %EDITTABLE