GB_MERGE_TBL(SQL Table) |
Index Back |
---|---|
Group Build Merging TableThis 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. |