| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RBTNUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Number For Telco
|
| 2 |
RBT_SUBSCRIBER_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Telephone subscriber number for use in number management
|
| 3 |
RBT_AREA_CODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Telephone area code for use in number management
|
| 4 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
Prompt Table:
RBT_REGION_VW
Set Control Field: DESCR
|
| 5 |
RBTCATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Number Category
Prompt Table:
RBT_CATEGORY
Set Control Field: RBTCATEGORY
|
| 6 |
RBTSUBCATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
SubCategory for MSISDN
EON=Employee Official Number
ESR=Emergency Service Routing Key
LDN=Local Directory Number
LRN=Local Routing Number
PPD=Prepaid Account Number
PST=Postpaid Account Number
SDT=SoftDial Tone Number
TST=Test Number
Prompt Table:
RBT_SUBCATEGORY
|
| 7 |
RBTTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Type For telco
MO=Wireless Number
PH=Wireline Number
|
| 8 |
RBTUSAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Usage for MSISDN
D=Data
F=Fax
V=Voice
|
| 9 |
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
|
| 10 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|