Reconnect check missing L Tables content query

From CCMDB Wiki
Revision as of 15:19, 2016 January 22 by PTorres (talk | contribs) (For Tina)
Jump to navigation Jump to search

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

Template:Discussion

  • For Record Status L dx only include Sent and Vetted not Incomplete.
  • is not incomplete and doesn't have at least one entry in one of
    • L_Como
    • L_Labs_Flowhseet
    • L_Pharm_Flowsheet