RBQ_SRCHDFN_TM2

(SQL Table)
Index Back

BO Search Result Temp

BO 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