Reconnect check missing L Tables content query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Ttenbergen moved page NDC missing L Tables content to PL missing L Tables content without leaving a redirect) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 10: | Line 10: | ||
|DIC_coding=query ''NDC_missing_L_Tables_content'' | |DIC_coding=query ''NDC_missing_L_Tables_content'' | ||
|DIC_implementation_date=2016-01-21 | |DIC_implementation_date=2016-01-21 | ||
|DIC_status= | |DIC_status=implemented | ||
|DIC_LProblem=No | |DIC_LProblem=No | ||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
}} | }} | ||
The [[CFE]] [[Quality Assurance queries in CFE | quality assurance query]] NDC_Missing_L Tables content will list any patient who | 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_ICD10 table]] | ||
** [[ | ** [[L_CCI_Picklist table]] | ||
** [[L_Labs_Flowsheet table]] | ** [[L_Labs_Flowsheet table]] | ||
** [[L_Pharm_Flowsheet table]] | ** [[L_Pharm_Flowsheet table]] | ||
Line 28: | Line 26: | ||
==Investigation Process== | ==Investigation Process== | ||
[[Data Processor]] must: | [[Data Processor]] must: | ||
* In CFE, review | * In CFE, review other profiles with the same [[sentDtTm]] 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. | * have collector resend data. | ||
**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. | ||
Line 37: | Line 35: | ||
{{Discuss | who = Pagasa | question = | {{Discuss | who = Pagasa | question = | ||
* Pagasa, could you please log here when this query lists errors, and what was found to be the problem (ie whether there was data in [[CCMDB.mdb]] that didn't make it, or no data in first place. }} | * Pagasa, could you please log here when this query lists errors, and what was found to be the problem (ie whether there was data in [[CCMDB.mdb]] that didn't make it, or no data in first place. }} | ||
== Log == | |||
2019-01-06 | |||
* added sendDtTm to query - if it needs to be reviewed each time the query triggers it might as well be there | |||
* removed L_Dxs and L_Como table, and added L_ICD10 and L_CCI_Picklist table | |||
== Related articles == | == Related articles == |
Revision as of 22:22, 2019 January 6
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: | No |
Status: | implemented |
Implementation Date: | 2016-01-21 |
Backlogged: | true |
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 other profiles with the same sentDtTm 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.mdb that should prevent sending of these. So, if any get through then either those checks are not working, or the problem arises during Sending and not at the source.
|
Log
2019-01-06
- added sendDtTm to query - if it needs to be reviewed each time the query triggers it might as well be there
- removed L_Dxs and L_Como table, and added L_ICD10 and L_CCI_Picklist table