DW_HNS_SPILL_RELEASE_EVENT_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Spill Release Event information

Details

Module: Workforce Health and Safety Incidents

Key Columns

SPILL_REL_EVT_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SPILL_REL_EVT_DETAIL_ID NUMBER 38 0 True System generated primary key column.    
SOURCE_RECORD_ID VARCHAR2 256     Unique Source Record Identifier with SPILL_REL_EVT_DETAIL_ID    
INCIDENT_DETAIL_ID NUMBER 38 0   Incident Detail identifier.    
SPILL_RELEASE_CODE VARCHAR2 32     Spill Release Identifier.    
WHAT_WAS_SPILLED_OR_RELEASED VARCHAR2 999     What was spilled or released.    
SPILLKIT_DEPLOYED_FLAG VARCHAR2 16     Spill kit deployed flag.    
REPLENISH_SPILL_KIT_FLAG VARCHAR2 16     Replenish Spill Kit Flag.    
CLEANUP_TEAM_NOTIFIED VARCHAR2 16     Cleanup team notified flag.    
CLEANUP_TEAM_NOTIFIED_DATE TIMESTAMP       At what time Cleanup team or Contractor notified.    
SPILL_POSSIBLE_CAUSE_CODE VARCHAR2 32     Possible cause of the spill or release.    
SPILL_SOURCE_CODE VARCHAR2 32     Spill or release source.    
AMOUNT_SPILLED NUMBER       Amount in volume spilled during the incident..    
AMOUNT_SPILLED_UNIT_CODE VARCHAR2 32     Unit of measurement for Amount spilled.    
AMOUNT_RECOVERED NUMBER       Amount in volume recovred during the event.    
AMOUNT_RECOVERED_UNIT_CODE VARCHAR2 32     Unit of measurement for Amount recovered.    
DELETED_FLAG VARCHAR2 16     This column signifies whether the incident event is checked for deletion.    

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