GB_MERGEVAL_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 GB_VALUE_NBR Number(3,0) SMALLINT NOT NULL Value Number
6 GB_VALUE Character(254) VARCHAR2(254) NOT NULL Field Value
7 GB_VALUE_DT Date(10) DATE Date
8 GB_VALUE_DTTM DateTime(26) TIMESTAMP Date Time
9 GB_VALUE_TM Time(15) TIMESTAMP Time
10 ADD_FLD1_NAME Character(50) VARCHAR2(50) NOT NULL Additional Field 1 Name
11 ADD_FLD1_VALUE Character(50) VARCHAR2(50) NOT NULL Additional Field 1 Value
12 ADD_FLD2_NAME Character(50) VARCHAR2(50) NOT NULL Additional Field 2 Name
13 ADD_FLD2_VALUE Character(50) VARCHAR2(50) NOT NULL Additional Field 2 Value
14 ADD_FLD3_NAME Character(50) VARCHAR2(50) NOT NULL Additional Field 3 Name
15 ADD_FLD3_VALUE Character(50) VARCHAR2(50) NOT NULL Additional Field 3 Value
16 ADD_FLD4_NAME Character(50) VARCHAR2(50) NOT NULL Additional Field 4 Name
17 ADD_FLD4_VALUE Character(50) VARCHAR2(50) NOT NULL Additional Field 4 Value
18 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
19 EXPRESSIONTEXT Long Character CLOB Expression Text