Reconnect check missing L Tables content query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 9: | Line 9: | ||
| DIC_timing = complete | | DIC_timing = complete | ||
| DIC_app = Centralized data front end.accdb | | DIC_app = Centralized data front end.accdb | ||
| DIC_coding = query '' | | DIC_coding = query ''NDC_missing_L_Tables_content'' | ||
| DIC_status = needs review | | DIC_status = needs review | ||
| DIC_implementation_date = 2016-01-21 | | DIC_implementation_date = 2016-01-21 |
Revision as of 00:27, 2018 October 30
Data Integrity Checks | |
Summary: | Complete patients must have entries in all of |
Related: | Quality Assurance queries in CFE, L_Dxs table, L_Como table, L_Labs_Flowsheet table, L_Pharm_Flowsheet table, Sending Patients |
Firmness: | hard check |
Timing: | complete |
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 |
Template:Discussion Wondering why this isn't a PL check; emailed Pagasa. Ttenbergen 20:52, 2018 October 29 (CDT)
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
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
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.