Page History
...
| TABLES | PRIMARY KEYS |
|---|---|
| DEMOGRAPHICS | IMREDEM_CODE |
| SCHEDULE | IMRESCHED_CODE |
| ENCOUNTER | IMREENC_CODE |
| CONTACT | IMRECONTACT_CODE |
| IMMUNIZATION_RECORD | IMMREC_ID |
| LABORDERS | IMRELABORDER_CODE |
| MEDICATIONS | IMREMED_CODE |
| PROVIDER | IMREPROV_CODE |
| RESULT | RESULT_ID |
| VITALS_DATA | VITALS_CODE |
| DX | IMREDX_CODE |
| HX_DIAGNOSIS | HX_DIAGNOSIS_ID |
Common Patient Tables
• HPSITE.DEMOGRAPHICS – Name, DOB, SSN, Bloodtype, Language, Marital Status
• HPSITE.ADDRESSES – holdsaddressesfor5typesofentities
• Patient, Provider, Site, Insurance Carriers, Institutions
• HPSITE.INSURANCES – containsinsuranceinformationforthepatient
• HPSITE.DEMOGRAPHICPICTURE ― link to picture in the EHR that is associated with the patient
• HPSITE.PHARMACYFAVORITE ― Containsprimarypharmacyinformation
• HPSITE.DEMGUARANTOR ― contains patient guarantor information
