PTSF_SBO

index back

  • Related language record: PTSF_SBO_LANG
  • Parent record of PTSF_SBO_ATTR PTSF_SBO_DOCACL PTSF_SBO_SCRACL
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTSF_SBO_NAMECharacter(65)VARCHAR2(65) NOT NULLSearch Definition (see PSPTSF_SD).
    PTSF_SOURCE_TYPECharacter(1)VARCHAR2(1) NOT NULLSource Type
    C=Connected Query
    F=File Source
    Q=Query
    W=Web Source

    Default: Q

    PTSF_SOURCE_NAMECharacter(30)VARCHAR2(30) NOT NULLSource Name

    Prompt Table: %EDITTABLE2

    PTSF_PSQUERY_DLTCharacter(30)VARCHAR2(30) NOT NULLQuery Name

    Prompt Table: PTSF_DELQRYS_VW

    PTSF_DELETE_URLCharacter(30)VARCHAR2(30) NOT NULLURL Link Field

    Prompt Table: PTSF_DQRYFLD_VW
    Set Control Field: QRYNAME

    PTSF_LASTUPDT_DLTCharacter(30)VARCHAR2(30) NOT NULLLast Modified Date Field

    Prompt Table: PTSF_DQRYFLD_VW

    PTSF_SRCH_UPDDTTMCharacter(30)VARCHAR2(30) NOT NULLLast Modified Date Time

    Prompt Table: PTSF_QRYDTTM_VW

    PTSF_CONTENT_URLCharacter(30)VARCHAR2(30) NOT NULLURL Link

    Prompt Table: PTSF_QRY_URL_VW
    Set Control Field: QRYNAME

    PTSF_DISPLAY_TITLECharacter(254)VARCHAR2(254) NOT NULL*Title
    PTSF_DISPLAY_BODYLong CharacterCLOB NOT NULL*Summary
    PTSF_ISGBLSRCHCharacter(1)VARCHAR2(1) NOT NULLIsGlobalSearch

    Y/N Table Edit

    PTSF_ISSRCACLCharacter(1)VARCHAR2(1) NOT NULLSource Level

    Y/N Table Edit

    PTSF_ISDOCACLCharacter(1)VARCHAR2(1) NOT NULLDocument Level

    Y/N Table Edit

    PTFP_FEED_IDCharacter(30)VARCHAR2(30) NOT NULLFeed ID (see PSFP_FEED).
    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_POST_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name

    Prompt Table: PTSF_POSTAE_VW

    PTSF_POST_AESECCharacter(8)VARCHAR2(8) NOT NULLSection

    Prompt Table: PTSF_POSAESECVW

    PTSF_PRE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name

    Prompt Table: PTSF_PREAE_VW

    PTSF_PRE_AESECCharacter(8)VARCHAR2(8) NOT NULLSection

    Prompt Table: PTSF_PREAESECVW

    LASTREFRESHDTTMDateTime(26)TIMESTAMPLast Swap Refresh Stamp
    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
    DESCR100Character(100)VARCHAR2(100) NOT NULLLength 100 Description
    PTSF_KEYWORDSCharacter(254)VARCHAR2(254) NOT NULLAlternate search keywords
    PTSF_SHOW_RACTIONSCharacter(1)VARCHAR2(1) NOT NULLShow Related Action
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19