Transfer Ready date and time: Difference between revisions
Ttenbergen (talk | contribs) →ICU: moved ACP-C to its own heading |
Ttenbergen (talk | contribs) →Transfer Date validation: Questions for main office re. validation |
||
| Line 75: | Line 75: | ||
== {{CCMDB Data Integrity Checks}} == | == {{CCMDB Data Integrity Checks}} == | ||
=== Transfer Date validation === | === CCMDB.mdb Transfer Date validation === | ||
If all of | If all of | ||
* transfer ready date /time is blank | * transfer ready date /time is blank | ||
* survived, | * survived, | ||
* [[Med Var 6 - AMA]] [[ICU Var 6 - AMA]] | * not [[Med Var 6 - AMA]] and not [[ICU Var 6 - AMA]] | ||
* the discharge-to location ends in W, U, Z, X | * the discharge-to location ends in W, U, Z, X | ||
then | then | ||
| Line 85: | Line 85: | ||
* don't allow final-check if notes are blank | * don't allow final-check if notes are blank | ||
This is checked at registry-check or final check. | This is checked at registry-check or final check. | ||
{{discussion}} | |||
I don't think these run as written right now, and even if they do, they would be different than [[#NDC_Missing_TransferDate_w_pivot]] | |||
=== NDC_Missing_TransferDate_w_pivot === | |||
This query in [[Centralized data front end.mdb]] flags patients discharged to "zz" or Like "?w" (ie home or ward) who have a discharge date "Between #2013/Oct/01# And #2013/Dec/31#" (?!) and a transfer date of #3000/Jan/01# (I think this would only catch those imported from Ed, not the newly sent ones). | |||
{{discussion}} | |||
Should this be changed to be like [[#CCMDB.mdb Transfer Date validation]], once that is what we want it to be? Ttenbergen 14:43, 2014 June 23 (CDT) | |||
=== Transfer Time validation === | === Transfer Time validation === | ||