GPBR_CLOS_VW

(SQL View)
 Index Back

Periodic eSocial - Closing Per

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

SELECT B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,B.GPBR_EVENT_ID ,A.GPBR_DET ,A.GPBR_CAL_PRD_ID ,A.GPBR_TP_ENV ,A.GPBR_ISSUER ,A.GPBR_VERSION ,A.GPBR_COMP_INS_TYPE ,A.ESTAB_ID_BRA ,A.GPBR_PERSON_NAME ,A.NATIONAL_ID ,A.PHONE ,A.EMAIL_ADDR ,A.GPBR_EVT_REM ,A.GPBR_EVT_PGT ,A.GPBR_EVT_AQ_PROD ,A.GPBR_EVT_COM_PROD ,A.GPBR_EVT_CONTR ,A.GPBR_EVT_INF ,A.GPBR_COMP_MVT ,A.GPBR_MOV_FIN ,A.GPBR_ES_SKIP_VA FROM %Table(GPBR_STG_CLOS) A ,%Table(GPBR_DRIVER_DAT) B WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND B.GPBR_STATUS = 'XRDY'

# 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