GPBR_HQ_DEL_VW (SQL View)	Index Back
Basic Table - Employer Data eSocial XML Framework View Table Stores the information about node tag "exclusao" event S-1000 - Basic Table - Employer Data

GPBR_HQ_DEL_VW

(SQL View)

Basic Table - Employer Data

eSocial XML Framework View Table Stores the information about node tag "exclusao" event S-1000 - Basic Table - Employer Data

SELECT B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,B.COMPANY ,A.BEGIN_DT ,A.GPBR_PER_END_DT FROM %Table(GPBR_STG_HQ) A , %Table(GPBR_DRIVER_DAT) B WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND B.GPBR_STATUS = 'XRDY' AND B.GPBR_ACTION = 'DEL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence

2 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

4 BEGIN_DT Date(10) DATE Begin Date

5 GPBR_PER_END_DT Date(10) DATE Period End Date -- Vacations Brazil

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPBR_DRIVER_SEQ	Number(30,0)	DECIMAL(30) NOT NULL	Driver Sequence
2	GPBR_DRV_SPLIT_SEQ	Number(20,0)	DECIMAL(20) NOT NULL	eSocial - Split Sequence
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	BEGIN_DT	Date(10)	DATE	Begin Date
5	GPBR_PER_END_DT	Date(10)	DATE	Period End Date -- Vacations Brazil