GPBR_NRP_WTD_VW

(SQL View)
 Index Back

Wage Type Table Detail

Wage Type Detail Table for eSocial

SELECT GPBR_WAGE_TYPES_ID ,GPBR_WAGE_CODE ,ENTRY_TYPE_ELEM ,PIN_ELEM_NUM + 50000000 ,BGN_DT ,GPBR_WAGE_ENTRY_TY ,GPBR_CP_TYPE ,GPBR_IR_TYPE ,GPBR_FG_TYPE ,GPBR_UN_TYPE ,GPBR_DSR_IND ,GPBR_13SAL_IND ,GPBR_VAC_IND ,GPBR_TERMN_IND ,LAST_UPDT_OPRID ,LAST_UPDT_DTTM FROM %Table(GPBR_WAGTYP_DTL)

# 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_WAGE_CODE Number(4,0) SMALLINT NOT NULL Wage Type Code
3 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
4 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number
5 BGN_DT Date(10) DATE NOT NULL Begin Date
6 GPBR_WAGE_ENTRY_TY Character(1) VARCHAR2(1) NOT NULL Wage Entry Type
1=Earming
2=Deduction
3=Informative
4=Informative Deduction

Default Value: 1

7 GPBR_CP_TYPE Character(2) VARCHAR2(2) NOT NULL INSS Tax Incident
8 GPBR_IR_TYPE Character(4) VARCHAR2(4) NOT NULL eSocial Income Tax Type
9 GPBR_FG_TYPE Character(2) VARCHAR2(2) NOT NULL FGTS Incidence
00=Not Applicable
11=FGTS - Base
12=FGTS - 13th Salary
21=FGTS-Termination(Prior Notice)
31=eConsignado Discount
91=Susp Judicial Monthly
92=Susp Judicial 13th Salary
93=Susp Judicial (Prior Notice)

Default Value: 00

10 GPBR_UN_TYPE Character(2) VARCHAR2(2) NOT NULL Union Contribution Incidence
00=Not Applicable
11=Union Cont.- Monthly Base
31=Union Contributiobn - Value
91=Suspended By Judicial Decision

Default Value: 00

11 GPBR_DSR_IND Character(1) VARCHAR2(1) NOT NULL DSR Indicator
N=No
Y=Yes

Default Value: N

12 GPBR_13SAL_IND Character(1) VARCHAR2(1) NOT NULL 13 th Salary Indicator
N=No
Y=Yes

Default Value: N

13 GPBR_VAC_IND Character(1) VARCHAR2(1) NOT NULL Vacation Indicator
N=NO
Y=YES

Default Value: N

14 GPBR_TERMN_IND Character(1) VARCHAR2(1) NOT NULL Termination Indicator
N=NO
Y=YES

Default Value: N

15 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
16 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp