GPBR_DRVEUC_XRF

(SQL Table)
 Index Back

eSocial EUC Cross Referen

eSocial Employer Union Contribution Cross Reference Table This record is composed by fields that are common to events to Employer. Each event that shall be sent to the government has an entry on this table.

  • Parent record: GPBR_ES_EUC_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_EUC_SEQ Signed Number(21,0) DECIMAL(20) NOT NULL EUC Sequence
    2 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
    3 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
    4 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
    5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    6 GPBR_ES_PERIOD_TP Character(1) VARCHAR2(1) NOT NULL eSocial Period Type
    1=Monthly
    2=Annual
    7 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
    8 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
    9 GPBR_UNION_CD1 Character(3) VARCHAR2(3) NOT NULL Union Code Brazil

    Prompt Table: UNION_TBL

    10 GPBR_CONTRIB_TYPE Character(3) VARCHAR2(3) NOT NULL Union Contribution Type
    ASI=Welfare Contribution
    ASO=Associative Contribution
    CON=Confederative Contribution
    11 GPBR_ES_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL January Amount
    12 GPBR_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
    13 GPBR_PRE_DRV_SEQ Number(30,0) DECIMAL(30) NOT NULL eSocial Pre Driver Sequence