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 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Query Name | |
| 3 | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. | |
| 4 | 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. |