Encounters & Service Lines

General metadata is provided at both the service_line and encounter granularities for easy reporting and summarization.

Table Relationships

Table	Primary Key	Description
`export_encounter`	`encounter_id`	Core encounter data with patient, provider, and claim information
`export_financial_summary`	`encounter_id`	Encounter-level financial summary (patient responsibility, copay, deductible, coinsurance)
`export_service_line`	`service_line_id`	Individual billable services within an encounter
`export_service_line_financial_summary`	`service_line_id`	Financial totals (billed, allowed, patient responsibility) per service line
`export_service_line_projected_financials`	`service_line_id`	Expected allowed amounts and projections

Common Queries

Join Service Lines to Encounters

1 SELECT
2   e.encounter_id,
3   e.date_of_service,
4   sl.service_line_id,
5   sl.procedure_code
6 FROM export_encounter e
7 JOIN export_service_line sl
8   ON e.encounter_id = sl.encounter_id

Service Line Financial Summary

1 SELECT
2   sl.service_line_id,
3   sl.procedure_code,
4   slfs.billed_amount_cents,
5   slfs.allowed_amount_cents,
6   slfs.patient_responsibility_cents
7 FROM export_service_line sl
8 JOIN export_service_line_financial_summary slfs
9   ON sl.service_line_id = slfs.service_line_id