RC_BI_REASON_VW

(SQL View)
 Index Back

Reason Codes for Call Center

This view is used by Call Center for providing the Billing Adjustment Reason for Case.

SELECT A.SETID , A.REASON_CD , A.DESCR , A.DESCR1 FROM PS_RB_REASON_CD A WHERE A.REASON_TYPE = 'CABA' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_RB_REASON_CD A_ED WHERE A.SETID = A_ED.SETID AND A.REASON_CD = A_ED.REASON_CD AND A_ED.EFFDT <= %CurrentDateIn)

  • Related Language Record: RC_BI_RSN_LNG_V

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Self-Service Description