GPBR_DRVWPL_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Workplace Cross RefereSocial Workplace Cross Reference Table This record is composed by fields that are common to events of Workplace (S-1060). Each event that shall be sent to the government has an entry on this table. |
| # | 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_EVENT_CD |
Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 4 | WPLACE_LOC_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Worplace location.
1=Employer Establishment 2=Service Taker Establishment 3=Third Party Establishment |
| 5 | WPLACE_CODE_BRA |
Character(10) | VARCHAR2(10) NOT NULL | Workplace code. |
| 6 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 7 | GPBR_SERVICE_TAKER |
Character(3) | VARCHAR2(3) NOT NULL | Service Taker |
| 8 | TP_INS_TYPE_BRA |
Character(2) | VARCHAR2(2) NOT NULL |
Third Party Inscription Type.
10=Juridic Person National Reg 20=INSS Special Register |
| 9 | TP_INSCR_BRA |
Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
| 10 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 11 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |