GPBR_REIMB_PARM

(SQL Table)
Index Back

Reimbursement Parameters

Reimbursement 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