FILTER_IDPrompt Table: FSFB_FLTRDEFN
OPRIDPrompt Table: OPERATOR_VW
PAGELET_CONFIG_IDEOWC_VIEWBYEOWC_VWBY_SRCH(SQL View) |
Index Back |
|---|---|
Filter Values search recFilter Values search rec |
| SELECT FILTER_ID , OPRID , PAGELET_CONFIG_ID , EOWC_VIEWBY FROM PS_EOWC_VIEWBY_VAL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FILTER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table: FSFB_FLTRDEFN |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 3 | PAGELET_CONFIG_ID |
Character(18) | VARCHAR2(18) NOT NULL | FSWC-Workcenter ID |
| 4 | EOWC_VIEWBY |
Character(36) | VARCHAR2(36) NOT NULL | Filter criteria identification |