GPBR_LCTN02_VW (SQL View)	Index Back
Basic Table - Wage Event eSocial XML Framework View Table Stores the information about node tag "alteracao" event S-1020 - Basic Table - Tax Location Table

GPBR_LCTN02_VW

(SQL View)

Basic Table - Wage Event

eSocial XML Framework View Table Stores the information about node tag "alteracao" event S-1020 - Basic Table - Tax Location Table

SELECT A.GPBR_DRIVER_SEQ , A.GPBR_DRV_SPLIT_SEQ , A.GPBR_THIRD_PAR_JUD , A.GPBR_NBR_PROCE_JUD , A.CD_SUSP_FPAS_BRA FROM %Table(GPBR_STG_LCTN01) 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 = 'UPD'

# 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 GPBR_THIRD_PAR_JUD Character(4) VARCHAR2(4) NOT NULL eSocial Third Party Code Judicial

4 GPBR_NBR_PROCE_JUD Character(20) VARCHAR2(20) NOT NULL eSocial Number Process Judicial

5 CD_SUSP_FPAS_BRA Number(14,0) DECIMAL(14) NOT NULL Susp Code FPAS

#	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	GPBR_THIRD_PAR_JUD	Character(4)	VARCHAR2(4) NOT NULL	eSocial Third Party Code Judicial
4	GPBR_NBR_PROCE_JUD	Character(20)	VARCHAR2(20) NOT NULL	eSocial Number Process Judicial
5	CD_SUSP_FPAS_BRA	Number(14,0)	DECIMAL(14) NOT NULL	Susp Code FPAS