SRCH_CNFG_FMAP(SQL Table) |
Index Back |
|---|---|
Search Configuration Field MapSearch Configuration Field Map |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SRCH_CONFIG_ID |
Character(20) | VARCHAR2(20) NOT NULL | Search Configuration ID |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | SRCH_OPERATOR |
Character(4) | VARCHAR2(4) NOT NULL |
Allowed logic operator by field type
!IN=not in 0=All Values 1=equal to 2=less than 21=before 3=greater than 31=after 4=less than or equal to 41=on or before 5=greater than or equal to 51=on or after 6=between 7=begins with 8=contains 9=in <=< <==<= <>=not = === >=> >==>= A=not in B=not equal BEG=begins with BTWN=between IN=in LIKE=contains |
| 5 | FROM_FIELDNAME | Character(30) | VARCHAR2(30) NOT NULL | From FieldName |
| 6 | TO_FIELDNAME | Character(30) | VARCHAR2(30) NOT NULL | To FieldName |
| 7 | SECURE | Character(1) | VARCHAR2(1) NOT NULL |
Secure
Y/N Table Edit |