search

smart-on-fhir / cumulus-etl

Extract FHIR data, Transform with NLP and DEID tools, and then Load FHIR data into a SQL Database for analysis
https://docs.smarthealthit.org/cumulus/etl
Apache License 2.0
9 stars 2 forks source link

cannot calculate LOS "Length of stay" after ETL run #242

Open comorbidity opened 12 months ago

comorbidity commented 12 months ago

LOS is the number of hours between period.start and period.end of a FHIR Period (usually encounter, but also other date differences). https://build.fhir.org/datatypes.html#Period

preserving HOUR level precision is therefore needed for ETL outputs. Alternatively, LOS could be calculated within ETL but this seems difficult (as difficult) as having ETL execute case definitions.

Effort easy: use datetime instead from ETL Effort hard: have ETL calculate LOS (much harder)

comorbidity commented 12 months ago

Only applies to i2b2 ETL, postponing.