GPBR_ES5001_CTG

(SQL Table)
Index Back

Employee ID & category

Employee ID and category: infoCategIncid tag fields in S-5001 file.

# 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_ESTAB_IN_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Establishment Inscription Type
1=CNPJ
3=CAEPF
4=CNO
4 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
5 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
6 GPBR_REG_ESOCIAL Character(30) VARCHAR2(30) NOT NULL eSocial eSocial Register
7 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code