RO_PK_SCATG_LVW(SQL View) |
Index Back |
---|---|
Pricing SubcategoryThis vie expands the Pricing Subcategory |
SELECT a.RBTCATEGORY , A.RBTSUBCATEGORY , a.language_cd , a.SUBCATEGORY_DESCR FROM PS_RBT_SUBCATEG_LN a |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |