auto_validation_service

Auto-validates Field Complete projects using a 10-point checklist. Advances to “Ready for Cert” on pass, creates RFI on fail.

Connections

• depends on: supabase-read-service
• triggered by: Pipeline Shepherd
• feeds into: RFI system
• advances: Project Status Flow

Notes

• 10-point checklist covers: photos, driving logs, SOW lines, permit, field notes, etc.
• Check 10: Scope Resolved — blocks cert if SOW_MODIFIED lines lack ABSoW quantities
• Full audit trail for every validation run
• Part of the auto-advance pipeline: Field Complete → Ready for Cert (no human needed if clean)
• On PASS: auto-calculates production days via auto_calculate_and_write_production_days() before advancing (session 39)
• Production days calc: 8 division rules (UND: 1/6.5 piers, ANC: 1/10, BRC: 1/12, SUP: 1/15 cols, FND: 1/type, WTR: 1+0.5/50LF, ENC: 1+0.5/500SF, RTW: 1/20LF). Manual overrides always win.