Changes between Version 6 and Version 7 of BRICCS CRLN Recruitment Report

Timestamp:

11/03/15 10:58:33 (9 years ago)

Author:

Richard Bramley

Comment:

--

BRICCS CRLN Recruitment Report

@@ -26 +26 @@
 {{{
 #!sql
-SELECT 
-          REPLACE(REPLACE(REPLACE([BPtNumber], 'b', 'B'), 'p', 'P'), 'T', 't') [ParticipantId]
-      ,i2b2ClinDataIntegration.dbo.InitCap(REPLACE(REPLACE([RecruitingSite], 'briccs_', ''), '_recruitment', '')) [RecruitingSite]
-      ,[InterviewDate] [EnrolmentDate]
-FROM [i2b2_app03_b1_data].[dbo].[ParticipantRecruitment]
-WHERE   InterviewDate >= '01-October-201?' AND   InterviewDate < '01-October-201? + 1'
+EXEC CrlnRecruitmentReport {Start year - starting from 1st October}
 }}}