2012 CLARC Grant Process

Sungduck

SUNG DUCK OVERALL STATS

04/28/12 - 02/04/13

With Sungduck: 1 month, 1 week
With Us: 3 months, 3 weeks
Data Discussion: 2 months
With Legal 2 months, 1 week

Application

04/30/2012 - 06/01/2012

4/30 Letter of interested sent.
6/05 Proposal Sent

In Review

6/4/2012 - 7/20/2012

NDA

7/20/2012 - 7/24/2012

NDA returned 7/24

Down Time

7/24/2012 - 8/29/2012

Sungduck emailed twice to know what was the next step

Data Discussion

8/29/12 - 11/02/12

8/29- Data Call
8/30- Sungduck sent post call info
9/17 Katie responded with futhure data questions
9/23 Sungduck responded and also asked questions
10/15 Aurora created SOW draft
10/21 Sungduck responded with corrections
10/29 Sent Sow to legal

With Legal

11/02/12 - 11/19/12

11/19 Legal sent Legal Agreement and Legal Draft

Review of Sow

11/19/2012 - 11/20/2012

11/19 Steph send Legal Agreement and Legal SOW to Sungduck for review
11/20 S.D asks questions for Legal

With Legal

11/21/12 - 01/11/13

11/21- Steph Sends S.D question's to legal
12/15 - Steph asked for update
12/24- Steph again asked for update
12/17 Flynn suggests SOW was sent on 11/18. Steph reminds Flynn of questions
1/11 Legal Sends new SOW

Review of Sow

1/11/13 - 1/13/13

1/13 Sungduck signs and returns new SOW.

In Pull

01/19/13 - 02/03/13

1/20 Steph sends SOW for Ben to sign
1/25 Signed Sow Returns
1/25 Steph tells Aurora to begin Sow
2/3 Pull complete

Erica Meyers

ERICA MEYERS OVERALL STATS

05/07/12 - 12/22/12

With Erica: 18 days
With Us: 4 Months 2 weeks
Data Discussion: 1 Month 12 days
Legal: 18 days

Application

05/08/12 - 05/24/12

In review

06/04/12 - 07/20/12

Review Date 6/30
Approval 7/20

NDA

07/21/12 - 07/23/12

Data Call

07/27/12 - 07/28/12

Idle

07/28/12 - 09/21/12

Data Discussion

09/17/12 - 10/29/12

9/17 Katie Sends post call info.
9/17 Erica responds with questions
9/27 Katie resoinds
9/27 Erica responds with questions
10/09 Katie responds
10/10 Erica responds with questions
10/19 Aurora sends list of Variables
10/21 Erica sends Variable request
10/24 SOW Draft sent to Erica
10/25 Erica send changes
10/29 Steph sends SOW to legal

With Legal

10/31/12 - 11/18/12

10/31/12 SOW sent to legal for review and creation for legal agreement
11/18- Legal sends SOW and LA back

In Pull

11/18/12 - 12/20/12

11/18/12 Sow approved by Erica
11/27/12 Ben approves SOW
12/05-15/10 last minute questions
12/20 Pull complete

Lan Shi

Application

07/18/2012 - 07/19/2012

Lan Shi Overall Stat

07/18/2012 - 05/15/2013

Lan was grant was terminated

Idle

7/20/12 - 9/01/12

Should have been in the July Review

In Review

09/01/2012 - 10/10/2012

NDA review and signing

10/11/2012 - 10/19/2012

Data Discussion

11/08/12 - 02/07/13

Data Call : 11/08
Lan Email: 11/09
Responce: 11/12
Lan Email 11/13
Responce: 11/16
Lan Email 11/16
Responce 11/29
Lan Email 11/29
Responce :12/04
Lan Email: 12/5
Responce: 12/22
Lan Email 12/30
HAd another call 01/05
Lan Email: 01/17
Responce 01/18
Lan Email 01/18

SOW creation

2/02/13 - 2/27/13

Worked on SOW 2/3-2/7
Sent draft to Lan 2/8
Lan sent change request 2/22
Sent new draft 2/27
Lan sent approval 3/01

Legal creating Docs

3/15/13 - 3/21/13

Lan reviewing legal Docs

03/22/2013 - 04/09/2013

Change requests with Legal

4/11/13 - 4/12/13

Lan send Signed SOW

4/13/13 - 4/14/13

Canceled

4/15/13 - 4/16/13

Found out Lan was no longer with U.W

If Pull would have happened, best guess

4/20/13 - 5/10/13

Ben Keys

Ben Keys Overall Stats

10/22/12 - 4/30/13

Application

10/22/12 - 10/23/12

In Review

10/29/12 - 12/07/12

