PTSF_DEP_CAT_VW

(SQL View)
 Index Back

SELECT A.PTSF_SRCCAT_NAME , A.DESCR100 FROM PSPTSF_SRCCAT A , PS_PTSF_DEPLOY_OBJ B WHERE A.PTSF_SRCCAT_NAME = B.PTSF_OBJ_NAME AND B.PTSF_OBJ_TYPE = 'CAT'

  • Related Language Record: PTSF_DEPCAT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).
    2 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description