SPARCRequest Wiki
Protocol Merges Report Data Dictionary (SPARCRequest v3.12.1)
- harikrip
- Brigette White
Owned by harikrip
This report provides information for protocols that have been merged together. The resulting report identifies protocol-specific information which includes the merge date, master (remaining) protocol, subordinate (merged) protocol, person performing the merge and the master protocol short title, PI and IRB Pro number.
Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | Date of Merge | The date on which the merge occurred | protocol_merges.updated_at | Date merge occurred | DATETIME |
2 | Master Protocol ID | The remaining protocol to which all other protocols have been merged | protocol_merges.master_protocol_id | Study other protocols are merged into using the SPARCDashboard, Merge Protocols action | INT(11) |
3 | Subordinate Protocol ID | List of historically merged protocols | protocol_merges.merged_protocol_id | Studies merged into another protocol using the SPARCDashboard, Merge Protocols action | INT(11) |
4 | Merged By | Administrator who performed the merge | protocol_merges.identity_id (identities.first_name identities.last_name) OR ‘Backend Admin’ if protocol_merges.identity_id is NULL | Pulled from LDAP for the logged-in user or added for Backend merges | VARCHAR(255) |
5 | Short Title | An abbreviated form of the title used to identify your study/project | protocols.short_title | SPARCRequest Step 2: Study Information (Required field); This field is auto-updated when RMID is used via the SPARC/RMID API. SPARCDashboard Study Information | VARCHAR(255) |
6 | PI | Principal Investigator | identities.first_name identities.last_name | SPARCRequest Step 2 Authorized Users; One Primary PI is required on each protocol. SPARCDashboard Authorized Users | VARCHAR(255) |
7 | IRB# | Institutional Review Board (IRB) System Generated Number. | irb_records.pro_number | SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Human Subject" checkbox. This number is auto-filled and updated by the SPARC/RMID API for verified RMID associated eIRB records. SPARCDashboard Study Information | VARCHAR(255) |
Sample Report
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page { mso-header-data:""; mso-footer-data:""; margin:1in 0.75in 1in 0.75in; mso-header-margin:0.5in; mso-footer-margin:0.5in; mso-page-orientation:Landscape; }tr {mso-height-source:auto; mso-ruby-visibility:none;}col {mso-width-source:auto; mso-ruby-visibility:none;}br {mso-data-placement:same-cell;}ruby {ruby-align:left;}.style0 { mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; border:none; mso-protection:locked visible; mso-style-name:Normal; mso-style-id:0;}.font0 { color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; }.font1 { color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; }td {mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; border:none; mso-protection:locked visible; mso-ignore:padding;}.style0 { text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; mso-style-name:"Normal"; }.style1 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style2 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style3 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style4 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style5 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style6 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style7 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style8 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style9 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style10 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style11 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style12 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style13 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style14 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.x15 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }.x16 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:normal;word-wrap:break-word; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }--></style><div class="cells-worksheet" data-sheet-number="0" data-sheet-name="Data"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;table-layout:fixed;width:745pt"> <colgroup> <col class="x16" style="mso-width-source:userset;background:none;width:129px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:120px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:100px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:138px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:279px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:134px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:94px"></col> </colgroup> <tbody> <tr style="mso-height-source:userset;height:13.8pt" id="r0"> <td class="x16" style="height:13.8pt;width:96.75pt">Report Generated:</td> <td class="x16" style="width:90pt">2023-08-08</td> <td class="x16" style="width:75pt"></td> <td class="x16" style="width:103.5pt"></td> <td class="x16" style="width:209.25pt"></td> <td class="x16" style="width:100.5pt"></td> <td class="x16" style="width:70.5pt"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r1"> <td class="x16" style="height:13.8pt"># of Records:</td> <td class="x16" style="text-align:right">29</td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r2"> <td class="x16" style="height:13.8pt"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r3"> <td class="x16" style="height:13.8pt">Report Parameters</td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r4"> <td class="x16" style="height:13.8pt">Type:</td> <td class="x16">Protocol Merges</td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:27.6pt" id="r5"> <td class="x16" style="height:27.6pt">Protocols Merged Date From:</td> <td class="x16">03/01/2023</td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:27.6pt" id="r6"> <td class="x16" style="height:27.6pt">Protocols Merged Date To:</td> <td class="x16">08/08/2023</td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r7"> <td class="x16" style="height:13.8pt"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:27.6pt" id="r8"> <td class="x16" style="height:27.6pt">Date of Merge</td> <td class="x16">Master Protocol ID</td> <td class="x16">Subordinate Protocol ID</td> <td class="x16">Merged By</td> <td class="x16">Short Title</td> <td class="x16">PI</td> <td class="x16">IRB#</td> </tr> <tr style="mso-height-source:userset;height:27.6pt" id="r9"> <td class="x16" style="height:27.6pt">03/08/23</td> <td class="x16" style="text-align:right">5427</td> <td class="x16" style="text-align:right">5426</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">urine gelatinase activity as cancer marker at home</td> <td class="x16">Shaoli Sun</td> <td class="x16">Pro00014383</td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r10"> <td class="x16" style="height:13.8pt">03/08/23</td> <td class="x16" style="text-align:right">8390</td> <td class="x16" style="text-align:right">8391</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Development of an in vitro caries model</td> <td class="x16">Walter Renne</td> <td class="x16">Pro00043691</td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r11"> <td class="x16" style="height:13.8pt">03/14/23</td> <td class="x16" style="text-align:right">2149</td> <td class="x16" style="text-align:right">2150</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Green Tea</td> <td class="x16">Jennifer Donovan</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r12"> <td class="x16" style="height:13.8pt">03/14/23</td> <td class="x16" style="text-align:right">2179</td> <td class="x16" style="text-align:right">2187</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">ROTEM</td> <td class="x16">Charles Greenberg</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r13"> <td class="x16" style="height:13.8pt">03/14/23</td> <td class="x16" style="text-align:right">2209</td> <td class="x16" style="text-align:right">2233</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">2-22-10 Barn</td> <td class="x16">Amanda Barnhorst</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r14"> <td class="x16" style="height:13.8pt">03/14/23</td> <td class="x16" style="text-align:right">2209</td> <td class="x16" style="text-align:right">2254</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">2-22-10 Barn</td> <td class="x16">Amanda Barnhorst</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r15"> <td class="x16" style="height:13.8pt">03/14/23</td> <td class="x16" style="text-align:right">2256</td> <td class="x16" style="text-align:right">2263</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">4-6-10 Bradl</td> <td class="x16">Scott Bradley</td> <td class="x16">HR19728</td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r16"> <td class="x16" style="height:13.8pt">03/17/23</td> <td class="x16" style="text-align:right">20643</td> <td class="x16" style="text-align:right">20646</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Lesions of Thorax</td> <td class="x16">Barry Gibney</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r17"> <td class="x16" style="height:13.8pt">03/17/23</td> <td class="x16" style="text-align:right">21099</td> <td class="x16" style="text-align:right">20958</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">LVAD and SDB</td> <td class="x16">Gregory Jackson</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r18"> <td class="x16" style="height:13.8pt">03/17/23</td> <td class="x16" style="text-align:right">21099</td> <td class="x16" style="text-align:right">21096</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">LVAD and SDB</td> <td class="x16">Gregory Jackson</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r19"> <td class="x16" style="height:13.8pt">03/17/23</td> <td class="x16" style="text-align:right">21287</td> <td class="x16" style="text-align:right">21284</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Math Matters</td> <td class="x16">Jennifer Wisniewski</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r20"> <td class="x16" style="height:13.8pt">03/24/23</td> <td class="x16" style="text-align:right">22137</td> <td class="x16" style="text-align:right">22093</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">SAMURAI PICU</td> <td class="x16">Allison Whalen</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r21"> <td class="x16" style="height:13.8pt">03/30/23</td> <td class="x16" style="text-align:right">21918</td> <td class="x16" style="text-align:right">21972</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Immunization patterns</td> <td class="x16">Kalyani Sonawane</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r22"> <td class="x16" style="height:13.8pt">03/30/23</td> <td class="x16" style="text-align:right">21924</td> <td class="x16" style="text-align:right">21931</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Flowchart</td> <td class="x16">Renee Rosati</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:27.6pt" id="r23"> <td class="x16" style="height:27.6pt">03/30/23</td> <td class="x16" style="text-align:right">22069</td> <td class="x16" style="text-align:right">22247</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Spectral characteristics of memory transformation (MEM_MOD)</td> <td class="x16">Kirstin-friederike Heise</td> <td class="x16">Pro00126392</td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r24"> <td class="x16" style="height:13.8pt">03/30/23</td> <td class="x16" style="text-align:right">22239</td> <td class="x16" style="text-align:right">22041</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Disparities in Sarcoidosis</td> <td class="x16">Brandon Miller</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:41.4pt" id="r25"> <td class="x16" style="height:41.4pt">04/06/23</td> <td class="x16" style="text-align:right">22994</td> <td class="x16" style="text-align:right">23013</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Racial Difference in Pain management for patients with systemic sclerosis admitted with digital ulcers</td> <td class="x16">Duaa Alkhader</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r26"> <td class="x16" style="height:13.8pt">04/07/23</td> <td class="x16" style="text-align:right">21908</td> <td class="x16" style="text-align:right">20223</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">DART Program</td> <td class="x16">Sudie Back</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r27"> <td class="x16" style="height:13.8pt">04/11/23</td> <td class="x16" style="text-align:right">22460</td> <td class="x16" style="text-align:right">22402</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">CTO#103815_sIND Magrolimab- Baratam</td> <td class="x16">Praneeth Baratam</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:41.4pt" id="r28"> <td class="x16" style="height:41.4pt">04/14/23</td> <td class="x16" style="text-align:right">21456</td> <td class="x16" style="text-align:right">21877</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Deep Learning Classifier for the Detection of Soft Tissue Infections Using Point-of-Care Ultrasound</td> <td class="x16">Nicole Li</td> <td class="x16">Pro00118409</td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r29"> <td class="x16" style="height:13.8pt">05/30/23</td> <td class="x16" style="text-align:right">23285</td> <td class="x16" style="text-align:right">23286</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Prograf vs Envarsus study</td> <td class="x16">Genta Uehara</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r30"> <td class="x16" style="height:13.8pt">07/07/23</td> <td class="x16" style="text-align:right">2201</td> <td class="x16" style="text-align:right">2202</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">2-11-10 Spra</td> <td class="x16">Eve Spratt</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r31"> <td class="x16" style="height:13.8pt">07/07/23</td> <td class="x16" style="text-align:right">2421</td> <td class="x16" style="text-align:right">3199</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Depocyt</td> <td class="x16">Bruce Frankel</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r32"> <td class="x16" style="height:13.8pt">07/07/23</td> <td class="x16" style="text-align:right">2460</td> <td class="x16" style="text-align:right">2961</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Hollywood Smiles</td> <td class="x16">Renata Leite</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r33"> <td class="x16" style="height:13.8pt">07/07/23</td> <td class="x16" style="text-align:right">2614</td> <td class="x16" style="text-align:right">2615</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Cooper SCTR#1</td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r34"> <td class="x16" style="height:13.8pt">07/07/23</td> <td class="x16" style="text-align:right">6924</td> <td class="x16" style="text-align:right">2392</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Fastrack Study</td> <td class="x16">Eric Nelson</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:27.6pt" id="r35"> <td class="x16" style="height:27.6pt">07/07/23</td> <td class="x16" style="text-align:right">7472</td> <td class="x16" style="text-align:right">2825</td> <td class="x16">Prathik Harikrishnan</td> <td class="x16">Cortical Excitability: Biomarker and Endophenotype in Combat Related PTSD</td> <td class="x16">Zhewu Wang</td> <td class="x16">Pro00012134</td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r36"> <td class="x16" style="height:13.8pt">08/04/23</td> <td class="x16" style="text-align:right">15510</td> <td class="x16" style="text-align:right">15506</td> <td class="x16">Leila Forney</td> <td class="x16">TEST</td> <td class="x16">Michael Watson</td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:13.8pt" id="r37"> <td class="x16" style="height:13.8pt">08/04/23</td> <td class="x16" style="text-align:right">15510</td> <td class="x16" style="text-align:right">16379</td> <td class="x16">Leila Forney</td> <td class="x16">TEST</td> <td class="x16">Michael Watson</td> <td class="x16"></td> </tr> <tr style="display:none"> <td style="width:96.75pt"></td> <td style="width:90pt"></td> <td style="width:75pt"></td> <td style="width:103.5pt"></td> <td style="width:209.25pt"></td> <td style="width:100.5pt"></td> <td style="width:70.5pt"></td> </tr> </tbody></table></div>
Copyright © 2011-2020 MUSC Foundation for Research Development