RO_INSTPRD_VW (SQL View)	Index Back
Installed Product Status view For query of installed products to determine if any Service or Agreement installed products need to be Cancelled.

RO_INSTPRD_VW

(SQL View)

Installed Product Status view

For query of installed products to determine if any Service or Agreement installed products need to be Cancelled.

SELECT A.SETID , A.INST_PROD_ID ,B.INST_PROD_STATUS ,A.INST_PROD_TYPE ,A.SVC_END_DATE ,A.INSTALLED_DATE ,A.AGREEMENT_CODE ,A.TMP_SERVICE ,A.PRODUCT_ID ,A.RESUME_DATE ,A.CAPTURE_ID ,A.RBTEXTERNAL_ID ,A.DISC_CAPTURE_ID ,A.RES_CAPTURE_ID FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID

# 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 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
Prompt Table: %EDITTABLE25

4 INST_PROD_TYPE Character(3) VARCHAR2(3) NOT NULL This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements).
001=Asset
002=Product
003=Service
004=Agreement
005=Commitment

5 SVC_END_DATE Date(10) DATE This field is used by the Installed Product component to designate the date that the Service was terminated or suspended.

6 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product

7 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

8 TMP_SERVICE Character(1) VARCHAR2(1) NOT NULL Indicates if the Service is temporary

9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

10 RESUME_DATE Date(10) DATE Temporary Suspension Resumption date

11 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

12 RBTEXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL Tis field has been used for COM service management. It captures the external id which has been used in upgrade purpose.

13 DISC_CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field used to save the Capture ID for the Disconnect for a Temporary Service

14 RES_CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field used to store the Resume Capture ID for Suspend/Resume

#	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	INST_PROD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Status of an installed product. Prompt Table: %EDITTABLE25
4	INST_PROD_TYPE	Character(3)	VARCHAR2(3) NOT NULL	This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements). 001=Asset 002=Product 003=Service 004=Agreement 005=Commitment
5	SVC_END_DATE	Date(10)	DATE	This field is used by the Installed Product component to designate the date that the Service was terminated or suspended.
6	INSTALLED_DATE	Date(10)	DATE	Field used for storing Installed Date of Installed product
7	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
8	TMP_SERVICE	Character(1)	VARCHAR2(1) NOT NULL	Indicates if the Service is temporary
9	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
10	RESUME_DATE	Date(10)	DATE	Temporary Suspension Resumption date
11	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
12	RBTEXTERNAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Tis field has been used for COM service management. It captures the external id which has been used in upgrade purpose.
13	DISC_CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field used to save the Capture ID for the Disconnect for a Temporary Service
14	RES_CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field used to store the Resume Capture ID for Suspend/Resume