Eliminating a diagnosis from collection: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
Line 1: Line 1:
When we eliminate a diagnosis from collection we need to accomodate any instances of it that are in our data.  
When we eliminate a diagnosis from collection we need to accomodate any instances of it that are in our data.  


==[[CCMDB.mdb]]==
==[[CCMDB.accdb]]==
=== [[:Category:Pre-ICD10 Diagnosis]] ===
=== [[:Category:Pre-ICD10 Diagnosis]] ===
A dx is active only if the field [[s_AllDiagnoses table]].collection_allowed is true. Setting it to false for the eliminated diagnosis will result in:  
A dx is active only if the field [[s_AllDiagnoses table]].collection_allowed is true. Setting it to false for the eliminated diagnosis will result in:  

Revision as of 11:45, 2019 September 22

When we eliminate a diagnosis from collection we need to accomodate any instances of it that are in our data.

CCMDB.accdb

Category:Pre-ICD10 Diagnosis

A dx is active only if the field s_AllDiagnoses table.collection_allowed is true. Setting it to false for the eliminated diagnosis will result in:

  • dx no longer available in dropdown
  • any previously entered instances turn "blank"
  • record can not be set to "complete", ie can't be sent
  • Function TmpChecker runs a test to ensure any record that is already set to complete is also caught

ICD10

Dxs in ICD10 are active only if the current date is after the " active_start" and before the " active_end" in s_ICD10 table is


Template:Discussion Will need to confirm that all the checks from the old system will apply to the new one.

Cross Checks

The process uses the query Check eliminated dx.