GVT_BU_UNIONS (SQL View)	Index Back
Federal Barganing Unit/Unions This table allows the combination of Barganing Unit and Union with Federal specific fields You can create multiple records for a barganing unit/union combination, each with a unique effective date.

GVT_BU_UNIONS

(SQL View)

Federal Barganing Unit/Unions

This table allows the combination of Barganing Unit and Union with Federal specific fields You can create multiple records for a barganing unit/union combination, each with a unique effective date.

SELECT A.BARG_UNIT , A.UNION_CD FROM PS_HR_BU_UNIONS A

# 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

#	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