Service Request Data Dictionary (SPARCRequest v3.12.1)

1

SRID

System generated protocol ID and request ID from SPARCRequest

protocols.id - sub_service_requests.ssr_id

Automatically generated by SPARC application.

BIGINT(20)

2

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

Date Submitted

Most recent date service request was submitted

sub_service_requests.submitted_at

Automatically generated by SPARC application at request submission.

DATETIME

4

Submitted By

Person who submitted the most recent service request submission.

sub_service_requests.recent_submitted_by

SPARCRequest Step 5: Generated after person uses “Submit Request' action with the most recently submission of a service request.

BIGINT(20)

5

Original Requester

Person who submitted the original service request.

sub_service_requests.service_requester_id

SPARCRequest Step 5: Generated after person uses “Submit Request' action when submitting the original service request.

Also viewable in SPARCDashboard Service Request table under Actions, Message an Authorized User

BIGINT(20)

6

Status*

Communication indicator which displays progress, determined by service provider workflow

sub_service_requests.status

SPARCDashboard Inside Protocol Request Table

VARCHAR(255)

7

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)

8

Full 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

9

Institution

The institution where the service is being provided (Level 1)

organizations.name

SPARCCatalog, institution to which the service belongs to 

VARCHAR(255)

10

Provider

The entity providing the service (Level 2)

organizations.name

SPARCCatalog, provider to which the service belongs to 

VARCHAR(255)

11

Program

The level of organization in which the service belongs (Level 3)

organizations.name

SPARCCatalog, program to which the service belongs to 

VARCHAR(255)

12

Core

The level of organization in which the service belongs (Level 4)

organizations.name

SPARCCatalog, core to which the service belongs to 

VARCHAR(255)

13

Service(s)

The name of the procedure or study level activity

services.name

SPARCCatalog Service Form

VARCHAR(255)

14

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)

15

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)

16

Primary PI Institution

Principal Investigator affiliated institution

professional_organizations.name (org_type = institution)

SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window

(Affiliation dropdown lists are logic-driven and only needs to be filled in once; it is shared across SPARC)

SPARCDashboard Authorized User Form, required Primary PI

SPARC User Profile

TEXT

17

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)

18

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)

19

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

20

Primary Coordinator(s)

Designated study coordinator(s) listed as an authorized user on a project/study

project_roles.role = research-assistant-coordinator

SPARCRequest Step 2 Authorized Users.

SPARCDashboard Authorized Users.

VARCHAR(255)

21

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)

22

IRB Checked Y/N

Whether or not the Human Subjects checkbox is selected on the study. This question provides the ability to add Institutional Review Board (IRB) information on the study.

research_types_info.human_subjects

SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Human Subject" checkbox.

SPARCDashboard Study Information

TINYINT(1)

23

Number of IRBs

Number of IRBs listed on the study.

Calculated field

Calculated value based on the number of IRBs listed on the study.

24

If true, PRO#

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 in the ‘IRB Records’ section and updated by the SPARC/RMID API for verified RMID associated eIRB records. This can also be manually entered in.

SPARCDashboard Study Information

VARCHAR(255)

25

IRB Approval Date

IRB Current Approval Date listed on the SPARC study. Shows information for all IRBs when there are multiple IRB listed on the study.

irb_records.irb_approval_date

SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Human Subject" checkbox. This number is auto-filled in the ‘IRB Records’ section and updated by the SPARC/RMID API for verified RMID associated eIRB records. This can also be manually entered in.

SPARCDashboard Study Information

DATE

26

IRB Expiration Date

IRB Study Expiration Date listed on the SPARC study. 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

27

IACUC Checked Y/N

Whether or not the Vertebrate Animals checkbox is selected on the study. This question provides the ability to add Institutional Animal Care and Use Committees (IACUC) information on the study.

research_types_info.vertebrate_animals

SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Vertebrate Animals" checkbox.

SPARCDashboard Study Information

TINYINT(1)

28

If true, IACUC #

IACUC System Generated Number.

vertebrate_animals_info.iacuc_number

SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Vertebrate Animals" checkbox, IACUC # field.

SPARCDashboard Study Information

VARCHAR(255)

29

IACUC Approval Date

IACUC Date of Approval

vertebrate_animals_info.iacuc_approval_date

SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Vertebrate Animals" checkbox, Approval Date field.

SPARCDashboard Study Information

DATETIME

30

IACUC Expiration Date

IACUC Date of Expiration

vertebrate_animals_info.iacuc_expiration_date

SPARCRequest Step 2: Study Information - Research Involving Section; This field is logic-driven by "Vertebrate Animals" checkbox, Expiration Date field.

SPARCDashboard Study Information

DATETIME

31

Sent to SPARCFulfillment

Whether or not the service request has been pushed to SPARCFulfillment module.

sub_service_requests.in_work_fulfillment

SPARCDashboard Admin Edit Push to Fulfillment

TINYINT(1)

32

Owner

Proprietor for a service request

sub_service_requests.owner_id

SPARCDashboard Admin Edit Page Owner Dropdown Menu

VARCHAR(255)