SYNCIDPrompt Table: %EDITTABLE25
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
RF_IP_STATUS_VW(SQL View) |
Index Back |
|---|---|
Installed Product StatusChild of RF_INST_PROD (installed product record) listing quantity for each status currently in effect for the parent installed product |
| SELECT A.SYNCID ,A.SETID , A.INST_PROD_ID , B.INST_PROD_STATUS , B.INST_PROD_REASON FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYNCID |
Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 3 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 4 | INST_PROD_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Status of an installed product.
Prompt Table: %EDITTABLE25 |
| 5 | 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 |