RBTCATEGORYRBTSUBCATEGORYEON=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
RO_PK_SBCATG_VW(SQL View) |
Index Back |
|---|---|
Pricing SubcategoryThis vie expands the Pricing Subcategory |
| SELECT a.RBTCATEGORY , a.RBTSUBCATEGORY , a.SUBCATEGORY_DESCR FROM PS_RBT_SUBCATEGORY a WHERE a.RBTCATEGORY = 'SP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTCATEGORY |
Character(2) | VARCHAR2(2) NOT NULL | Number Category |
| 2 | 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 |
| 3 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |