TRN_T_ACTION_VW

(SQL View)
 Index Back

Prompt Action

Prompt Action for TRN_T_SESN_SRCH

SELECT DISTINCT A.TRN_T_ACTION_ESP , B.DESCR FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRN_T_ACT_ESP) B WHERE A.TRN_T_ACTION_ESP = B.TRN_T_ACTION_ESP AND B.EFF_STATUS = 'A' AND %EffdtCheck(TRN_T_ACT_ESP B_EFFDT,B,%CURRENTDATEIN)

  • Related Language Record: TRN_T_ACT_S_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRN_T_ACTION_ESP Character(5) VARCHAR2(5) NOT NULL Training Action
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description