GPBR_TERMA_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 evtDeslig S-2399 - Labor Event - Workers who have no employment relationship End TAG - evtTSVTermino

SELECT A.GPBR_DRIVER_SEQ , A.GPBR_DRV_SPLIT_SEQ , A.GPBR_WAGE_CODE , SUM(CASE WHEN A.GPBR_RSLT_ERN_WAGE > 0 THEN 1 ELSE 0 END) , SUM(CASE WHEN A.GPBR_FAC_ERN_WAGE > 0 THEN 1 ELSE 0 END) ,CASE WHEN SUM(CASE WHEN A.GPBR_RSLT_ERN_WAGE > 0 THEN 1 ELSE 0 END) <> SUM(CASE WHEN A.GPBR_FAC_ERN_WAGE > 0 THEN 1 ELSE 0 END) AND SUM(CASE WHEN A.GPBR_FAC_ERN_WAGE > 0 THEN 1 ELSE 0 END) > 0 THEN '3' WHEN SUM(CASE WHEN A.GPBR_RSLT_ERN_WAGE > 0 THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN A.GPBR_FAC_ERN_WAGE > 0 THEN 1 ELSE 0 END) = 0 THEN '2' WHEN SUM(CASE WHEN A.GPBR_RSLT_ERN_WAGE > 0 THEN 1 ELSE 0 END) = SUM(CASE WHEN GPBR_FAC_ERN_WAGE > 0 THEN 1 ELSE 0 END) THEN '1' ELSE '0' END , SUM(A.GPBR_RSLT_ERN_WAGE) , SUM(A.GPBR_FAC_ERN_WAGE) FROM PS_GPBR_STG_TERM03 A , PS_GPBR_DRIVER_DAT B WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND A.GPBR_WAGE_CODE = 9213 AND A.GPBR_LABOR_CAT_CD NOT IN ('722','901') AND A.GPBR_WAGE_CODE <> 0 AND B.GPBR_STATUS = 'XRDY' GROUP BY A.GPBR_DRIVER_SEQ, A.GPBR_DRV_SPLIT_SEQ, A.GPBR_WAGE_CODE

# 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_WAGE_CODE Number(4,0) SMALLINT NOT NULL Wage Type Code
4 COUNT1 Number(12,0) DECIMAL(12) NOT NULL AUS WGEA counts
5 COUNT2 Number(12,0) DECIMAL(12) NOT NULL AUS WGEA counts
6 GPBR_ALIMONY_IND Character(1) VARCHAR2(1) NOT NULL Alimony Indicator
0=No Alimony
1=Percentage
2=Amount
3=Percentage and Amount
7 GPBR_RSLT_ERN_WAGE Number(17,2) DECIMAL(16,2) NOT NULL eSocial Wage EarningRslt
8 GPBR_FAC_ERN_WAGE Number(8,2) DECIMAL(7,2) NOT NULL eSocial Wage Factor