PSPTSF_SD

index back

  • Related language record: PSPTSF_SD_LANG
  • Parent record of PSPTSF_ADD_PRMS PSPTSF_ATT_PROP PSPTSF_SD_ATTR PSPTSF_SD_ATTRH PSPTSF_SD_DCACL PSPTSF_SD_DCATR PSPTSF_SD_LANG PSPTSF_SD_PNLGP PSPTSF_SD_SRACL PTSF_ATTR_WRK PTSF_DEPLY_PRMS
  • PeopleSoft Field Name Field Type Column Type Description
    PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition
    PTSF_SOURCE_TYPE Character(1) VARCHAR2(1) NOT NULL Source Type
    C=Connected Query
    F=File Source
    Q=Query
    W=Web Source

    Default: Q

    PTSF_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name

    Prompt Table: %EDITTABLE2

    PTSF_PSQUERY_DLT Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: PTSF_DELQRYS_VW

    PTSF_DELETE_URL Character(30) VARCHAR2(30) NOT NULL URL Link Field

    Prompt Table: PTSF_DQRYFLD_VW
    Set Control Field: PTSF_PSQUERY_DLT

    PTSF_LASTUPDT_DLT Character(30) VARCHAR2(30) NOT NULL Last Modified Date Field

    Prompt Table: PTSF_DQRYFLD_VW

    PTSF_SRCH_UPDDTTM Character(30) VARCHAR2(30) NOT NULL Last Modified Date Time

    Prompt Table: PTSF_QRYDTTM_VW

    PTSF_CONTENT_URL Character(30) VARCHAR2(30) NOT NULL URL Link

    Prompt Table: PTSF_QRY_URL_VW
    Set Control Field: QRYNAME

    PTSF_DISPLAY_TITLE Character(254) VARCHAR2(254) NOT NULL *Title
    PTSF_DISPLAY_BODY Long Character CLOB NOT NULL *Summary
    PTSF_ISGBLSRCH Character(1) VARCHAR2(1) NOT NULL IsGlobalSearch

    Y/N Table Edit

    PTSF_ISSRCACL Character(1) VARCHAR2(1) NOT NULL Source Level

    Y/N Table Edit

    PTSF_ISDOCACL Character(1) VARCHAR2(1) NOT NULL Document Level

    Y/N Table Edit

    PTFP_FEED_ID Character(30) VARCHAR2(30) NOT NULL Feed ID (see PSFP_FEED).
    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_POST_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name

    Prompt Table: PTSF_POSTAE_VW

    PTSF_POST_AESEC Character(8) VARCHAR2(8) NOT NULL Section

    Prompt Table: PTSF_POSAESECVW

    PTSF_PRE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name

    Prompt Table: PTSF_PREAE_VW

    PTSF_PRE_AESEC Character(8) VARCHAR2(8) NOT NULL Section

    Prompt Table: PTSF_PREAESECVW

    LASTREFRESHDTTM DateTime(26) TIMESTAMP Last Swap Refresh Stamp
    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
    DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    PTSF_KEYWORDS Character(254) VARCHAR2(254) NOT NULL Alternate search keywords
    PTSF_SHOW_RACTIONS Character(1) VARCHAR2(1) NOT NULL Show Related Action
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 1

    PTSF_IMAGE_URL Character(30) VARCHAR2(30) NOT NULL *Image URL

    Prompt Table: PTSF_QRY_URL_VW
    Set Control Field: QRYNAME

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 25-NOV-20