| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
COUNTY_CD_BRA |
Number(7,0) |
INTEGER NOT NULL |
COUNTY_CD_BRA
County Code
Prompt Table:
CITYCODE_VW_BRA
|
| 4 |
COMP_INS_TYPE_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Company Inscription Type
10=Juridic Person National Reg
20=INSS Special Register
Default Value: 10
|
| 5 |
ESTAB_ASOC_BRA |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment CNPJ Asociated
Prompt Table:
GET_CNPJ_VW_BRA
|
| 6 |
LOCAT_TYPE_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
eSocial Location Type
Prompt Table:
LOC_TYPE_BRA
|
| 7 |
ESTAB_TYPE_CD_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Establishment Type Code
1=Micro
2=Small
3=Other
Default Value: 3
|
| 8 |
THIRD_PTY_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Social Security Third Party
|
| 9 |
WORK_RISK_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
work risk Brazil
|
| 10 |
INDEPENDNT_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Independent Percentage
|
| 11 |
COMPANY_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Company Percentage
|
| 12 |
SAT_UP_15Y_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
SAT Percentage Up to 15 Years
|
| 13 |
SAT_UP_20Y_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
SAT Percentage Up to 20 Years
|
| 14 |
SAT_UP_25Y_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
SAT Percentage Up to 25 Years
|
| 15 |
ISE_FIL_PCT_BRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Philanthropy Exempt Percentage
|
| 16 |
RAT_PROCEEDING_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
RAT Process Type Field
A=Administrative
J=Judicial
N=None
Default Value: N
|
| 17 |
RAT_NBR_PROCED_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
RAT Process Number
|
| 18 |
FAP_PROCEEDING_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
FAP Process Type
A=Administrative
J=Judicial
N=None
Default Value: N
|
| 19 |
FAP_NBR_PROCED_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
FAP Process Number
|
| 20 |
ISE_FIL_MIN_BRA |
Character(4) |
VARCHAR2(4) NOT NULL |
Granted Exemption
CNAS=CNAS - Social Welfare
LAW=LAW - Specific Law
MDS=MDS - Soc. Dev. Fight Hunger
MEC=MEC - Ministry of Education
MS=MS - Ministry of Health
|
| 21 |
ISE_FIL_CERT_BRA |
Character(40) |
VARCHAR2(40) NOT NULL |
Exemption Certificate Number
|
| 22 |
ISE_DT_ISSUED_BRA |
Date(10) |
DATE |
Exemption Issued Date Certificate
|
| 23 |
ISE_DT_EXPIRATN_BR |
Date(10) |
DATE |
Certificate Expiration Date
|
| 24 |
ISE_PROTREN_NBR_BR |
Character(40) |
VARCHAR2(40) NOT NULL |
Protocol Renewal Number
|
| 25 |
ISE_RENEWAL_DT_BRA |
Date(10) |
DATE |
Issued Date Renewal
|
| 26 |
ISE_DOU_DT_BRA |
Date(10) |
DATE |
DOU Issued Date
|
| 27 |
ISE_DOU_PG_BRA |
Number(5,0) |
INTEGER NOT NULL |
DOU page
|
| 28 |
CAGED_CLOSEACT_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Closing Activities CAGED
Y/N Table Edit
Default Value: N
|
| 29 |
CAT_DATE_BRA |
Date(10) |
DATE |
Date CAT Brazil
|
| 30 |
DIRF_REP_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative Type DIRF
1=Company
2=Employee
3=Non Employee
Default Value: 2
|
| 31 |
DIRF_RESP_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID DIRF
Prompt Table:
%GP_EDIT_FLD1
|
| 32 |
PV_ADM_BRA |
Character(17) |
VARCHAR2(17) NOT NULL |
PV Administration
Prompt Table:
BNK_BRCH_VW_BRA
|
| 33 |
TSO_DT_BRA |
Date(10) |
DATE |
TSO Generation Date
|
| 34 |
RAIS_ESTAB_PRE_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Establishment Prefix RAIS
|
| 35 |
OWNER_NUM_BRA |
Number(4,0) |
SMALLINT NOT NULL |
Number of Owners Working in Establishment
|
| 36 |
PAT_OPTION_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
PAT Participation Option
Y/N Table Edit
Default Value: N
|
| 37 |
RAIS_CENTR_IND_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
RAIS Centralizer indicator
|
| 38 |
CENTR_ESTABID_BRA |
Character(12) |
VARCHAR2(12) NOT NULL |
Centralizer Establishment ID
Prompt Table:
EST_RAIS_WV_BRA
|
| 39 |
OWN_SERV_PCT_BRA |
Number(3,0) |
SMALLINT NOT NULL |
Own Service Percentage
|
| 40 |
KIT_ADMIN_PCT_BRA |
Number(3,0) |
SMALLINT NOT NULL |
Kitchen Administration Percentage
|
| 41 |
MEAL_AGR_PCT_BRA |
Number(3,0) |
SMALLINT NOT NULL |
Meals Agreement Percentage
|
| 42 |
FEED_AGR_PCT_BRA |
Number(3,0) |
SMALLINT NOT NULL |
Feeding Tickets Agreement Percentage
|
| 43 |
TRANS_MEAL_PCT_BRA |
Number(3,0) |
SMALLINT NOT NULL |
Transported Meals Percentage
|
| 44 |
FOOD_BSKT_PCT_BRA |
Number(3,0) |
SMALLINT NOT NULL |
Food Basket Percentage
|
| 45 |
TIMECARD_TYPE_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Timecard Type Brazil for RAIS
00=00 Negative RAIS
01=01 Up 10 employees all months
02=02 Manual system control
03=03 Mechanical control system
04=04 SREP - Decree 1.510/2009
05=05 Art 1 Decree Alter non-elec
06=06 Decree Alternative electron
|
| 46 |
RAIS_DT_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Base Date for Collective Agree
Prompt Table:
MONTH_BRA_VW
|
| 47 |
ASSOC_UNION_ID_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Union for Associative Contribution
Prompt Table:
UN_CNPJ_VW_BRA
|
| 48 |
ASSOC_UNION_AM_BRA |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Associative Contribution
Amount
|
| 49 |
CONTR_UNION_ID_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Contribution
Prompt Table:
UN_CNPJ_VW_BRA
|
| 50 |
CONTR_UNION_AM_BRA |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Union Contribution Amount
|
| 51 |
ASSIS_UNION_ID_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Union for Assistive Contribution
Prompt Table:
UN_CNPJ_VW_BRA
|
| 52 |
ASSIS_UNION_AM_BRA |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Assistive Contribution Amount
|
| 53 |
CONFE_UNION_ID_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Confederative Contribution
Prompt Table:
UN_CNPJ_VW_BRA
|
| 54 |
CONFE_UNION_AM_BRA |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Confederative Contribution
|
| 55 |
GPS_PAY_CD_BRA |
Number(4,0) |
SMALLINT NOT NULL |
Payment Code for GPS (Social Security Contribution Code)
|
| 56 |
FPAS_CD_BRA |
Number(3,0) |
SMALLINT NOT NULL |
FPAS Social Assistant & Prevision Code
Prompt Table:
FPAS_TBL_BRA
|
| 57 |
SAT_CD_BRA |
Number(5,0) |
INTEGER NOT NULL |
Work Accident Insurance Code
|
| 58 |
THIRD_PARTY_CD_BRA |
Number(4,0) |
SMALLINT NOT NULL |
Third Party Code
Prompt Table:
FPAS_TERC_BRA
|
| 59 |
SEFIP_REP_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative Type SEFIP
1=Company
2=Employee
3=Non Employee
Default Value: 2
|
| 60 |
SEFIP_RESP_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Representative ID SEFIP
Prompt Table:
%GP_EDIT_FLD2
|
| 61 |
SEFIP_RESPN_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee Representative ID SEFIP
Prompt Table:
PERS_SRCH_EMP
|
| 62 |
RAIS_REP_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative Type RAIS
1=Company
2=Employee
3=Non Employee
Default Value: 2
|
| 63 |
RAIS_RESP_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID RAIS
Prompt Table:
%GP_EDIT_FLD3
|
| 64 |
CNAE_ALTER_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAE Alteration
Y/N Table Edit
Default Value: N
|
| 65 |
CENTRALIZE_CD_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Centralization Code
0=Not Centralized
1=Centralizer
2=Centralized
|
| 66 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table:
SRC_BANK
|
| 67 |
ACTIVE_PIS_BRA |
Number(1,0) |
SMALLINT NOT NULL |
PIS Activated
1/0 Table Edit (1=True, 0=False)
Default Value: 0
|
| 68 |
LEGAL_ENT_TYPE_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Entity Type Brazil (Company Name for Legal Reports)
COM=Company
EST=Establishment
Default Value: COM
|
| 69 |
GRRF_REP_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative Type GRRF
1=Company
2=Employee
3=Non Employee
Default Value: 2
|
| 70 |
GRRF_RESP_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Representative ID GRRF
Prompt Table:
%GP_EDIT_FLD4
|
| 71 |
GRRF_CONT_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Contact ID GRRF
Prompt Table:
PERS_S_E_VW_BRA
|
| 72 |
LAST_REG_NUM_BRA |
Number(11,0) |
DECIMAL(11) NOT NULL |
Used to keep the last employee registry number for an establishment
Default Value: 1
|
| 73 |
FAP_PCT_BRA |
Signed Number(7,4) |
DECIMAL(5,4) NOT NULL |
FAP percentage
Preventions Accidental Factor
Default Value: 1
|
| 74 |
CAGED_REP_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative Type CAGED
1=Employee
2=Non Employee
Default Value: 1
|
| 75 |
CAGED_RESP_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID DIRF
Prompt Table:
%GP_EDIT_FLD5
|
| 76 |
WO_ACTIVITIES_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Without Activities
|
| 77 |
ESOC_REP_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative Type eSocial
1=Company
2=Employee
3=Non Employee
Default Value: 2
|
| 78 |
ESOCIAL_RES_ID_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
eSocial Responsible
Prompt Table:
GPBR_EMP_SRC_VW
|
| 79 |
UNBURD_INDIC_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll unburdening
0=Not Applicable
1=Art. 14 Law 11.774/2008
2=Art. 7 to 9 Law 12.546/2011
Default Value: 0
|
| 80 |
CONTRIB_SUBST_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Override of the employer's contribution (civil construction)
0=Not Applicable
1=Admin Proceeding
2=Judicial Proceeding
Default Value: 0
|
| 81 |
TP_LOCAT_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Location Type
01=Department
02=Own civil construction
03=Partial Contract
11=Different FPAS/Third
90=Location Outside Country
Default Value: 01
|
| 82 |
MAIN_ESTAB_BRA |
Character(15) |
VARCHAR2(15) NOT NULL |
Main establishment
Prompt Table:
EST_CMP_BRA_VW
|