Reconnect check missing L Tables content query: Difference between revisions

mNo edit summary
mNo edit summary
Line 7: Line 7:


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.  
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.  
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = * complete patients must have entries in all of  
| DIC_summary =  
** [[table L_Dxs]]
* complete patients must have entries in all of  
** [[table L_Como]]
** [[L_Dxs table]]
** [[table L_Labs_Flowhseet]]
** [[L_Como table]]
** [[table L_Pharm_Flowsheet]]
** [[L_Labs_Flowhseet table]]
** [[L_Pharm_Flowsheet table]]
| DIC_related_concepts = [[Quality Assurance queries in CFE]]
| DIC_related_concepts = [[Quality Assurance queries in CFE]]
| DIC_firmness = hard check  
| DIC_firmness = hard check  
| DIC_app = CFE
| DIC_app = Centralized data front end.accdb
| DIC_coding = query ''NDC missing L Tables content''
| DIC_coding = query ''NDC missing L Tables content''
| DIC_status = needs review
| DIC_status = needs review
Line 28: Line 28:
**if data is deleted, the processor to obtain backup from Regional Server ASAP and resend.   
**if data is deleted, the processor to obtain backup from Regional Server ASAP and resend.   


== Log ==
== Log errors ==
There are checks in place in CCMDB that should prevent sending of these. {{Discuss|who=Tina|question= What are theese checks? Ttenbergen 11:43, 2018 September 25 (CDT)  
There are checks in place in CCMDB that should prevent sending of these. {{Discuss|who=Tina|question= What are theese checks? Ttenbergen 11:43, 2018 September 25 (CDT)  
So, if any get through, there is a problem with those earlier checks. Please log if any get trhough so I can review this! Ttenbergen 11:43, 2018 September 25 (CDT)
So, if any get through, there is a problem with those earlier checks. Please log if any get trhough so I can review this! Ttenbergen 11:43, 2018 September 25 (CDT) }}


== Related articles ==
== Related articles ==