Sent Report

The sent report is an MS Access report generated by the CCMDB.mdb at the end of sending patients. The report does not need to be printed and filed locally or sent to the main office.

Use and processing

Data collectors keep this and use it to find records for patients when Pagasa wants them to look something up. I don't understand how that process works or why this report is helpful. Could someone please add this here? If I know how this is used I might be able to make it more helpful, e.g. by adding more fields. Ttenbergen 10:49, 24 September 2009 (CDT)

Potential Change Checklist

data storage

• store the following in CCMDB_data.mdb:
  • batch number
  • file name generated as
  • send date
  • (generated patient count per batch, this would not be stored)
  • also, for each patient store patient name, id and batch

interface changes

• add new button to front page to open "sent batches"
• add new sortable form that lists all patients with their info as per above
  • Template:Discussion can we minimize this? only list initials? possibly only the id? What is actually needed to find patients Pagasa sent? Since I still don't understand how this helps I don't know what is needed. I still think that, for the most part, Pagasa should be able to provide enough info with any request that none of this would need to be stored locally. Ttenbergen 16:01, 2012 November 19 (EST)

• Can you think of other data that would be helpful on this form?

• pre-fill the batch number in sending with the likely next one, but leave it editable; make it fail gracefully by not pre-populating a number if most recent "number" wasn't a number, e.g. in case of re-sends.

• since this is stored in ccmdb_data it will be available in backups for main office as needed

other fields?

• Debbie at StB also puts on her report "ward, medicine, SBGH, my initials, and the date I sent." Not sure how this would be used, but it would be easy enough to include. Personally I don't think it adds anything and would only fill space. How would including this help anyone? Ttenbergen 16:01, 2012 November 19 (EST) Template:Discussion

clean-up

Notes field used to auto-generate content for this, make sure all that is cleaned up when reprogramming. Ttenbergen 16:08, 2012 November 19 (EST)

Legacy info only below here!

Legacy Info

Report used to list the same patients in three columns since we went to the new program. At the time there were some concerns about patients being shown in the program as sent, but not actually being sent. I removed the duplicate data today and made the text bigger instead.