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    

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