RO_REASON_LNG

(SQL View)
 Index Back

Hold Denial Codes

Define the hold denial codes for order capture

SELECT A.SETID ,A.RO_REASON_TYPE ,A.HOLD_DENIAL_CD ,B.LANGUAGE_CD , B.DESCR FROM PS_RO_DEFN_HLD_DEN A , PS_RO_DEFN_HDENLNG B WHERE A.SETID = B.SETID AND A.HOLD_DENIAL_CD = B.HOLD_DENIAL_CD

  • Related Language Record for RO_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.

    Prompt Table: SP_SETID_NONVW

    2 RO_REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason code type for hold denials and cancellation reason codes.
    ACT=Activate Reason
    CHG=Change Reason
    CHR=Charge Reason
    CNCL=Cancellation Reason
    CPH=Change Phone Reason
    DISC=Disconnect Reason
    HOLD=Hold Denial
    NORD=New Order
    OVRD=Hold Override
    PAC=PAC Request Reason
    RENW=Renew Reasons
    RESM=Resume Reason
    SNC=Suspend and Change
    SNR=Suspend and Resume
    SUS=Suspend Reason
    3 HOLD_DENIAL_CD Character(6) VARCHAR2(6) NOT NULL Define the hold denial codes that can be used by order capture an enterprise user want to deny an order that was placed by a partner user and went on hold.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description