|
SELECT A.RBTNUMBER , A.RBT_AREA_CODE , A.RBT_SUBSCRIBER_NUM , A.REGION_ID , A.RBTUSAGE , A.RBT_FACTOR_VALUE , A.RBT_FACTOR_VALUE , A.RBTTYPE , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.RBTCATEGORY , A.RBTSUBCATEGORY ,A.RBTSTATUS ,A.RBTENDDT ,A.RBT_PORTIN_FLG , %subrec(RB_AUDIT_SBR,A) FROM PS_RBT_NUMBER A
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RBTNUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Number For Telco
|
| 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 |
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 |
RBTUSAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Usage for MSISDN
D=Data
F=Fax
V=Voice
|
| 6 |
RBT_FACTOR_VALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Factor Value
|
| 7 |
RBT_FACTOR_VALUE2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Factor Value
|
| 8 |
RBTTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Type For telco
MO=Wireless Number
PH=Wireline Number
|
| 9 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 10 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 11 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 12 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 13 |
RBTCATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Number Category
Prompt Table:
RBT_CATEGORY
Set Control Field: RBTCATEGORY
|
| 14 |
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
|
| 15 |
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
|
| 16 |
RBTENDDT |
Date(10) |
DATE |
Enddt for Telco
|
| 17 |
RBT_PORTIN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
tells whether this number has been ported in
Y/N Table Edit
Default Value: N
|
| 18 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 19 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 20 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 21 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 22 |
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.
|
| 23 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|