FSFB_FLTRVALS(SQL Table) |
Index Back |
|---|---|
Filter ValuesFilter values |
| # | 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 | 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 |
| 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 |
| 12 | LABEL30 | Character(30) | VARCHAR2(30) NOT NULL | Label Description 30 char |
| 13 | FSFB_SQL_LONG | Long Character | CLOB | SQL Statement |