GPBR_PRE_HI_VW

(SQL View)
 Index Back

Labor Event - Hiring - Prelimi

eSocial XML Framework View Table This record is used to generate informations for eSocial layout S-2190 - Labor Event - Hiring - Preliminary Event - TAG- evtAdmPrelim

SELECT B.GPBR_DRIVER_SEQ , B.GPBR_DRV_SPLIT_SEQ , B.GPBR_EVENT_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 , A.NATIONAL_ID , A.BIRTHDATE , A.LAST_HIRE_DT , A.GPBR_COD_CATEG , A.CONT_SAL_TYPE_BRA , A.GPBR_VLREC , A.GPBR_RECT , Coalesce(( 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 ) , ' ') , A.GPBR_REG_ESOCIAL , A.GPBR_NAT_ACTIV , A.CBO_CD_BRA , A.CNTR_TYPE_BRA , A.CONTRACT_END_DT FROM %Table(GPBR_STG_PRE_HI) 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_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
5 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
6 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
7 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
8 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
9 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
10 BIRTHDATE Date(10) DATE Date of Birth
11 LAST_HIRE_DT Date(10) DATE Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
12 GPBR_COD_CATEG Number(3,0) SMALLINT NOT NULL Category Code
13 CONT_SAL_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Contract Salary Type Brazil
1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
14 GPBR_VLREC Number(17,2) DECIMAL(16,2) NOT NULL eSocial Payment
15 GPBR_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
16 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num
17 GPBR_REG_ESOCIAL Character(30) VARCHAR2(30) NOT NULL eSocial eSocial Register
18 GPBR_NAT_ACTIV Number(1,0) SMALLINT NOT NULL Activity
19 CBO_CD_BRA Character(7) VARCHAR2(7) NOT NULL Occupation Code for Brazil
20 CNTR_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Contract Type Bra
1=Indeterminate
2=Indeterminate w/probation prd
3=Determinate
21 CONTRACT_END_DT Date(10) DATE Contract End Date