GPBR_REIMB_PARM(SQL Table) |
Index Back |
---|---|
Reimbursement ParametersReimbursement Parameters |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPBR_WAGE_TYPES_ID | Character(8) | VARCHAR2(8) NOT NULL | Wages Types IDs for eSocial Brazil |
2 | GPBR_REIMB_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Reimbursement Source
1=Health Provider 2=Employer |
3 | GPBR_H_PROV_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
Healt Provider configuration
1=User Field 1 2=User Field 2 3=User Field 3 4=User Field 4 5=User Field 5 6=User Field 6 S=Select Health Provider |
4 | HPROV_CD_BRA | Character(10) | VARCHAR2(10) NOT NULL |
Health Provider Code
Prompt Table: HEALTH_PROV_BRA |
5 | GPBR_DIRF_HLT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
DIRF Health Type
10=Employee 20=Dependent |
6 | GPBR_REIMB_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Reimbursement Period
1=Current Period 2=Previous Years |
7 | PIN_ELEM_NUM | Number(8,0) | INTEGER NOT NULL |
Element Number
Prompt Table: GPBR_PIN_ER_VW |
8 | GPBR_HEALTH_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
Healt Provider User Field Number
1=User Field 1 2=User Field 2 3=User Field 3 4=User Field 4 5=User Field 5 6=User Field 6 Default Value: 1 |
9 | GPBR_H_3P_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
Health Third Party Service Provider User Field Number
1=User Field 1 2=User Field 2 3=User Field 3 4=User Field 4 5=User Field 5 6=User Field 6 |
10 | GPBR_DEPEND_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
Depdente User Field Number
0=Not applicable 1=User Field 1 2=User Field 2 3=User Field 3 4=User Field 4 5=User Field 5 6=User Field 6 Default Value: 0 |