RO_PK_SCATG_LVW

(SQL View)
Index Back

Pricing Subcategory

This vie expands the Pricing Subcategory

SELECT a.RBTCATEGORY , A.RBTSUBCATEGORY , a.language_cd , a.SUBCATEGORY_DESCR FROM PS_RBT_SUBCATEG_LN a

  • Related Language Record for RO_PK_SBCATG_VW
  • # 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