GPBR_STG_LPTXVW

(SQL View)
 Index Back

Dependents and Beneficiaries

Dependents and Beneficiaries Data - Tax Not Withheld in Labor Proceeding Tax.

SELECT LPTXPR.GPBR_DRIVER_SEQ , LPTXPR.GPBR_DRV_SPLIT_SEQ , LPTXPR.COMPANY , LPTXPR.GPBR_PROC_NUM , LPTXPR.GPBR_ESOC_YEAR , LPTXPR.GPBR_ESOC_MONTHCD , LPTXPR.GPBR_CPF_ID , LPTXPR.PRC_TYPE_BRA , LPTXPR.PROC_NBR_BRA , LPTXPR.SUSP_CODE_BRA , LPTXPR.PERIOD_TYPE_BRA , LPTXPR.SUSP_DED_TYPE_BRA , LPTXPR.AMOUNT1_BRA FROM %TABLE(GPBR_STG_LPTXPR) LPTXPR, %Table(GPBR_DRIVER_DAT) DRV WHERE LPTXPR.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LPTXPR.GPBR_DRV_SPLIT_SEQ = DRV.GPBR_DRV_SPLIT_SEQ AND DRV.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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
5 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
6 GPBR_ESOC_MONTHCD Character(2) VARCHAR2(2) NOT NULL eSocial Competency Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
7 GPBR_CPF_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
8 PRC_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Process Type
1=Administrative
2=Judicial
3=Benefit Number - INSS
4=FAP - Process before 2019
9 PROC_NBR_BRA Character(21) VARCHAR2(21) NOT NULL Proceeding Number BRA
10 SUSP_CODE_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code BRA
11 PERIOD_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Period Type.
1=Monthly
2=Annual (13th Salary)
12 SUSP_DED_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Suspended Deduction Type.
1=Public Pension
2=Private Pension
3=FAPI
4=Funpresp
5=Alimony
7=Dependents
13 AMOUNT1_BRA Number(17,2) DECIMAL(16,2) NOT NULL Amount