incident
Core TableEHS & Compliance
Records incidents, accidents, near misses and related investigations and corrective actions.
Primary Key
incident_code
Record Type
Operational
Log Tables
incident_status_log
Summary Views
monthly_incident_summary
Last Updated
May 20, 2026
AI Usefulness
4.6
/ 5.0
High value for AI analytics, prediction and automation.
All (7)Key (1)Calculated (2)
| Field Code | Caption | Data Type | Length | PK | Calculated | Description |
|---|---|---|---|---|---|---|
| incident_code | Incident Code | Varchar | 50 | — | Unique code for each incident. | |
| incident_type_code | Incident Type Code | Varchar | 50 | — | — | Reference to incident_type. |
| incident_date | Incident Date | Date | — | — | — | Date of the incident. |
| severity_code | Severity Code | Varchar | 50 | — | — | Severity level of the incident. |
| location_code | Location Code | Varchar | 50 | — | — | Where the incident occurred. |
| status_code | Status Code | Varchar | 50 | — | — | Current status of the incident. |
| reported_by | Reported By | Varchar | 50 | — | — | Person who reported the incident. |
Showing 7 of 7 (34 total in schema)
Relationships (Links to)
- incident_type N:1Incident classification.
- building N:1Where incident occurred.
- contact N:1Reporter of the incident.
Operational Meaning
Captures every safety event with full investigation trail for regulatory reporting and trend analysis.
AI Opportunities
- Trend analysis & risk scoring
- Root cause prediction
- Leading indicator detection
- Auto-routing of corrective actions
Suggested Queries
- "Show all high-severity incidents in the last 90 days."
- "Which buildings have rising near-miss counts?"
- "List open incidents past their target close date."