GPBR_STG_COMP08

(SQL Table)
Index Back

Periodic eSocial Compensation

eSocial Stage Table This record is used to generate informations for eSocial layout S-1200 - Periodic eSocial � Compensation TAG-Group detPlano

# 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 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
4 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
5 HPROV_CD_BRA Character(10) VARCHAR2(10) NOT NULL Health Provider Code
6 GPBR_IDE_DMDEV Character(30) VARCHAR2(30) NOT NULL eSocial Unique payment identifier.
7 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code
8 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
9 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
10 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
11 HPROV_CNPJ_BRA Character(14) VARCHAR2(14) NOT NULL Health Provider CNPJ
12 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
13 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
14 BIRTHDATE Date(10) DATE Date of Birth
15 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
16 GPBR_PERSON_NAME Character(92) VARCHAR2(92) NOT NULL Person Name
17 GPBR_VLREC Number(17,2) DECIMAL(16,2) NOT NULL eSocial Payment