Comments (8)
And how do we know if two records are the same guy?
from themis.
Same NPI or SOURCE_PROVIDER_ID?
from themis.
Ugly. We have the same NPI, but a different provider_id? Half of the folks will get confused.
from themis.
It would be nice to see an example. How is the provider defined in the medical encounters? Do you have both provider id and specialty or just a provider id? If the latter, then ETL will again have the problem of having to choose one or the other provider.
If it is necessary to maintain multiple provider specialties add a table provider_specialty (provider_id, specialty_concept_id, rank). You will still have the problem of choosing the primary specialty (which should also go into the provider table) but will as least be able to maintain the source information that provider has more that one specialty.
from themis.
Friends:
Here is what I will do. I will pull the list of these multiple-specialty docs and check it against the specialty hierarchy we are building. Because in the real world there are almost no true double-specialty docs. Trust me. It takes a lot of time, and a lot of training, and a lot of examinations, a lot of lost income to get there. What's happening a lot is like a "cardiologist" will also call himself "internist" in another circumstance. But of course cardiology is a subspecialty of internal medicine.
I will report back how bad the situation really is.
from themis.
a provider with a NPI number can be a care_site, a hospital, with multiple specialty associated with it. (i.e. outpatient specialty clinic, hospital and a hospice.)
a provider as a physician who took care of a patient can be medpeds in US, who is both internal medicine and pediatric specialty doctor.
Not being able to add specialty value associated with the same NPI is causing a problem both in provider and the care_site table.
from themis.
- NPI: That is correct. In the CDM, we only collect Entity Type 1 providers: Individuals, including sole proprietors. And, to be honest, I think even that is TMI.
- Specialty of organizations: We do not model those. We had debates about that. It wouldn't work.
- Medical pediatrics: No problem adding that as a concept, as descendant of both Pediatric Medicine and Internal Medicine. Strangely, there is no such thing, even though we have tons of mixed pediatric specialties (look under "Subsumes").
from themis.
Closing this issue. Vocabulary and CDM conventions were updated.
from themis.
Related Issues (20)
- How should we handle quantities of ‘0’ in Devices and Procedures HOT 2
- Is diagnostic system equipments (CT, MRI, etc.) exposure data also included in device_exposure? HOT 1
- Duplicated PROVIDER.NPI HOT 1
- Duplicate Providers? HOT 2
- Mapping from source conditions to standard concepts HOT 1
- How to determine the date to use to populate measurement_date when there are multiple dates in the source
- how to map admitted from to concept table for visit_occurrence HOT 1
- Is it OK to use admin date or claim date for condition_start_date in claims data
- How to link readmission to the primary to primary admission using the field preceding_visit_occurrence_id in the Visit_occurrence table?
- Adding a source value column for IDs to the visit_occurence table HOT 1
- Drug_exposure_end_date for vaccine records HOT 2
- Impute drug_exposure_end_date using ATC Defined Daily Dose (DDD)
- How to store Microbiology Susceptibility data into OMOP CDM
- Can we populate CONDITION_OCCURRENCE.condition_end_date with another date or '2999-12-31' if don't have this information HOT 1
- What should be done with patient reported drugs or conditions HOT 4
- Should we also add a record to CONDITION_OCCURRENCE table for each cause of death HOT 2
- Should we deduplicate same diagnosis records on the same claim or visit HOT 2
- Multiple Specialties per Provider HOT 1
- cost table: guidance to represent capitation monthly cost (for primary care)
- Link cost row A to procedure row B HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from themis.