GPBR_COMP15_VW

(SQL View)
 Index Back

Periodic eSocial Compensation

eSocial XML Framework View Table This record is used to generate informations for eSocial layout S-1200 - Periodic eSocial - Compensation TAG-Group itensRemun

SELECT A.GPBR_DRIVER_SEQ , A.GPBR_DRV_SPLIT_SEQ , A.GPBR_IDE_DMDEV , A.GPBR_LABOR_CAT_CD , A.GPBR_DATE1 , A.GPBR_CAL_PRD_ID , B.COMP_INS_TYPE_BRA , B.ESTAB_ID_BRA , B.GPBR_COD_LOCAT , A.GPBR_PIN_NUM_ITEN , A.GPBR_ID_TAB_WAGE , CASE WHEN A.GPBR_QTD_ERN_WAGE < 0 THEN 0 ELSE A.GPBR_QTD_ERN_WAGE END , CASE WHEN A.GPBR_FAC_ERN_WAGE < 0 THEN 0 ELSE A.GPBR_FAC_ERN_WAGE END , A.GPBR_AMT_ERN_WAGE , A.GPBR_RSLT_ERN_WAGE , CASE WHEN XRF.GPBR_PAYROLL_TP = '1' THEN CASE WHEN XRF.GPBR_ES_PS >= %DateIn('2021-07-01') THEN '0' ELSE ' ' END WHEN XRF.GPBR_PAYROLL_TP = '2' THEN CASE WHEN GPBR_ESOC_YEAR >= 2021 THEN '0' ELSE ' ' END ELSE ' ' END FROM PS_GPBR_STG_COMP15 A , PS_GPBR_STG_COMP13 B , PS_GPBR_DRIVER_DAT C , PS_GPBR_DRVCMP_XRF XRF WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND A.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND A.ESTABID = B.ESTABID AND B.GPBR_CAL_PRD_ID = A.GPBR_CAL_PRD_ID AND A.GPBR_IDE_DMDEV = B.GPBR_IDE_DMDEV AND A.GPBR_DRIVER_SEQ = C.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = C.GPBR_DRV_SPLIT_SEQ AND C.GPBR_STATUS = 'XRDY'

# 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 GPBR_IDE_DMDEV Character(30) VARCHAR2(30) NOT NULL eSocial Unique payment identifier.
4 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code
5 GPBR_DATE1 Date(10) DATE Date 1
6 GPBR_CAL_PRD_ID Character(7) VARCHAR2(7) NOT NULL eSocial Period Calculation
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_GP_PCT Number(8,2) DECIMAL(7,2) NOT NULL eSocial Wage Percent
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_PAYROLL_TP Character(1) VARCHAR2(1) NOT NULL Payroll TP
0=N/A
1=Monthly
2=Annual