I am working on creating a site for the educational clinics of the Faculty of Dentistry using erpnext and I need a code that creates a report for students so that each student is obliged to treat five cases of each type of case that is dealt with in the educational clinics of the Faculty of Dentistry
And we want the code to be like this
It shows how much this student has done from this case and how much is left
Also, do I complete this case or do I need another appointment?
In which clinic does this work work and who is responsible for it and at what time and date
Sounds like you’re knee-deep in web development for your Dentistry faculty project, props to you! An ERP system like ERPNext is a smart choice, especially for managing multi-faceted tasks like these.
Are you asking for help regarding the setup, reports or both?
So investing in a ready made software for educational dental clinics like Axium might be easier, more scalable and smoother on the long run. However, I hated the mentioned software during my college years so I will broadly guide you in achieving a similar use case in ERPNext.
Roles Required
- BDS/DDS Student (Role for each academic year)
- Mentor/Instructor
- Specialist
- Nurse (Might require multiple nurse roles per dept. i.e, surgery, restorative, materials, etc)
- Patient Flow Coordinator
- Registrar
- Appointment Mgr/Receptionist
Doctypes Required
- Patient
- Treatment List (ADA codes)
- Diagnoses List (ADA)
- Vitals
- History (Medical/Dental/Social)
- Treatment Plan
- Referral Form
- Consent Form
- Radiographs (You need a custom app to integrate your digital sensor with a dicom viewer within ERPNext)
- Appointments
- Orthodontic Form
- Lab Form
- Periodontal Form
- Endodontics Form
- Sick Leave
- Prescriptions
- Incident Report
- Complaints
- Treatment Notes
… and a lot more…
Logic Required
-
Every Treatment Code (i.e, Pulpectomy 2 canals) is a multi-step procedure including diagnosis, access, instrumentation, obturation, final restoration.
Students rarely finish the whole procedure in one appointment so you would need to figure out a way to determine when a treatment is actually completed so you can award it to the student. -
Educational Clinics involve lots of approvals (back and forth) from higher authority (i.e, the mentor, the specialist or sometimes both during exams) so good luck on the workflow design of this.
-
Patient flow from A to Z (registration, triage, student A, student B, treatment completed, re-registration, referrals, etc…)
-
Radiographs, digital sensor readers and Dicom viewer, not sure if Frappe Healthcare has a builtin dicom reader (I don’t think) but you need one. Also get your reader supplier to integrate the hardware with ERPNext so that an XRAY is directly uploaded to the patient’s file. (Please dont go the manual way as this is a waste of time for students and staff and is not efficient in the long run)
And there is a lot more but im tired from writing.
TL;DR
If you would like assistance with this, I can help you setup ERPNext to be as ready as possible to an Educational Dental Environment however this is definitely a paid work and not a bunch of forum comments so DM me if interested.
However, as a former BDS student, I can tell you that ERPNext would be very frustrating specially to newly practicing students.
Good Luck