GPBR_DRIVER_SEQ01=Regular / Construction
02=Partial Contract
03=Partial Contract
11=Different FPAS/Third
90=Location Outside Country
04=Legal Entity
05=ST-Temp Work- Replace of Staff
06=ST-Temp Work- Contingent Work
GPBR_DRVLOC_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Tax Location Cross RefeSocial Tax Location Cross Reference Table This record is composed by fields that are common to events to Tax Location. 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_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 3 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 4 | GPBR_SERVICE_TAKER | Character(3) | VARCHAR2(3) NOT NULL | Service Taker |
| 5 | TP_LOCAT_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Location Type
01=Regular / Construction 02=Partial Contract 03=Partial Contract 11=Different FPAS/Third 90=Location Outside Country |
| 6 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 7 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |
| 8 | GPBR_CNTRCT_BGN_DT | Date(10) | DATE | Contract Begin Date for Service Takers Bra |
| 9 | GPBR_PRE_EFFDT | Date(10) | DATE | GP BRA Prevous Effective Date eSocial |
| 10 | TP_SERV_TAKER_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Service Taker Type
04=Legal Entity 05=ST-Temp Work- Replace of Staff 06=ST-Temp Work- Contingent Work |