# DW_HNS_INCIDENT_H (Preview)

This table requires activation of Health and Safety functional area. Health and Safety Incident Helper table

## Details

Module: Workforce Health and Safety Incidents

## Key Columns

INCIDENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INCIDENT_ID | NUMBER | 38 | 0 | True | Incident Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier |  |
ERGONOMIC_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Ergonomic Event Detail Identifier | DW_HNS_ERGONOMIC_EVENT_D | ERGONOMIC_EVT_DETAIL_ID
FIRE_INC_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Fire Incident Event Detail Identifier | DW_HNS_FIRE_INCIDENT_EVENT_D | FIRE_INC_EVT_DETAIL_ID
AIR_QUALITY_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Air Quality Event Detail Identifier | DW_HNS_AIR_QUALITY_EVENT_D | AIR_QUALITY_EVT_DETAIL_ID
ISSUE_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Issue Event Detail Identifier | DW_HNS_ISSUE_EVENT_DETAIL_D | ISSUE_EVT_DETAIL_ID
NEAR_MISS_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Near Miss Event Detail Identifier | DW_HNS_NEAR_MISS_EVENT_D | NEAR_MISS_EVT_DETAIL_ID
NOTICE_VIO_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Notice Violation Event Detail Identifier | DW_HNS_NOTICE_VIOLATION_EVENT_D | NOTICE_VIO_EVT_DETAIL_ID
PROP_DAMAGE_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Property Damage Event Detail Identifier | DW_HNS_PROPERTY_DAMAGE_EVENT_D | PROP_DAMAGE_EVT_DETAIL_ID
SPILL_REL_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Spill Release Event Detail Identifier | DW_HNS_SPILL_RELEASE_EVENT_D | SPILL_REL_EVT_DETAIL_ID
SUGG_IMPROV_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Suggestion Improvement Event Detail Identifier | DW_HNS_SUGGESTION_IMPROV_EVENT_D | SUGG_IMPROV_EVT_DETAIL_ID
UNSAFE_ACT_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Unsafe Act Event Detail Identifier | DW_HNS_UNSAFE_ACT_EVENT_D | UNSAFE_ACT_EVT_DETAIL_ID
UNSAFE_COND_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Unsafe Condition Event Detail Identifier | DW_HNS_UNSAFE_CONDITION_EVENT_D | UNSAFE_COND_EVT_DETAIL_ID
INJURED_PERSON_SUMMARY_ID | NUMBER | 38 | 0 |  | Injured Person Summary Identifier | DW_HNS_INJURED_PERSON_SUMMARY_D | INJURED_PERSON_SUMMARY_ID

Copyright © 2019, 2025, Oracle and/or its affiliates.