SVFCL - YAKAP: Medical Records System

C# & PostgreSQL Implementation

SVFCL - YAKAP is a comprehensive medical records management system built with C# and PostgreSQL, designed to streamline healthcare data management while prioritizing patient privacy and data security.

Key Features

🔐 Enterprise-Grade Security

• Multi-layer authentication, role-based access control, PIN verification

• Encrypted password storage with "Remember Me" functionality

📋 Patient Records Management

• Complete patient registration with medical history logging

• Budget monitoring with available balance display in pesos

🏥 Medical Workflow Integration

• PhilHealth and PCU transaction number tracking

• Follow-up scheduling and attending physician assignment

💊 Prescription & Laboratory Management

• Dynamic medicine and lab test modules with itemized costing

• Real-time cost calculation in Philippine Pesos

📊 Advanced Search & Reporting

• Filterable data grid (ID, Name, PCU, PhilHealth, Checkup Date)

• Printable medical records and diagnosis history logs

👥 User Management

• Multi-role support (Admin, Doctor, Staff)

• Secure account creation with PIN verification

Technical Stack

Backend: C# / ASP.NET Core, Entity Framework Core, RESTful API
Database: PostgreSQL 14+, ACID compliance, full-text search
Security: BCrypt hashing, encryption at rest, SSL/TLS, SQL injection prevention

System Benefits

For Providers: Reduced paperwork, faster processing, improved accuracy
For Patients: Enhanced privacy, continuity of care, transparent billing
For Facilities: Regulatory compliance, reduced costs, scalable solution

Developed with C# and PostgreSQL. Committed to healthcare innovation and patient privacy.