| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RBTNUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Number For Telco
|
| 2 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
Prompt Table:
RBT_REGION_VW
Set Control Field: DESCR
|
| 3 |
RBTCATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Number Category
Prompt Table:
RBT_CATEGORY
Set Control Field: RBTCATEGORY
|
| 4 |
RBT_AREA_CODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Telephone area code for use in number management
|
| 5 |
RBT_SUBSCRIBER_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Telephone subscriber number for use in number management
|
| 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 |
RBTUSAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Usage for MSISDN
D=Data
F=Fax
V=Voice
|
| 8 |
RBTTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Type For telco
MO=Wireless Number
PH=Wireline Number
|
| 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
Default Value: PE
|
| 10 |
RBT_PORTIN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
tells whether this number has been ported in
Y/N Table Edit
Default Value: N
|
| 11 |
RBTAGING |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate Number aging
|
| 12 |
RBT_PORT_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
The company that a number has been ported from
AT=AT&T
CI=Cingular
SB=SBC
SP=Sprint PCS
TM=T-Mobile
VE=Verizon
Prompt Table:
RBT_MOB_CARR_VW
|
| 13 |
RBT_PORT_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
The company that a number has been ported to
AT=AT&T
CI=Cingular
SB=SBC
SP=Sprint PCS
TM=T-Mobile
VE=Verizon
Prompt Table:
RBT_MOB_CARR_VW
|
| 14 |
RBTSTARTDT |
Date(10) |
DATE |
Start Date for Telco
|
| 15 |
RBTENDDT |
Date(10) |
DATE |
Enddt for Telco
|
| 16 |
RBTSESSION |
Character(15) |
VARCHAR2(15) NOT NULL |
Session for Number assignment
|
| 17 |
RBTDATETIME |
Character(26) |
VARCHAR2(26) NOT NULL |
Datetime for Telco
|
| 18 |
RBTNUMBERCI |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether ci or gui
|
| 19 |
RBT_FACTOR_VALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Factor Value
|
| 20 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 21 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 22 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 23 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 24 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
|
| 25 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 26 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 27 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 28 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 29 |
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.
|
| 30 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|