GPBR_DRIVER_SEQGPBR_DRV_SPLIT_SEQGPBR_LABOR_CAT_CDGPBR_IND_RESBRCOUNTRYGPBR_IND_BENEFGPBR_ES5002_EXT(SQL Table) |
Index Back |
|---|---|
Beneficiary addressBeneficiary address complementary info: endExt tag fields in S-5002 file. |
| # | 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_LABOR_CAT_CD |
Character(3) | VARCHAR2(3) NOT NULL | eSocial Labor Category Legal Code |
| 4 | GPBR_IND_RESBR |
Character(1) | VARCHAR2(1) NOT NULL | eSocial Live Abroad |
| 5 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | GPBR_IND_BENEF |
Number(1,0) | SMALLINT NOT NULL | eSocial Nif Beneficiary |
| 7 | GPBR_NIF_BENEF | Character(20) | VARCHAR2(20) NOT NULL | eSocial Nif Beneficiary |
| 8 | GPBR_ADDRESS_PLACE | Character(100) | VARCHAR2(100) NOT NULL | Address place. |
| 9 | GPBR_ADDRESS_NUM | Character(10) | VARCHAR2(10) NOT NULL | Address number. |
| 10 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 11 | GPBR_NEIGHBORHOOD | Character(90) | VARCHAR2(90) NOT NULL | Neighborhood or district. |
| 12 | GPBR_CITY | Character(50) | VARCHAR2(50) NOT NULL | City. |
| 13 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |