Query check tmp AHC: Difference between revisions

← Older edit

@@ Line 13: / Line 13: @@
 == Consistency Checks ==
-* must have an entry to send (either '''referral sent''' or '''referral received''')
+for each matching allied health discipline
-* dttms within admission
+* at all times
-** if date is present and time is blank then the date must be within admission or on admit or on discharge date.
+** must have an entry for each allied health discipline
+** if there is a date, it must be within the admission
+*** nz(date, now()) + nz(time, .9999) must be after admission
+*** nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now)
+** '''not yet done''' - if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team> entry for consult received
+* at complete time
+** if there is a time there has to be a date
+** if item in ("referral received", "Late consult received") then it must have the checkbox checked ("no dttm") or a date
+{{DL|
+** item must not be "not entered"
+* I implemented this one and 40 records in my test data have a "not entered" in complete data. Did I misunderstand the instructions?
+}}
 {{DL|