GPBR_STG_TERM03

(SQL Table)
 Index Back

eSocial Termination Event

eSocial Stage Table This record is used to generate informations for eSocial layout S-2299 - Labor Event Termination - TAG detVerbas S-2399 - Labor Event - Workers who have no employment relationship End TAG - detVerbas

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
2 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
3 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
4 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
5 GPBR_IDE_DMDEV Character(30) VARCHAR2(30) NOT NULL eSocial Unique payment identifier.
6 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code
7 GPBR_COM_INS_TYPEE Character(2) VARCHAR2(2) NOT NULL Company Inscription Type
8 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
9 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
10 GPBR_PIN_NUM_ITEN Character(30) VARCHAR2(30) NOT NULL eSocial Wage Code
11 GPBR_ID_TAB_WAGE Character(30) VARCHAR2(30) NOT NULL eSocial Wage Code
12 GPBR_QTD_ERN_WAGE Number(9,2) DECIMAL(8,2) NOT NULL eSocial Wage Earning Qty
13 GPBR_FAC_ERN_WAGE Number(8,2) DECIMAL(7,2) NOT NULL eSocial Wage Factor
14 GPBR_AMT_ERN_WAGE Number(17,2) DECIMAL(16,2) NOT NULL eSocial Wage Earning Amt
15 GPBR_RSLT_ERN_WAGE Number(17,2) DECIMAL(16,2) NOT NULL eSocial Wage EarningRslt
16 GPBR_WAGE_CODE Number(4,0) SMALLINT NOT NULL Wage Type Code
17 GPBR_CP_TYPE Character(2) VARCHAR2(2) NOT NULL INSS Tax Incident