| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
GB_GROUP_TBL
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 3 |
OPERAND_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Criteria Number
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
GB_TABLES_VW
|
| 5 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Default Value: GB_REC_FIELD.EDITTABLE
Prompt Table:
GB_RECDEFN_VW
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
GB_RECFIELD_VW
|
| 7 |
FIELDLABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label
Default Value: GB_REC_FIELD.FIELDLABEL
|
| 8 |
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 >
Default Value: A
|
| 9 |
GROUP_RIGHT_PAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Right parentheses for group selection criteria.
0=
1=)
2=))
3=)))
4=))))
5=)))))
Default Value: 0
|
| 10 |
GROUP_LEFT_PAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Left Parentheses for groups.
0=
1=(
2=((
3=(((
4=((((
5=(((((
Default Value: 0
|
| 11 |
GROUP_BOOLEAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Boolean for groups
AND=AND
OR=OR
Default Value: AND
|
| 12 |
GB_FROMCRIT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Build - From Crtietria Flag
Y/N Table Edit
Default Value: N
|
| 13 |
GB_VALUES_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
Values List
|