GPBR_COMP06_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 B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,GPBR_IDE_DMDEV ,GPBR_LABOR_CAT_CD ,GPBR_COMP_INS_TYPE ,ESTAB_ID_BRA ,GPBR_COD_LOCAT ,A.GPBR_PIN_NUM_ITEN ,A.GPBR_ID_TAB_WAGE ,CASE WHEN COUNT(A.GPBR_PIN_NUM_ITEN) > 1 THEN 0 ELSE MAX(A.GPBR_QTD_ERN_WAGE) END AS PCT ,CASE WHEN COUNT(A.GPBR_PIN_NUM_ITEN) > 1 THEN 0 ELSE MAX(A.GPBR_FAC_ERN_WAGE) END AS RATE ,CASE WHEN COUNT(A.GPBR_PIN_NUM_ITEN) > 1 THEN 0 ELSE MAX(A.GPBR_AMT_ERN_WAGE) END AS BASE ,SUM(A.GPBR_RSLT_ERN_WAGE) AS CALC_RSLT_VAL , 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 XRF.GPBR_ESOC_YEAR >= 2021 THEN '0' ELSE ' ' END ELSE ' ' END FROM PS_GPBR_STG_COMP06 A ,PS_GPBR_DRIVER_DAT B ,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 B.GPBR_STATUS = 'XRDY' GROUP BY B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,GPBR_IDE_DMDEV ,GPBR_LABOR_CAT_CD ,GPBR_COMP_INS_TYPE ,ESTAB_ID_BRA ,GPBR_COD_LOCAT ,A.GPBR_PIN_NUM_ITEN ,A.GPBR_ID_TAB_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 XRF.GPBR_ESOC_YEAR >= 2021 THEN '0' ELSE ' ' END ELSE ' ' END

# 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_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
6 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
7 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
8 GPBR_PIN_NUM_ITEN Character(30) VARCHAR2(30) NOT NULL eSocial Wage Code
9 GPBR_ID_TAB_WAGE Character(30) VARCHAR2(30) NOT NULL eSocial Wage Code
10 GPBR_QTD_ERN_WAGE Number(9,2) DECIMAL(8,2) NOT NULL eSocial Wage Earning Qty
11 GPBR_GP_PCT Number(8,2) DECIMAL(7,2) NOT NULL eSocial Wage Percent
12 GPBR_AMT_ERN_WAGE Number(17,2) DECIMAL(16,2) NOT NULL eSocial Wage Earning Amt
13 GPBR_RSLT_ERN_WAGE Number(17,2) DECIMAL(16,2) NOT NULL eSocial Wage EarningRslt
14 GPBR_PAYROLL_TP Character(1) VARCHAR2(1) NOT NULL Payroll TP
0=N/A
1=Monthly
2=Annual