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

GPBR_EVT_CMP_VW

(SQL View)

eSocail Event Active

eSocail Event Active (Initial Basic Data Load)

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: GPBR_CMP_FLG_VW

4 GPBR_ES_PS Date(10) DATE eSocial on PeopleSoft Date

5 GPBR_ES_LAST Date(10) DATE eSocial on PeopleSoft Last Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: GPBR_CMP_FLG_VW
4	GPBR_ES_PS	Date(10)	DATE	eSocial on PeopleSoft Date
5	GPBR_ES_LAST	Date(10)	DATE	eSocial on PeopleSoft Last Date