GPBR_STG_WAG_AD

(SQL Table)
Index Back

Wage Type Stg AD Record

eSocial Wage Type Staging AD Record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
3 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
4 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
5 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
6 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
7 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
8 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number
9 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
10 GPBR_WAGE_TYPES_ID Character(8) VARCHAR2(8) NOT NULL Wages Types IDs for eSocial Brazil
11 BEGIN_DT Date(10) DATE Begin Date
12 GPBR_PER_END_DT Date(10) DATE Period End Date -- Vacations Brazil
13 GPBR_PIN_DESCR Character(100) VARCHAR2(100) NOT NULL eSocial Wage Description
14 GPBR_ELEM_CODE Character(6) VARCHAR2(6) NOT NULL Report Code
15 GPBR_WAGE_ENTRY_TY Character(1) VARCHAR2(1) NOT NULL Wage Entry Type
1=Earming
2=Deduction
3=Informative
4=Informative Deduction
16 GPBR_CP_TYPE Character(2) VARCHAR2(2) NOT NULL INSS Tax Incident
17 GPBR_IR_TYPE Character(4) VARCHAR2(4) NOT NULL eSocial Income Tax Type
18 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)
19 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
20 GPBR_DSR_IND Character(1) VARCHAR2(1) NOT NULL DSR Indicator
N=No
Y=Yes
21 GPBR_13SAL_IND Character(1) VARCHAR2(1) NOT NULL 13 th Salary Indicator
N=No
Y=Yes
22 GPBR_VACATION_IND Character(1) VARCHAR2(1) NOT NULL GP Brazil Vacation Indicator
23 GPBR_TERMN_IND Character(1) VARCHAR2(1) NOT NULL Termination Indicator
N=NO
Y=YES
24 GPBR_INI_VAL_DATE Date(10) DATE Initial Validity Date
25 GPBR_END_VAL_DATE Date(10) DATE End Validity Date