Reference Data
The master data the other tables point to: payers, payer plans, providers, service facilities and non-insurance payers.
Tables
Notes
- An encounter’s payer: join
export_encounter.subscriber_primary_payer_plan_group_id(or the secondary or tertiary column) toexport_payer_plan_group.payer_plan_group_id, thenpayer_uuidtoexport_payer. - Providers: join on
npiandorganization_id, and filteris_billingoris_rendering. - Service facilities: join
export_encounter.service_facility_idtoexport_service_facility.organization_service_facility_id. - Non-insurance payers: join
non_insurance_payer_idonexport_encounterorexport_patient_non_insurance_payer_historytoexport_non_insurance_payer.id. export_providerhas no deleted-row marker. Reload this small table in full rather than incrementally.