PSPTSF_SRCCAT

(SQL Table)
 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

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name
    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
    15 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Package Name

    Prompt Table: PSPACKAGROOT_VW

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

    Prompt Table: PSPACKAGPATH_VW

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

    Prompt Table: PSPACKAGCLAS_VW

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

    Default Value: U

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

    Default Value: 1

    20 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.
    21 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.
    22 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier