RF_AG_REASON_VW

(SQL View)
 Index Back

Reason Codes for Agreement

This reason code view is a specific view from the Reason Code table for Agreement related reasons only.

SELECT setid , reason_cd , descr , descr1 FROM PS_RB_REASON_CD A WHERE A.REASON_TYPE = 'AGBA' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_RB_REASON_CD B WHERE A.SETID = B.SETID AND A.REASON_CD = B.REASON_CD AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: RF_AG_RSN_LNG_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 REASON_CD Character(10) VARCHAR2(10) NOT NULL Used to store the identification number for the reason code.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr