I have been trying to upload data from my previous EMR. To date I have been successful in uploading patient demographics, insurance company info (address, contact info etc), and referring physician info into the address book.
One issue that Ive encountered is linking a patient to their insurance company. Im able to link insurance info such as Plan ID and Group number but Im unable to link to the actual Insurance Company eg. Blue Cross Blue Shield.
From my understanding Patients are linked to other tables by use of a
pid. Insurance plans are linked to patients by that same
pid. What is the mapping that links an
insurance_company to a patient’s insurance plan?