sdac-log-validation-tracking

Purpose

Records validation actions (returned, validated, notes) with timestamps, reviewer identity, and summary metrics.

Tool type

Deterministic (rule-based)

Tool ID

sdac-log-validation-tracking

Inputs

• report_id (string)
• action (RETURNED | VALIDATED | NOTE)
• notes (string, optional)
• reviewer_id (string, optional)
• reviewer_name (string, optional)
• return_reason (string, optional)

Outputs

• success
• summary (first_submitted, last_returned, validated, return_count)
• history (recent actions)
• tracking_id, timestamp

Example output

{
  "success": true,
  "summary": {
    "first_submitted": "2026-05-01",
    "last_returned": null,
    "validated": false,
    "return_count": 0
  },
  "history": [
    {
      "action": "SUBMITTED",
      "timestamp": "2026-05-01T09:30:00.000Z",
      "actor": "district-admin"
    }
  ],
  "tracking_id": "track-2024-q2-d123",
  "timestamp": "2026-05-08T14:30:00.000Z"
}

Functional details

• Creates a durable audit trail entry for each review action.
• Returns a summary of prior actions and days in queue.
• Supports adding reviewer notes without changing status.

Usage notes

• Use immediately after queue operations that change status.
• Pair with sdac-manage-validation-queue for lifecycle management.

Implementation details

• Ensures SDAC.data_ValidationTracking exists and inserts a new row.
• Reads prior history from SDAC.data_ValidationHistory.
• Calculates queue duration based on submission date and latest action.

Code Location: packages/domain-sdac/src/tools/log-validation-tracking.tool.ts