GPGB_EVENT_VW (SQL View)	Index Back
Pension Event views GBR Pension Event views GBR

GPGB_EVENT_VW

(SQL View)

Pension Event views GBR

SELECT DISTINCT A.GPGB_PEN_EVENT , A.GPGB_EVENT_DESCR ,B.GPGB_PRC_USED_FLG FROM PS_GPGB_SET_EVNTL0 A , PS_GPGB_SET_EVNTL1 B WHERE B.GPGB_PEN_EVENT = A.GPGB_PEN_EVENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPGB_PEN_EVENT Character(20) VARCHAR2(20) NOT NULL Pension Events GBR

2 GPGB_EVENT_DESCR Character(100) VARCHAR2(100) NOT NULL GBR Pension Event Descr

3 GPGB_PRC_USED_FLG Character(1) VARCHAR2(1) NOT NULL Process Used Flag for GBR
0=NO
1=YES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPGB_PEN_EVENT	Character(20)	VARCHAR2(20) NOT NULL	Pension Events GBR
2	GPGB_EVENT_DESCR	Character(100)	VARCHAR2(100) NOT NULL	GBR Pension Event Descr
3	GPGB_PRC_USED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Process Used Flag for GBR 0=NO 1=YES