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 | |||
: | : | ||
: | : | ||
=====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.
