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     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 38 0   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    

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