Procedure when there are differences between L Log and L PHI

From CCMDB Wiki
Jump to navigation Jump to search

"Pulling" Centralized data.mdb should result in consistent data sets being copied, but sometimes differences appear between L_PHI and L_Log. Usually this happens when something goes wrong during sending or during PHI copy automation or when a patient is deleted in one but not the other table.

You would usually find out about this when you click the "Re-connect Data" button in CFE and get an error that the number of records in L_Log and L_PHI is not the same.

More records in L_Log than in L_PHI

In that case, 1_In_L_Log_but_NOT_in_L_PHI will show you which record.

  • to ask them to send now:
Your send did not go through correctly today, please reset the "sent" records to "complete" and then re-send. I have pushed the data and it is ready for you to re-send now. Please let me know when done so I can pull again to make sure that the error is fixed. 

or

  • to ask them to send when ready:
Your send did not go through correctly today, please reset the "sent" records to "complete" and then re-send. I don't need you to re-send right now, just don't delete your sent records and send at your usual time.

If this does not fix it, then: *

  • check X:\CCMDB/PHI/PHI_CSV. You want to make sure there is no CSV file sitting in this folder that was not uploaded to PHI.mdb
  • this could mean a problem with PHI copy automation

More records in L_PHI than in L_Log

In that case, query 1_In_L_Phi_but_NOT_in_L_Log triggers.

Example:   
Today Pam sent with that problem and her error message say "Invalid SQL statement expected Delete,Insert,Procedure,Select or Update" message.  Also I need to change in the master CFE the Record Status Complete to Incomplete so collector can send no problem.

Test records

  • If file was a test, or error, you can delete it from L_Log and/or L_PHI, whichever still has part of the record. Usually you would have heard from Tina or whoever is doing the testing in that case.

Related articles

Related articles: