Check Sub PharmCheck

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: Every CC record has to have at least one pharmacy record (possibly all zeros), and the number of drug days can't be GT LOS,
Related: Pharmacy collection, LOS
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: Sub PharmCheck
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2012-01-01
Backlogged: true
  • Cargo

  • SMW

  • Categories: 
  • form:
  • each patient has to have at least one line of no entries (implemented)

uses function LOS() to calculate the LOS

PharmCheck used to be used to do internal consistency checks on Pharmacy data. No longer used since change in Pharmacy data structure 2012-01-01. See Pharmacy_collection#Data_Integrity_Rules for data consistency checking in new paradigm.

Legacy data   

Public Sub PharmCheck provides for the consistency checks for pharmacy collection.

  • If the settings file has "CC" as program and not HSC as the hospital (pharmacy is imported for HSC) and if the patient was admitted before 2012-Jan-1 then the following checks are run:
    • if there is no entry for a patient, an error is generated (must enter "No Drugs")
    • if there are more than 16 entries, an error is generated
    • if there is an entry but any of the following are true, an error is generated
      • drug name missing
      • # doses is 0
      • # doses > maxdoses as per S Drugs
        • maxdoses in s_drugs are all 9999 as of 2011-11-18, i.e. this was not meaningfully implemented. not doing now as we are moving to a different pharmacy scheme soon Ttenbergen 11:31, 18 November 2011 (CST)
      • # days is 0
      • # days > LOS
  • if there are duplicate drugs, an error is generated
  • if three are duplicate priorities, an error is generated
  • if one of the entries is "No Pharm" and there are other entries, an error is generated


  • 2022-03-31 - updated no longer check for starting time since that is now checked from minimal data set query

Related articles

Related articles: