RF_SO_REASON_VW

(SQL View)
Index Back

Reason Codes for Service Order

This view is used by Field Service for providing the Billing Adjustment reason for Service Order.

SELECT A.SETID , A.REASON_CD , A.DESCR , A.DESCR1 FROM PS_RB_REASON_CD A WHERE A.REASON_TYPE = 'SOBA' 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: RF_SO_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