RO_REASON_VW

(SQL View)
 Index Back

Reason Codes

Define the hold denial and cancellation codes for order capture

SELECT SETID ,RO_REASON_TYPE ,HOLD_DENIAL_CD , DESCR FROM PS_RO_DEFN_HLD_DEN

  • Related Language Record: RO_REASON_LNG

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