PSPTSF_SD

(SQL Table)
 Index Back

  • Related Language Record: PSPTSF_SD_LANG

  • Parent Record Of PSPTSF_ADD_PRMS PSPTSF_ATT_PROP PSPTSF_GN_DCATR PSPTSF_GN_DSMAP PSPTSF_GN_DSPRC PSPTSF_RECORDS PSPTSF_SD_ATTR PSPTSF_SD_ATTRH PSPTSF_SD_DCACL PSPTSF_SD_DCATR PSPTSF_SD_LANG PSPTSF_SD_PNLGP PSPTSF_SD_SRACL PSPTSF_SRCHATTR PSPTSF_TMPLATES SSR_CAF_FCT_WRK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition
    2 PTSF_SOURCE_TYPE Character(1) VARCHAR2(1) NOT NULL Source Type
    A=Activity Guide
    C=Connected Query
    F=File Source
    Q=Query
    R=External Data Source
    W=Web Source

    Default Value: Q

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

    Prompt Table: %EDITTABLE2

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

    Prompt Table: PTSF_DELQRYS_VW

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

    Prompt Table: PTSF_DQRYFLD_VW
    Set Control Field: PTSF_PSQUERY_DLT

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

    Prompt Table: PTSF_DQRYFLD_VW

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

    Prompt Table: PTSF_QRYDTTM_VW

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

    Prompt Table: PTSF_QRY_URL_VW
    Set Control Field: QRYNAME

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Prompt Table: PTSF_POSTAE_VW

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

    Prompt Table: PTSF_POSAESECVW

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

    Prompt Table: PTSF_PREAE_VW

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

    Prompt Table: PTSF_PREAESECVW

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

    Default Value: 1

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

    Prompt Table: PTSF_QRY_URL_VW
    Set Control Field: QRYNAME

    31 PTSF_SEC_JOIN Character(1) VARCHAR2(1) NOT NULL Disable Security Join

    Y/N Table Edit

    Default Value: Y

    32 PTSF_DP_APPLID Character(12) VARCHAR2(12) NOT NULL Used in Index By Data Partition

    Prompt Table: PTSF_DPAE_VW

    33 PTSF_DP_SECTION Character(8) VARCHAR2(8) NOT NULL Used in Index By Data Partition

    Prompt Table: PTSF_DPAESECVW

    34 PTSF_DP_STGNAME Character(15) VARCHAR2(15) NOT NULL Used in Index By Data Partition

    Prompt Table: PTSF_DP_REC_VW

    35 PTSF_DP_TTBLNAME Character(15) VARCHAR2(15) NOT NULL Used in Index By Data Partition

    Prompt Table: PTSF_DP_TREC_VW