DW_HNS_FIRE_INCIDENT_EVENT_D (Preview)

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

Details

Module: Workforce Health and Safety Incidents

Key Columns

FIRE_INC_EVT_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FIRE_INC_EVT_DETAIL_ID NUMBER 38 0 True Fire Incident Event Detail Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
INCIDENT_DETAIL_ID NUMBER 38 0 Incident Detail identifier
EXPLOSION_FUEL_OR_ENERGY_CODE VARCHAR2 32 Explosion Fuel or Energy Code
EXPLOSION_IGNITION_SOURCE_CODE VARCHAR2 32 Explosion Ignition Source Code
EXPLOSION_ORIGIN_CODE VARCHAR2 32 Explosion Origin Code
FIRE_FUEL_OR_ENERGY_CODE VARCHAR2 32 Fire Fuel or Energy Code
FIRE_IGNITION_SOURCE_CODE VARCHAR2 32 Fire Ignition Source Code
FIRE_ORIGIN_CODE VARCHAR2 32 Fire Origin Code
MATERIAL_FIRST_IGNITED_CODE VARCHAR2 32 Material First Ignited Code
POSSIBLE_CAUSE_OF_EXPLOSION_CODE VARCHAR2 32 Possible Cause of Explosion Code
POSSIBLE_CAUSE_OF_FIRE_CODE VARCHAR2 32 Possible Cause of Fire Code
TYPE_OF_EXPLOSION_CODE VARCHAR2 32 Type Of Explosion Code
TYPE_OF_FIRE_CODE VARCHAR2 32 Type Of Fire Code
EXPLOSION_FLAG VARCHAR2 16 Explosion Flag
FIRE_FLAG VARCHAR2 16 Fire Flag
REPLN_FIRE_FIGHTING_EQUIP_FLAG VARCHAR2 16 Replenish Fire Fighting Equipment Flag
DELETED_FLAG VARCHAR2 16 Deleted flag.This column signifies whether the incident event is checked for deletion