RC_BI_RSN_LNG_V

(SQL View)
 Index Back

Reason Codes for Case

Related Language record for RC_BI_REASON_VW.

SELECT B.setid , B.reason_cd , B.language_cd , B.descr , B.descr1 FROM PS_RB_REASON_CD A , PS_RB_REASON_CDLNG B WHERE B.SETID = A.SETID AND B.REASON_CD = A.REASON_CD AND A.REASON_TYPE = 'CABA' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_RB_REASON_CD C WHERE C.SETID = A.SETID AND C.REASON_CD = A.REASON_CD AND C.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record for RC_BI_REASON_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 REASON_CD Character(10) VARCHAR2(10) NOT NULL Used to store the identification number for the reason code.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Self-Service Description