wiki:BRICCS CRLN Recruitment Report

BRICCS CRLN Recruitment Report

Tags: BRICCS Study Reporting Category CRLN

Summary

Report run at the start of each month summarizing all participants recruited into the BRICCS Study in the current year - starting 1st of October. Report does not include participants with a status of CANCELLED.

Format

Excel.

Ordered by date recruited.

Details

Recipient
angel.christian@…
Server
UHLSQLBRICCSDB\UHLBRICCSDB
Database
i2b2_app03_b1_data
Archive Directory
V:\BRICCS data requests\030 BRICCS recruitment data for CLRN\Extracts
SQL
EXEC CrlnRecruitmentReport NULL

Procedure

  1. Log on to the database and run the stored procedure and execute the SQL.
  2. Copy the output into a spreadsheet and save the spreadsheet in the archive directory with the name BRICCS_Enrollment_{year}{month}.xls. E.g., BRICCS_Enrollment_201506.xls
  3. Send the report to Angel.

Error: Macro BackLinks(None) failed
'Environment' object has no attribute 'get_db_cnx'

Last modified 7 years ago Last modified on 12/02/15 11:51:31
Note: See TracWiki for help on using the wiki.