RBT_IPVOICE_VW

(SQL View)
 Index Back

Installed Voice Phone Products

Installed products with voice type

SELECT A.SETID ,A.INST_PROD_ID ,D.DESCR ,A.RBTNUMBER ,A.MFG_ID ,A.MODEL ,A.SERIAL_ID ,B.INST_PROD_STATUS ,F.RB_XLATLONGNAME ,A.PARENT_INST_PRODID ,B.INST_PROD_REASON FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B , PS_RBT_PROD_ITEM C , PS_PROD_ITEM D , PS_RF_ISTATXLAT_VW F WHERE A.SETID=B.SETID AND A.INST_PROD_ID=B.INST_PROD_ID AND A.SETID=C.SETID AND A.PRODUCT_ID=C.PRODUCT_ID AND A.SETID=D.SETID AND A.PRODUCT_ID=D.PRODUCT_ID AND A.SETID=F.SETID AND F.FIELDVALUE = B.INST_PROD_STATUS AND A.INST_PROD_TYPE=F.INST_PROD_TYPE AND D.PROD_CATEGORY='MOBILE_PHONES'

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
5 MFG_ID Character(50) VARCHAR2(50) NOT NULL Key field to represent Manufacturer Identification number
6 MODEL Character(30) VARCHAR2(30) NOT NULL Model
7 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
8 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
9 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
10 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product
11 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