BARG_UNIT1=Bargaining Unit 1
2=Bargaining Unit 2
Prompt Table: GVT_BARG_UNIT
UNION_CDPrompt Table: UNION_TBL
GVT_NEGBLTY_ITEMPrompt Table: GVT_UNION_NEGBL
EFFDTDefault Value: %date
GVT_NGBLTY_STEPGVT_NGBLTY_STEP(SQL Table) |
Index Back |
|---|---|
Union Negblty Appeals StepsUse GVT_NGBLTY_STEP to identify the step in the appeals process an item is in and the date it entered that step. You can create multiple steps per item - each with a unique identifier and effective date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BARG_UNIT |
Character(4) | VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: GVT_BARG_UNIT |
| 2 | UNION_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Union Code
Prompt Table: UNION_TBL |
| 3 | GVT_NEGBLTY_ITEM |
Character(7) | VARCHAR2(7) NOT NULL |
Non-Negotiable Item
Prompt Table: GVT_UNION_NEGBL |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | GVT_NGBLTY_STEP |
Character(2) | VARCHAR2(2) NOT NULL | Appeal Step |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |