GPBR_ES_EUC_DTL

(SQL Table)
 Index Back

Employer Union Contrib Detail

Employer Union Contrib Detail table

  • Parent record: GPBR_ES_EUC_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 GPBR_EUC_SEQ Signed Number(21,0) DECIMAL(20) NOT NULL EUC Sequence

    Default Value: 1

    3 GPBR_ES_PERIOD_TP Character(1) VARCHAR2(1) NOT NULL eSocial Period Type
    1=Monthly
    2=Annual
    4 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
    5 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
    6 GPBR_UNION_CD1 Character(3) VARCHAR2(3) NOT NULL Union Code Brazil

    Prompt Table: UNION_TBL

    7 GPBR_ES_CONT_TYP Character(1) VARCHAR2(1) NOT NULL Contribution Type Employeer Union Contribution
    1=Compulsory
    2=Associative
    3=Assistance
    4=Confederative
    8 GPBR_ES_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL January Amount