PSPTSF_SD_ATTR

index back

  • Parent record: PSPTSF_SD
  • PeopleSoft Field Name Field Type Column Type Description
    PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
    SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    QRYNAMEPARENT Character(30) VARCHAR2(30) NOT NULL Connected Queries Parent Query Name
    PTSF_SRCATTR_NAME Character(65) VARCHAR2(65) NOT NULL Attribute Name (see PSPTSF_ATTRS).
    PTSF_ISFIELDTOIDX Character(1) VARCHAR2(1) NOT NULL Field to Index

    Y/N Table Edit

    PTSF_ISFLDTODISPL Character(1) VARCHAR2(1) NOT NULL Field to Display

    Y/N Table Edit

    PTSF_ISATTACHMENT Character(1) VARCHAR2(1) NOT NULL Attachment Field

    Y/N Table Edit

    PTSF_IS_CLUSTERD Character(1) VARCHAR2(1) NOT NULL Define Hierarchy

    Y/N Table Edit

    Default: N

    FLDDATESEPARATOR Character(1) VARCHAR2(1) NOT NULL Hierarchy Separator

    Default: /

    PTSF_IS_FACETED Character(1) VARCHAR2(1) NOT NULL Is Faceted

    Y/N Table Edit

    Default: N

    PTSF_ATTR_ENC Character(2) VARCHAR2(2) NOT NULL Attribute Encoding
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19