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
| 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. |