GPBR_DRIVER_SEQGPBR_DRV_SPLIT_SEQ1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
1=Indeterminate
2=Indeterminate w/probation prd
3=Determinate
GPBR_STG_PRE_HI(SQL Table) |
Index Back |
|---|---|
Labor Event - Hiring - PrelimieSocial Stage Table This record is used to generate informations for eSocial layout S-2190 - Labor Event - Hiring - Preliminary Event - TAG- evtAdmPrelim |
| # | 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 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 8 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 9 | LAST_HIRE_DT | Date(10) | DATE | Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD. |
| 10 | GPBR_RECEIPT_PREV | Character(40) | VARCHAR2(40) NOT NULL | Register Previous |
| 11 | GPBR_COD_CATEG | Number(3,0) | SMALLINT NOT NULL | Category Code |
| 12 | CONT_SAL_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly 2=Fortnightly 3=Weekly 4=Daily 5=Hourly 6=Per Task 7=Commission 8=Other |
| 13 | GPBR_VLREC | Number(17,2) | DECIMAL(16,2) NOT NULL | eSocial Payment |
| 14 | GPBR_RECT | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Ind Calculation |
| 15 | GPBR_REG_ESOCIAL | Character(30) | VARCHAR2(30) NOT NULL | eSocial eSocial Register |
| 16 | GPBR_NAT_ACTIV | Number(1,0) | SMALLINT NOT NULL | Activity |
| 17 | CBO_CD_BRA | Character(7) | VARCHAR2(7) NOT NULL | Occupation Code for Brazil |
| 18 | CNTR_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Contract Type Bra
1=Indeterminate 2=Indeterminate w/probation prd 3=Determinate |
| 19 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |