RUN_CNTL_RFIPRD (SQL Table)	Index Back
Install Product Cascade Status This run control record is used by the Installed Product Cascade Status Application Engine program.

RUN_CNTL_RFIPRD

(SQL Table)

Install Product Cascade Status

This run control record is used by the Installed Product Cascade Status Application Engine program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

4 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

5 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

6 INST_PROD_REASON Character(4) VARCHAR2(4) NOT NULL Reason for Installed product Status
BLK=Blacklisted
CTP=Converted to Postpaid
DWN=Downgrade
LS=Lost or Stolen
NPO=Number Ported Out
OVC=On Vacation
REL=Relocation
TEX=Too Expensive
UPG=Upgrade
USS=Unsatisfactory Service
WRG=Wrong Calls

7 ORIG_IPRD_STATUS Character(4) VARCHAR2(4) NOT NULL This field is used to hold the original installed product status for the Installed Product Relationship action.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
4	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
5	INST_PROD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Status of an installed product.
6	INST_PROD_REASON	Character(4)	VARCHAR2(4) NOT NULL	Reason for Installed product Status BLK=Blacklisted CTP=Converted to Postpaid DWN=Downgrade LS=Lost or Stolen NPO=Number Ported Out OVC=On Vacation REL=Relocation TEX=Too Expensive UPG=Upgrade USS=Unsatisfactory Service WRG=Wrong Calls
7	ORIG_IPRD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the original installed product status for the Installed Product Relationship action.