GPBR_STG_HS2_VW

(SQL View)
 Index Back

Periodic eSocial H&S

eSocial XML Framework View Table This record is used to generate informations for eSocial layout S-2220 - Periodic eSocial - Health and Safety

SELECT B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,A.EMPLID ,A.EMPL_RCD ,A.EXAM_DT ,MED.ESOC_CODE_BRA ,CASE WHEN A.ASO_ORD_EXAM_BRA <> ' ' THEN %Substring(A.ASO_ORD_EXAM_BRA ,2 ,2) ELSE A.ASO_ORD_EXAM_BRA END ,CASE WHEN A.ASO_IND_RSLT_BRA <> ' ' THEN %Substring(A.ASO_IND_RSLT_BRA ,2 ,2) ELSE A.ASO_IND_RSLT_BRA END ,A.COMMENTS FROM PS_GPBR_STG_HAS2 A ,PS_GPBR_DRIVER_DAT B ,PS_MED_TESTS_BRA MED WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND A.MED_TESTS_CD_BRA= MED.MED_TESTS_CD_BRA AND MED.EFFDT=( SELECT MAX(J.EFFDT) FROM PS_MED_TESTS_BRA J WHERE J.MED_TESTS_CD_BRA=A.MED_TESTS_CD_BRA) 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 EXAM_DT Date(10) DATE Exam Date
6 MED_TESTS_CD_BRA Character(15) VARCHAR2(15) NOT NULL Laboratory Exam Code
7 ASO_ORD_EXAM_BRA Character(2) VARCHAR2(2) NOT NULL ASO Order of Exam
01=Initial
02=Sequential
8 ASO_IND_RSLT_BRA Character(2) VARCHAR2(2) NOT NULL ASO Indicator Results
00=None
01=Normal
02=Altered or Modified
03=Stable
04=Aggravation
9 COMMENTS Long Character CLOB Comment