TC_CATEGORY_VW

(SQL View)
 Index Back

Category/Subcategory view

Category/Subcategory view

SELECT %Substring(X.FIELDVALUE,1,2) FROM PSXLATITEM X WHERE X.FIELDNAME = 'TC_CATEGORY'

  • Related Language Record: TC_CATEGORY_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TC_CATEGORY Character(2) VARCHAR2(2) NOT NULL Compensation Category
    BN=Benefits
    BP=Base Pay
    EP=Executive Perk
    I=Incentive
    M=Miscellaneous
    ST=Stock