Last updated: April 2026
One of New York City's oldest residential care communities needed a medical scheduling and records system serving 400+ residents, 800+ employees, and 1,000+ vendors and contractors around the clock with zero downtime. The platform had to cover individual medical records, onsite and offsite appointment scheduling, medication tracking, nurse station monitoring, HIPAA-compliant security, transport scheduling, and scanned document management. PCG built it in .NET Visual Basic with SQL Server, producing significant improvements in care coordination and eliminating lost records across more than a dozen floors of residents.
Project requirements

Individual medical records management. Scheduling for onsite and offsite appointments. Medication tracking. Nurse station monitoring. Mental health visits. HIPAA security access. Scanned records. Hard forms repository. Ambulance and transport scheduling. Nurse, doctor, and social worker scheduling. Special dietary requirements.

Languages and database

.NET Visual Basic, SQL Server, Internet Information Services (IIS).

Company size

800+ employees, 400+ residents, 1,000+ vendors and contractors.

Industry

Healthcare / residential care.

❓ What problem did this project solve?

A residential care facility spanning more than a dozen floors in New York City was coordinating medical, dental, mental health, and eye care services for hundreds of elderly residents across hundreds of staff, outside doctors, vendors, and contractors. The scheduling complexity alone was substantial: onsite appointments, offsite medical visits, ambulance and transport logistics, and the dietary and medication requirements of each individual resident all had to be tracked and coordinated continuously.

The existing system could not handle that coordination at scale. Records were managed in disconnected systems, forms were cumbersome, and the chain of custody on medical records had gaps that created both operational and compliance risk. For a facility operating 24 hours a day, 7 days a week with no tolerance for downtime, the consequences of a missed appointment, a medication error, or a lost record were serious. The system needed to serve every category of user, from internal nursing staff to outside contractors, with HIPAA-compliant security throughout.

🛠️ What PCG built

PCG built the medical scheduling platform in .NET Visual Basic with SQL Server, designed from the ground up for the operational scale and regulatory requirements of this facility. The system provided multiple interfaces tailored to each user type: nursing staff, physicians, social workers, outside vendors, and administrators each accessed the system through a view built for their specific workflows.

Individual medical records covered the full picture for each resident: medical history, current conditions and regimens, scheduled visits, medication tracking, dietary requirements, and scanned document storage with a complete chain of custody. Scheduling covered every category of appointment and service, from internal nurse and doctor rounds to offsite specialist visits, ambulance transport coordination, and mental health sessions.

The safeguards built into the system eliminated the cumbersome paper forms that had been generating lost records and coordination gaps. HIPAA security access controls were implemented throughout, with permissions structured by role so that each category of user could access exactly what their work required and nothing beyond that. The facility reported significant improvements in care coordination and process clarity after deployment.

🔍 Technology used

.NET Visual Basic SQL Server Internet Information Services (IIS) HIPAA-compliant security Medical records management Multi-user role-based access Scanned document repository Transport and ambulance scheduling
Running a healthcare or residential care operation with scheduling, records, or compliance systems that are not keeping up? PCG has built healthcare and medical scheduling platforms since the 1990s. The $2,500 diagnostic engagement scopes the problem before any development begins.
Talk to PCG

PCG founded 1995. All project details drawn from PCG's internal documentation. Client identity withheld at client request.

Frequently Asked Questions

Yes. PCG built a full medical scheduling and records management platform for one of New York City's oldest aging residential care facilities, serving 400+ residents, 800+ employees, and over 1,000 vendors and outside contractors. The system operated 24 hours a day, 7 days a week with no downtime. It covered individual medical records, appointment scheduling, medication tracking, nurse station monitoring, transport scheduling, and HIPAA-compliant access controls. The first step is a free 30-minute consultation.
HIPAA requires that access to protected health information is role-controlled, that access is logged with an audit trail, that data is encrypted in transit and at rest, and that the system prevents unauthorized users from reaching patient records through any path. For the residential care system PCG built, this meant different access levels for internal nursing staff, outside physicians, social workers, vendors, and administrators, with each role seeing only the records their function required. PCG builds HIPAA access controls into the system architecture from the start, not as a retrofit.
Yes. The system PCG built handled scheduling across medical appointments, mental health visits, dental and eye care, nurse and doctor assignments, social worker visits, ambulance and transport logistics, and special dietary requirements, all within a single platform. The scheduling challenge in a large residential care environment is that these appointment types compete for the same staff, the same rooms, and the same transport resources. PCG built the system to surface and resolve those conflicts before they become gaps in care.
The residential care platform PCG built included a scanned records repository and a hard forms management module alongside the digital record system. Physical documents were scanned and attached to the relevant patient record, maintaining chain of custody across both paper and digital formats. For facilities still operating with a mix of paper-based and digital records, PCG designs the system to accommodate both without creating two separate sources of truth for the same patient.
The residential care scheduling system was built on .NET Visual Basic, SQL Server, and Internet Information Services. PCG currently builds all new healthcare applications on .NET Core 8 with SQL Server, hosted on PCG-managed infrastructure. For operations requiring continuous uptime, PCG designs the system architecture around availability from the start, with database redundancy and monitoring built in rather than added after the fact. Most issues on PCG-built systems are resolved within hours of being reported.