sdac-orchestrate-full-review

Purpose

Builds a structured review plan that enumerates which validation tools to run, in which order, and with what default inputs.

Tool type

Deterministic (planning tool)

Tool ID

sdac-orchestrate-full-review

Inputs

• report_id (string)
• file_name (string, optional)
• review_mode (QUICK | STANDARD | THOROUGH)
• skip_external_verification (boolean, default: false)
• threshold_pct (number, default: 5)

Outputs

• success
• steps_to_execute (array of tool definitions and default inputs)
• execution_order
• estimated_time_minutes
• district_name, quarter, year, totals

Example output

{
  "success": true,
  "district_name": "Example R-II School District",
  "quarter": "Q2",
  "year": 2024,
  "totals": {
    "salary": 1250000,
    "fringe": 312000
  },
  "steps_to_execute": [
    {
      "tool_id": "sdac-validate-source-codes",
      "default_inputs": {
        "report_id": "SDAC-2024-Q2-001"
      }
    },
    {
      "tool_id": "sdac-validate-fringe",
      "default_inputs": {
        "report_id": "SDAC-2024-Q2-001"
      }
    }
  ],
  "execution_order": [
    "metadata",
    "deterministic_validations",
    "ai_assisted_analysis"
  ],
  "estimated_time_minutes": 4
}

Functional details

• Filters steps based on review mode and available inputs.
• Provides default inputs for each tool (e.g., thresholds, flags).
• Calculates an estimated execution duration.

Usage notes

• This tool does not run validations; it returns a plan for agents to execute.
• Use in coordinator agents or workflow automation.

Implementation details

• Loads report metadata, district info, and totals via SDAC DB helpers.
• Maps steps to tool IDs defined in the SDAC tool registry.
• Skips file metadata validation when no file name is provided.

Code Location: packages/domain-sdac/src/tools/orchestrate-full-review.tool.ts