IN_TM_DFN_CATVW

(SQL View)
 Index Back

View of Non-System Categories

View of template code categories that are not flagged as system data

SELECT A.IN_TM_CODE , A.IN_TM_CATEGORY , A.DESCR FROM PS_IN_TM_DEFN_CAT A WHERE A.SYSTEM_DATA_FLG = 'N'

  • Related Language Record: IN_TM_DFN_CATLV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IN_TM_CODE Character(15) VARCHAR2(15) NOT NULL Template Code
    2 IN_TM_CATEGORY Character(15) VARCHAR2(15) NOT NULL Template Category
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description