BARG_UNIT1=Bargaining Unit 1
2=Bargaining Unit 2
UNION_CDEFFDTDefault Value: %date
GVT_STEWARD_NRA=Active
I=Inactive
Default Value: A
GVT_UNION_STWD(SQL Table) |
Index Back |
|---|---|
Union StewardsUse GVT_UNION_STWD to identify the union stewards. You can create multiple GVT_UNION_STWD records for a union, each with a unique 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 |
| 2 | UNION_CD |
Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GVT_STEWARD_NR |
Character(10) | VARCHAR2(10) NOT NULL | Union Steward Number |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | UNION_STEWARD_NAME | Character(50) | VARCHAR2(50) NOT NULL | Union Steward |
| 7 | GVT_UNION_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Union Title |
| 8 | GVT_PRIMARY_PHONE | Character(12) | VARCHAR2(12) NOT NULL | Primary Phone |
| 9 | GVT_ALTERNATE_PHON | Character(12) | VARCHAR2(12) NOT NULL | Alternate Phone |
| 10 | GVT_FAX_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Fax Number |