GPBR_RISK04_VW

(SQL View)
 Index Back

Non Periodic Event S-2240

eSocial Stage Table This record is used to generate informations for eSocial layout S-2240

SELECT B.GPBR_DRIVER_SEQ ,B.GPBR_DRV_SPLIT_SEQ ,A.GPBR_EVENT_ID ,A.HAZARD_ID ,HAZ.HAZARD_CODE_BRA ,PRT.IPE_AC_BRA ,CASE WHEN PRT.IPE_AC_BRA IS NULL OR PRT.IPE_AC_BRA = ' ' THEN %Substring(PRT.DESCRLONG,1,999)ELSE NULL END ,CASE WHEN A.IPE_INFO_QU1_BRA = 'Y' THEN 'S' ELSE A.IPE_INFO_QU1_BRA END AS IPE_INFO_QU1_BRA ,CASE WHEN A.IPE_INFO_QU2_BRA = 'Y' THEN 'S' ELSE A.IPE_INFO_QU2_BRA END AS IPE_INFO_QU2_BRA ,CASE WHEN A.IPE_INFO_QU3_BRA = 'Y' THEN 'S' ELSE A.IPE_INFO_QU3_BRA END AS IPE_INFO_QU3_BRA ,CASE WHEN A.IPE_INFO_QU4_BRA = 'Y' THEN 'S' ELSE A.IPE_INFO_QU4_BRA END AS IPE_INFO_QU4_BRA ,CASE WHEN A.IPE_INFO_QU5_BRA = 'Y' THEN 'S' ELSE A.IPE_INFO_QU5_BRA END AS IPE_INFO_QU5_BRA ,CASE WHEN A.IPE_INFO_QU6_BRA = 'Y' THEN 'S' ELSE A.IPE_INFO_QU6_BRA END AS IPE_INFO_QU6_BRA ,CASE WHEN A.IPE_INFO_QU7_BRA = 'Y' THEN 'S' ELSE A.IPE_INFO_QU7_BRA END AS IPE_INFO_QU7_BRA FROM PS_GPBR_STG_RISK04 A , PS_GPBR_DRIVER_DAT B , PS_PROT_EQUPMT_BRA PRT , PS_HAZARD_TBL_BRA HAZ ,PS_GPBR_STG_RISK AA WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND A.GPBR_DRIVER_SEQ = AA.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = AA.GPBR_DRV_SPLIT_SEQ AND PRT.SETID = A.SETID AND PRT.IPE_CODE_BRA = A.IPE_CODE_BRA AND A.HAZARD_ID = HAZ.HAZARD_ID AND A.SETID = HAZ.SETID AND HAZ.EFFDT = ( SELECT MAX(HAZ2.EFFDT) FROM PS_HAZARD_TBL_BRA HAZ2 WHERE HAZ2.HAZARD_ID = HAZ.HAZARD_ID AND HAZ2.SETID = HAZ.SETID AND HAZ2.EFFDT <= AA.GPBR_ES_PS) 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 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID
5 HAZARD_CODE_BRA Character(9) VARCHAR2(9) NOT NULL Hazard Code BRA
6 IPE_AC_BRA Character(20) VARCHAR2(20) NOT NULL IPE AC BRA Value
7 DESCRLONG Long Character CLOB Long Description
8 IPE_INFO_QU1_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
9 IPE_INFO_QU2_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
10 IPE_INFO_QU3_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
11 IPE_INFO_QU4_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
12 IPE_INFO_QU5_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
13 IPE_INFO_QU6_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
14 IPE_INFO_QU7_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes