Protocols Report Data Dictionary (SPARCRequest v3.12.1)

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)

12

Number of IRBs

Number of IRBs listed 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 Number. 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)

14

IRB of Record

An IRB of record is named once an institution assumes IRB responsibilities for a given project/study. 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)

15

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 Expiration. 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

17

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)

18

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)

19

Primary PI Email

Principal Investigator Email

identities.email

SPARCRequest Step 2 Authorized Users; Email automatically loads from LDAP.

SPARCDashboard Authorized Users

VARCHAR(255)

20

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)

21

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)

22

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)

23

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)

24

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)

25

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)

26

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)

27

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)

28

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)

29

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

30

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)

31

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)

32

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)

33

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)