GPBR_ES5002_BPE

(SQL Table)
Index Back

Ded suspended by depend

Income tax information: benefPen tag fields in S-5002 file for Information of deductions suspended by dependents and child support beneficiaries.

  • Parent record: GPBR_ES5002_SUS
  • # 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_DED_CD Character(6) VARCHAR2(6) NOT NULL Social security deduction code.
    4 GPBR_PROCEED_TYPE Character(1) VARCHAR2(1) NOT NULL Proceeding Type Bra
    1=Administrative
    2=Judicial
    3=INSS Benefit Number
    5 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
    6 CODE_SUSP_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code
    7 GPBR_DET Number(1,0) SMALLINT NOT NULL eSocial Ind Calculation
    8 GPBR_ROW_SEQUENCE Number(3,0) SMALLINT NOT NULL Row sequence in the layout.
    9 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    10 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.