Reconnect check missing L Tables content query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
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 ==

Revision as of 11:45, 25 September 2018

The CFE quality assurance query NDC_Missing_L Tables content 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

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 Checks
Summary: * complete patients must have entries in all of
Related: [[Quality Assurance queries in CFE]]
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query NDC missing L Tables content
Uses L Problem table: not entered
Status: needs review
Implementation Date: 2016-01-21
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Investigation Process

Data Processor must:

  • In CFE, review SEND date and time for the batch from site location. The concern is that if one profile has missing content in one of the above, other profiles that had changes made and where completed and sent, could be missing any changes collector made to any table above.
  • have collector resend data.
    • if data is deleted, the processor to obtain backup from Regional Server ASAP and resend.

Log errors

There are checks in place in CCMDB that should prevent sending of these.

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)

  • SMW


  • Cargo


  • Categories

Related articles

Related articles: