RBTNUMBERAG=Aging
AS=Active
AV=Available
BL=Blocked
PA=Activation-Pending
PE=Pending
PO=Ported-Out
RL=Released
RS=Reserved
RBT_NUM_CATG_VW(SQL View) |
Index Back |
|---|---|
Table for Number ManagementNumber Inventory table for Telco.Number Inventory table for Telco.Number Inventory table for Telco |
| SELECT A.RBTNUMBER , A.RBTCATEGORY , A.RBTSTATUS , B.CATEGORY_DESCR FROM PS_RBT_NUMBER A , PS_RBT_CATEGORY B WHERE A.RBTCATEGORY = B.RBTCATEGORY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTNUMBER |
Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |
| 2 | RBTCATEGORY | Character(2) | VARCHAR2(2) NOT NULL | Number Category |
| 3 | RBTSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Status for Telco
AG=Aging AS=Active AV=Available BL=Blocked PA=Activation-Pending PE=Pending PO=Ported-Out RL=Released RS=Reserved |
| 4 | CATEGORY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Category Description field. Used in Text Tray |