Primary Admit Diagnosis: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 25: Line 25:
* [[Query L_ICD10_primary]]
* [[Query L_ICD10_primary]]


{{Discuss | who = Tina | question =  
{{Discuss | who = Julie | question =  
*The query Primary_admit of CFE contains multi records per D_ID.  These are the records with admit dates before or on Dec 31, 2018 and are still in the unit by Jan 1, 2019.  The L_Dxs of these cases have all the same priority number.  }}
*The query Primary_admit of CFE contains multi records per D_ID.  These are the records with admit dates before or on Dec 31, 2018 and are still in the unit by Jan 1, 2019.  The L_Dxs of these cases have all the same priority number.  
** I updated [[Query L_Dxs_w_primary]] and query Primary_Admit to exclude all records of patients with [[Dispo DtTm]] > 2019-01-01 }}


{{Discuss | who = Julie | question =  
{{Discuss | who = Julie | question =  

Revision as of 16:08, 1 February 2019

The Primary Admit Diagnosis is the most responsible reason why the patient was admitted should be given the highest priority among the Admit Diagnosiss entered into CCMDB.mdb.

ICD10

Admit Diagnosis with Dx Primary = true

Old dx schema

Admit Diagnosis with highest priority

Reporting

The concept of primary diagnosis is used in

  • They are used in the periodic quarter and fiscal year reports of both the Critical Care and Medicine Programs. (Julie)
    • are the two I linked to above those reports? Ttenbergen 14:03, 2015 April 20 (CDT)
  • SMW


  • Cargo


  • Categories

Cross checks

Related queries

  • The query Primary_admit of CFE contains multi records per D_ID. These are the records with admit dates before or on Dec 31, 2018 and are still in the unit by Jan 1, 2019. The L_Dxs of these cases have all the same priority number.
  • SMW


  • Cargo


  • Categories
  • How will the primary admit dx involving ICD10 be handled - another query? or be combined to Primary_admit of old dx? --JMojica 09:17, 2019 January 31 (CST)
    • I have built query Query L_ICD10_primary and documented it. Julie, once you have found this and read it, please delete.
  • SMW


  • Cargo


  • Categories

old

Query L Dxs w primary will list these.

z PIC

  • that can be deleted when ICD10 implementation is complete.
  • SMW


  • Cargo


  • Categories