City employee pay statistics
get_city_salary_statsRetrieve head count and annual pay rates for City of Charlotte employees, grouped by department or job title for a specified quarter. Get aggregated salary data without individual employee details.
Instructions
Pay statistics for City of Charlotte employees: head count and annual pay rates.
Aggregated by department or job title for one quarter (the latest by default); individual employees are not listed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | No | ||
| limit | No | ||
| quarter | No | ||
| group_by | No | department | |
| job_title | No | Partial match, e.g. 'Fire Fighter' or 'Captain'. | |
| department | No | Partial match on abbreviated department names, e.g. 'CFD' (Fire), 'CMPD' (Police), 'CDOT', 'CATS', 'Charlotte Water'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| year | Yes | ||
| notes | Yes | ||
| filters | Yes | ||
| overall | Yes | ||
| quarter | Yes | ||
| group_by | Yes |