GPBR_ABS_VW

(SQL View)
 Index Back

Labor Event - Temporary Absenc

eSocial XML Framework View Table This record is used to generate informations for eSocial layout S-2230 - Labor Event - Temporary Absence

SELECT B.GPBR_DRIVER_SEQ , B.GPBR_DRV_SPLIT_SEQ , B.COMPANY , B.GPBR_EVENT_CD , A.GPBR_TP_ENV , CASE WHEN ( 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)) IS NULL THEN ' ' ELSE ( 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)) END , A.GPBR_ISSUER , B.GPBR_ACTION , A.GPBR_COMP_INS_TYPE , A.ESTAB_ID_BRA , B.GPBR_EVENT_ID , A.GPBR_RECT , CASE WHEN ( SELECT E.GPBR_RECEIPT_NUM FROM %Table(GPBR_DRVEMP_XRF) D , %Table(GPBR_DRIVER_DAT) E WHERE D.GPBR_DRIVER_SEQ = A.GPBR_DRIVER_SEQ AND E.GPBR_DRIVER_SEQ = D.GPBR_PRE_DRV_SEQ ) IS NULL THEN ' ' ELSE ( SELECT E.GPBR_RECEIPT_NUM FROM %Table(GPBR_DRVEMP_XRF) D , %Table(GPBR_DRIVER_DAT) E WHERE D.GPBR_DRIVER_SEQ = A.GPBR_DRIVER_SEQ AND E.GPBR_DRIVER_SEQ = D.GPBR_PRE_DRV_SEQ ) END , A.NATIONAL_ID , A.GPBR_NAT_ID , A.GPBR_REG_ESOCIAL , A.BGN_DT , A.GPBR_ABSEN_CD , A.GPBR_ACCID_TYPE , A.GPBR_CID_CODE , A.GPBR_DURATION_ABS , A.GPBR_PERS_NAME , A.GPBR_MED_TYPE , A.MED_CRM_BRA , A.GPBR_STATE_OC , A.UNION_CNPJ_BRA , A.GPBR_UNION_PAID , A.GPBR_ABSEN_DT , A.GPBR_ABS_PRE_CD , A.GPBR_ABS_CD , A.GPBR_ABS_IND , A.END_DT , A.GPBR_ABS_END_CD , A.COMMENT1 , A.GPBR_CD_CATG , A.GPBR_INF_MVT , A.GPBR_ORIG_RET , A.GPBR_TP_PROC , A.GPBR_NR_PROC , CASE WHEN A.BGN_DT IS NOT NULL AND A.BGN_DT >= %DateIn('2021-07-19') AND A.GPBR_ABSEN_CD = '15' THEN A.BEGIN_DT ELSE NULL END , CASE WHEN A.BGN_DT IS NOT NULL AND A.BGN_DT >= %DateIn('2021-07-19') AND A.GPBR_ABSEN_CD = '15' THEN A.END_DATE ELSE NULL END FROM %Table(GPBR_STG_ABS) 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
5 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
6 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
7 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
8 GPBR_ACTION Character(3) VARCHAR2(3) NOT NULL eSocial Action
ADD=Row Inserted
COR=Row Correction
DEL=Row Deleted
UPD=Row Updated
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_EVENT_ID Character(40) VARCHAR2(40) NOT NULL eSocial - Generate ID Number Governant
12 GPBR_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
13 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num
14 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
15 GPBR_NAT_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
16 GPBR_REG_ESOCIAL Character(30) VARCHAR2(30) NOT NULL eSocial eSocial Register
17 BGN_DT Date(10) DATE Begin Date
18 GPBR_ABSEN_CD Character(2) VARCHAR2(2) NOT NULL Absence Code
19 GPBR_ACCID_TYPE Number(1,0) SMALLINT NOT NULL Accident Type
20 GPBR_CID_CODE Character(5) VARCHAR2(5) NOT NULL CID Code
21 GPBR_DURATION_ABS Number(3,0) SMALLINT NOT NULL Duration Absence
22 GPBR_PERS_NAME Character(70) VARCHAR2(70) NOT NULL Used to keep a person name.
23 GPBR_MED_TYPE Number(1,0) SMALLINT NOT NULL Medical Type
24 MED_CRM_BRA Character(15) VARCHAR2(15) NOT NULL Medical Certication Register.
25 GPBR_STATE_OC Character(2) VARCHAR2(2) NOT NULL OC State
26 UNION_CNPJ_BRA Character(14) VARCHAR2(14) NOT NULL Union CNPJ, this is the ID that all the companies/establishments in Brazil have.
27 GPBR_UNION_PAID Character(1) VARCHAR2(1) NOT NULL Union Contribution Paid BRA
28 GPBR_ABSEN_DT Date(10) DATE Absence Date
29 GPBR_ABS_PRE_CD Character(2) VARCHAR2(2) NOT NULL Absence Previous Code
30 GPBR_ABS_CD Character(2) VARCHAR2(2) NOT NULL Absence Code
31 GPBR_ABS_IND Character(1) VARCHAR2(1) NOT NULL Absence Retro Ind
32 END_DT Date(10) DATE end date
33 GPBR_ABS_END_CD Character(2) VARCHAR2(2) NOT NULL Absence End Code
34 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
35 GPBR_CD_CATG Number(3,0) SMALLINT NOT NULL Category Code for eSocial absence
36 GPBR_INF_MVT Character(1) VARCHAR2(1) NOT NULL Type process for eSocial absence
1=Yes
2=No
37 GPBR_ORIG_RET Number(1,0) SMALLINT NOT NULL Type process for eSocial absence
38 GPBR_TP_PROC Number(1,0) SMALLINT NOT NULL Type process for eSocial absence
1=Administrative
2=Judicial
39 GPBR_NR_PROC Character(30) VARCHAR2(30) NOT NULL Number process for eSocial absence
40 BEGIN_DT Date(10) DATE Begin Date
41 END_DATE Date(10) DATE End Date