FSFB_FLTRFLDS(SQL Table) |
Index Back |
|---|---|
Filter FieldsFilter fields |
| # | 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).
Prompt Table: FSFB_RECFLD_VW |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table: FSFB_FLDLBL_VW |
| 5 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit Default Value: N |
| 6 | FSFB_RESTRICT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Operands if Required
Y/N Table Edit Default Value: N |
| 7 | PROMPT_TABLE | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
Prompt Table: FSFBRECDEFN_VW3 |
| 8 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 9 | XLAT_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Xlat Fieldname
Prompt Table: FSFB_INSEL_VW |
| 10 | KEY_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
Defines the primary "value" field to use when searching a table for "IN" list values.
Prompt Table: FSFB_INSEL_VW |
| 11 | DESCR_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Defines the primary "description" field to use when searching a table for "IN" list values.
Prompt Table: FSFB_INSEL_VW |
| 12 | FSFB_YES | Character(1) | VARCHAR2(1) NOT NULL | Yes |
| 13 | FSFB_NO | Character(1) | VARCHAR2(1) NOT NULL | No |
| 14 | FSFB_EXCLUDEIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Exclude "IN" operator flag for WorkCenter
Y/N Table Edit Default Value: N |