Check Sub PharmCheck: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| 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 = 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 | ||
| DIC_firmness = hard check | | DIC_firmness = hard check | ||
| 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) | ||
| Line 16: | Line 14: | ||
* maximum count for any drug must be < LOS+2 if calculated using admit date/time & discharge date/(time or 23:59 if unavailable) | * maximum count for any drug must be < LOS+2 if calculated using admit date/time & discharge date/(time or 23:59 if unavailable) | ||
** implemented as LOS = CLng(Nz(Form_View.R_DisDate) + nz(Form_View.R_DisTime, 1)) - Nz(Form_View.R_AdmDate, 0)) | ** 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 36: | ||
* 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}} | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Length of stay]] | |||