REASON_CD_VW

(SQL View)
Index Back

Reason Code View


SELECT A.SETID ,A.REASON_CD ,A.REASON_TYPE ,A.DESCR50 ,A.DESCRLONG FROM PS_REASON_CD A WHERE A.EFFDT= ( SELECT MAX(A1.EFFDT) FROM PS_REASON_CD A1 WHERE A1.SETID = A.SETID AND A1.REASON_TYPE = A.REASON_TYPE AND A1.REASON_CD = A.REASON_CD AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.REASON_TYPE = '36'

  • Related Language Record: REASON_CD_VW_LN
  • # 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 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCRLONG Long Character CLOB Long Description