Check Sub PharmCheck: Difference between revisions
Jump to navigation
Jump to search
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]] |
Revision as of 16:53, 2021 May 5
Data Integrity Checks | |
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, |
Related: | Pharmacy collection |
Firmness: | hard check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | Sub PharmCheck |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
Implementation Date: | 2012-01-01 |
Backlogged: | true |
- 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)
- 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.
Legacy data |
Public Sub PharmCheck provides for the consistency checks for pharmacy collection.
|
Related articles
Related articles: |