GPBR_EUC1_VW (SQL View)	Index Back
Labor Event - Accident at Work eSocial Stage Table This record is used to generate informations for eSocial layout S-1300 -Employer Union Contribution - TAG- cnpjSindic

GPBR_EUC1_VW

(SQL View)

Labor Event - Accident at Work

eSocial Stage Table This record is used to generate informations for eSocial layout S-1300 -Employer Union Contribution - TAG- cnpjSindic

SELECT B.GPBR_DRIVER_SEQ , B.GPBR_DRV_SPLIT_SEQ , A.UNION_CNPJ_BRA , A.GPBR_ES_CONT_TYP , A.GPBR_ES_AMT FROM %Table(GPBR_STG_EUC1) 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'

# 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 UNION_CNPJ_BRA Character(14) VARCHAR2(14) NOT NULL Union CNPJ, this is the ID that all the companies/establishments in Brazil have.

4 GPBR_ES_CONT_TYP Character(1) VARCHAR2(1) NOT NULL Contribution Type Employeer Union Contribution
1=Compulsory
2=Associative
3=Assistance
4=Confederative

5 GPBR_ES_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL January Amount

#	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	UNION_CNPJ_BRA	Character(14)	VARCHAR2(14) NOT NULL	Union CNPJ, this is the ID that all the companies/establishments in Brazil have.
4	GPBR_ES_CONT_TYP	Character(1)	VARCHAR2(1) NOT NULL	Contribution Type Employeer Union Contribution 1=Compulsory 2=Associative 3=Assistance 4=Confederative
5	GPBR_ES_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	January Amount