GPBR_REIMB_PARM(SQL Table) |
Index Back |
---|---|
Reimbursement ParametersReimbursement Parameters |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Wages Types IDs for eSocial Brazil | |
2 | Character(1) | VARCHAR2(1) NOT NULL |
Reimbursement Source
1=Health Provider 2=Employer |
|
3 | 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 | Character(10) | VARCHAR2(10) NOT NULL |
Health Provider Code
Prompt Table: HEALTH_PROV_BRA |
|
5 | Character(2) | VARCHAR2(2) NOT NULL |
DIRF Health Type
10=Employee 20=Dependent |
|
6 | Character(1) | VARCHAR2(1) NOT NULL |
Reimbursement Period
1=Current Period 2=Previous Years |
|
7 | 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 |