Data Health & Quarantine

Nightly Drop Ingestion Pipeline (JobBOSS / E2 / Epicor)

Last Sync: 02:00 AM CST

Status: Partial Ingestion

Overall Data Health

92/100

↑ 3 pts vs last week

Records Processed

14,208

Past 24 hours

Quarantined Records

142

0.9% Error Rate (Target < 2%)

Completeness (Ops Labor)

88%

12% missing clock-out data

The Enginuity Universal Schema (Required CSV Headers)

These exact column headers must be present in the nightly SFTP drop. If a required column is missing, the entire file is rejected.

1. Sales_Quotes.csv

  • Quote_ID Req
  • Customer_ID Req
  • Industry_Vertical Opt
  • Quote_Date Req
  • Est_Labor_Cost Req
  • Est_Material_Cost Req
  • Quoted_Price Req
  • Win_Loss_Status Req

2. WO_Execution.csv

  • WO_ID Req
  • Quote_ID_Ref Req
  • Routing_Step Req
  • Est_Hours Req
  • Actual_Hours Req
  • Rework_Hours Opt
  • WO_Status Req

3. Purchasing.csv

  • PO_ID Req
  • WO_ID_Ref Opt
  • Material_Cat Req
  • Est_Unit_Cost Req
  • Act_Unit_Cost Req
  • Order_Date Req
  • Receipt_Date Opt

4. AP_AR_Finance.csv

  • Invoice_ID Req
  • WO_ID_Ref Req
  • Invoice_Amt Req
  • Issue_Date Req
  • Paid_Date Opt

Quarantine Log (Action Required)

Timestamp File Origin Error Type Record ID Resolution Action
02:01:14 WO_Execution.csv Missing `Actual_Hours` WO-9942 (Row 412)
02:01:18 Purchasing.csv Invalid Data Type (Cost) PO-4412 (Row 89)
02:01:45 Sales_Quotes.csv Missing `Quote_ID_Ref` QT-2026-041 (Row 12)