INJURY_ILL

(SQL Table)
 Index Back

EE Injury/Illness Detail Facts

This is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJURY_ILL to record details about a person's injury or illness.

  • Parent record: PER_ORG_ASGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

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

    Prompt Table: PER_ORG_ASGN_VW

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

    Prompt Table: NE_INCIDNT_SRCH

    4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

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

    Default Value: N

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

    Default Value: INCIDENT_DATA.REG_REGION

    Prompt Table: REG_HANDS_VW

    7 REPORTABLE_CASE Character(1) VARCHAR2(1) NOT NULL Reportable Case

    Y/N Table Edit

    Default Value: Y

    8 DT_REPORTED Date(10) DATE Date Reported
    9 TM_REPORTED Time(15) TIMESTAMP Time Reported
    10 HS_TIMEZONE1 Character(9) VARCHAR2(9) NOT NULL Health and Safety Time Zone Field 1

    Prompt Table: PSTIMEZONE

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

    Default Value: 1

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

    Default Value: N

    16 LAST_FULL_WORK_DAY Date(10) DATE Last Work Date Before Injury
    17 RETURN_DT Date(10) DATE Return Date
    18 FATALITY_SW Character(1) VARCHAR2(1) NOT NULL Fatal Injuries Sustained
    19 HOSPITAL_SW Character(1) VARCHAR2(1) NOT NULL Patient Taken To Hospital
    20 RESUSCITATION_SW Character(1) VARCHAR2(1) NOT NULL Resuscitation Required
    21 UNCONSCIOUS_SW Character(1) VARCHAR2(1) NOT NULL Patient Fell Unconscious
    22 UNCONSCIOUS_HRS Number(3,0) SMALLINT NOT NULL Hours Unconscious
    23 UNCONSCIOUS_MINS Number(3,0) SMALLINT NOT NULL Minutes Unconscious
    24 AMBULANCE_SW Character(1) VARCHAR2(1) NOT NULL Ambulance Required
    25 AMBULANCE_CNTCT_DT Date(10) DATE Ambulance Contact Date
    26 AMBULANCE_CNTCT_TM Time(15) TIMESTAMP Ambulance Contact Time
    27 AMBULANCE_ARRVL_DT Date(10) DATE Ambulance Arrival Date
    28 AMBULANCE_ARRVL_TM Time(15) TIMESTAMP Ambulance Arrival Time
    29 EMPLOYER_OBJECT_SW Character(1) VARCHAR2(1) NOT NULL Employer Objects to Statement

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: OCC_ILLNESS_TBL

    32 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
    33 HS_TIMEZONE3 Character(9) VARCHAR2(9) NOT NULL Health and Safety Time Zone Field 3

    Default Value: INJURY_ILL_VW.HS_TIMEZONE1

    34 HRS_AM_STRT_TM_FRA Time(15) TIMESTAMP AM Start Time
    35 HRS_AM_END_TM_FRA Time(15) TIMESTAMP AM End Time
    36 HRS_PM_STRT_TM_FRA Time(15) TIMESTAMP PM Start Time
    37 HRS_PM_END_TM_FRA Time(15) TIMESTAMP PM End Time
    38 OH_REGISTER_SW_FRA Character(1) VARCHAR2(1) NOT NULL Registered at Infirmary

    Y/N Table Edit

    Default Value: N

    39 OH_REG_DATE_FRA Date(10) DATE Registration Date
    40 OH_REG_NUMBER_FRA Character(10) VARCHAR2(10) NOT NULL Registration Number
    41 PHYDIS_NTFY_DT_FRA Date(10) DATE Disability Notification Date
    42 PHYDIS_PCT_FRA Number(6,2) DECIMAL(5,2) NOT NULL Disability Amount %
    43 PHYDIS_TIME_CD_FRA Character(3) VARCHAR2(3) NOT NULL Disability Period
    PAR=Temporary Disability
    PER=Permanent Disability
    44 INJ_ILL_CONSEQ_FRA Character(1) VARCHAR2(1) NOT NULL Consequences
    N=None
    R=Reject Claim
    T=Stop Work
    X=Change Job
    45 CASE_NBR_USA Character(5) VARCHAR2(5) NOT NULL Case Number
    46 ILLNESS_TYPE Character(1) VARCHAR2(1) NOT NULL Illness Type
    1=Occupational Skin Disease
    2=Dust Disease of the Lungs
    3=Toxic Agent Respiratory Cond.
    4=Toxic Poisoning
    5=Physical Agents Disorder
    6=Repeated Trauma Disorder
    7=Other Occupational Illness
    8=Not Applicable
    47 DT_FILED_USA Date(10) DATE Date Filed
    48 OSHA_200_DESCR Character(60) VARCHAR2(60) NOT NULL Log Comments
    49 PRIVACY_CASE Character(1) VARCHAR2(1) NOT NULL Privacy Case

    Y/N Table Edit

    Default Value: N

    50 ABSENT_AFTER Character(1) VARCHAR2(1) NOT NULL Absent after day of injury
    N=No
    U=Unknown
    Y=Yes

    Y/N Table Edit

    51 LAST_WRKD_START_TM Time(15) TIMESTAMP Last Day Worked Start Time
    52 EARN_LESS_PAY Character(1) VARCHAR2(1) NOT NULL Earn less pay

    Y/N Table Edit

    Default Value: N

    53 PAYMENTS_DURING Character(1) VARCHAR2(1) NOT NULL Payments during disability

    Y/N Table Edit

    Default Value: N

    54 BENEFITS_CONT Character(1) VARCHAR2(1) NOT NULL Benefits continue
    A=Not Applicable
    N=No
    Y=Yes

    Y/N Table Edit

    55 WRK_AFTR_ST_DT Date(10) DATE Work aftr init absence St Dt
    56 WRK_AFTR_END_DT Date(10) DATE Work aftr init absence end dt
    57 TIME_PERIOD_CD Character(1) VARCHAR2(1) NOT NULL Time Period
    B=Biweekly
    D=Day
    H=Hour
    M=Month
    Q=Quarter
    S=Semi-monthly
    T=Ten-monthly
    W=Week
    Y=Year
    58 FA_DESIG_SEQNUM Number(2,0) SMALLINT NOT NULL First Aider Designate Seqnum

    Prompt Table: INJ_DSGCAN_VW

    59 TRANSPORT_HRS Number(2,0) SMALLINT NOT NULL Transportation Time - Hours
    60 TRANSPORT_MIN Number(2,0) SMALLINT NOT NULL Transportation Time - Minutes
    61 ATTENDANT_OBS_SW Character(1) VARCHAR2(1) NOT NULL Attendant Observe Unconscious

    Y/N Table Edit

    62 WRKR_ARRIVE_FA Character(2) VARCHAR2(2) NOT NULL How Worker Arrived First Aid
    05=Walking
    10=Carried
    15=Stretcher
    20=Truck
    25=Car
    30=Assisted by helper
    35=Emergency Transport Vehicle
    40=Air Evacuation
    45=Industrial Ambulance
    50=Ambulance
    55=Other
    63 WRKR_LEAVE_FA Character(2) VARCHAR2(2) NOT NULL How Worker Left First Aid
    05=Walking
    10=Carried
    15=Stretcher
    20=Truck
    25=Car
    30=Assisted by helper
    35=Emergency Transport Vehicle
    40=Air Evacuation
    45=Industrial Ambulance
    50=Ambulance
    55=Other
    64 PRIOR_DISAB_SW Character(1) VARCHAR2(1) NOT NULL Prior Disability

    Y/N Table Edit

    Default Value: N

    65 PRIOR_HLTH_COND_SW Character(1) VARCHAR2(1) NOT NULL Prior Health Condition

    Y/N Table Edit

    Default Value: N

    66 NEAREST_HOSP_DIST Number(8,2) DECIMAL(7,2) NOT NULL Nearest Hospital Distance
    67 NEAREST_HOSP_NAME Character(30) VARCHAR2(30) NOT NULL Nearest Hospital Name
    68 NEAREST_PRACT_DIST Number(8,2) DECIMAL(7,2) NOT NULL Nearest Practitioner Distance
    69 ACTIONS_BUSREL_SW Character(1) VARCHAR2(1) NOT NULL Actions Business Related

    Y/N Table Edit

    Default Value: Y

    70 ACTIONS_ROUTINE_SW Character(1) VARCHAR2(1) NOT NULL Actions Routine

    Y/N Table Edit

    Default Value: Y

    71 RTW_EMPLCNS_SW_CAN Character(1) VARCHAR2(1) NOT NULL Employer Consider Return

    Y/N Table Edit

    Default Value: N

    72 RTW_MODWORK_SW_CAN Character(1) VARCHAR2(1) NOT NULL Modified Work Available

    Y/N Table Edit

    Default Value: N

    73 RTW_CONTACT_CAN Character(11) VARCHAR2(11) NOT NULL Return To Work Contact

    Prompt Table: PERSON_NAME

    74 RTN_WRK_FL_SLRY Character(1) VARCHAR2(1) NOT NULL Return to Work At Full Salary

    Y/N Table Edit

    Default Value: N

    75 EMPR_BENEFITS_DESC Character(250) VARCHAR2(250) NOT NULL Employer Benefits Description
    76 VAR_SHIFT_ROTATION Character(1) VARCHAR2(1) NOT NULL Variable Shift Rotation

    Y/N Table Edit

    Default Value: N

    77 LAST_DAY_SCHED_ST Time(15) TIMESTAMP Last Day Scheduled Start Time
    78 LAST_DAY_SCHED_END Time(15) TIMESTAMP Last Day Scheduled End Time
    79 FIXED_ROTN_ST_DT Date(10) DATE Fixed Rotation Start Date
    80 LUMP_SUM_HOL_RCVD Character(1) VARCHAR2(1) NOT NULL Lump Sum Holiday Pay Received

    Y/N Table Edit

    Default Value: N

    81 HOLIDAY_PAY_RT Number(4,2) DECIMAL(3,2) NOT NULL Holiday Pay Rate Percent
    82 LAST_DAY_WAGES Number(8,2) DECIMAL(7,2) NOT NULL Last Day's Wages
    83 INJURY_DATE Date(10) DATE Injury Date
    84 INJURY_TIME Time(15) TIMESTAMP Injury Time
    85 HS_TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Health and Safety Time Zone Field 2

    Default Value: INJURY_ILL_VW.HS_TIMEZONE1

    86 EXPOSURE_ST_DT Date(10) DATE Exposure Start Date
    87 EXPOSURE_ST_TM Time(15) TIMESTAMP Exposure Start Time
    88 EXPOSURE_END_DT Date(10) DATE Exposure End Date
    89 EXPOSURE_END_TM Time(15) TIMESTAMP Exposure End Time
    90 CLASS_SUBCLASS Number(6,0) INTEGER NOT NULL Class/Subclass

    Prompt Table: %EDITTABLE17

    91 COST_CENTER_CAN Character(15) VARCHAR2(15) NOT NULL Customer Cost Center
    92 INJ_OUTCOME_CAN Character(4) VARCHAR2(4) NOT NULL Injury Outcome
    FAT=Fatality
    HCO=Health Care Only
    RPO=Reported Only
    STD=Short Term Disability
    93 DATE_TIME_EXACT_SW Character(1) VARCHAR2(1) NOT NULL Date and Time Exact

    Y/N Table Edit

    Default Value: N

    94 BUSINESS_TYPE Character(30) VARCHAR2(30) NOT NULL Business Type For Event
    95 SCENE_DESCR Character(200) VARCHAR2(200) NOT NULL Description of Accident Scene
    96 DAMAGED_APP_IND Character(1) VARCHAR2(1) NOT NULL Damaged Appliance Indicator

    Y/N Table Edit

    Default Value: N

    97 WRKR_SUP_EQP_IND Character(1) VARCHAR2(1) NOT NULL Worker Supplies Own Equipment Indicator

    Y/N Table Edit

    Default Value: N

    98 SHFT_DIFF_IND Character(1) VARCHAR2(1) NOT NULL Shift Differential Included Indicator

    Y/N Table Edit

    Default Value: N

    99 SHFT_DIFF_MES_CD Character(1) VARCHAR2(1) NOT NULL Differential Premium Ind
    D=Day
    100 SHIFT_DIFF_AMNT Number(12,2) DECIMAL(11,2) NOT NULL Amount of shift differential premiumm that the worker is paid
    101 OFF_WRK_VAC_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether vacation pay continues to accrue while off work Valid Codes Y = Yes N = No

    Y/N Table Edit

    Default Value: N

    102 SHT_CYCL_ONE_DY_ON Number(1,0) SMALLINT NOT NULL Number of days the worker was ON during the first shift cycle from the shift cycle start date
    103 SHFT_CYC_ONE_DY_OF Number(1,0) SMALLINT NOT NULL Number of days the worker was OFF during the first shift cycle from the shift cycle start date
    104 SHFT_CYC_TWO_DY_ON Number(1,0) SMALLINT NOT NULL Number of days the worker was ON during the second shift cycle from the shift cycle start date
    105 SHFT_CYC_TWO_DY_OF Number(1,0) SMALLINT NOT NULL Number of days the worker was OFF during the second shift cycle from the shift cycle start date
    106 SHFT_THREE_DAY_ON Number(1,0) SMALLINT NOT NULL Number of days the worker was ON during the third shift cycle from the shift cycle start date
    107 SHFT_THREE_DAY_OFF Number(1,0) SMALLINT NOT NULL Number of days the worker was OFF during the third shift cycle from the shift cycle start date
    108 SHT_CYC_FOUR_DY_ON Number(1,0) SMALLINT NOT NULL Number of days the worker was ON during the fourth shift cycle from the shift cycle start date
    109 SHT_CYC_FOUR_DY_OF Number(1,0) SMALLINT NOT NULL Number of days the worker was OFF during the fourth shift cycle from the shift cycle start date
    110 SHT_CYC_FIVE_DY_ON Number(1,0) SMALLINT NOT NULL Number of days the worker was ON during the fifth shift cycle from the shift cycle start date
    111 SHT_CYC_FIVE_DY_OF Number(1,0) SMALLINT NOT NULL Number of days the worker was off during the fifth shift cycle from the shift cycle start date
    112 EMPLD_SHORT_TM_IND Character(1) VARCHAR2(1) NOT NULL Indicates that this worker has a temporary or sporadic employment with the employer Valid Codes: Y = Yes N - No
    1=Short Term Basis
    2=Less Than Three Months
    3=Temporary Basis
    4=On Call
    5=Other Employment Service

    Default Value: N

    113 EMPL_THREE_MON_IND Character(1) VARCHAR2(1) NOT NULL Indicates that this worker has been employed for less than three consecutive months with the employer Valid codes: Y = Yes N = No

    Y/N Table Edit

    Default Value: N

    114 EMPLD_ON_CAL_IND Character(1) VARCHAR2(1) NOT NULL Indicates this worker works an on call basis Valid Codes: Y = Yes N = No

    Y/N Table Edit

    Default Value: N

    115 EMPLD_TEMP_IND Character(1) VARCHAR2(1) NOT NULL Indicates this worker is employed on a temporary basis Valid Codes: Y = yes N = No

    Y/N Table Edit

    Default Value: N

    116 EMPLD_OTHER_IND Character(1) VARCHAR2(1) NOT NULL Indicates that none of the specified scenarios is applicable to this worker valid codes Y = Yes N = No

    Y/N Table Edit

    Default Value: N

    117 EMPL_TEMP_START_DT Date(10) DATE The start date of the temporary assignment
    118 EMPL_TEMP_END_DT Date(10) DATE The end date of the temporary assignment
    119 EMPLD_END_DT_UID Character(1) VARCHAR2(1) NOT NULL The end date of the temporary assignment is unknown Valid Code: Y = Yes N = No

    Y/N Table Edit

    Default Value: N

    120 MONDAY_WRKD_IND Character(1) VARCHAR2(1) NOT NULL Did worker normally work on Mondays Valid Codes Y = yes N = no

    Y/N Table Edit

    Default Value: N

    121 TUESDAY_WRKD_IND Character(1) VARCHAR2(1) NOT NULL Did worker normally work on Tuesdays Valid Codes Y = yes N = no

    Y/N Table Edit

    Default Value: N

    122 WEDNESDAY_WRKD_IND Character(1) VARCHAR2(1) NOT NULL Did worker normally work on Wednesdays Valid Codes Y = yes N = no

    Y/N Table Edit

    Default Value: N

    123 THURSDAY_WRKD_IND Character(1) VARCHAR2(1) NOT NULL Did worker normally work on Thursdays Valid Codes Y = yes N = no

    Y/N Table Edit

    Default Value: N

    124 FRIDAY_WRKD_IND Character(1) VARCHAR2(1) NOT NULL Did worker normally work on Fridays Valid Codes Y = yes N = no

    Y/N Table Edit

    Default Value: N

    125 SATURDAY_WRKD_IND Character(1) VARCHAR2(1) NOT NULL Did worker normally work on Saturdays Valid Codes Y = yes N = no

    Y/N Table Edit

    Default Value: N

    126 SUNDAY_WRKD_IND Character(1) VARCHAR2(1) NOT NULL Did worker normally work on Sundays Valid Codes Y = yes N = no

    Y/N Table Edit

    Default Value: N

    127 OVR_FIVE_SHFT_IND Character(1) VARCHAR2(1) NOT NULL Are there more than five shift cycles Valid Codes Y = Yes N = No

    Y/N Table Edit

    Default Value: N

    128 WRK_SCHLD_TYP_CD Character(1) VARCHAR2(1) NOT NULL indicates whether the injured worker works a set schedule every week, has a fixed rotating shift or has a variable shift work Valid codes: F = Fixed R = Rotating V = Variable
    F=Fixed
    129 OWNR_PRTNR_SW_GER Character(1) VARCHAR2(1) NOT NULL Owner Partner

    Y/N Table Edit

    Default Value: N

    130 PARTNER_SW_GER Character(1) VARCHAR2(1) NOT NULL Partner

    Y/N Table Edit

    Default Value: N

    131 INCOMPETENT_SW_GER Character(1) VARCHAR2(1) NOT NULL Incompetent

    Y/N Table Edit

    Default Value: N

    132 RELATION_SW_GER Character(1) VARCHAR2(1) NOT NULL Relation

    Y/N Table Edit

    Default Value: N

    133 WA_CD_GER Character(4) VARCHAR2(4) NOT NULL Work Area

    Prompt Table: WA_TBL_GER

    134 UNSAFE_ITEM_CD_GER Character(2) VARCHAR2(2) NOT NULL Unsafe Item

    Prompt Table: UNSAFE_ITEM_GER

    135 CASE_NBR_GER Character(5) VARCHAR2(5) NOT NULL Case Number
    136 CASE_OFFICER_GER Character(11) VARCHAR2(11) NOT NULL Case Officer ID

    Prompt Table: PERSON_NAME

    137 REJECT_REASON_GER Character(3) VARCHAR2(3) NOT NULL Reject Reason
    ANG=Unreliable Statement
    BET=Comp. Physician Not Consulted
    HIL=First Aid Rejected
    TAT=Not Job Related
    VOR=No Accident
    138 DT_FILED_GER Date(10) DATE Date Filed
    139 PAY_CONT_SW_GER Character(1) VARCHAR2(1) NOT NULL Payments Continue

    Y/N Table Edit

    Default Value: N

    140 PAY_UNTIL_DT_GER Date(10) DATE Payments Continue Until
    141 WRK_AFTR_ST_SW_GER Character(1) VARCHAR2(1) NOT NULL Work After Start

    Y/N Table Edit

    Default Value: N

    142 WRK_STOP_CD_GER Character(2) VARCHAR2(2) NOT NULL Work Stop
    N=No
    S=Immediately
    SP=Later
    143 WRK_STOP_DT_GER Date(10) DATE Work Stop Date
    144 SI_PROVIDER_GER Character(10) VARCHAR2(10) NOT NULL SI provider ID
    145 FALL_HEIGHT_UK Number(5,1) DECIMAL(4,1) NOT NULL FALL_HEIGHT_UK
    146 HOSPITAL_24_SW_UK Character(1) VARCHAR2(1) NOT NULL Hospitalised for over 24 hours

    Y/N Table Edit

    Default Value: N

    147 OCC_ILL_DIAG_DT_UK Date(10) DATE Occ Illness Diagnosis Date
    148 MEM_PUBLIC_SW_UK Character(1) VARCHAR2(1) NOT NULL Member Of Public

    Y/N Table Edit

    Default Value: N

    149 SELF_EMPL_SW_UK Character(1) VARCHAR2(1) NOT NULL SELF_EMPL_SW_UK

    Y/N Table Edit

    Default Value: N

    150 CASE_NUMBER_AUS Character(12) VARCHAR2(12) NOT NULL Case Number
    151 DT_FILED_AUS Date(10) DATE Date Filed
    152 CASE_NUMBER_NZL Character(12) VARCHAR2(12) NOT NULL Case Number
    153 DT_FILED_NZL Date(10) DATE Date Filed
    154 IMSS_ST7_FORM_MEX Character(1) VARCHAR2(1) NOT NULL IMSS ST7 Form Mexico

    Y/N Table Edit

    Default Value: N

    155 REPORT_DATE Date(10) DATE Report Date
    156 FURTHER_INQUIRY Character(1) VARCHAR2(1) NOT NULL Further Inquiry

    Y/N Table Edit

    157 LAST_WORKED_TM Time(15) TIMESTAMP Time last worked
    158 RETURN_TM Time(15) TIMESTAMP Return Time
    159 EMPL_RETURN_WORK Character(1) VARCHAR2(1) NOT NULL Employee Return To Work

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    161 COMMENTS Long Character CLOB Comment