Reconnect check missing L Tables content query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m for Tina
updated, request addressed
Line 1: Line 1:
The [[CFE]] [[Quality Assurance queries in CFE | quality assurance query]] NDC_Missing_Ls will list any patient who
The [[CFE]] [[Quality Assurance queries in 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
* is '''not''' incomplete and doesn't have at least one entry in one of
***For Record Status L dx only include Sent and Vetted not Incomplete.{{Discussion}} (Ptorres)
** L_Dxs
**** 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:
** L_Como
** L_Como
** L_Labs_Flowhseet
** L_Labs_Flowhseet
** L_Pharm_Flowsheet
** L_Pharm_Flowsheet

Revision as of 15:49, 2016 January 28

The CFE quality assurance query NDC_Missing_Ls will list any patient who

  • is not incomplete and doesn't have at least one entry in one of
    • L_Dxs
    • L_Como
    • L_Labs_Flowhseet
    • L_Pharm_Flowsheet
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Reconnect_check_missing_L_Tables_content_query&oldid=46747"