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 |
(Should we change the definition to match other reports in SPARCReport - “Principal Investigator 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
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 |
Institutional Review Board Date of Study Approval
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 |
Institutional Review Board Date of Study Expiration
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 |
Institutional Animal Care And Use Committee Date of Approval
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 |
Institutional Animal Care And Use Committee Date of Expiration
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 | |
|---|---|
|
...
|
...
|