FPMACTNREA2_LNG

(SQL View)
 Index Back

PS- Reason Codes - Seniority

The ACTN_REASON_TBL view allows you to display with F4 reason codes linked to specific actions (see Updating System - Public Service table transaction ).

SELECT A.ACTION ,A.ACTION_REASON ,C.LANGUAGE_CD ,C.DESCR ,C.DESCRSHORT FROM PS_ACTN_REASON_TBL A , PS_ACTN_RSN_LANG C WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ACTN_REASON_TBL B WHERE B.ACTION = A.ACTION AND B.ACTION_REASON=A.ACTION_REASON AND B.EFFDT <= %CurrentDateIn) AND A.ACTION = C.ACTION AND A.ACTION_REASON = C.ACTION_REASON AND A.EFFDT = C.EFFDT

  • Related Language Record for FPMACTNREA_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FP_ACTN_STEP Character(3) VARCHAR2(3) NOT NULL Action for (Sub)Step Increment
    2 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description