GPBR_UNI_SEL_VW (SQL View)	Index Back
Select Union Codes This view selects union codes based on the effective date. It is used in an array.

GPBR_UNI_SEL_VW

(SQL View)

Select Union Codes

This view selects union codes based on the effective date. It is used in an array.

SELECT A.UNION_CD , A.EFFDT , A.PIN_NUM , A.ELEMENT_TYPE , B.PIN_NM , B.DESCR ,'N' FROM PS_GPBR_UNION_SOVR A , PS_GP_PIN B WHERE A.PIN_NUM=B.PIN_NUM UNION SELECT C.UNION_CD , C.EFFDT , C.PIN_NUM , C.ELEMENT_TYPE , B.PIN_NM , B.DESCR ,'Y' FROM PS_GPBR_SOVR_VAL C , PS_GP_PIN B WHERE C.PIN_NUM=B.PIN_NUM AND C.DEFAULT_IND='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

4 ELEMENT_TYPE Character(6) VARCHAR2(6) NOT NULL Element Type
A=Attribute
D=Dimension
M=Measure

5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 DEFAULT_IND Character(1) VARCHAR2(1) NOT NULL An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
4	ELEMENT_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Element Type A=Attribute D=Dimension M=Measure
5	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DEFAULT_IND	Character(1)	VARCHAR2(1) NOT NULL	An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.