GPBR_ES5002_RRA

(SQL Table)
Index Back

Additional information - RRA

Income tax information: infoRRA tag fields in S-5002 file for Additional information - RRA.

  • Parent record: GPBR_ES5002_DEM
  • # 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_PER_REF Character(7) VARCHAR2(7) NOT NULL eSocial Reference Period
    4 GPBR_IDE_DMDEV Character(30) VARCHAR2(30) NOT NULL eSocial Unique payment identifier.
    5 GPBR_PAY_TP Character(1) VARCHAR2(1) NOT NULL Patyment TP
    0=N/A
    1=Payroll
    2=Termination
    3=Term Non Empl
    7=Vacation
    6 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
    7 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
    8 GPBR_PROCEED_TYPE Character(1) VARCHAR2(1) NOT NULL Proceeding Type Bra
    1=Administrative
    2=Judicial
    3=INSS Benefit Number
    9 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
    10 ROW_DESCR1 Character(50) VARCHAR2(50) NOT NULL row column 1
    11 GPBR_DUR_IN_MONTH Number(7,2) DECIMAL(6,2) NOT NULL eSocial Absence Duration in Month
    12 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
    13 GPBR_ESOC_AMT_02 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
    14 GPBR_ESOC_AMT_03 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.