GPBR_STG_CLOS

(SQL Table)
Index Back

Periodic eSocial - Closing Per

eSocial Stage Table This record is used to generate information for eSocial layout S-1299 - Periodic - Closing Periodic Events TAG- evtFechaEvPer

# 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_EVENT_ID Character(40) VARCHAR2(40) NOT NULL eSocial - Generate ID Number Governant
4 GPBR_DET Number(1,0) SMALLINT NOT NULL eSocial Ind Calculation
5 GPBR_CAL_PRD_ID Character(7) VARCHAR2(7) NOT NULL eSocial Period Calculation
6 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
7 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
8 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
9 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
10 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
11 GPBR_PERSON_NAME Character(92) VARCHAR2(92) NOT NULL Person Name
12 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
14 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
15 GPBR_EVT_REM Character(1) VARCHAR2(1) NOT NULL eSocial Remuneration Ind
16 GPBR_EVT_PGT Character(1) VARCHAR2(1) NOT NULL eSocial Payment Ind
17 GPBR_EVT_AQ_PROD Character(1) VARCHAR2(1) NOT NULL eSocial Farm Buy
18 GPBR_EVT_COM_PROD Character(1) VARCHAR2(1) NOT NULL eSocial Production
19 GPBR_EVT_CONTR Character(1) VARCHAR2(1) NOT NULL eSocial Independent Worker
20 GPBR_EVT_INF Character(1) VARCHAR2(1) NOT NULL eSocial Simply
21 GPBR_COMP_MVT Character(7) VARCHAR2(7) NOT NULL eSocial Period
22 GPBR_MOV_FIN Character(1) VARCHAR2(1) NOT NULL eSocial Financial
23 GPBR_ES_SKIP_VA Character(1) VARCHAR2(1) NOT NULL Skip Closing rule