Changes between Version 2 and Version 3 of BRICCS CRLN Recruitment Report

Timestamp:

07/02/15 08:15:59 (9 years ago)

Author:

Richard Bramley

Comment:

--

BRICCS CRLN Recruitment Report

@@ -17 +17 @@
 Ordered by date recruited.
 
-== Details
+== Old Details
+
+ Recipient:: angel.christian@nihr.ac.uk
+ Server:: `UHLSQLBRICCSDB\UHLBRICCSDB`
+ Database:: `i2b2_app03_b1_data`
+ Procedure:: `LastMonthCrlnBriccsRecruitmentReport`
+ Archive Directory:: {{{V:\BRICCS data requests\BRICCS recruitment data for CLRN}}}
+
+== Procedure (if output format approved by Angel)
+
+1. Log on to the database and run the stored procedure: `EXEC LastMonthCrlnBriccsRecruitmentReport`
+2. The stored procedure produces the recruitment report for the previous month.  So it must be run in the following month.  I.e., for June 2015 recruits it must be run in July 2015.
+3. 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`
+4. Send the report to Angel.
+
+== Old Details - Delete when next process approved
 
  Recipient:: angel.christian@nihr.ac.uk
@@ -25 +40 @@
  SQL Account:: Auditor
 
-== Procedure
+== Old Procedure - Delete when next process approved
 
 === Create Participant Extracts