Tag: Healthcare
All the articles with the tag "Healthcare".
-
Building a member-month churn panel in dbt without leaking the future
Turn eligibility, medical and pharmacy claims into a leak-free member-month training table for disenrollment prediction, with dbt tests and Snowflake ML.
-
De-identifying FHIR data: HIPAA Safe Harbor, limited data sets and leaks
Dropping name and SSN is not de-identification. Apply HIPAA Safe Harbor to FHIR NDJSON with an allowlist, surrogate keys and a leak check, in Python.
-
Synthea vs SynPUF: picking synthetic healthcare data for pipeline tests
Synthea simulates coherent patients and exports FHIR; SynPUF is perturbed Medicare claims. When to use each, and how to turn Synthea into a messy roster.
-
HL7 v2 ADT feeds: from pipe-delimited events to an encounters table
Parse HL7 v2 ADT messages in plain Python, ACK them over MLLP, and fold admits, discharges and cancellations into one row per hospital visit.
-
Modeling a patient roster as a FHIR Group (Da Vinci ATR)
Map a roster CSV to FHIR Group, Patient and Coverage using the Da Vinci ATR profile — with a Python converter and namespaced identifiers.
-
Why flat-file rosters break: CSV over SFTP in healthcare data pipelines
CSV rosters over SFTP still run value-based care. Here are the failure modes: full replace, fuzzy identity, no acknowledgements, no deltas.
-
Connecting Clinical and Operational Data to Tuva with dbt
How to map EHR and operational sources into the Tuva Input Layer with dbt, and where to join what Tuva does not model.
-
Tuva column extensions: carry a custom column from eligibility to core
How to carry a custom column like contract_type from Tuva's eligibility input layer to core__eligibility using x_ extension columns, without forking.