SP_REASONCD_VW

(SQL View)
Index Back

Reason Code View

This view displays the reason codes for a particular setid, reason type

SELECT A.SETID , A.REASON_TYPE , A.REASON_CD , A.DESCR50 , A.DESCRLONG FROM PS_REASON_CD A WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(REASON_CD B, A, %CurrentDateIn)

  • Related Language Record: SP_REASONCD_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
    3 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCRLONG Long Character CLOB Long Description