GPBR_TERM03_VW

(SQL View)
 Index Back

eSocial Termination Event

eSocial XML Framework View 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

SELECT B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,A.GPBR_IDE_DMDEV , A.GPBR_LABOR_CAT_CD ,A.GPBR_COM_INS_TYPEE ,A.GPBR_ESTAB_ID_EST ,A.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 C.TERMINATION_DT >= %DateIn('2021-07-01') THEN '0' ELSE ' ' END FROM %Table(GPBR_STG_TERM03) A ,%Table(GPBR_DRIVER_DAT) B ,%Table (GPBR_STG_TERM) C 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 = C.GPBR_DRIVER_SEQ AND B.GPBR_STATUS = 'XRDY' GROUP BY B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,A.GPBR_IDE_DMDEV ,A.GPBR_LABOR_CAT_CD ,A.GPBR_COM_INS_TYPEE ,A.GPBR_ESTAB_ID_EST ,A.GPBR_COD_LOCAT ,A.GPBR_PIN_NUM_ITEN ,A.GPBR_ID_TAB_WAGE ,CASE WHEN C.TERMINATION_DT >= %DateIn('2021-07-01') THEN '0' 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_COM_INS_TYPEE Character(2) VARCHAR2(2) NOT NULL Company Inscription Type
6 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
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_FAC_ERN_WAGE Number(8,2) DECIMAL(7,2) NOT NULL eSocial Wage Factor
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