GPBR_DEP_VW

(SQL View)
 Index Back

Labor Event - Personal Data Ch

eSocial ViewTable This record is used to generate informations for eSocial layout S-2200 - Labor Event - Hiring - TAG- dependente S-2205 - Labor Event - Personal Data Changes - TAG- dependente S-2300 - Labor Event - Workers who have no employment relationship Begin - TAG- dependente

SELECT B.GPBR_DRIVER_SEQ , B.GPBR_DRV_SPLIT_SEQ , A.DEPENDENT_BENEF , A.RELATIONSHIP , A.GPBR_PERSON_NAME , A.BIRTHDATE , A.NATIONAL_ID , A.GPBR_SEX , A.GPBR_DEP_IR , A.GPBR_DEP_SF , A.GPBR_DEP_HEALTH , A.GPBR_DISAB_MEN , A.GPBR_DEP_DESCR FROM %Table(GPBR_STG_DEP) 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' AND A.RELATIONSHIP <> '00'

# 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 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
4 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
5 GPBR_PERSON_NAME Character(92) VARCHAR2(92) NOT NULL Person Name
6 BIRTHDATE Date(10) DATE Date of Birth
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 GPBR_SEX Character(1) VARCHAR2(1) NOT NULL Sex.
F=Female
M=Male
U=Unknown
9 GPBR_DEP_IR Character(1) VARCHAR2(1) NOT NULL Dependent IR
10 GPBR_DEP_SF Character(1) VARCHAR2(1) NOT NULL Dependent SF
11 GPBR_DEP_HEALTH Character(1) VARCHAR2(1) NOT NULL Dependent Health Plan
12 GPBR_DISAB_MEN Character(1) VARCHAR2(1) NOT NULL Disability Mental
13 GPBR_DEP_DESCR Character(30) VARCHAR2(30) NOT NULL Dependent description.