GPBR_MISC15_VW

(SQL View)
 Index Back

Staging Table for S-1210

Staging table for eSocial Event S-1210

SELECT B.GPBR_DRIVER_SEQ , B.GPBR_DRV_SPLIT_SEQ , A.GPBR_REVENUE_CODE , A.PRC_TYPE_BRA , A.PROC_NBR_BRA , A.SUSP_CODE_BRA , A.PERIOD_TYPE_BRA , A.AMOUNT1_BRA , A.AMOUNT2_BRA , A.AMOUNT3_BRA , A.AMOUNT4_BRA , A.AMOUNT5_BRA FROM %Table(GPBR_STG_MISC15) A , %Table(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 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_REVENUE_CODE Character(6) VARCHAR2(6) NOT NULL Revenue Code.
4 PRC_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Process Type
1=Administrative
2=Judicial
3=Benefit Number - INSS
4=FAP - Process before 2019
5 PROC_NBR_BRA Character(21) VARCHAR2(21) NOT NULL Proceeding Number BRA
6 SUSP_CODE_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code BRA
7 PERIOD_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Period Type.
1=Monthly
2=Annual (13th Salary)
8 AMOUNT1_BRA Number(17,2) DECIMAL(16,2) NOT NULL Amount
9 AMOUNT2_BRA Number(17,2) DECIMAL(16,2) NOT NULL Amount
10 AMOUNT3_BRA Number(17,2) DECIMAL(16,2) NOT NULL Amount
11 AMOUNT4_BRA Number(17,2) DECIMAL(16,2) NOT NULL Amount
12 AMOUNT5_BRA Number(17,2) DECIMAL(16,2) NOT NULL Amount