BARG_UNIT1=Bargaining Unit 1
2=Bargaining Unit 2
UNION_CDEFFDTDefault Value: %date
GVT_CONTACT_NRA=Active
I=Inactive
Default Value: A
GVT_UNION_CNTCT(SQL Table) |
Index Back |
|---|---|
Union Contact NamesUse GVT_UNION_CNTCT to identify the people to use as primary contacts for unions business. You can create multiple contacts for a union - 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 |
| 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_CONTACT_NR |
Character(10) | VARCHAR2(10) NOT NULL | Union Contact Number |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 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 |