RF_INSP_HIST_VW (SQL View)	Index Back
Installed Product PM Child Rec Preventive Maintenance History Child Record for Installed Product

RF_INSP_HIST_VW

(SQL View)

Installed Product PM Child Rec

Preventive Maintenance History Child Record for Installed Product

SELECT setid , inst_prod_id , seq_num , agreement_code , agr_renewal_num , agreement_line , create_date , so_date , business_unit , so_id , setid_service , service_id , insprd_pmso_status , comments254 FROM PS_RF_INST_PROD_PM WHERE insprd_pmso_status <> 'PND'

# 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 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
Default Value: NEXT

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

4 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
Prompt Table: RF_INSP_AGR_VW

5 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
Prompt Table: RF_INSP_AGR1_VW

6 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
Prompt Table: RF_INSP_AGR2_VW

7 CREATE_DATE Date(10) DATE Creation Date

8 SO_DATE Date(10) DATE Stores the Service Order creation date.

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RFPMNONVW

10 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID

11 SETID_SERVICE Character(5) VARCHAR2(5) NOT NULL This field is used to represent the SETID of the Service

12 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID

13 INSPRD_PMSO_STATUS Character(3) VARCHAR2(3) NOT NULL Preventive Maintenance SO Status
CAN=Canceled
CMP=Completed
CRT=Created
INP=In Progress
PND=Pending

14 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)

#	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	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field) Default Value: NEXT
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement Prompt Table: RF_INSP_AGR_VW
5	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal) Prompt Table: RF_INSP_AGR1_VW
6	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number Prompt Table: RF_INSP_AGR2_VW
7	CREATE_DATE	Date(10)	DATE	Creation Date
8	SO_DATE	Date(10)	DATE	Stores the Service Order creation date.
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RFPMNONVW
10	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
11	SETID_SERVICE	Character(5)	VARCHAR2(5) NOT NULL	This field is used to represent the SETID of the Service
12	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID
13	INSPRD_PMSO_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Preventive Maintenance SO Status CAN=Canceled CMP=Completed CRT=Created INP=In Progress PND=Pending
14	COMMENTS254	Character(254)	VARCHAR2(254) NOT NULL	Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)