Difference between revisions of "Demographic Improvements"

From OpenEMR Project Wiki
 
(One intermediate revision by the same user not shown)
Line 49: Line 49:


=====Proposed Schema:=====
=====Proposed Schema:=====
[[file:Demographic_Improvements_-_Table_Schema_2021-10-24.png|200px|thumb|left|alt text]]
[[file:Projects_-_03_-_03_-_Demographic_Improvements_-_Table Schema_2021-12-10.png|400px|thumb|left]]

Latest revision as of 07:36, 12 December 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:
Projects - 03 - 03 - Demographic Improvements - Table Schema 2021-12-10.png