EOWC_VIEWBY_VAL(SQL Table) |
Index Back |
|---|---|
WorkCenter View By - ValuesWorkCenter View By - My Work Link Filter Values |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | PAGELET_CONFIG_ID |
Character(18) | VARCHAR2(18) NOT NULL | FSWC-Workcenter ID |
| 3 | EOWC_VIEWBY |
Character(36) | VARCHAR2(36) NOT NULL | Filter criteria identification |
| 4 | FILTER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table: FSFB_FLTRDEFN |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: FSFB_RECFLD_VW |
| 6 | OPERATION | Character(3) | VARCHAR2(3) NOT NULL |
Arithmetic Operation
<=Less Than <==Less Than or Equal To <>=Not Equal To ==Equal To >=Greater Than >==Greater Than or Equal To |
| 7 | OPER_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Operation Fieldname |
| 8 | OP_TIME_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Time Unit
DY=Days HR=Hours MN=Minutes Default Value: DY |
| 9 | FSFB_VALUEFROM_01 | Character(254) | VARCHAR2(254) NOT NULL |
"From" value
Prompt Table: %EDITTABLE |
| 10 | FSFB_VALUETO_01 | Character(254) | VARCHAR2(254) NOT NULL |
"To" value
Prompt Table: %EDITTABLE |
| 11 | FSFB_VALDTFROM_01 | Date(10) | DATE | "From" value |
| 12 | FSFB_VALDTTO_01 | Date(10) | DATE | "To" value |
| 13 | FSFB_VALUEIN_01 | Long Character(1999) | VARCHAR2(1999) | "IN" list values |
| 14 | LABEL30 | Character(30) | VARCHAR2(30) NOT NULL | Label Description 30 char |
| 15 | FSFB_SQL_LONG | Long Character | CLOB | SQL Statement |