GPBR_STG_COMP06

(SQL Table)
Index Back

Periodic eSocial Compensation

eSocial Stage Table This record is used to generate informations for eSocial layout S-1200 - Periodic eSocial � Compensation TAG-Group itensRemun

# 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_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
8 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
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_CP_TYPE Character(2) VARCHAR2(2) NOT NULL INSS Tax Incident
17 GPBR_WAGE_CODE Number(4,0) SMALLINT NOT NULL Wage Type Code