Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

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

Excel
name2023-08-08 Protocol Merges.xlsx

...