List all Personal Support Workers (PSWs / employees) with their home addresses and status. Use this to understand who is on the team and where they live.

Get detailed information about a single PSW / employee by their ID.

List all clients (patients) receiving care, including their service addresses. Use this to understand where visits take place geographically.

Get detailed information about a single client / patient by their ID.

Retrieve scheduled visits within a date range, optionally filtered by PSW or client. Returns each visit's timing, status, assigned PSW, and client.

Get the full visit schedule for a specific PSW within a date range. Shows all their assigned clients, times, and locations.

Calculate utilization rates for PSWs — how many hours they are scheduled versus how many hours they are available. Identifies under- or over-utilized workers.

Given a PSW, rank all active clients by distance from the PSW's home address. Useful for identifying which clients are geographically closest and reducing travel time.

Given a client, rank all active PSWs by how close their home is to the client's service address. Useful for finding the most travel-efficient PSW assignment.

Analyze a PSW's day schedule: visit order, gaps between visits, travel distances between consecutive stops, and total care hours. Identifies inefficient routing.