GPBR_EVENT_E_VW (SQL View)	Index Back
eSocail Event Active eSocail Event Active (Initial Basic Data Load)

GPBR_EVENT_E_VW

(SQL View)

eSocail Event Active

eSocail Event Active (Initial Basic Data Load)

SELECT DISTINCT A.COMPANY , B.GPBR_EVENT_CD , C.DESCR100 FROM %Table(GPBR_BASIC_CMP) A , %Table(GPBR_COMP_PARAM) B , %Table(GPBR_EVNT_SETUP) C WHERE A.COMPANY = B.COMPANY AND B.GPBR_EVNT_STATUS = 'A' AND B.GPBR_EVENT_CD = C.GPBR_EVENT_CD AND C.GPBR_EVNT_CATEGORY = 'N' AND C.GPBR_INITIAL_EVNT = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Default Value: GPBR_EVNT_E_SEL.COMPANY

2 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: GPBR_EVNT_E_SEL.COMPANY
2	GPBR_EVENT_CD	Character(6)	VARCHAR2(6) NOT NULL	eSocial - Event Code
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description