A system for management of patient data and simplifying the workflow of attending physicians, residents, nurses, etc. The system is implemented in three software modules: 1) a workflow management module for information entry, manipulation and output (workflow forms management); 2) a query module for data research; and 3) a billing module for medical billing coding. The three modules are constructed atop a foundation comprising a specific relational database design using a segregated static database (containing past day or approved information) and a dynamic database (containing current day unapproved information). The status of dynamic data is changed to static approval by an attending, or lapse of time. The information in the dynamic database is combined with the static to populate a workflow static / dynamic formset including Discharge Summaries, Admission / Daily Notes (with date ranges), Labs, Radiology, Other Information, Prescriptions (Medications filled versus prescribed), and Discharge Orders / Paperwork. This system method more nearly conforms to and automatically fulfills the workflow requirements of attending providers.