GPBR_STG_HS1_VW

(SQL View)
 Index Back

Periodic eSocial H&S

eSocial Stage Table This record is used to generate informations for eSocial layout S-2220 - Occupational Health Monitoring

SELECT B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,A.EMPLID ,A.EMPL_RCD ,A.PPP_EXAM_TYPE_BRA ,A.ASO_DT_BRA ,A.CAPABILITY_CD_BRA ,A.NID_CPF_BRA ,A.PIS_BRA ,A.PHYSICIAN_NAME_BRA ,%Substring(A.MED_CRM_BRA ,1 ,10) ,A.STATE ,A.ALLOW_EMPLOYEE FROM %Table(GPBR_STG_HAS1) 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 PPP_EXAM_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL PPP Exam Type
A=New Hire
D=Termination
M=Job/Position Change
P=Periodical according to PCMSO
R=Return to Work
S=Specific Monitoring
6 ASO_DT_BRA Date(10) DATE ASO date.
7 CAPABILITY_CD_BRA Character(1) VARCHAR2(1) NOT NULL Work abillity.
1=Able
2=Able with restrictions
3=Unable
8 NID_CPF_BRA Character(20) VARCHAR2(20) NOT NULL Brazilian CPF National ID
9 PIS_BRA Character(14) VARCHAR2(14) NOT NULL PIS / NIS Number
10 PHYSICIAN_NAME_BRA Character(70) VARCHAR2(70) NOT NULL Physician Name BRA field.
11 MED_CRM_BRA Character(15) VARCHAR2(15) NOT NULL Medical Certication Register.
12 STATE Character(6) VARCHAR2(6) NOT NULL State
13 ALLOW_EMPLOYEE Character(1) VARCHAR2(1) NOT NULL Allow to inform results