Skip to main content

sdac-validate-federal-funding-backout

Purpose​

Checks federal source code backouts and mixed funding calculations against state/local percentages.

Tool type​

Deterministic (rule-based)

Tool ID​

sdac-validate-federal-funding-backout

Inputs​

  • report_id (string)
  • record_ids (number[], optional)
  • amount_tolerance (number, optional, default: 1)

Outputs​

  • errors and warnings for incorrect backouts or missing percentages

Example output​

{
  "success": true,
  "report_id": "SDAC-2024-Q2-001",
  "passed": false,
  "errors": [
    {
      "rule_id": "FEDERAL_FUNDS_NOT_BACKED_OUT",
      "row_number": 19,
      "message": "Source code includes federal funding but 100% of salary is still claimed.",
      "severity": "ERROR"
    }
  ],
  "warnings": []
}

Functional details​

  • Ensures federal-only rows have zero claimable amounts.
  • Validates mixed funding backout calculations using state/local percentages.
  • Applies amount_tolerance for rounding differences.

Implementation details​

  • Parses source codes from SourceCodesParsed or SourceCode.
  • Federal-only rows emit FEDERAL_SOURCE_ONLY_NONZERO if claimables > 0.
  • Mixed funding requires state/local percentages (derived from PctStateLocalFunds* or PctFederalFunds*).
  • Uses amount_tolerance when comparing expected vs actual claimable amounts.
  • Calculates expected claimable amounts from gross * state/local percentage.

Code Location: packages/domain-sdac/src/tools/validate-federal-funding-backout.tool.ts