Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Investigate Telemedicine (telephone) visits #9

Open
comorbidity opened this issue Jun 30, 2023 · 0 comments
Open

Investigate Telemedicine (telephone) visits #9

comorbidity opened this issue Jun 30, 2023 · 0 comments

Comments

@comorbidity
Copy link
Contributor

how is a telephone encounter linked to a valid blood pressure reading?

comorbidity added a commit that referenced this issue Jun 30, 2023
dogversioning pushed a commit that referenced this issue Jul 7, 2023
telemedicine visit valueset
initial import
#9

added more outpatient valusets from
CMS165v11 AdultOutpatientEncounters

valueset.py split *encounter* inclusion and exclusion into sets

valueset.py split *rx medications* inclusion and exclusion

steward: CMS165v11 AdvancedIllnessandFrailtyExclusionECQM

inpatient now includes both acute and NON acute inpatient encounters.

define_enc_observation are now exclusion criteria

define_enc_edvisit are now exclusion criteria

define_enc_icu are now exclusion criteria

milestone: Encounter inclusion/exclusion criteria
valusets from CMS165v11 and other sources, most commonly referencing NQF#0018

define_pregnancy: do not exclude pregnant patients

define_esrd.sql end stage renal disease (exclude)
define_frailty.sql frailty by device/dx/encounter (exclude)
define_advanced_illness.sql very sick patients (exclude)

organization: updating paths to prepare for valueset subdir

moved VSAC files to "valueset" dir

count low/high blood pressure from core__observation_vital_sign

https://github.com/smart-on-fhir/cumulus-library/blob/f630f01ee2ad74ce90348213a80840a123f9c203/cumulus_library/studies/core/observation_vital_signs.sql#L18

using US CORE Profile tested against Cerner data.

-- http://hl7.org/fhir/us/vitals/StructureDefinition/blood-pressure-panel
--
--85354-9	Blood pressure panel with all children optional
-- 8480-6	Systolic blood pressure
-- 8462-4	Diastolic blood pressure

performance improvements for buildings tables/counts.
Athena is struggling to index this much data, so we build tables in steps.

fixed table_bp.sql to join "observation_ref", much better SQL speed.
count.py updated to ouput counts for htn__count_bp

count.py now count by number of
PATIENT (instead of encounters)

table_bp.sql added race and ethnicity

htn__dx defined (refactored from counts sql file)

added support or htn__count_rx (optional)

updated README.md

* _htn__count_bp_month_ : BP (blood pressure) measures
* _htn__count_dx_month_ : HTN diagnosis codes
* _htn__count_rx_month_ : HTN blood pressure control meds

scaled back what we count.py

updated counts views.
procedure and medication are optional and by default commented out.

removed "order by cnt desc", will address in more detail later.
smart-on-fhir/cumulus-library#71
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant