EOWC_FVALS_VW(SQL View) |
Index Back |
|---|---|
Filter ValuesFilter values |
| SELECT FILTER_ID , FIELDNAME , OPRID , OPERATION , OPER_FIELDNAME , OP_TIME_UNIT , FSFB_VALUEFROM_01 , FSFB_VALUETO_01 , FSFB_VALDTFROM_01 , FSFB_VALDTTO_01 , FSFB_VALUEIN_01 FROM PS_FSFB_FLTRVALS |
| # | 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 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: FSFB_RECFLD_VW |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 4 | EOWC_SRCH_COND | Character(4) | VARCHAR2(4) NOT NULL |
Search condition 1 for character fields
<=< <==<= <>=not= === >=> >==>= BEG=begins with BET=between CON=contains IN=in WIT=within last |
| 5 | OPER_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Operation Fieldname |
| 6 | OP_TIME_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Time Unit
DY=Days HR=Hours MN=Minutes Default Value: DY |
| 7 | FSFB_VALUEFROM_01 | Character(254) | VARCHAR2(254) NOT NULL |
"From" value
Prompt Table: %EDITTABLE |
| 8 | FSFB_VALUETO_01 | Character(254) | VARCHAR2(254) NOT NULL |
"To" value
Prompt Table: %EDITTABLE |
| 9 | FSFB_VALDTFROM_01 | Date(10) | DATE | "From" value |
| 10 | FSFB_VALDTTO_01 | Date(10) | DATE | "To" value |
| 11 | FSFB_VALUEIN_01 | Long Character(1999) | VARCHAR2(1999) | "IN" list values |