Automated alert to receive IRB approval documents

[wibeasley]

From https://github.com/OuhscCcanMiechvEvaluation/MReporting/issues/293

@thomasnwilson will setup an automated REDCap something to email alerts to a Project Owner to upload their annual IRB approval document.

[thomasnwilson]

@wibeasley

Thinking aloud here (metaphoricaly speaking): My thoughts about this process.

REDCap field for expiration date of IRB approval.
Knitr report that pulls Project Owner's name, contact info, etc. for all projects that have passed their IRB expiration.
Work out some R code (or some other programming language) that writes a packaged e-mail to the Project Owner and copies the appropriate BBMC member (myself?)
Have a cron job run this daily?

I'd like your input on this process (will this achieve what we want), as well as its feasibility.

[DavidBard]

FWIW, I like it. You'll probably want another field that filters out "dead" projects so that you don't continue to ask for the approval letters from inactive studies.

[thomasnwilson]

@bard1536 Good catch.

Fields to include in Knitr report:

Project Name
Project Owner Name
Project Owner Contact info (Phone, e-mail)
IRB expiration Date
Project expiration date (the day the project died...and they were singin' bye bye, Miss American pie)

[wibeasley]

Is only one record being displayed? If so, I think knitr is more than you need. The fields could be inserted into a character variable, and then placed in the body of the email.

Another thing to consider is whether this is done in R or in a PHP plugin. I think we're more comfortable with R, but sending an email might be easier with PHP. I'm not sure.

I like your plan overall.