PTSF_SRCCAT_NAMEPTSF_FACET_NAMEPrompt Table: PTSF_CATFCTP_V
A=Application Class
E=Employee ID
O=User ID
N=No
Y=Yes
N=No
Y=Yes
N=Collapse
Y=Expand
PSPTSF_CATFACET(SQL Table) |
Index Back |
|---|---|
Facets list for a categoryWhen the UI is dynamically generated this table can provide the list of facets that can be rendered for a given category. |
| # | 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 |
| 4 | PTSF_ASSOIATED_FCT | Character(2) | VARCHAR2(2) NOT NULL |
Facet Association
A=Application Class E=Employee ID O=User ID |
| 5 | PTSF_FACET_ORDER | Character(70) | VARCHAR2(70) NOT NULL | Facet order |
| 6 | PTSF_FCT_MINDOC_NO | Number(3,0) | SMALLINT NOT NULL | Minimum Document Count |
| 7 | PTSF_FCT_MAX_CHILD | Signed Number(7,0) | DECIMAL(6) NOT NULL | Maximum Facet Children |
| 8 | PTSF_DISFCT_COUNT | Character(1) | VARCHAR2(1) NOT NULL |
Disable Facet Count
N=No Y=Yes |
| 9 | PTSF_FCT_MULTISEL | Character(1) | VARCHAR2(1) NOT NULL |
Allow Multi Select
N=No Y=Yes |
| 10 | PTSF_EXPANDED_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Expand Tree Facet
N=Collapse Y=Expand |