GPBR_NRP_RMB_VW

(SQL View)
 Index Back

Reimbursement Parameters

Reimbursement Parameters

SELECT GPBR_WAGE_TYPES_ID , GPBR_REIMB_SOURCE , GPBR_H_PROV_FIELD , HPROV_CD_BRA , GPBR_DIRF_HLT_TYPE , GPBR_REIMB_PERIOD , PIN_ELEM_NUM + 50000000 , GPBR_HEALTH_FIELD , GPBR_H_3P_FIELD , GPBR_DEPEND_FIELD FROM PS_GPBR_REIMB_PARM

# 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
5 GPBR_DIRF_HLT_TYPE Character(2) VARCHAR2(2) NOT NULL DIRF Health Type
10=Employee
20=Dependent

Default Value: 10

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
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