Check Sub PharmCheck: Difference between revisions

(6 intermediate revisions by the same user not shown)

Line 1:

{{Data Integrity Check

| DIC_summary = ~~checks that every~~ CC pt has at least one pharmacy record (possibly all zeros), ~~that patients don~~'t ~~have more 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_timing = complete

Line 12:

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

Line 36:

Line 35:

* 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 ==

[[Category:Length of stay]]

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-| DIC_summary = checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have more 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_timing = complete
@@ Line 12: / Line 12: @@
 * 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.
@@ Line 36: / Line 35: @@
 * 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]]