sdac-manage-validation-queue

Purpose

Provides queue operations to list pending reports, retrieve report details, send reports back, or mark reports as validated.

Tool type

Deterministic (rule-based)

Tool ID

sdac-manage-validation-queue

Inputs

• action (LIST_PENDING | GET_REPORT | SEND_BACK | MARK_VALIDATED | GET_HISTORY)
• page (number, default: 1)
• page_size (number, default: 25)
• report_id (string, required for GET_REPORT, SEND_BACK, MARK_VALIDATED)
• sendback_reason (string, optional)
• reviewer_id (string, optional)

Outputs

• success, action
• pending_reports (when listing)
• report_details (when fetching a report)
• history (when fetching history)
• message (confirmation for sendback/validation)

Example output

{
  "success": true,
  "action": "list_pending",
  "pending_reports": [
    {
      "report_id": "SDAC-2024-Q2-001",
      "district_name": "Example R-II School District",
      "year": 2024,
      "quarter": "Q2",
      "submitted_at": "2026-05-01T09:30:00.000Z"
    }
  ],
  "message": "1 pending report found."
}

Functional details

• Lists pending reports ordered by submission date.
• Returns district metadata, quarter, year, and submission type.
• Updates validation status and records history entries for sendbacks or approvals.

Usage notes

• Pair with sdac-log-validation-tracking for a full audit trail.
• Use paging parameters for large queues.

Implementation details

• Reads from SDAC.data_CostReports and SDAC.dim_Districts.
• Writes to SDAC.data_ValidationHistory when updating status.
• Normalizes submission types into EXCEL / ONLINE_ENTRY / UNKNOWN.

Code Location: packages/domain-sdac/src/tools/manage-validation-queue.tool.ts