RF_INST_PROD_ST

(SQL Table)
 Index Back

Installed Product Status

Child of RF_INST_PROD (installed product record) listing quantity for each status currently in effect for the parent installed product

  • Parent record: RF_INST_PROD

    • # 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 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

    Prompt Table: %EDITTABLE25

    4 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
    5 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Asset qty