Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
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 | 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 |
List of all IRBs associated with a protocol
21
If true, PRO#
22
IRB Approval Date
Institutional Review Board Date of Study Approval
23
IRB Expiration Date
Institutional Review Board Date of Study Expiration
24
IACUC Checked Y/N
25
If true, IACUC #
26
IACUC Approval Date
Institutional Animal Care And Use Committee Date of Approval
27
IACUC Expiration Date
Institutional Animal Care And Use Committee Date of Expiration
28
Sent to SPARCFulfillment
Has the protocol been pushed to Fulfillment
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) |
Sample Report
...
| Excel | |
|---|---|
|
...
|
...
|
| View file | |
|---|---|
|
...
|
...
|