SETIDINST_PROD_IDBLK=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
RBT_IPVOICE_VW2(SQL View) |
Index Back |
|---|---|
Installed Voice Phone ProductsInstalled products with voice type |
| SELECT A.SETID ,A.INST_PROD_ID ,A.DESCR ,A.RBTNUMBER ,A.MFG_ID ,B.DESCR ,A.MODEL ,A.SERIAL_ID ,A.INST_PROD_STATUS ,A.DESCR1 ,A.PARENT_INST_PRODID ,A.INST_PROD_REASON FROM PS_RBT_IPVOICE_VW A LEFT OUTER JOIN PS_MANUFACTURER B ON A.SETID=B.SETID AND A.MFG_ID=B.MFG_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 | 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 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
| 8 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the Serial ID of an item or installed product |
| 9 | INST_PROD_STATUS | Character(4) | VARCHAR2(4) NOT NULL | Status of an installed product. |
| 10 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 11 | PARENT_INST_PRODID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to store the installed product ID of the parent installed product |
| 12 | 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 |