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.