Reconnect check missing L Tables content query: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m TOstryzniuk moved page Query NDC missing Ls to Query NDC missing L Tables content without leaving a redirect |
TOstryzniuk (talk | contribs) m NDC Missing L Tables content - Red flag for processor - to be run daily |
||
| Line 1: | Line 1: | ||
The [[CFE]] [[Quality Assurance queries in CFE | quality assurance query]] | The [[CFE]] [[Quality Assurance queries in 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 | * is '''not''' incomplete and doesn't have at least one entry in one of | ||
** L_Dxs | ** L_Dxs | ||
| Line 6: | Line 5: | ||
** L_Labs_Flowhseet | ** L_Labs_Flowhseet | ||
** L_Pharm_Flowsheet | ** L_Pharm_Flowsheet | ||
This query must be run daily by collector. This is one RED flag to data processor, that there was a problem with the sending. | |||
==Investigation Process== | |||
[[Data Processor]] must: | |||
* review SEND date and time for the batch from site location in CFE. 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. | |||
[[Category:Centralized_data_front_end.accdb]] | [[Category:Centralized_data_front_end.accdb]] | ||
Revision as of 15:05, 2018 January 2
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 collector. This is one RED flag to data processor, that there was a problem with the sending.
Investigation Process
Data Processor must:
- review SEND date and time for the batch from site location in CFE. 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.