RBT_NUMBER_IMP

(SQL Table)
 Index Back

Table for Number Management

Number Inventory table for Telco.Number Inventory table for Telco.Number Inventory table for Telco

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

Prompt Table: RBT_REGION_VW
Set Control Field: DESCR

2 RBT_AREA_CODE Character(15) VARCHAR2(15) NOT NULL Telephone area code for use in number management
3 RBT_SUBSCRIBER_NUM Character(15) VARCHAR2(15) NOT NULL Telephone subscriber number for use in number management
4 RBTCATEGORY Character(2) VARCHAR2(2) NOT NULL Number Category

Prompt Table: RBT_CATEGORY
Set Control Field: RBTCATEGORY

5 RBT_FACTOR_VALUE Character(20) VARCHAR2(20) NOT NULL Factor Value
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 ACTION_ID Character(10) VARCHAR2(10) NOT NULL Action ID