GPBR_NRP_C_P_VW (SQL View)	Index Back
Wage Type Compl Pension Fund Wage Type Complementary Pension fund setup - AD Record

GPBR_NRP_C_P_VW

(SQL View)

Wage Type Compl Pension Fund

Wage Type Complementary Pension fund setup - AD Record

SELECT GPBR_WAGE_TYPES_ID , PIN_ELEM_NUM + 50000000 , FAPI_CD_BRA FROM PS_GPBR_C_PEN_FUND

# 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 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number

3 FAPI_CD_BRA Character(10) VARCHAR2(10) NOT NULL Fapi Provider Code

#	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	PIN_ELEM_NUM	Number(8,0)	INTEGER NOT NULL	Element Number
3	FAPI_CD_BRA	Character(10)	VARCHAR2(10) NOT NULL	Fapi Provider Code