TL_GRP_PARM_TBL(SQL Table) |
Index Back |
|---|---|
TL Group Parameters TableTL Group Parameters Table. This is used for group creation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TL_GROUP_ID |
Character(7) | VARCHAR2(7) NOT NULL | Time and Labor Groups |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | GROUP_BOOLEAN | Character(3) | VARCHAR2(3) NOT NULL |
Boolean for groups
AND=AND OR=OR Default Value: AND |
| 4 | GROUP_LEFT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Left Parentheses for groups.
0= 1=( 2=(( 3=((( 4=(((( 5=((((( Default Value: 0 |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: TL_GRP_REC_VW |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: TL_GRP_FLD_EDIT |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 8 | GROUP_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
SQL operator for Groups
<=< <==<= <>=<> === >=> >==>= LIKE=LIKE Default Value: = |
| 9 | GROUP_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
Value for group selection criteria.
Prompt Table: %GRP_VALUE_EDIT |
| 10 | GROUP_RIGHT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Right parentheses for group selection criteria.
0= 1=) 2=)) 3=))) 4=)))) 5=))))) Default Value: 0 |