This report provides information for those protocols utilizing the services as selected in the report criteria. These criteria can include the institution, provider, program and/or core. The resulting report identifies protocol-specific information which includes the Long and Short titles, funding source, sponsor name, financial account, study phase, NCT #, PRO #, IRB of record, IRB expiration date as well as including the PI and PI's institution, division and department details, coordinator information, etc.
Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | Protocol ID (SRID) | System generated from SPARCRequest | protocols.id | Automatically generated by SPARC application. | BIGINT(20) |
2 | Research Master ID (Should we change this column title to match other reports in Fulfillment - “RMID”) | A unique numeric identifier that links a research study across multiple MUSC electronic research systems | protocols.research_master_id | SPARCRequest Step 2: Study Information; Required field when Human Subjects checkbox is selected; System-generated in RMID application. SPARCDashboard Study Information | INT(11) |
3 | Combined Protocol ID(s) | List of historically merged protocols | |||
4 | Protocol Short Title (Should we change this column title to match other reports in Fulfillment - “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) |
5 | Protocol Title | Full (unabbreviated) form of the title used to identify your study/project | protocols.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 | TEXT |
6 | Number of Requests | Total number of packaged services from a service provider | calculated field | Calculated value based on the total number of requests under the same protocol. | |
7 | Funding Source | System required field which indicates primary source of support for a study, which drives system pricing | protocols.funding_source | SPARCRequest Step 2: Study Information (Required field when choosing funded). SPARCDashboard Study Information | VARCHAR(255) |
8 | Potential Funding Source | Indicates whether or not funding has been applied or obtained | protocols.potential_funding_source | SPARCRequest Step 2: Study Information (Required field when choosing pending funding). SPARCDashboard Study Information | VARCHAR(255) |
9 | Sponsor Name | Name of the entity funding the project/study | protocols.sponsor_name | SPARCRequest Step 2: Study Information (Required field) SPARCDashboard Study Information | VARCHAR(255) |
10 | Financial Account | Used to identify account of financial record for billing purposes (i.e. UDAK) | protocols.udak_project_number | SPARCRequest Step 2: Study Information - Optional Information Section SPARCDashboard Study Information | VARCHAR(255) |
11 | NCT # | National Clinical Trials Number | human_subject_info.nct_number | SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Human Subject" checkbox. SPARCDashboard Study Information | VARCHAR(255) |
12 | Number of IRBs | List of all IRBs associated with a protocol | |||
13 | PRO # | Institutional Review Board (IRB) System Generated Number | human_subject_info.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) |
14 | IRB of Record | An IRB of record is named once an institution assumes IRB responsibilities for a given project/study | human_subject_info.irb_of_record | SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Human Subject" checkbox. SPARCDashboard Study Information | VARCHAR(255) |
15 | Study Phase | The stage(s) of which the clinical trial is in. | protocols_study_phases.study_phase_id | SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Human Subject" checkbox. SPARCDashboard Study Information | INT(11) |
16 | IRB Expiration Date | Institutional Review Board Date of Study Expiration | human_subject_info.irb_expiration_date | SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Human Subject" checkbox. This field is auto-filled and updated by the SPARC/RMID API for verified RMID associated eIRB records. SPARCDashboard Study Information | DATE |
15 | Primary PI Last Name | Principal Investigator Last Name | identities.last_name | SPARCRequest Step 2 Authorized Users; One Primary PI is required on each protocol. SPARCDashboard Authorized Users | VARCHAR(255) |
16 | Primary PI First Name | Principal Investigator First Name | identities.first_name | SPARCRequest Step 2 Authorized Users; One Primary PI is required on each protocol. SPARCDashboard Authorized Users | VARCHAR(255) |
17 | Primary PI Email | Principal Investigator Email | identities.email | SPARCRequest Step 2 Authorized Users; Email automatically loads from LDAP. SPARCDashboard Authorized Users | VARCHAR(255) |
18 | Primary PI Institution | Principal Investigator Institution | professional_organizations.name (org_type = institution) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC; SPARCDashboard Authorized Users Institution can also be entered/edited from Profiles page Institution dropdown menu. | VARCHAR(255) |
19 | Primary PI College | Principal Investigator College | professional_organizations.name (org_type = college) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC. SPARCDashboard Authorized Users College can also be entered/edited from Profiles page College dropdown menu. | VARCHAR(255) |
20 | Primary PI Department | Principal Investigator Department | professional_organizations.name (org_type = department) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC. SPARCDashboard Authorized Users Department can also be entered/edited from Profiles page Department dropdown menu. | VARCHAR(255) |
21 | Primary PI Division | Principal Investigator Division | professional_organizations.name (org_type = division) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC. SPARCDashboard Authorized Users Division can also be entered/edited from Profiles page Division dropdown menu. | VARCHAR(255) |
22 | Primary Coordinator(s) | Designated study coordinator(s) listed on project/study | project_roles.role = research-assistant-coordinator | SPARCRequest Step 2 Authorized Users. SPARCDashboard Authorized Users | VARCHAR(255) |
23 | Primary Coordinator Email(s) | Primary coordinator(s) email for a project/study | identities.email | SPARCRequest Step 2 Authorized Users; Email automatically loads from LDAP. SPARCDashboard Authorized Users | VARCHAR(255) |
24 | Business Manager(s) | Designated manager who is responsible for budget review in SPARC | project_roles.role = business-grants-manager | SPARCRequest Step 2 Authorized Users. SPARCDashboard Authorized Users | VARCHAR(255) |
25 | Business Manager Email(s) | Business Manager(s) email address for a project/study | identities.email | SPARCRequest Step 2 Authorized Users; Email automatically loads from LDAP. SPARCDashboard Authorized Users | VARCHAR(255) |
26 | Selected For Epic | Whether a protocol is chosen to be pushed to Epic | protocols.selected_for_epic | SPARCRequest Step 2 Protocol Information section SPARCDashboard Authorized Users | TINYINT(1) |
27 | Last Epic Push Date | The most recent date when the protocol was pushed from SPARCRequest to EPIC | protocols.last_epic_push_time | System generated date stamp | DATETIME |
28 | Last Epic Push Status | The status (success/failure) for the most recent EPIC push | protocols.last_epic_push_status | System generated status based on the EPIC interface | VARCHAR(255) |
29 | IND # | The Investigational New Drug Application (IND) number | investigational_products_info.ind_number | SPARCRequest Step 2 Protocol Information table, when Investigation Device is selected SPARCDashboard Study Information | VARCHAR(255) |
30 | IDE/HDE/HUD Type | The type of an investigational device exemption | investigational_products_info.exemption_type | SPARCRequest Step 2 Protocol Information table, when Investigation Device is selected SPARCDashboard Study Information | VARCHAR(255) |
31 | IDE/HDE/HUD # | The identification number of Investigational Device Exemption (IDE)/ Humanitarian Device Exemption (HDE) /Humanitarian Use Device (HUD) | investigational_products_info.inv_device_number | SPARCRequest Step 2 Protocol Information table, when Investigation Device is selected SPARCDashboard Study Information | VARCHAR(255) |