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) | Pulled from LDAP for the logged-in user | 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) |