GPBR_TERM10_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

SELECT B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,A.GPBR_IDE_DMDEV ,A.GPBR_LABOR_CAT_CD ,A.GPBR_DATE1 ,A.ESTABID ,A.GPBR_COM_INS_TYPEE ,A.GPBR_COD_LOCAT ,A.GPBR_CAL_PRD_ID ,A.GPBR_PIN_NUM_ITEN ,A.GPBR_ID_TAB_WAGE ,A.GPBR_QTD_ERN_WAGE ,A.GPBR_GP_PCT ,A.GPBR_AMT_ERN_WAGE ,A.GPBR_RSLT_ERN_WAGE ,CASE WHEN C.TERMINATION_DT >= %DateIn('2021-07-01') THEN '0' ELSE ' ' END FROM %Table(GPBR_STG_TERM10) 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'

# 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 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
7 GPBR_COM_INS_TYPEE Character(2) VARCHAR2(2) NOT NULL Company Inscription Type
8 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
9 GPBR_CAL_PRD_ID Character(7) VARCHAR2(7) NOT NULL eSocial Period Calculation
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