GPBR_COMPL_VW

(SQL View)
 Index Back

eSocial - Complementary Info.

eSocial XML Framework View Table This record is used to generate informations for eSocial layout S1280 - eSocial - Complementary Information to Periodic Events. TAG- evtInfoComplPer

SELECT B.GPBR_DRIVER_SEQ , B.GPBR_DRV_SPLIT_SEQ , B.GPBR_EVENT_ID , A.GPBR_RECT , A.GPBR_EVENT_CD , A.GPBR_RECEIPT_NUM , A.GPBR_DET , A.GPBR_CAL_PRD_ID , A.GPBR_TP_ENV , A.GPBR_ISSUER , %Coalesce((SELECT C.GPBR_VERSION FROM %Table(GPBR_EVNT_SETUP) C WHERE C.GPBR_EVENT_CD = B.GPBR_EVENT_CD AND %EffdtCheck(GPBR_EVNT_SETUP C1, C, %CurrentDateIn)), ' ') , A.GPBR_COMP_INS_TYPE , A.ESTAB_ID_BRA , CASE WHEN A.OTHER_SECTORS_BRA <> '9' THEN A.OTHER_SECTORS_BRA ELSE ' ' END , CASE WHEN A.OTHER_SECTORS_BRA <> '9' THEN %Sql(GPBR_NUM_TO_CHAR,A.GPBR_ES_PERC_RE) ELSE ' ' END , A.GPBR_EVENT , A.GPBR_TAX_DUE FROM %Table(GPBR_STG_COMPL) 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_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
5 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
6 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num
7 GPBR_DET Number(1,0) SMALLINT NOT NULL eSocial Ind Calculation
8 GPBR_CAL_PRD_ID Character(7) VARCHAR2(7) NOT NULL eSocial Period Calculation
9 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
10 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
11 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
12 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
13 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
14 OTHER_SECTORS_BRA Character(1) VARCHAR2(1) NOT NULL Other Sectors
0=Not Applicable
1=Fully Replaced
2=Partially Replaced
15 GPBR_ES_PERC_CH Character(8) VARCHAR2(8) NOT NULL eSocial % Reduction
16 GPBR_EVENT Character(6) VARCHAR2(6) NOT NULL eSocial Event Code
17 GPBR_TAX_DUE Character(2) VARCHAR2(2) NOT NULL % Tax Due
1=0,200
2=0,400
3=0,600
4=0,800
5=1,000