PTUS_GROUPS1_VW

(SQL View)
 Index Back

List of search groups prompt


SELECT PTSF_SRCCAT_NAME , DESCR100 FROM PSPTSF_SRCCAT WHERE PTSF_ISGBLSRCH = 'Y' AND PTSF_SRCCAT_NAME NOT LIKE ('PTSF_INSIGHTS%') AND PTSF_SRCCAT_NAME NOT LIKE ('PTSF_RECENT%')

  • Related Language Record: PTUS_GROUPS_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