Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | SRID (Should we change this column title to match other reports in Fulfillment - “Protocol ID (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 | Date service request was submitted | sub_service_requests.submitted_at | Automatically generated by SPARC application at request submission. | DATETIME |
4 | Communication indicator which displays progress, determined by service provider workflow | sub_service_requests.status | SPARCDashboard Inside Protocol Request Table | VARCHAR(255) | |
5 | 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) |
6 | 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 |
7 | Institution | The institution where the service is being provided (Level 1) | organizations.name | SPARCCatalog, institution to which the service belongs to | VARCHAR(255) |
8 | Provider | The entity providing the service (Level 2) | organizations.name | SPARCCatalog, provider to which the service belongs to | VARCHAR(255) |
9 | Program | The level of organization in which the service belongs (Level 3) | organizations.name | SPARCCatalog, program to which the service belongs to | VARCHAR(255) |
10 | Core | The level of organization in which the service belongs (Level 4) | organizations.name | SPARCCatalog, core to which the service belongs to | VARCHAR(255) |
11 | 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) |
12 | 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) |
13 | Primary PI Institute (Should we change this column title to match other reports in SPARCReport - “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 |
14 | 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) |
15 | 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) |
16 | 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 |
17 | Primary Coordinator(s) | Designated study coordinator(s) listed as an authorized user on a project/study (Should we change the definition to match other reports in SPARCReport - “Designated study coordinator(s) listed on project/study”) | project_roles.role = research-assistant-coordinator | SPARCRequest Step 2 Authorized Users. SPARCDashboard Authorized Users. | VARCHAR(255) |
18 | 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) |
19 | IRB Checked Y/N | ||||
20 | 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 | |||
19 | Owner | Proprietor for a service request | sub_service_requests.owner_id | SPARCDashboard Admin Edit Page Owner Dropdown Menu | VARCHAR(255) |