GPBR_EST_UPD_VW

(SQL View)
 Index Back

Basic Table - Establishment

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

SELECT A.GPBR_DRIVER_SEQ ,A.GPBR_DRV_SPLIT_SEQ ,B.COMPANY ,A.GPBR_TP_ENV ,A.GPBR_ISSUER ,A.GPBR_COMP_INS_TYPE ,A.ESTAB_ID_BRA ,A.GPBR_ESTAB_IN_TYPE ,A.GPBR_ESTAB_ID_EST ,A.BEGIN_DT ,A.GPBR_CNAE ,A.GPBR_WORK_RISK_PCT ,CASE WHEN (SELECT C.SEND_FAP_TO_ES_BRA FROM PS_ESTAB_TBL_BRA C, PS_GPBR_DRVEST_XRF D WHERE C.ESTABID = B.ESTABID AND C.EFFDT = (SELECT MAX(C1.EFFDT) FROM PS_ESTAB_TBL_BRA C1 WHERE C1.ESTABID = C.ESTABID AND C1.EFFDT <= B.GPBR_ES_MAP_DT) AND C.COUNTY_CD_BRA = D.COUNTY_CD_BRA AND D.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ) = 'Y' THEN A.FAP_PCT_BRA WHEN A.GPBR_ESTAB_IN_TYPE = '4' AND A.GPBR_CNPJ = ' ' THEN A.FAP_PCT_BRA ELSE 0 END ,A.GPBR_RATE_FAP ,A.RAT_PROCEEDING_BRA ,A.RAT_NBR_PROCED_BRA ,A.FAP_PROCEEDING_BRA ,A.FAP_NBR_PROCED_BRA ,A.CONTRIB_SUBST_BRA ,A.GPBR_PER_END_DT ,A.GPBR_NEW_BGN_DT ,A.SUSP_CODE_RAT_BRA ,A.SUSP_CODE_FAP_BRA ,A.APPRENT_CONTR_BRA ,A.PROCEED_NBR_AP_BRA ,A.EDUC_ENT_AP_BRA ,A.GPBR_TIMECARD_CD ,A.CONT_DISAB_BRA ,A.PROCEED_NBR_BRA ,A.GPBR_CNPJ 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 = '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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
5 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
6 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
7 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
8 GPBR_ESTAB_IN_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Establishment Inscription Type
1=CNPJ
3=CAEPF
4=CNO
9 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
10 BEGIN_DT Date(10) DATE Begin Date
11 GPBR_CNAE Character(7) VARCHAR2(7) NOT NULL CNAE Brazilian National ID
12 GPBR_WORK_RISK_PCT Number(1,0) SMALLINT NOT NULL work risk Brazil
13 FAP_PCT_BRA Signed Number(7,4) DECIMAL(5,4) NOT NULL FAP factor Preventions Accidental Factor
14 GPBR_RATE_FAP Number(7,4) DECIMAL(6,4) NOT NULL Rate after adjusting for FAP
15 RAT_PROCEEDING_BRA Character(1) VARCHAR2(1) NOT NULL RAT Process Type Field
A=Administrative
J=Judicial
N=None
16 RAT_NBR_PROCED_BRA Character(30) VARCHAR2(30) NOT NULL RAT Process Number
17 FAP_PROCEEDING_BRA Character(1) VARCHAR2(1) NOT NULL FAP Process Type
A=Administrative
F=FAP
J=Judicial
N=None
18 FAP_NBR_PROCED_BRA Character(30) VARCHAR2(30) NOT NULL FAP Process Number
19 CONTRIB_SUBST_BRA Character(1) VARCHAR2(1) NOT NULL Override of the employer's contribution (civil construction)
0=Not Applicable
1=Replaced Contribution
2=Non-Replaced Contribution
20 GPBR_PER_END_DT Date(10) DATE Period End Date -- Vacations Brazil
21 GPBR_NEW_BGN_DT Date(10) DATE eSocial New Begin Date
22 SUSP_CODE_RAT_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code RAT
23 SUSP_CODE_FAP_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code FAP
24 APPRENT_CONTR_BRA Character(1) VARCHAR2(1) NOT NULL Apprentice Contract
0=Exempted by Law
1=Exempted by Judicial Process
2=Mandatory
9=Not Applicable
25 PROCEED_NBR_AP_BRA Character(20) VARCHAR2(20) NOT NULL Proceeding Number
26 EDUC_ENT_AP_BRA Character(1) VARCHAR2(1) NOT NULL Education Entity Contract
N=No
Y=Yes
27 GPBR_TIMECARD_CD Character(1) VARCHAR2(1) NOT NULL Timecard Code
0=Not Applicable
1=Manual System Control
2=Mechanical Control Sysytem
3=SREP-Decree.510/2009
4=Decree Alternative no Eletron
5=Decree Alternative Eletronic
6=Electronic-Others
28 CONT_DISAB_BRA Character(1) VARCHAR2(1) NOT NULL Disabled People Contract
0=Exempted by Law
1=Exempted by Judicial Process
2=Mandatory
9=Not Applicable
29 PROCEED_NBR_BRA Character(20) VARCHAR2(20) NOT NULL Proceeding Number
30 GPBR_CNPJ Character(14) VARCHAR2(14) NOT NULL Establlishment CNPJ Number