PSPTSF_SRCCAT

 index back

Search Categories


  • Related language record: PSPTSF_CAT_LANG

  • Parent record of PSPTSF_CATADVFD PSPTSF_CATDSPFD PSPTSF_CATFACET PSPTSF_CATSRTFD PSPTSF_CAT_LANG PSPTSF_SRCCATAT PTSF_CATATTRSVW PTSF_CAT_ATTRS

    • PeopleSoft Field Name Field Type Column Type Description
    PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name
    DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    PTSF_ISGBLSRCH Character(1) VARCHAR2(1) NOT NULL Search Group

    Y/N Table Edit

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

    Y/N Table Edit

    Default: Y

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

    Y/N Table Edit

    Default: Y

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

    Prompt Table: PSMENUNAME_VW

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

    Prompt Table: PSMENUCOMP_VW

    MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values

    Default: GBL

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

    Prompt Table: PSCOMPPAGE_VW

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

    Prompt Table: PSCOMPPAGE_VW

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

    Y/N Table Edit

    Default: N

    PTSF_SRCH_ENG Character(30) VARCHAR2(30) NOT NULL Search Engine Instance
    PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Package Name

    Prompt Table: PSPACKAGROOT_VW

    QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: PSPACKAGCLAS_VW

    PTSF_ALLOW_DUPS Character(1) VARCHAR2(1) NOT NULL Allow Duplicates
    A=Allow Duplicates
    S=Suppress Duplicates
    U=Use API

    Default: U

    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 1

    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20