GPBR_ES5002_MRE(SQL Table) |
Index Back |
---|---|
Medical expense reimbursementsIncome tax information: infoReembMed tag fields in S-5002 file for Medical expense reimbursements. |
# | 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_ROW_SEQUENCE | Number(3,0) | SMALLINT NOT NULL | Row sequence in the layout. |
4 | GPBR_DET | Number(1,0) | SMALLINT NOT NULL | eSocial Ind Calculation |
5 | ESTAB_ID_BRA | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
6 | HPROV_ANS_CD_BRA | Character(6) | VARCHAR2(6) NOT NULL | ANS Registry |