Difference between revisions of "Demographic Improvements"
From OpenEMR Project Wiki
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Summary== | ==Summary== | ||
===Create a new contact info system.=== | =====Create a new contact info system.===== | ||
:Focus of project is on centralizing and improving contact info in OpenEMR. | :Focus of project is on centralizing and improving contact info in OpenEMR. | ||
:Create and normalize tables with contact information. | :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. . . | |||
: | : | ||
"Person" | =====Create tables:===== | ||
This will point to contact info for all people, not just patients. | :"Person" | ||
::This will point to contact info for all people, not just patients. | |||
: | : | ||
"Business" | :"Business" | ||
Business contact info. | ::Business contact info. | ||
: | : | ||
"Contact" | :"Contact" | ||
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 | |||
: | : | ||
: | : | ||
Not only able to store multiple phone numbers, addresses, etc, but also store old numbers, addresses. | =====Keeping Old Data:===== | ||
Old data does not need to be deleted. | :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:===== | |||
[[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.
