RF_IPRDSTAT_AET (SQL Table)	Index Back
State Table for Cascade Status This table is used by the RF_IPRD_CASC Application Engine program.

RF_IPRDSTAT_AET

(SQL Table)

State Table for Cascade Status

This table is used by the RF_IPRD_CASC Application Engine program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

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

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

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

7 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

8 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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
5	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
6	INST_PROD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Status of an installed product.
7	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
8	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.