HS_INJ_ILL_VW

(SQL View)
 Index Back

Injury/Illness View


SELECT A.Incident_Nbr , A.Emplid , A.EMPL_RCD , A.Non_Employee_ID , A.Injury_Illness , CASE WHEN A.Injury_Illness = ' ' THEN 'X' ELSE A.Injury_Illness END , A.Reg_Region , COALESCE (( SELECT RR.DESCR50 FROM PS_REG_REGION_TBL RR WHERE RR.REG_REGION = A.REG_REGION), ' ') , A.Reportable_Case , CASE WHEN A.Reportable_Case = ' ' THEN 'N' ELSE A.Reportable_Case END , A.Dt_Reported , A.Tm_Reported , A.hs_timezone1 , A.Injury_Treatment , CASE WHEN A.Injury_Treatment = ' ' THEN '3' ELSE A.Injury_Treatment END , A.Away_from_Workdays , A.Restrictd_Workdays , A.Transfer_Workdays , A.Illness_Result , A.last_full_work_day , A.return_dt , A.fatality_sw , A.hospital_sw , A.resuscitation_sw , A.unconscious_sw , A.unconscious_hrs , A.unconscious_mins , A.ambulance_sw , A.ambulance_cntct_dt , A.ambulance_cntct_tm , A.ambulance_arrvl_dt , A.ambulance_arrvl_tm , A.employer_object_sw , A.witness_confirm_sw , A.occ_illness_cd , COALESCE (( SELECT OCC.DESCR50 FROM PS_OCC_ILLNESS_TBL OCC WHERE OCC.SETID = (SELECT RR1.DEFAULT_SETID FROM PS_REG_REGION_TBL RR1 WHERE RR1.REG_REGION = A.REG_REGION) AND OCC.OCC_ILLNESS_CD = A.OCC_ILLNESS_CD AND %EffdtCheck(OCC_ILLNESS_TBL OCC2, OCC, %CurrentDateIn)), ' ') , A.relationship , A.further_inquiry , A.last_worked_tm , A.return_tm , A.empl_return_work , CASE WHEN A.empl_return_work = ' ' THEN 'N' ELSE A.empl_return_work END , A.work_related , CASE WHEN A.work_related = ' ' THEN 'N' ELSE A.work_related END FROM PS_INJURY_ILL A

  • Parent record: INCIDENT_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: EMPLOYMENT

    4 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

    Prompt Table: NE_INCIDNT_SRCH

    5 INJURY_ILLNESS Character(1) VARCHAR2(1) NOT NULL Primarily Injury/Illness
    D=Death
    L=Illness
    N=Injury

    Default Value: N

    6 HS_INJ_ILLNESS Character(1) VARCHAR2(1) NOT NULL Injury Illness
    D=Death
    L=Illness
    N=Injury
    X=No Injury or Illness

    Default Value: X

    7 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: INCIDENT_DATA.REG_REGION

    Prompt Table: REG_HANDS_VW

    8 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    9 REPORTABLE_CASE Character(1) VARCHAR2(1) NOT NULL Reportable Case

    Y/N Table Edit

    Default Value: N

    10 HS_REPORTABLE_CASE Character(1) VARCHAR2(1) NOT NULL Reportable Case
    N=Not Reportable
    Y=Reportable

    Default Value: N

    11 DT_REPORTED Date(10) DATE Date Reported
    12 TM_REPORTED Time(15) TIMESTAMP Time Reported
    13 HS_TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Health and Safety Time Zone Field 2

    Prompt Table: PSTIMEZONE

    14 INJURY_TREATMENT Character(1) VARCHAR2(1) NOT NULL Injury Treatment
    1=Medical Treatment
    2=First Aid
    3=Not Required
    4=Hospitalized

    Default Value: 1

    15 HS_INJ_TREATMNT Character(1) VARCHAR2(1) NOT NULL Injury Treatment
    1=Medical Treatment
    2=First Aid
    3=None
    4=Hospitalized

    Default Value: 3

    16 AWAY_FROM_WORKDAYS Number(4,0) SMALLINT NOT NULL Days Away From Work
    17 RESTRICTD_WORKDAYS Number(4,0) SMALLINT NOT NULL Restricted Workdays
    18 TRANSFER_WORKDAYS Number(4,0) SMALLINT NOT NULL Temp Transfer Work Days
    19 ILLNESS_RESULT Character(1) VARCHAR2(1) NOT NULL Illness Resulted In
    N=Not Applicable
    T=Termination
    X=Transfer

    Default Value: N

    20 LAST_FULL_WORK_DAY Date(10) DATE Last Work Date Before Injury
    21 RETURN_DT Date(10) DATE Return Date
    22 FATALITY_SW Character(1) VARCHAR2(1) NOT NULL Fatal Injuries Sustained

    Y/N Table Edit

    Default Value: N

    23 HOSPITAL_SW Character(1) VARCHAR2(1) NOT NULL Patient Taken To Hospital

    Y/N Table Edit

    Default Value: N

    24 RESUSCITATION_SW Character(1) VARCHAR2(1) NOT NULL Resuscitation Required

    Y/N Table Edit

    Default Value: N

    25 UNCONSCIOUS_SW Character(1) VARCHAR2(1) NOT NULL Patient Fell Unconscious

    Y/N Table Edit

    Default Value: N

    26 UNCONSCIOUS_HRS Number(3,0) SMALLINT NOT NULL Hours Unconscious
    27 UNCONSCIOUS_MINS Number(3,0) SMALLINT NOT NULL Minutes Unconscious
    28 AMBULANCE_SW Character(1) VARCHAR2(1) NOT NULL Ambulance Required

    Y/N Table Edit

    Default Value: N

    29 AMBULANCE_CNTCT_DT Date(10) DATE Ambulance Contact Date

    Default Value: INCIDENT_DATA.INCIDENT_DT

    30 AMBULANCE_CNTCT_TM Time(15) TIMESTAMP Ambulance Contact Time
    31 AMBULANCE_ARRVL_DT Date(10) DATE Ambulance Arrival Date

    Default Value: INCIDENT_DATA.INCIDENT_DT

    32 AMBULANCE_ARRVL_TM Time(15) TIMESTAMP Ambulance Arrival Time
    33 EMPLOYER_OBJECT_SW Character(1) VARCHAR2(1) NOT NULL Employer Objects to Statement

    Y/N Table Edit

    Default Value: N

    34 WITNESS_CONFIRM_SW Character(1) VARCHAR2(1) NOT NULL Witness Confirms Statement

    Y/N Table Edit

    Default Value: N

    35 OCC_ILLNESS_CD Character(6) VARCHAR2(6) NOT NULL Occupational Illness

    Prompt Table: OCC_ILLNESS_TBL

    36 OCC_ILLNESS_DESCR Character(50) VARCHAR2(50) NOT NULL Occupational Illness
    37 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
    38 FURTHER_INQUIRY Character(1) VARCHAR2(1) NOT NULL Further Inquiry

    Y/N Table Edit

    39 LAST_WORKED_TM Time(15) TIMESTAMP Time last worked
    40 RETURN_TM Time(15) TIMESTAMP Return Time
    41 EMPL_RETURN_WORK Character(1) VARCHAR2(1) NOT NULL Employee Return To Work

    Y/N Table Edit

    Default Value: N

    42 HS_EMP_RETURN_WORK Character(1) VARCHAR2(1) NOT NULL Employee Return To Work
    N=No
    Y=Yes

    Default Value: N

    43 WORK_RELATED Character(1) VARCHAR2(1) NOT NULL Work-Related

    Y/N Table Edit

    Default Value: N

    44 HS_WORK_RELATED Character(1) VARCHAR2(1) NOT NULL Work-Related
    N=Not Work-Related
    Y=Work-Related

    Default Value: N