RF_IPRDSOHIS_VW

(SQL View)
 Index Back

Installed Product History SO

This is a view of the service orders that are associated with the installed product.

SELECT B.SETID , B.INST_PROD_ID , A.BUSINESS_UNIT , A.SO_ID , C.DESCR80 , C.SHORT_DESCR , C.PRVNT_MNTC_FLAG , A.SERVICE_ID , A.SO_STATUS , A.SO_DATE , A.DATE_END , A.CUST_END_DATE , A.ROW_LASTMANT_DTTM , A.CASE_ID , A.ROW_ADDED_OPRID , A.SYNCID , A.SYNCDTTM FROM PS_RF_SO_HDR A , PS_RF_INST_PROD B , PS_RF_SERVICE C WHERE A.INST_PROD_ID = B.INST_PROD_ID AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE= A.BUSINESS_UNIT AND D.RECNAME = 'RF_INST_PROD') AND A.SERVICE_ID = C.SERVICE_ID AND C.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'RF_SERVICE')

  • Related Language Record: RF_SERVICE_LANG

    • # 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.
    2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
    5 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.
    6 SHORT_DESCR Character(15) VARCHAR2(15) NOT NULL This field is used to represent the short description for various objects
    7 PRVNT_MNTC_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to show whether Preventive Maintenance is required or not.
    N=No
    Y=Yes
    8 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID
    9 SO_STATUS Character(1) VARCHAR2(1) NOT NULL This field is used to store the Service Order Header Status.
    C=Complete
    D=Closed
    O=Open
    X=Canceled
    10 SO_DATE Date(10) DATE Stores the Service Order creation date.
    11 DATE_END Date(10) DATE End Date
    12 CUST_END_DATE Date(10) DATE Customer Preferred end date recorded for a service activity.
    13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    14 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
    15 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    16 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time