healthcare

sqllocks_spindle.domains.healthcare

Healthcare domain — clinical encounters, claims, and medications.

Classes

HealthcareDomain

Bases: Domain

Healthcare domain — clinical encounters, claims, and medications.

Available schema modes

• 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - provider: Doctors, nurses, and other healthcare professionals - facility: Hospitals, clinics, and care sites - patient: Patient demographics and insurance - encounter: Patient visits/admissions - diagnosis: ICD-10 diagnoses linked to encounters - procedure: CPT procedures linked to encounters - medication: Prescriptions linked to encounters - claim: Insurance claims linked to encounters - claim_line: Line items on claims linked to procedures

Methods:

star_schema_map()

Return the star schema mapping for the Healthcare domain.

Produces

• dim_patient (from patient)
• dim_provider (from provider)
• dim_facility (from facility)
• dim_date (generated from encounter dates)
• fact_encounter (from encounter)
• fact_claim (from claim + claim_line)

cdm_map()

Return the CDM entity map for the Healthcare domain.