GPBR_JUD_AD2_VW (SQL View)	Index Back
Basic Table - Judicial Table eSocial XML Framework View Table Stores the information about node tag "inclusao" event S-1070 - Basic Table - Juducal Proceeding Table

GPBR_JUD_AD2_VW

(SQL View)

Basic Table - Judicial Table

eSocial XML Framework View Table Stores the information about node tag "inclusao" event S-1070 - Basic Table - Juducal Proceeding Table

SELECT A.GPBR_DRIVER_SEQ , A.GPBR_DRV_SPLIT_SEQ , A.SUSP_CODE_BRA , A.DECIS_DATE_BRA , A.TAX_SUP_BRA , CASE WHEN A.DEPOSIT_BRA = 'Y' THEN 'S' ELSE A.DEPOSIT_BRA END FROM %Table(GPBR_STG_JUD02) 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 = 'ADD'

# 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 SUSP_CODE_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code BRA

4 DECIS_DATE_BRA Date(10) DATE Desicion Date Legal Proceedings table
Default Value: %date

5 TAX_SUP_BRA Character(2) VARCHAR2(2) NOT NULL Taxe Supension Type
Prompt Table: TAX_SUS_TBL_BRA

6 DEPOSIT_BRA Character(1) VARCHAR2(1) NOT NULL Deposit Table 1070
N=No
Y=Yes

#	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	SUSP_CODE_BRA	Number(14,0)	DECIMAL(14) NOT NULL	Suspension Code BRA
4	DECIS_DATE_BRA	Date(10)	DATE	Desicion Date Legal Proceedings table Default Value: %date
5	TAX_SUP_BRA	Character(2)	VARCHAR2(2) NOT NULL	Taxe Supension Type Prompt Table: TAX_SUS_TBL_BRA
6	DEPOSIT_BRA	Character(1)	VARCHAR2(1) NOT NULL	Deposit Table 1070 N=No Y=Yes