Check Sub PharmCheck: Difference between revisions

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_related_concepts = Pharmacy collection

| DIC_related_concepts = Pharmacy collection, Arrive DtTm, Accept DtTm, 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 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_related_concepts = Pharmacy collection
+| DIC_related_concepts = Pharmacy collection, Arrive DtTm, Accept DtTm, 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.