SEARCH_DEFN_NAMEOPRIDA=Advanced Search
B=Basic Search
M=Advanced - More Search Options
Prompt Table: RC_ROW_TBL
RB_VRTY_UR_CFG(SQL Table) |
Index Back |
|---|---|
User ConfigurationUser Level Configuration Table for Verity options under user preferences |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEARCH_DEFN_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Search Definition Name |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | SEARCH_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Search Mode: Advance, Basic, More Options
A=Advanced Search B=Basic Search M=Advanced - More Search Options |
| 4 | ROW_NUMERIC | Number(6,0) | INTEGER NOT NULL |
Row Numeric
Prompt Table: RC_ROW_TBL |