Difference between revisions of "Demographic Improvements"

From OpenEMR Project Wiki
 
(6 intermediate revisions by the same user not shown)
Line 7: Line 7:
:
:
=====Functional Result:=====
=====Functional Result:=====
Multiple addresses per patient.
:Multiple addresses per patient.
Multiple phone numbers per patient.
:Multiple phone numbers per patient.
Multiple email addresses per patient.
:Multiple email addresses per patient.
But, I want to expand to much more. . .
:But, I want to expand to much more. . .
:
:
:
:
=====Create tables:=====
=====Create tables:=====
:"Person"
:"Person"
Line 24: Line 23:
::Contact table to be used for every address in OpenEMR.
::Contact table to be used for every address in OpenEMR.
:
:
"Address"
:"Address"
"Telephone_Number"
:"Telephone_Number"
"Email_Address"  
:"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
 
:
:
=====Add New Tabs to Demographic Screen:=====
:
:
=====Keeping Old Data:=====
:Not only able to store multiple phone numbers, addresses, etc, but also store old numbers, addresses.
:Not only able to store multiple phone numbers, addresses, etc, but also store old numbers, addresses.
:Old data does not need to be deleted.
:Old data does not need to be deleted.
=====Proposed Schema:=====
[[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