Edit Data Integrity Check: Check Sub PharmCheck

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	Sub ''PharmCheck''
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown Yes No
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

* 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. {{Collapsable | always= Legacy data | full= 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 [[User:Ttenbergen|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}} == Log == * 2022-03-31 - updated no longer check for starting time since that is now checked from minimal data set query == Related articles == {{Related Articles}} [[Category:Length of stay]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel