Reconnect check missing L Tables content query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
are you sure about the incompletes?
PTorres (talk | contribs)
m
Line 4: Line 4:
***For Record Status L dx only include Sent and Vetted not Incomplete.{{Discussion}} (Ptorres)
***For Record Status L dx only include Sent and Vetted not Incomplete.{{Discussion}} (Ptorres)
**** The whole discussion started because Julie uses the Dx data even for incompletes. Are you sure I should remove them? Ttenbergen 15:59, 2016 January 25 (CST)
**** The whole discussion started because Julie uses the Dx data even for incompletes. Are you sure I should remove them? Ttenbergen 15:59, 2016 January 25 (CST)
 
*****Yes we are sure.  [[User:PTorres|PTorres]] 12:04, 2016 January 26 (CST)
* is '''not''' incomplete and doesn't have at least one entry in one of
* is '''not''' incomplete and doesn't have at least one entry in one of
** L_Como
** L_Como
** L_Labs_Flowhseet
** L_Labs_Flowhseet
** L_Pharm_Flowsheet
** L_Pharm_Flowsheet

Revision as of 12:04, 2016 January 26

The CFE quality assurance query NDC_Missing_Ls will list any patient who

  • is <any Recordstatus> and doesn't have at least one entry in
    • L_Dxs
      • For Record Status L dx only include Sent and Vetted not Incomplete.Template:Discussion (Ptorres)
        • The whole discussion started because Julie uses the Dx data even for incompletes. Are you sure I should remove them? Ttenbergen 15:59, 2016 January 25 (CST)
          • Yes we are sure. PTorres 12:04, 2016 January 26 (CST)
  • is not incomplete and doesn't have at least one entry in one of
    • L_Como
    • L_Labs_Flowhseet
    • L_Pharm_Flowsheet