TS_PROFILE_TXT(SQL Table) |
Index Back |
|---|---|
Search Criteria - TextSearch Criteria - Text |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: TS_PROFILE.OPRID |
| 2 | TS_SRCH_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Text Search Identifier
Default Value: TS_PROFILE.TS_SRCH_ID |
| 3 | TS_SRCH_BASE_TEXT |
Character(30) | VARCHAR2(30) NOT NULL | Base Search Text |
| 4 | TS_SRCH_LANG_TEXT |
Character(30) | VARCHAR2(30) NOT NULL | Non-Base Search Text |
| 5 | TS_RPLC_LANG_TEXT |
Character(30) | VARCHAR2(30) NOT NULL | Replacement Text |
| 6 | TS_BASE_MATCHTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Base Text Matching Type
E=Exact Text Match F=Full Word Match P=Like Text Match Default Value: F |
| 7 | TS_LANG_MATCHTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Lang Text Matching Type
E=Exact Text Match F=Full Word Match P=Like Text Match Default Value: F |
| 8 | TS_BASE_MATCH_CASE | Character(1) | VARCHAR2(1) NOT NULL |
Base Match Case
Y/N Table Edit Default Value: N |
| 9 | TS_LANG_MATCH_CASE | Character(1) | VARCHAR2(1) NOT NULL |
Lang Match Case
Y/N Table Edit Default Value: N |
| 10 | TS_RPLC_MATCH_CASE | Character(1) | VARCHAR2(1) NOT NULL |
Replace Text Case
N=Overwrite Text Y=Preserve Original Case Default Value: Y |