Reconnect check missing L Tables content query: Difference between revisions

mNo edit summary
m removed duplicate description, one in top table should do, they were already out of synch
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Complete patients must have entries in all of  
|DIC_summary=Complete patients must have entries in all of  
* [[L_Dxs table]]
* [[L_ICD10 table]]
* [[L_Como table]]
* [[L_CCI_Picklist table]]
* [[L_Labs_Flowsheet table]]
* [[L_Labs_Flowsheet table]]
* [[L_Pharm_Flowsheet table]]
* [[L_Pharm_Flowsheet table]]
Line 15: Line 15:
}}
}}


The [[CFE]] [[Quality Assurance queries in CFE | quality assurance query]] NDC_Missing_L Tables content will list any patient who
'''This query must be run daily by [[Data Processor]]. This is one RED flag to data processor, that there was a problem with the [[sending]]. '''
* is '''not''' incomplete and doesn't have at least one entry in one of
** [[L_ICD10 table]]
** [[L_CCI_Picklist table]]
** [[L_Labs_Flowsheet table]]
** [[L_Pharm_Flowsheet table]]
 
This query must be run daily by [[Data Processor]]. This is one RED flag to data processor, that there was a problem with the [[sending]].  


==Investigation Process==
==Investigation Process==