Check Sub PharmCheck: Difference between revisions

m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
m updated documentation, the check was already doing this right since it uses LOS
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have drug days than LOS, disallows complete check if [[Arrive DtTm]] or [[Dispo DtTm]] are missing because that would break max count check,  
| DIC_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,
| DIC_related_concepts = Pharmacy collection
| DIC_related_concepts = Pharmacy collection; LOS
| DIC_firmness = hard check
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_timing = complete
Line 9: Line 9:
| DIC_implementation_date = 2012-01-01
| DIC_implementation_date = 2012-01-01
}}
}}


* each patient has to have at least one line of no entries (implemented)
* each patient has to have at least one line of no entries (implemented)


* maximum count for any drug must be < LOS+2 if calculated using admit date/time & discharge date/(time or 23:59 if unavailable)
uses function LOS() to calculate the LOS
** implemented as LOS = CLng(Nz(Form_View.R_DisDate) + nz(Form_View.R_DisTime, 1)) - Nz(Form_View.R_AdmDate, 0))
 


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.  
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.  
Line 39: Line 35:
* if three are duplicate priorities, 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}}
* 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]]