GB_FROMCRIT_TBL(SQL Table) |
Index Back |
|---|---|
Group Build - Group CriteriaGroup build - Group Criteria records |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GB_CRITERIA_ID |
Character(5) | VARCHAR2(5) NOT NULL |
Group Criteria ID
Prompt Table: GB_CRITERIA_TBL |
| 2 | OPERAND_SEQ |
Number(3,0) | SMALLINT NOT NULL | Criteria Number |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: GB_TABLES_VW |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: GB_RECFIELD_VW |
| 5 | FIELDLABEL | Character(30) | VARCHAR2(30) NOT NULL |
Field Label
Default Value: PSDBFLDLABL_VW.LONGNAME |
| 6 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table: GB_RECDEFN_VW |
| 7 | GROUP_RIGHT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Right parentheses for group selection criteria.
0= 1=) 2=)) 3=))) 4=)))) 5=))))) Default Value: 0 |
| 8 | GROUP_LEFT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Left Parentheses for groups.
0= 1=( 2=(( 3=((( 4=(((( 5=((((( Default Value: 0 |
| 9 | GROUP_BOOLEAN | Character(3) | VARCHAR2(3) NOT NULL |
Boolean for groups
AND=AND OR=OR Default Value: AND |
| 10 | GB_FROMCRIT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Group Build - From Crtietria Flag
Y/N Table Edit Default Value: Y |