# DW_HNS_INCIDENT_EVENT_EF (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Incident Event information

## Details

Module: Workforce Health and Safety Incidents

## Key Columns

INCIDENT_DETAIL_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INCIDENT_DETAIL_ID | NUMBER | 38 | 0 | True | Incident Detail Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier which in this case is nothing but Incident Detail Identifier |  |
INCIDENT_ID | NUMBER | 38 | 0 |  | Incident identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier of the Employee. | DW_PERSON_D | PERSON_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment ID of the Employee. |  |
INCIDENT_EVENT_NUMBER | VARCHAR2 | 64 |  |  | Incident Event Number |  |
INCIDENT_EVENT_SUMMARY | VARCHAR2 | 999 |  |  | The Summary information entered by the reporter for each incident event. |  |
INCIDENT_EVENT_DATE | DATE |  |  |  | Date incident event was reported. |  |
INCIDENT_EVENT_DATE_TIME | TIMESTAMP |  |  |  | Date time incident event was reported. |  |
INCIDENT_EVENT_STATUS_CODE | VARCHAR2 | 32 |  |  | Current Incident Event Status. |  |
TARGET_COMPLETION_DATE | TIMESTAMP |  |  |  | Target completion date set for each incident event. |  |
ACTUAL_COMPLETION_DATE | TIMESTAMP |  |  |  | Actual Completion date set per incident event. |  |
INCIDENT_EVNT_OWNR_PERSON_ID | NUMBER | 38 | 0 |  | Owner Person Identifier for an Incident Event. Owner is an employee. | DW_PERSON_D | PERSON_ID
INCIDENT_EVNT_OWNR_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Id of the incident event owner. |  |
COMPLETED_FLAG | VARCHAR2 | 16 |  |  | Incident event completed flag. This signifies if the incident event is completed. |  |
SEVERITY_LEVEL_CODE | VARCHAR2 | 32 |  |  | Severity level set per incident event. |  |
EVENT_CREATION_DATE | TIMESTAMP |  |  |  | The date incident event was created in the system. |  |
LESSONS_LEARNED | VARCHAR2 | 999 |  |  | Lessons Learned. |  |
ACTION_REQUIRED_FLAG | VARCHAR2 | 16 |  |  | Check box to confirm whether an action is required. |  |
DATE_DISCLOSED | TIMESTAMP |  |  |  | Date employee notified the organization about the event. |  |
INCIDENT_EVENT_CODE | VARCHAR2 | 32 |  |  | Incident Event Code |  |
ERGONOMIC_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Ergonomic Event Detail Identifier |  |
FIRE_INC_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Fire Incident Event Detail Identifier |  |
AIR_QUALITY_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Air Quality Event Detail Identifier |  |
ISSUE_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Issue Event Detail Identifier |  |
NEAR_MISS_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Near Miss Event Detail Identifier |  |
NOTICE_VIO_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Notice Violation Event Detail Identifier |  |
PROP_DAMAGE_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Property Damage Event Detail Identifier |  |
SPILL_REL_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Spill Release Event Detail Identifier |  |
SUGG_IMPROV_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Suggestion Improvement Event Detail Identifier |  |
UNSAFE_ACT_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Unsafe Act Event Detail Identifier |  |
UNSAFE_COND_EVT_DETAIL_ID | NUMBER | 38 | 0 |  | Unsafe Condition Event Detail Identifier |  |
INJURED_PERSON_SUMMARY_ID | NUMBER | 38 | 0 |  | Injured Person Summary Identifier |  |
DELETED_FLAG | VARCHAR2 | 16 |  |  | This column signifies whether the incident event is checked for deletion. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |

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