The most useful reporting workflow does not merely attach a PDF to a job. It creates an explicit, reviewable relationship between planned work, completed activity, and the evidence behind the report.

The problem: planned work and field activity live separately

Work completion records typically capture the administrative and contractual view of a task. Spray logs capture operational detail from the applicator and equipment. When those records remain separate, managers must manually decide which jobs belong to which WCR before totals can be checked.

Filename matching is tempting, but fragile. Names change, operators abbreviate differently, and one WCR may cover several days or jobs. A reliable connection needs more than a text resemblance.

A practical approach: build the relationship deliberately

  1. Extract the WCR identifiers. Capture contract, work order, location, date range, applicator, product, and expected treatment information.
  2. Normalize the spray jobs. Standardize operator names, dates, products, units, and route geometry before matching.
  3. Create candidate links. Use explicit job references first, then date overlap, operator, road location, and spatial proximity as supporting evidence.
  4. Score and review uncertain matches. Strong matches can be automated. Ambiguous links should be visible for a person to confirm.
  5. Store the link as data. Record why the WCR and job were connected, who confirmed it, and when.
Reporting principleA generated total should always have a visible path back to the spray activity that produced it.

Implementation notes

Model the relationship so that one WCR can connect to multiple jobs and one job can be reviewed against the appropriate scope. Avoid copying every spray value into the WCR record; store the relationship and calculate summaries from the underlying operational data.

For spatial work, road identifiers are valuable but may not be present in the source. A nearest-road or intersecting-road process can create a candidate road association, provided the tolerance and coordinate system are explicit and uncertain results can be reviewed.

The desired outcome

A manager can open a WCR, see the spray jobs and road segments that support it, compare expected and recorded quantities, and investigate exceptions. The report becomes reproducible rather than a one-time spreadsheet exercise.

This connection also creates a foundation for better questions: which work is complete, which WCRs lack supporting activity, and where field data does not match the planned scope.