GPBR_STG_HQ(SQL Table) |
Index Back |
|---|---|
Basic Table Employer DataeSocial Stage Table This record is used to generate informations for eSocial layout S-1000 - Basic Table - Employer Data |
| # | 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_TP_ENV | Character(1) | VARCHAR2(1) NOT NULL | eSocial Environment Identification |
| 4 | GPBR_ISSUER | Number(1,0) | SMALLINT NOT NULL | eSocial Issuer |
| 5 | GPBR_COMP_INS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | eSocial Company Inscription Type |
| 6 | ESTAB_ID_BRA | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
| 7 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 8 | GPBR_PER_END_DT | Date(10) | DATE | Period End Date -- Vacations Brazil |
| 9 | GPBR_DESCR | Character(115) | VARCHAR2(115) NOT NULL | Description |
| 10 | TAX_CLASSIF_BRA | Character(2) | VARCHAR2(2) NOT NULL | Tax Classification Field. |
| 11 | LEGAL_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Legal Entity for Company |
| 12 | IND_CONSTRUC_BRA | Character(1) | VARCHAR2(1) NOT NULL | Construction Indicator for Brazil Company. |
| 13 | UNBURD_INDIC_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Payroll unburdening
0=Not Applicable 1=Company - Current Legislation 1=Art. 7 to 9 Law 12.546/2011 2=Municipality - Current Legs 2=Art. 7 to 9 Law 12.546/2011 |
| 14 | GPBR_TIMECARD_TYPE | Number(1,0) | SMALLINT NOT NULL | Timecard Type Brazil for RAIS |
| 15 | GPBR_WAGE_FINE | Character(1) | VARCHAR2(1) NOT NULL | eSocial Wage Fine. If Company has more than one Wage Table definition |
| 16 | FAP_PCT_BRA | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | FAP factor Preventions Accidental Factor |
| 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 | GPBR_ISE_FIL_MIN | Character(70) | VARCHAR2(70) NOT NULL | Granted Exemption |
| 20 | ISE_FIL_CERT_BRA | Character(40) | VARCHAR2(40) NOT NULL | Exemption Certificate Number |
| 21 | ISE_DT_ISSUED_BRA | Date(10) | DATE | Exemption Issued Date Certificate |
| 22 | ISE_DT_EXPIRATN_BR | Date(10) | DATE | Certificate Expiration Date |
| 23 | ISE_PROTREN_NBR_BR | Character(40) | VARCHAR2(40) NOT NULL | Protocol Renewal Number |
| 24 | ISE_RENEWAL_DT_BRA | Date(10) | DATE | Issued Date Renewal |
| 25 | ISE_DOU_DT_BRA | Date(10) | DATE | DOU Issued Date |
| 26 | ISE_DOU_PG_BRA | Number(5,0) | INTEGER NOT NULL | DOU page |
| 27 | GPBR_PERSON_NAME | Character(92) | VARCHAR2(92) NOT NULL | Person Name |
| 28 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 29 | GPBR_PHONE_BUSN | Character(30) | VARCHAR2(30) NOT NULL | Business Phone Number. |
| 30 | GPBR_PHONE_MOBILE | Character(30) | VARCHAR2(30) NOT NULL | Business Phone Number. |
| 31 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 32 | SPCL_PARTNER_BRA | Character(1) | VARCHAR2(1) NOT NULL |
To track Special Partnership Company Situation.
0=Normal Situation 1=Extinction 2=Merger 3=Split 4=Incorporation |
| 33 | GPBR_NEW_BGN_DT | Date(10) | DATE | eSocial New Begin Date |
| 34 | EDUC_ENT_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Education Entity Contract
N=No Y=Yes |
| 35 | ORG_CONV_DT_BRA | Date(10) | DATE | Date Conversion to Profit Organization |
| 36 | PIS_COFINS_TAX_BRA | Character(1) | VARCHAR2(1) NOT NULL | PIS/COFINS Tax Indicator. |