PTSF_SRCHCAT

(SQL Table)
 Index Back

Search Categorys

  • Related Language Record: PTSF_CAT_LANG

  • Parent Record Of PTSF_CAT_ADVFLD PTSF_CAT_DSPFLD PTSF_CAT_FACETS PTSF_CAT_PSFTSD PTSF_CAT_SES_SD

    • # 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
    3 PTSF_ISGBLSRCH Character(1) VARCHAR2(1) NOT NULL Search Group

    Y/N Table Edit

    4 PTSF_DISPLAY_TYPE Character(2) VARCHAR2(2) NOT NULL Display Type
    GR=Grid
    LI=List
    5 PTSF_ADV_SHWCMNFLD Character(1) VARCHAR2(1) NOT NULL Auto detect common fields

    Y/N Table Edit

    Default Value: Y

    6 PTSF_FCT_SHWCMN Character(1) VARCHAR2(1) NOT NULL Auto detect facets

    Y/N Table Edit

    Default Value: Y

    7 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUNAME_VW

    8 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: PSMENUCOMP_VW

    9 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    10 PTSF_BASIC_SRCH_PG Character(30) VARCHAR2(30) NOT NULL Search results page

    Prompt Table: PSCOMPPAGE_VW

    11 PTSF_ADV_SRCH_PG Character(30) VARCHAR2(30) NOT NULL Advanced search page

    Prompt Table: PSCOMPPAGE_VW

    12 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    13 PTSF_SHOW_RACTIONS Character(1) VARCHAR2(1) NOT NULL Show Related Action

    Y/N Table Edit

    Default Value: N

    14 PTSF_SRCH_ENG Character(30) VARCHAR2(30) NOT NULL Search Engine Instance