Managing a large-scale hospital ward is a logistical challenge where the cost of a data error is measured in human safety. When a patient is admitted, a ward manager cannot rely on a whiteboard to track their diagnostic trajectory or the specific consultants currently managing their care. If a neurologist is requested for a patient in the GS Annex but the referral date isn't hard-coded into the chart, the consultation window can slip, delaying critical interventions. This Memento system acts as a rigid, institutional-grade clinical vault, forcing medical staff to map the exact spatial, diagnostic, and personnel parameters for every active bed.
Locking the Ward Geography
A hospital chart is only as useful as its location data. The template refuses to allow a patient record to float in undefined space, forcing a strict ward hierarchy.
It begins with the "Patient's Name", "Age", and "Sex", but immediately demands the specific "Hospital Number" and the exact "Bed No.". Crucially, the system requires the classification of the "Primary Service" (Medicine, Surgery, ObGyn, Fammed). Once selected, the user must narrow the location down to a specific ward—from specialized units like the "CNR" or "MICU" to surgical zones like the "Neuro-Ortho Ward" or "CENSICU". By anchoring the patient to a specific bed and service from the moment of "Date Admitted", the database creates a real-time, auditable ward census.
The Consultant Matrix
In a teaching hospital or complex medical center, a single patient is often managed by multiple internal medicine sub-specialties. The database forces a granular audit of the care team.
The "IM Service" module utilizes a multi-select matrix to flag every specialty on board: Cardiology, Pulmonology, Nephrology, Infectious Diseases, and more. It goes further by providing dedicated choice fields for specific physicians in every department (e.g., Dr. Norden in Neurology, Dr. Llanos in Cardiology). This ensures that the resident on duty knows exactly which consultant to call for any given complication, eliminating the need to hunt through paper files for referral names.
The Clinical Workflow and Disposition
The true power of this database is its ability to track the daily clinical progression. It moves past static census data into active management.
The system requires a "Working Diagnosis" and tracks the status of the "Chart" and "Rounds Done?" via boolean gates. It integrates visual diagnostic evidence by providing upload fields for "Laboratory results" and physical "Management" photos. Finally, the patient lifecycle is closed at the "Disposition" field. The physician must declare a hard outcome: "Discharged", "Admitted", "Expired", or "Absconded" (signed out against medical advice). This ensures that the ward census is continuously purged of inactive records, maintaining a lean and accurate view of the facility's active clinical load.