is_get_claims_summary_db
Retrieve a summary of iSuite claims by year, including counts by status, total liability, and average settlement amounts for analysis. Optionally filter by claim type.
Instructions
Get a summary of iSuite claims from the SQL Server database — counts by status, total liability, and average settlement amounts for analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | Yes | Claims filed in this year | |
| claim_type | No | Filter by claim type (optional) |