Difference between revisions of "Demographic Improvements"

From OpenEMR Project Wiki
Line 49: Line 49:


=====Proposed Schema:=====
=====Proposed Schema:=====
[[file:Demographic_Improvements_-_Table_Schema_2021-10-24.png|200px|thumb|left|alt text]]
[[file:Demographic_Improvements_-_Table_Schema_2021-10-24.png|200px|thumb|left]]

Revision as of 10:35, 30 November 2021

Summary

Create a new contact info system.
Focus of project is on centralizing and improving contact info in OpenEMR.
Create and normalize tables with contact information.
Functional Result:
Multiple addresses per patient.
Multiple phone numbers per patient.
Multiple email addresses per patient.
But, I want to expand to much more. . .
Create tables:
"Person"
This will point to contact info for all people, not just patients.
"Business"
Business contact info.
"Contact"
Contact table to be used for every address in OpenEMR.
"Address"
"Telephone_Number"
"Email_Address"
Demographic Screen Tabs:
Who
Address (new)
Phone/Internet (new)
Secondary Contacts (new)
Insurance
Pharmacy (new)
Medical Providers (new)
Send Results To (new)
Employer
Choices
Stats
Misc
Keeping Old Data:
Not only able to store multiple phone numbers, addresses, etc, but also store old numbers, addresses.
Old data does not need to be deleted.
Proposed Schema:
Demographic Improvements - Table Schema 2021-10-24.png