RBQ_CRITDFN_TMP(SQL Table) |
Index Back |
|---|---|
BO Search Criteria DefinitionBO Search Criteria Definition Temporary record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEFAULT_OPERATOR | Character(2) | VARCHAR2(2) NOT NULL |
Default Operator
1=begins with 2=contains 3== 4=not = 5=< 6=<= 7=> 8=>= |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Field for Descriptions of 50 Characters |
| 4 | FIELD_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Field Sequence Number |
| 5 | FLDDFN_ID | Character(20) | VARCHAR2(20) NOT NULL | BO Search Role ID |
| 6 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |