TD_REASON_CD_VW

(SQL View)
 Index Back

Reason Code (TD)


SELECT A.SETID , A.REASON_CD , A.DESCR50 FROM PS_REASON_CD A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_REASON_CD A_ED WHERE A.SETID = A_ED.SETID AND A.REASON_CD = A_ED.REASON_CD AND A_ED.EFFDT <= %CurrentDateIn ) AND A.REASON_TYPE = '17'

  • Related Language Record: TD_REASONCD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50