All Diagnosis are posted with concept ID “Telemedicine diagnosis” into the database - this makes it hard to run a query to generate the hist of the number of each diagnosis - each coded diagnosis should be posted with a unique concept ID.
USER NEED: Implementation engineers need to create reports to get counts of patients by diagnosis.
Change needed in the Diagnosis fragment and the way the data is posted in the database
Solution 1: Post all coded diagnoses with concept ID “Telemedicine diagnosis-coded” and all non-coded diagnoses with “Telemedicine diagnosis-non coded”
Eg: R05 Cough, R50.09 Fever of unknown origin
Run hist function on the coded
Solution 2: Post all coded diagnoses with their individual concept IDs and all non-coded diagnoses with a single concept ID of non-coded diagnosis - BETTER
Query by using a join between concept dictionary (concept table) and obs table, where you are querying the obs table with all the concept ids of concept class diagnosis.
How is the Core apps diagnosis module querying the concept dictionary to get a list of diagnosis? Its querying the concept dictionary to get the concepts of class “Diagnosis”
nehav39
commented
6 years ago
All Diagnosis are posted with concept ID “Telemedicine diagnosis” into the database - this makes it hard to run a query to generate the hist of the number of each diagnosis - each coded diagnosis should be posted with a unique concept ID.
USER NEED: Implementation engineers need to create reports to get counts of patients by diagnosis.
Change needed in the Diagnosis fragment and the way the data is posted in the database
Solution 1: Post all coded diagnoses with concept ID “Telemedicine diagnosis-coded” and all non-coded diagnoses with “Telemedicine diagnosis-non coded”
Eg: R05 Cough, R50.09 Fever of unknown origin
Run hist function on the coded
Solution 2: Post all coded diagnoses with their individual concept IDs and all non-coded diagnoses with a single concept ID of non-coded diagnosis - BETTER
Query by using a join between concept dictionary (concept table) and obs table, where you are querying the obs table with all the concept ids of concept class diagnosis.