RF_IPRDCSHIS_VW (SQL View)	Index Back
Installed Product History Case This is a view of the cases that are associated with the installed product.

RF_IPRDCSHIS_VW

(SQL View)

Installed Product History Case

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

SELECT B.SETID , B.INST_PROD_ID , A.BUSINESS_UNIT , A.CASE_ID , F.WO_ID , F.BUSINESS_UNIT_WO , A.RC_SUMMARY , C.RC_SHORT_DESCR , A.CREATION_DATE , A.CLOSED_DATE , A.ROW_ADDED_OPRID , A.SYNCID , A.SYNCDTTM FROM PS_RC_CASE A , PS_RC_CASE_WO F , PS_RF_INST_PROD B , PS_RC_STATUS_TBL C WHERE A.BUSINESS_UNIT = F.BUSINESS_UNIT(+) AND A.CASE_ID = F.CASE_ID(+) AND F.ERROR_FLAG(+) <> 'Y' AND 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 C.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'RC_STATUS_TBL') AND C.RC_STATUS = A.RC_STATUS

Related Language Record: RF_IPRDCSHS_LVW

# 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 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.

5 WO_ID Character(10) VARCHAR2(10) NOT NULL This field contains the Work Order ID for the work order in FMS.

6 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL This field contains the Work Order Business Unit from Work Order Management.

7 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

8 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

9 CREATION_DATE Date(10) DATE Creation date of the case.

10 CLOSED_DATE Date(10) DATE Date Closed

11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

12 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.

13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	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.
5	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	This field contains the Work Order ID for the work order in FMS.
6	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	This field contains the Work Order Business Unit from Work Order Management.
7	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
8	RC_SHORT_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables
9	CREATION_DATE	Date(10)	DATE	Creation date of the case.
10	CLOSED_DATE	Date(10)	DATE	Date Closed
11	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
12	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.
13	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time