"No Transfer Date" in Medicine

We want to have a cross check in medicine that all absent transfer dates are really unavailable rather than forgotten.

Instructions

For each medicine patient who requires a transfer date (see Transfer Ready date and time) for whom the collector could not even reasonably guess a transfer date and time, enter into Tmp:

• Project:: No Transfer Date
• no other fields in tmp need entering for this project

Purpose

Provide a way for collector to verify that they did not miss entering in this field.

We also want to give a basic report to Dr Roberts.

Why are we not collecting more detailed data in this

Because this is enough information for our purposes. :-)

Template:CCMDB Data Integrity Checks

Any medicine patient who requires a transfer date as per Transfer Ready date and time needs to have a transfer date or this tmp entry. If missing, won't be able to send. If there is a tmp entry but a transfer date, won't be able to send either.

query check_tmp_no_transfer_date

Start/End dates

• Started date Feb 29.14
• End Date: ' 2016-07-01