# DW_HNS_INCIDENT_F (Preview)

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

## 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 |  |
INCIDENT_NUMBER | VARCHAR2 | 32 |  |  | Incident Number |  |
REPORTER_TYPE_CODE | VARCHAR2 | 32 |  |  | Reporter Type Code |  |
REPORTER_NONEMP_TYPE_CODE | VARCHAR2 | 32 |  |  | Reporter Non Employee Type Code |  |
REPORTER_PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier | DW_PERSON_D | PERSON_ID
REPORTER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment ID of the reporter (employee) at the time when Incident happened. |  |
REPORTER_NAME | VARCHAR2 | 256 |  |  | Reporter Name |  |
INCIDENT_DATE | DATE |  |  |  | Incident Date |  |
INCIDENT_DATE_TIME | TIMESTAMP |  |  |  | Incident Date Time |  |
INCIDENT_REPORTED_DATE | TIMESTAMP |  |  |  | This is the date that the incident reporter informed a person in authority |  |
INCIDENT_CREATE_DATE | DATE |  |  |  | Incident Creation Date |  |
LOCATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Location Type Code |  |
OFFSITE_LOCATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Offsite Location Type Code |  |
REPORTED_SPECIFIC_LOCATION | VARCHAR2 | 256 |  |  | Reported Specific Location |  |
REPORTED_CITY | VARCHAR2 | 128 |  |  | Reported City |  |
REPORTED_COUNTRY | VARCHAR2 | 128 |  |  | Reported Country |  |
INCIDENT_SUMMARY | VARCHAR2 | 999 |  |  | Incident Summary |  |
SEVERITY_LEVEL_CODE | VARCHAR2 | 32 |  |  | Severity Level Code |  |
INCIDENT_OWNER_PERSON_ID | NUMBER | 38 | 0 |  | Incident Owner Person Identifier | DW_PERSON_D | PERSON_ID
INCIDENT_OWNER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Id for ther person/employee who owns the incident. |  |
NOTIFIED_PERSON_ID | NUMBER | 38 | 0 |  | Employee ID of the person who was notified about the incident. |  |
NOTIFIED_PERSON_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment ID of the person who was notified about the incident. |  |
TARGET_COMPLETION_DATE | TIMESTAMP |  |  |  | Target Completion Date |  |
ACTUAL_COMPLETION_DATE | TIMESTAMP |  |  |  | Actual Completion Date |  |
INCIDENT_STATUS_CODE | VARCHAR2 | 32 |  |  | Incident Status Code |  |
EMERGENCY_FLAG | VARCHAR2 | 16 |  |  | Deleted flag.This column signifies whether the incident is checked for deletion |  |
CONFIDENTIAL_FLAG | VARCHAR2 | 16 |  |  | Is Confidential flag. This column signifies whether the incident is checked confidential. |  |
COMPLETED_FLAG | VARCHAR2 | 16 |  |  | COMPLETED flag.This signifies if the incident is completed or not. |  |
REPORTED_STATE | VARCHAR2 | 128 |  |  | REPTR_STATE column : Incident state reported by the reporter. |  |
REPORTED_ZIP_CODE | VARCHAR2 | 128 |  |  | REPTR_ZIP_CODE column : Incident zipcode reported by the reporter. |  |
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
BIZ_CONT_PLAN_ACT_BY_PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier of the person who activated the business continuity plan. | DW_PERSON_D | PERSON_ID
BIZ_CONT_PLAN_ACTIVATED_DATE | TIMESTAMP |  |  |  | At what time the business continuity plan is activated. |  |
BIZ_CONT_PLAN_ACTIVATED_FLAG | VARCHAR2 | 16 |  |  | Business continuity plan activated flag |  |
EMRGNCY_ACTN_PLAN_ACTVTD_BY_PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier of the person who activated the emergency action plan. | DW_PERSON_D | PERSON_ID
EMRGNCY_ACTN_PLAN_ACTVTD_FLAG | VARCHAR2 | 16 |  |  | Emergency Action Plan Activated Flag |  |
EMRGNCY_ACTN_PLAN_ACTVTD_DATE | TIMESTAMP |  |  |  | At what time the Emergency Action Plan is Activated. |  |
EVACUATION_FLAG | VARCHAR2 | 16 |  |  | Evacuation Flag |  |
EVACUATION_LENGTH_OF_TIME | VARCHAR2 | 16 |  |  | Length of Time(Hrs) the evacuation is happened for |  |
EVACUATION_ORDERED_DATE | TIMESTAMP |  |  |  | At what time the evacuation is ordered. |  |
EVACUATION_ORDERED_BY_PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier of the person who ordered the evacuation. | DW_PERSON_D | PERSON_ID
EVACUATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Evacuation Type Code |  |
FACILITY_CLOSED_DATE | TIMESTAMP |  |  |  | At what time the facility is closed. |  |
FACILITY_CLOSED_BY_PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier of the person who closed the facility. | DW_PERSON_D | PERSON_ID
FACILITY_CLOSED_FLAG | VARCHAR2 | 16 |  |  | Facility Closed or Operations Ceased Flag |  |
FACILITY_CLOSED_LENGTH_OF_TIME | VARCHAR2 | 16 |  |  | Length of Time(Hrs) the facility is closed. |  |
INCIDENT_SOURCE_CODE | VARCHAR2 | 32 |  |  | Source for Incident creation |  |
INCIDENT_TYPE_CODE | VARCHAR2 | 32 |  |  | Incident Type Code |  |
ACTION_REQUIRED_FLAG | VARCHAR2 | 16 |  |  | Check box to confirm whether an action is required. |  |
LESSONS_LEARNED | VARCHAR2 | 999 |  |  | Lessons Learned |  |
RADIUS | NUMBER |  |  |  | Distance in terms of radiating circles from the facility where the fire or explosion occurred. |  |
RADIUS_UNIT_CODE | VARCHAR2 | 32 |  |  | Radius Unit Code. Unit of measure for distance |  |
DELETED_FLAG | VARCHAR2 | 16 |  |  | Deleted Flag |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  | Month identifier in YYYYQMM format. For example, 1979412. |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  | Quarter identifier in YYYYQ format. For example, 19794. |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  | Year identifier in YYYY format. For example, 1979. |  |

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