This table requires activation of Health and Safety functional area. Table stores Health and Safety Spill Release Event information
Module: Workforce Health and Safety Incidents
SPILL_REL_EVT_DETAIL_ID
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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.