GPBR_RAIS_E_WRK(SQL Table) |
Index Back |
|---|---|
RAIS Establishment Work TableRAIS Establishment Work Table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 3 | COMP_INS_TYPE_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Company Inscription Type
10=Juridic Person National Reg 20=INSS Special Register |
| 4 | GPBR_CNPJ | Character(14) | VARCHAR2(14) NOT NULL | Establlishment CNPJ Number |
| 5 | RAIS_ESTAB_PRE_BRA | Character(2) | VARCHAR2(2) NOT NULL | Establishment Prefix RAIS |
| 6 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 7 | OWNER_NUM_BRA | Number(4,0) | SMALLINT NOT NULL | Number of Owners Working in Establishment |
| 8 | ESTAB_TYPE_CD_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Establishment Type Code
1=Micro 2=Small 3=Other |
| 9 | PAT_OPTION_BRA | Character(1) | VARCHAR2(1) NOT NULL | PAT Participation Option |
| 10 | OWN_SERV_PCT_BRA | Number(3,0) | SMALLINT NOT NULL | Own Service Percentage |
| 11 | KIT_ADMIN_PCT_BRA | Number(3,0) | SMALLINT NOT NULL | Kitchen Administration Percentage |
| 12 | MEAL_AGR_PCT_BRA | Number(3,0) | SMALLINT NOT NULL | Meals Agreement Percentage |
| 13 | TRANS_MEAL_PCT_BRA | Number(3,0) | SMALLINT NOT NULL | Transported Meals Percentage |
| 14 | FOOD_BSKT_PCT_BRA | Number(3,0) | SMALLINT NOT NULL | Food Basket Percentage |
| 15 | 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 |
| 16 | RAIS_DT_BRA | Character(2) | VARCHAR2(2) NOT NULL | Base Date for Collective Agree |
| 17 | FEED_AGR_PCT_BRA | Number(3,0) | SMALLINT NOT NULL | Feeding Tickets Agreement Percentage |
| 18 | CAGED_CLOSEACT_BRA | Character(1) | VARCHAR2(1) NOT NULL | Closing Activities CAGED |
| 19 | CAT_DATE_BRA | Date(10) | DATE | Date CAT Brazil |
| 20 | ASSOC_UNION_ID_BRA | Character(3) | VARCHAR2(3) NOT NULL | Union for Associative Contribution |
| 21 | ASSOC_UNION_AM_BRA | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Associative Contribution Amount |
| 22 | GPBR_ASSOC_CNPJ | Character(14) | VARCHAR2(14) NOT NULL | CNPJ Assoc Union |
| 23 | CONTR_UNION_ID_BRA | Character(3) | VARCHAR2(3) NOT NULL | Union Contribution |
| 24 | CONTR_UNION_AM_BRA | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Union Contribution Amount |
| 25 | GPBR_CONTR_CNPJ | Character(14) | VARCHAR2(14) NOT NULL | CNPJ Contr Union |
| 26 | ASSIS_UNION_ID_BRA | Character(3) | VARCHAR2(3) NOT NULL | Union for Assistive Contribution |
| 27 | ASSIS_UNION_AM_BRA | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Assistive Contribution Amount |
| 28 | GPBR_ASSIS_CNPJ | Character(14) | VARCHAR2(14) NOT NULL | CNPJ Assis Union |
| 29 | CONFE_UNION_ID_BRA | Character(3) | VARCHAR2(3) NOT NULL | Confederative Contribution |
| 30 | CONFE_UNION_AM_BRA | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Confederative Contribution |
| 31 | GPBR_CONFE_CNPJ | Character(14) | VARCHAR2(14) NOT NULL | CNPJ Confe Union |
| 32 | WO_ACTIVITIES_BRA | Character(1) | VARCHAR2(1) NOT NULL | Without Activities |
| 33 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 34 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 35 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 36 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 37 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 38 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 39 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 40 | COUNTY_CD_BRA | Number(7,0) | INTEGER NOT NULL | COUNTY_CD_BRA County Code |
| 41 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 42 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 43 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 44 | GPBR_CNAE | Character(7) | VARCHAR2(7) NOT NULL | CNAE Brazilian National ID |
| 45 | LEGAL_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Legal Entity for Company |
| 46 | SIMPLES_OPTION_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Option Simples Brazil
01=Non Opting 02=Opting 03=Opting + 1.200.000,00 Annual 04=Non Opting + 1.200.000,00 Annl 05=No Opting Company with Injunc 06=Opting + 1.200.000 with Injunc |
| 47 | GPBR_CEI | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
| 48 | RAIS_RESP_ID_BRA | Character(11) | VARCHAR2(11) NOT NULL | Responsible ID RAIS |
| 49 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |