Demographic Improvements

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:

alt text