Reconnect check missing L Tables content query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "The CFE quality assurance query NDC_Missing_Ls will list any patient who * is <any Recordstatus> and doesn't have at least one entry..."
 
PTorres (talk | contribs)
minor'
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 <any Recordstatus> and doesn't have at least one entry in  
**L_Dxs
* is '''not''' incomplete anddoesn't have at least one entry in one of
* is '''not''' incomplete anddoesn'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 14:30, 2016 January 22

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
  • is not incomplete anddoesn't have at least one entry in one of
    • L_Como
    • L_Labs_Flowhseet
    • L_Pharm_Flowsheet