GPBR_STG_WPLACE

(SQL Table)
Index Back

eSocial S-1060 BasTbl Main Stg

Main eSocial S-1060 (Workplace) event staging table.

# 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_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
4 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
5 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
6 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
7 GPBR_WPLACE_CODE Character(30) VARCHAR2(30) NOT NULL eSocial workplace code.
8 BEGIN_DT Date(10) DATE Begin Date
9 GPBR_PER_END_DT Date(10) DATE Period End Date -- Vacations Brazil
10 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
11 WPLACE_LOC_BRA Character(1) VARCHAR2(1) NOT NULL Worplace location.
1=Employer Establishment
2=Service Taker Establishment
3=Third Party Establishment
12 GPBR_COM_INS_TYPEE Character(2) VARCHAR2(2) NOT NULL Company Inscription Type
13 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
14 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
15 GPBR_INI_VAL_DATE Date(10) DATE Initial Validity Date
16 GPBR_END_VAL_DATE Date(10) DATE End Validity Date
17 DESCRLONG Long Character CLOB Long Description