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 This column is for Oracle Internal use only. 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.