RBQ_SRCHDFN_TM2(SQL Table) |
Index Back |
---|---|
BO Search Result TempBO Search Result Temporary record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DESCR100_1 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
2 | DESCR100_2 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
3 | DESCR100_3 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
4 | DESCR100_4 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
5 | DESCR100_5 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
6 | DESCR100_6 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
7 | DESCR100_7 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
8 | DESCR100_8 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
9 | DESCR100_9 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
10 | DESCR100_10 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
11 | DESCR100_11 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
12 | DESCR100_12 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
13 | DESCR100_13 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
14 | DESCR100_14 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
15 | DESCR100_15 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
16 | DESCR100_16 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
17 | DESCR100_17 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
18 | DESCR100_18 | Character(100) | VARCHAR2(100) NOT NULL | Description of length 100 |
19 | SRCHRL_ID | Character(20) | VARCHAR2(20) NOT NULL |
BO Search Role ID
Prompt Table: RBQ_SRCHRL |
20 | SRCHSQL_ID | Character(20) | VARCHAR2(20) NOT NULL | BO Search SQL ID |
21 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
22 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
23 | REL_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
24 | BO_REL_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
This field describes the position of a Relationship pertaining to a BO. i.e. - To identify a BO in a relationship, BO_REL_ID and BO_REL_POSITION give you the relative position F = First, S = Second.
F=First Position S=Second Postion |
25 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
26 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes |
27 | BO_ID_2 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 2 |
28 | ROLE_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
29 | REL_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
30 | BO_NAME_DISPLAY_2 | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
31 | PRIMARY_IND2 | Character(1) | VARCHAR2(1) NOT NULL |
primary ind
N=No Y=Yes |
32 | GROUP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Group Sequence Number |
33 | EDIT_BTN | Character(1) | VARCHAR2(1) NOT NULL | Edit |
34 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
C=C N=N Y=Y Y/N Table Edit |
35 | DELETE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Deletion Flag
N=Not Selected Y=Selected |
36 | MATCH_SCORE_NUM | Number(3,0) | SMALLINT NOT NULL | Duplicate match score percentage |