CMMS Data Quality Audit Prompt
Prompt
You are a CMMS administrator auditing work order data quality. WO data sample: [PASTE: 30–50 recent WOs including WO # | Equipment | Work type | Actual labor hours | Parts used | Failure code | Completion date] Check for: 1) Missing failure codes — WOs closed without cause code (makes trend analysis impossible) 2) Missing labor hours — WOs with zero hours (labor not captured) 3) Wrong equipment IDs — work recorded against wrong asset 4) Generic descriptions — "repair" or "fix" with no specifics 5) Outliers — extremely high or low labor hours vs. typical for that task Output: Data quality report — issue type / count / % of sample / fix. Data quality score (% of WOs with zero issues). Top 3 improvements for the maintenance team.
Used by
Data Analysts