FILTER_IDFIELDNAMEFIELDVALUEFSFB_YESNO_VW(SQL View) |
Index Back |
|---|---|
Filters Yes/No view |
| SELECT FILTER_ID , FIELDNAME , FSFB_YES FROM PS_FSFB_FLTRFLDS UNION SELECT FILTER_ID , FIELDNAME , FSFB_NO FROM PS_FSFB_FLTRFLDS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FILTER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Filter criteria identification |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | FIELDVALUE |
Character(4) | VARCHAR2(4) NOT NULL | Field Value |