Ben Review of NDA

12/09/12 - 12/14/12

Data Discussion

12/14/12 - 02/05/13

Data call 12/14
12/21- Sent Data Dictional
12/22- Ben sent questions
01/07- Responded
01/15- Ben sent data request
01/20: Had another data call
1/30 Ben sent revised Data request

SOW Creation

02/07/13 - 02/17/13

2/7 Started work on
2/11 Sent SOW TO Ben
2/12 Ben sent changes
2/14 Sent Ben new draft with changes
2/16- Ben Approves

Request with Legal

2/19/13 - 3/02/13

Legal Docs with Ben

3/14/13 - 3/22/13

Pull

04/02/13 - 04/25/13

Joanne Wood- CHOP

Joanne Wood-CHOP

10/02/2012 - 04/24/2013

Application

10/02/12 - 10/03/12

In Review

10/03/12 - 11/18/12

Reviewed by CLARC team 10/25
Approved by Board 11/18

NDA

11/19/2012 - 11/20/2012

Used old

Data Discussion

11/26/12 - 12/07/12

Had Data Call 11/26, we asked for which fips she wanted
12/07- Sent information

SOW creation

12/08/12 - 03/07/13

12/21 Joanne asked for Legal agreement
12/21: Sent Legal Agreement
03/07/13: Sent SOW and LA redlines

Idle

01/07/13 - 3/10/13

Sent a few check in email. Joanne responded that the documents were in review

In Legal

04/07/13 - 04/10/13

Legal sent docs back 4/10

Legal Docs with CHOP

04/10/13 - 04/17/13

In pull

04/19/13 - 04/24/13

04/18/13 Asked Gilberto For Pull
4/20/13 Gilberto Completed Pull
4/24/13- Data in FTP site

Lynn Fisher

Application

7/5/12 - 7/6/12

Review

7/5/12 - 9/1/12

Team Approved on 7/21
Board Approved on 9/1

Lynn Fisher- UNC

7/5/12 - 5/31/13

NDA Sent

9/3/12 - 9/17/12

Data Discussion

9/24/12 - 10/19/12

9/25 Katie send DD
9/27-10/19 emails back and forth on how to best match data

SOW Creation

10/19/12 - 10/24/12

Sent SOW for Lynn to approve

Idle

10/30/12 - 11/12/12

Due to preparing for CLARC meeting

Sent Docs to legal

11/15/12 - 12/21/12

12/18-Legal emailed to ask qestuions
12/19- Stephanie replied

Legal Docs with Lynn

12/24/12 - 1/24/13

idle

1/12/13 - 1/24/13

SOW Creation

1/24/13 - 4/25/13

2/5- Had a new call with Lynn
2/19-3/13- Emails back and forth discussing how to match data
3/24- Katie talks to CMAS about what can and can not be done
4/5 sent me SOW to lynn
4/20- Lynn sends Redlines
4/24- We sent Lynn new SOW
4/25 Lynn approves SOW

New SOW with legal

4/30/13 - 5/1/13

Legal Agreement with Lynn

5/01/13 - 5/02/13

approved

Fullfillment

5/3/13 - 5/31/13

Half data was pulled 5/16

Paul Carrillo-GWU

Paul Carrillo-GWU

09/05/2012 - 05/25/2013

Application

9/5/12 - 9/6/12

In Review

9/6/12 - 10/9/12

9/6- Proposal Received
9/26- Team review
9/28- Sent to board
10/10 Approved

NDA with Grantee

10/11/12 - 11/3/12

Data Discussion

11/3/12 - 1/30/13

11/11- Had Data call
11/12- Sent Paul list of CBSA to choose
12/20 - Steph Paul a " checking in" email
1/10- Sent Paul another " "Checking in" email
1/14 - Paul sent a list of CBSA
1/30- Had another data call

IDLE

11/13/12 - 01/14/13

Paul was MIA

SOW Creation

2/4/13 - 05/05/2013

2/4 -2/21 Paul was reviewing docs
2/21- Paul asked REA questions
2/22- Asked for Clarification
3/1 respond
3/8 Told paul can only have aggregated data
3/8-4/9 Paul MIA
4/8 Sent checking in email
4/11 Paul Sent SOW changes
4/23 Sent Paul new SOW
5/05- Paul Approved SOW draft

IDLE

3/8/13 - 4/8/13

4/9- Sent checking in email

Sent to Legal

05/09/2013 - 5/21/2013

5/14- Sent Legal Check in email

Sent Grantee LLA

5/21/13 - 5/23/13

Sent Paul docs
Paul sends LLA back

Fullfillment

05/25/13 - 05/26/13

We were able to do pull without CMAS