GPBR_EST_DEL_VW (SQL View)	Index Back
Basic Table - Establishment eSocial XML Framework View Table Stores the information about node tag "exclusao" event S-1005 - Basic Table - Establishment and Building Site Table

GPBR_EST_DEL_VW

(SQL View)

Basic Table - Establishment

eSocial XML Framework View Table Stores the information about node tag "exclusao" event S-1005 - Basic Table - Establishment and Building Site Table

SELECT A.GPBR_DRIVER_SEQ ,A.GPBR_DRV_SPLIT_SEQ ,B.COMPANY ,A.GPBR_ESTAB_IN_TYPE ,A.GPBR_ESTAB_ID_EST ,A.BEGIN_DT ,A.GPBR_PER_END_DT FROM %Table(GPBR_STG_ESTAB) 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 GPBR_ESTAB_IN_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Establishment Inscription Type
1=CNPJ
3=CAEPF
4=CNO

5 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID

6 BEGIN_DT Date(10) DATE Begin Date

7 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	GPBR_ESTAB_IN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	eSocial Establishment Inscription Type 1=CNPJ 3=CAEPF 4=CNO
5	GPBR_ESTAB_ID_EST	Character(20)	VARCHAR2(20) NOT NULL	Establishment ID
6	BEGIN_DT	Date(10)	DATE	Begin Date
7	GPBR_PER_END_DT	Date(10)	DATE	Period End Date -- Vacations Brazil