GPBR_EVT_HST_VW (SQL View)	Index Back
Vw of eSocial evts hist txns View for importing historical transactions of eSocial events.

GPBR_EVT_HST_VW

(SQL View)

Vw of eSocial evts hist txns

View for importing historical transactions of eSocial events.

SELECT GPBR_EVENT_CD , EFFDT , DESCR100 FROM PS_GPBR_EVNT_SETUP WHERE GPBR_IMP_HIST_DATA = 'Y'

Related Language Record: GPBR_EVNT_S_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE Effective Date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPBR_EVENT_CD	Character(6)	VARCHAR2(6) NOT NULL	eSocial - Event Code
2	EFFDT	Date(10)	DATE	Effective Date
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description