Incident Reports

This directory contains documentation for SQL scripts that generate incident-related reports. These reports track employee incidents, point systems, attendance monitoring, and corrective action triggers for disciplinary management.

Available Reports

Point System Reports

Report	Description	Key Features
Employee Point Balance Today	Current point balances for all active employees	Real-time point tracking, 12-month rolling period, Workgroup integration
Employee Point Balance in Range (Positive Points)	Employees with positive point balances in date range	Disciplinary tracking, Action triggers, Risk assessment
Employee Point Balance in Range (Negative Points)	Employees with negative point balances in date range	Recognition programs, Point credits, Performance tracking
Points in Range with Balance	Comprehensive point activity analysis for all employees	Complete overview, Trend analysis, Period comparisons

Incident Tracking & Analysis

Report	Description	Key Features
Days Since Last Incident	Calculates days elapsed since employee's last incident	Time-based analysis, Last incident tracking, Employee safety metrics
Employee Incidents in Range (Standard)	Comprehensive incident history within date range	Standardized format, Date range filtering, Compliance reporting
Broken Expirations	Identifies incidents with expired or broken expiration dates	Data integrity, Expiration tracking, System maintenance

Corrective Action & Discipline

Report	Description	Key Features
Trigger Corrective Action (Last 30 Days)	Recent corrective action triggers for HR follow-up	30-day window, HR workflow integration, Action trigger identification
Trigger Corrective Action - Trigger in Range	Action triggers within specified date range	Policy compliance, Multiple trigger types, Priority ranking

System Maintenance & Audit

Report	Description	Key Features
Supervisor Edit History - Change Incident 601	Tracks supervisor edits to incident type 601 records	Audit trail, Change documentation, Compliance monitoring

Common Use Cases

Disciplinary Management - Monitor employee behavior and implement progressive discipline
Performance Recognition - Identify employees with exceptional attendance and behavior
Compliance Reporting - Generate standardized reports for regulatory requirements
Risk Assessment - Identify high-risk employees requiring proactive intervention
System Integrity - Maintain data quality and audit trails for incident records

Technical Notes

All reports support date range filtering for flexible analysis periods
Point calculations follow current disciplinary policy configurations
Reports include both positive and negative point tracking capabilities
Audit trails are maintained for all incident record modifications
Results can be filtered by employee, workgroup, or other criteria

Getting Started

Identify Report Purpose - Determine what type of incident analysis you need
Select Appropriate Report - Choose from point tracking, incident analysis, or corrective action reports
Configure Parameters - Set date ranges, filters, and thresholds as needed
Execute Report - Generate the report with your specified parameters
Review Results - Analyze findings for trends, compliance, or action requirements
Take Action - Use report insights for disciplinary decisions or recognition programs

Perfect Attendance Reports - For attendance-based recognition programs
Employee Information Reports - Additional employee tracking capabilities
System Information Reports - System maintenance and data integrity tools

Incident Reports

On this page