GVT_UNION_VW

(SQL View)
Index Back

Union Table View

This view allow prompting of the Union Tbl without a bargianing unit value.

SELECT A.BARG_UNIT, A.UNION_CD, A.EFFDT, A.EFF_STATUS, B.DESCRSHORT FROM PS_GVT_BU_UNION A, PS_UNION_TBL B WHERE A.UNION_CD = B.UNION_CD

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description