✏️Prompts

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