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 NameField TypeColumn TypeDescription
    PTSF_SRCCAT_NAMECharacter(65)VARCHAR2(65) NOT NULLSearch Category Name
    DESCR100Character(100)VARCHAR2(100) NOT NULLLength 100 Description
    PTSF_ISGBLSRCHCharacter(1)VARCHAR2(1) NOT NULLSearch Group

    Y/N Table Edit

    PTSF_DISPLAY_TYPECharacter(2)VARCHAR2(2) NOT NULLDisplay Type
    GR=Grid
    LI=List
    PTSF_ADV_SHWCMNFLDCharacter(1)VARCHAR2(1) NOT NULLAuto detect common fields

    Y/N Table Edit

    Default: Y

    PTSF_FCT_SHWCMNCharacter(1)VARCHAR2(1) NOT NULLAuto detect facets

    Y/N Table Edit

    Default: Y

    MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

    Prompt Table: PSMENUNAME_VW

    PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name

    Prompt Table: PSMENUCOMP_VW

    MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values

    Default: GBL

    PTSF_BASIC_SRCH_PGCharacter(30)VARCHAR2(30) NOT NULLSearch results page

    Prompt Table: PSCOMPPAGE_VW

    PTSF_ADV_SRCH_PGCharacter(30)VARCHAR2(30) NOT NULLAdvanced search page

    Prompt Table: PSCOMPPAGE_VW

    MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    PTSF_SHOW_RACTIONSCharacter(1)VARCHAR2(1) NOT NULLShow Related Action

    Y/N Table Edit

    Default: N

    PTSF_SRCH_ENGCharacter(30)VARCHAR2(30) NOT NULLSearch Engine Instance
    PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLPackage Name

    Prompt Table: PSPACKAGROOT_VW

    QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID

    Prompt Table: PSPACKAGCLAS_VW

    PTSF_ALLOW_DUPSCharacter(1)VARCHAR2(1) NOT NULLAllow Duplicates
    A=Allow Duplicates
    S=Suppress Duplicates
    U=Use API

    Default: U

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

    Default: 1

    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19