TD_REASONCD_LNG

(SQL View)
 Index Back

Reason Code (TD)


SELECT A.SETID , A.REASON_CD , B.LANGUAGE_CD , B.DESCR50 FROM PS_REASON_CD A , PS_REASON_CD_LNG B WHERE A.SETID = B.SETID AND A.REASON_CD = B.REASON_CD AND A.EFFDT = B.EFFDT AND 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 for TD_REASON_CD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50