SCD_TMCH_RSN_VW

(SQL View)
 Index Back

Template Change Reason Codes

Template Change Reason Codes View

SELECT A.SETID , A.REASON_CD , A.DESCR50 FROM PS_REASON_CD A , PS_SET_CNTRL_GROUP B WHERE A.REASON_TYPE = 'TMCH' AND A.SETID = B.SETCNTRLVALUE AND B.REC_GROUP_ID = 'FS_35' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_REASON_CD B WHERE B.SETID = A.SETID AND B.REASON_CD = A.REASON_CD AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: SCD_TMCHRSN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_REASON_SETID Character(5) VARCHAR2(5) NOT NULL Reason Code Set ID

    Default Value: OPR_DEF_TBL_FS.SETID

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