Required stack
필요 기술
Microsoft AccessVBASQLVisual BasicDatabase ProgrammingData AnalysisDatabase Management
Project brief
프로젝트 내용
1. Project Overview
The goal is to develop a robust, high-precision clinical database system (preferably using MS Access with VBA) to automate the ordering process for Oncology Chemotherapy protocols. The system will bridge the gap between diagnosis and drug administration by automating clinical calculations, tracking patient treatment history, and enforcing safety dosage limits.
2. Key Modules & Features
A. Admin Dashboard (Protocol Management)
Database Management: Ability to Add, Edit, or Delete Diagnoses and their associated Protocols.
Protocol Structure: Each protocol must be divided into three sections:
Pre-medications (Supportive care).
Chemotherapy Agents (Cytotoxic drugs).
Post-medications (Take-home or recovery drugs).
Safety Limit Settings:
Per Cycle Cap: Set a maximum dose for a single administration (e.g., Vincristine capped at 2mg).
Lifetime Cumulative Cap: Set a maximum total dose a patient can receive across all cycles (e.g., Doxorubicin max 400-550 mg/m^2).
B. Physician Ordering Interface
Patient Profile: Fields for Name, Medical Record Number (MRN), Gender, Age, Height, Weight, and Serum Creatinine.
Dynamic Filtering: Selecting a "Diagnosis" must automatically filter and show only the relevant "Protocols."
Interactive Medication List: * Once a protocol is selected, all associated drugs auto-populate.
Checkboxes: Every drug must have a checkbox. If unchecked, the drug is excluded from both the dose calculation and the final printout.
Dose Modification: Option to adjust dose by percentage (e.g., 75%, 80%, 100%) or manual override.
C. Clinical Logic & Safety Guardrails
Automated Calculations:
BSA: Mosteller Formula \sqrt{\frac{Ht(cm) \times Wt(kg)}{3600}}
CrCl: Cockcroft-Gault Equation.
Carboplatin Dose: Calvert Formula Dose = Target AUC \times (GFR + 25).
Patient History Tracking: Entering an MRN should display a history of all previous protocols and total doses received.
The 6-Day Rule: If the same protocol is ordered within 6 days for the same MRN, the system must flag it as the "Same Cycle" rather than a new one.
Cumulative Dose Alert: A hard warning or block must trigger if the new dose exceeds the pre-set Lifetime Cumulative Cap for that patient.
3. Reporting & Output
Standardized Printout: Generate a professional PDF Order Form matching the attached Ministry of Health (MOH) template.
Modified Protocol Label: If any standard dose is manually changed by the physician, a prominent "MODIFIED PROTOCOL" warning must appear on the printed form.
Signature Blocks: Include dedicated fields for the Consultant, Pharmacist, and Nurse signatures with auto-generated timestamps.
4. Technical Requirements
Expertise in MS Access & VBA (or similar relational database platforms).
Strong understanding of SQL and Data Integrity.
Experience in Healthcare/Clinical software development is highly preferred.
Ability to translate clinical formulas into precise code.
The goal is to develop a robust, high-precision clinical database system (preferably using MS Access with VBA) to automate the ordering process for Oncology Chemotherapy protocols. The system will bridge the gap between diagnosis and drug administration by automating clinical calculations, tracking patient treatment history, and enforcing safety dosage limits.
2. Key Modules & Features
A. Admin Dashboard (Protocol Management)
Database Management: Ability to Add, Edit, or Delete Diagnoses and their associated Protocols.
Protocol Structure: Each protocol must be divided into three sections:
Pre-medications (Supportive care).
Chemotherapy Agents (Cytotoxic drugs).
Post-medications (Take-home or recovery drugs).
Safety Limit Settings:
Per Cycle Cap: Set a maximum dose for a single administration (e.g., Vincristine capped at 2mg).
Lifetime Cumulative Cap: Set a maximum total dose a patient can receive across all cycles (e.g., Doxorubicin max 400-550 mg/m^2).
B. Physician Ordering Interface
Patient Profile: Fields for Name, Medical Record Number (MRN), Gender, Age, Height, Weight, and Serum Creatinine.
Dynamic Filtering: Selecting a "Diagnosis" must automatically filter and show only the relevant "Protocols."
Interactive Medication List: * Once a protocol is selected, all associated drugs auto-populate.
Checkboxes: Every drug must have a checkbox. If unchecked, the drug is excluded from both the dose calculation and the final printout.
Dose Modification: Option to adjust dose by percentage (e.g., 75%, 80%, 100%) or manual override.
C. Clinical Logic & Safety Guardrails
Automated Calculations:
BSA: Mosteller Formula \sqrt{\frac{Ht(cm) \times Wt(kg)}{3600}}
CrCl: Cockcroft-Gault Equation.
Carboplatin Dose: Calvert Formula Dose = Target AUC \times (GFR + 25).
Patient History Tracking: Entering an MRN should display a history of all previous protocols and total doses received.
The 6-Day Rule: If the same protocol is ordered within 6 days for the same MRN, the system must flag it as the "Same Cycle" rather than a new one.
Cumulative Dose Alert: A hard warning or block must trigger if the new dose exceeds the pre-set Lifetime Cumulative Cap for that patient.
3. Reporting & Output
Standardized Printout: Generate a professional PDF Order Form matching the attached Ministry of Health (MOH) template.
Modified Protocol Label: If any standard dose is manually changed by the physician, a prominent "MODIFIED PROTOCOL" warning must appear on the printed form.
Signature Blocks: Include dedicated fields for the Consultant, Pharmacist, and Nurse signatures with auto-generated timestamps.
4. Technical Requirements
Expertise in MS Access & VBA (or similar relational database platforms).
Strong understanding of SQL and Data Integrity.
Experience in Healthcare/Clinical software development is highly preferred.
Ability to translate clinical formulas into precise code.