GPBR_STG_LBR_VW

(SQL View)
 Index Back

Labor Proceedings BRA

Staging Record View. This record is used to generate information related to eSocial layout S-2500 - Labor Proceedings.

SELECT LBR_PR.GPBR_DRIVER_SEQ , LBR_PR.GPBR_DRV_SPLIT_SEQ , DRV.GPBR_EVENT_ID , LBR_PR.GPBR_RECT , LBR_PR.GPBR_RECEIPT_NUM , LBR_PR.GPBR_TP_ENV , LBR_PR.GPBR_ISSUER , LBR_PR.GPBR_VERSION , LBR_PR.GPBR_COMP_INS_TYPE , LBR_PR.ESTAB_ID_BRA , LBR_PR.GPBR_INSCR_TYPE , LBR_PR.GPBR_INSCR_NUMBER , LBR_PR.GPBR_PROC_SOURCE , LBR_PR.GPBR_PROC_NUM , LBR_PR.DECIS_DATE_BRA , LBR_PR.STATE , LBR_PR.CODE_CITY_BRA , LBR_PR.COURTID_BRA , LBR_PR.GPBR_CONCIL_DATE , LBR_PR.GPBR_AMBIT_AGRMNT , LBR_PR.GPBR_CNPJ , LBR_PR.GPBR_CPF_ID , LBR_PR.GPBR_PERSON_NAME , LBR_PR.BIRTHDATE , LBR_PR.GPBR_COMMENTS FROM %Table(GPBR_STG_LBR_PR) LBR_PR , %Table(GPBR_DRIVER_DAT) DRV WHERE LBR_PR.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBR_PR.GPBR_DRV_SPLIT_SEQ = DRV.GPBR_DRV_SPLIT_SEQ AND DRV.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 GPBR_EVENT_ID Character(40) VARCHAR2(40) NOT NULL eSocial - Generate ID Number Governant
4 GPBR_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
5 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num
6 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
7 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
8 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
9 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
10 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
11 GPBR_INSCR_TYPE Character(1) VARCHAR2(1) NOT NULL Inscription Type.
1=CNPJ
2=CPF
12 GPBR_INSCR_NUMBER Character(20) VARCHAR2(20) NOT NULL Inscription Number.
13 GPBR_PROC_SOURCE Character(1) VARCHAR2(1) NOT NULL Proceeding Source.
1=Judicial
2=Submitted to CCP or NINTER
14 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
15 DECIS_DATE_BRA Date(10) DATE Desicion Date Legal Proceedings table
16 STATE Character(6) VARCHAR2(6) NOT NULL State
17 CODE_CITY_BRA Number(7,0) INTEGER NOT NULL Code City Brazil
18 COURTID_BRA Number(4,0) SMALLINT NOT NULL Court ID Value BRA
19 GPBR_CONCIL_DATE Date(10) DATE Date of Conciliation.
20 GPBR_AMBIT_AGRMNT Character(1) VARCHAR2(1) NOT NULL Ambit of Agreement
1=CCP Company
2=CCP Union
3=NINTER
21 GPBR_CNPJ Character(14) VARCHAR2(14) NOT NULL Establlishment CNPJ Number
22 GPBR_CPF_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
23 GPBR_PERSON_NAME Character(92) VARCHAR2(92) NOT NULL Person Name
24 BIRTHDATE Date(10) DATE Date of Birth
25 GPBR_COMMENTS Long Character CLOB Comments.