| Contributors | ||||||||
|---|---|---|---|---|---|---|---|---|
|
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 | System generated from SPARCRequest | protocols.id | Automatically generated by SPARC application. | BIGINT(20) | ||
2 | Research Master ID | 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 | protocol_merges.merged_protocol_id | Studies merged into another protocol using the SPARCDashboard, Merge Protocols action | INT(11) | ||
4 | Protocol 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 Status | Description of whether the study is funded or funding is pending | protocols.funding_status | SPARCRequest Step 2: Study Information (Required field in Financial Information section). SPARCDashboard Study Information | VARCHAR(255) | ||
8 | 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 in Financial Information section). 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) | 11||
12 | Number of IRBs | Number of IRBs | List of all IRBs associated with a protocol | 12listed on the study. | Calculated field | Calculated value based on the number of IRBs listed on the study. | |
13 | PRO # | Institutional Review Board (IRB) System Generated Numberhuman_subject_info. Shows Pro# for all IRBs when there are multiple IRB listed on the study. | 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) | ||
1314 | IRB of Record | An IRB of record is named once an institution assumes IRB responsibilities for a given project/studyhuman_subject_info. Shows information for all IRBs when there are multiple IRB listed on the study. | irb_records.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) | ||
1415 | Study Phase | The stage(s) of which the clinical trial is in. Shows information for all IRBs when there are multiple IRB listed on the study. | 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 Expirationhuman_subject_info. Shows information for all IRBs when there are multiple IRB listed on the study. | irb_records.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 | ||
1517 | 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) | ||
1618 | 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) | ||
1719 | Primary PI Email | Principal Investigator Email | identities.email | SPARCRequest Step 2 Authorized Users; Email automatically loads from LDAP. SPARCDashboard Authorized Users | VARCHAR(255) | ||
1820 | 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) | ||
1921 | 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) | ||
2022 | 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) | ||
2123 | 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) | ||
2224 | 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) | ||
2325 | 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) | ||
2426 | 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) | ||
2527 | 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) | ||
2628 | 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) | ||
2729 | 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 | ||
2830 | 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) | ||
2931 | 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) | ||
3032 | 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) | ||
3133 | 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) |
Sample Report
| Excel | ||
|---|---|---|
|
| View file | |
|---|---|
|
...
|
...
|
...
|