GB_MERGE_TBL

(SQL Table)
Index Back

Group Build Merging Table

This record is use to merge the group defininition and Query. The select statement for the construction of the group is built from this table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
4 OPERAND_SEQ Number(3,0) SMALLINT NOT NULL Criteria Number
5 LRECNAME Character(15) VARCHAR2(15) NOT NULL Left Record (Table) Name
6 LFIELDNAME Character(18) VARCHAR2(18) NOT NULL Left Field Name
7 RRECNAME Character(15) VARCHAR2(15) NOT NULL Right Record (Table) Name
8 RFIELDNAME Character(18) VARCHAR2(18) NOT NULL Right Field Name
9 SQL_OPERATOR Character(1) VARCHAR2(1) NOT NULL SQL Operator
A=Equal
B=Less than
C=Greater than
D=Less or Equal
E=Greater or Equal
F=In List
G=Not in List
H=Between
I=Not Equal
J=Minimum
K=Maximum
L=Current
M=Is Null
N=Not Null
O=Not Between
P=Like
Q=Not Like
R=Effdt <=
S=Effdt >=
T=Effdt <
U=Effdt >
10 EFFDTOPERATOR_FLG Character(1) VARCHAR2(1) NOT NULL Effective date operator flag

Y/N Table Edit

Default Value: N

11 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
12 BINDABLE_FLG Character(1) VARCHAR2(1) NOT NULL Bindable?
13 GROUP_RIGHT_PAREN Character(1) VARCHAR2(1) NOT NULL Right parentheses for group selection criteria.
0=
1=)
2=))
3=)))
4=))))
5=)))))
14 GROUP_LEFT_PAREN Character(1) VARCHAR2(1) NOT NULL Left Parentheses for groups.
0=
1=(
2=((
3=(((
4=((((
5=(((((
15 GROUP_BOOLEAN Character(3) VARCHAR2(3) NOT NULL Boolean for groups
AND=AND
OR=OR
16 NEGATION Character(1) VARCHAR2(1) NOT NULL Negation
17 R2CRTEXPNUM Number(3,0) SMALLINT NOT NULL Right2 Criteria Expression No.