PL missing L Tables content

From CCMDB Wiki
Jump to navigationJump to search
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 relevant for this app
Status: ready to implement
Implementation Date: 2016-01-21
Backlogged: true


  • Cargo


  • SMW


  • Categories: 
Todo.svg

Swiss Army Knife.svg

dev_CFE

  • Confirm this only deals with complete records
  • Needs to check not listing missing Dispo, Previous Location - email Pagasa when fixed.
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

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.accdb 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.

Data processor.svg
  • 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.accdb that didn't make it, or no data in first place.
  • SMW


  • Cargo


  • Categories

Log

2019-08-22

  • HSC_SICd-2547 - Found out missing all the L Table's (ICD10,CCI,APACHE,LAB TMP and PHARM). Noticed that the RecordStatus is Blank.

These are the D_ID's that the date stamped never get changed.

    • HSC_SICd-2547 Sent 2019/Aug/15 15:15 - Blanks -(ICD10,CCI,APACHE,LAB TMP and PHARM)
    • STB_E6a-939 Sent 2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )
    • STB_E6a-1042 Sent 2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )
    • STB_E6a-1046 Sent 2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )
    • STB_E6a-1061 Sent 2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )
    • STB_E6a-984 Sent 2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )
    • STB_E6a-1056 Sent 2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )
      • PTorres 15:38, 2019 August 22 (CDT)
Data processor.svg

Have there been more since?

  • SMW


  • Cargo


  • Categories

2019-03-27

  • added L_Problems functionality

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: