PTSF_CAT_FACETS

(SQL Table)
Index Back

Facets list for a category

When the UI is dynamically generated this tables can provide the list of facets that can be rendered for a givin category.

  • Parent record: PTSF_SRCHCAT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).
    2 PTSF_FACET_NAME Character(65) VARCHAR2(65) NOT NULL Facet Name

    Prompt Table: PTSF_CATFCTP_V

    3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number