SYNCIDRBTCATEGORYEON=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
RBT_SUBCAT_VW(SQL View) |
Index Back |
|---|---|
Number CategoryThis table contains information about Number category. |
| SELECT A.SYNCID ,A.RBTCATEGORY ,A.RBTSUBCATEGORY ,B.SUBCATEGORY_DESCR FROM PS_RBT_NUMBER A , PS_RBT_SUBCATEGORY B WHERE A.RBTSUBCATEGORY = B.RBTSUBCATEGORY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | RBTCATEGORY |
Character(2) | VARCHAR2(2) NOT NULL | Number Category |
| 3 | 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 |
| 4 | SUBCATEGORY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Category Description field. Used in Text Tray |