SPARCRequest Wiki
SPARCFulfillment Subsidy Report Data Dictionary and Sample Report (v3.6.1)
Reports studies with subsidies approved within the selected dates. Customizable title with filter options: ‘Subsidy Approval Date From’ and ‘Subsidy Approval Date To”, sort by options ‘Protocol ID’ or ‘Primary PI’ and sort order ‘ascending’ or 'descending’.
Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | Protocol ID | System generated from SPARCRequest | protocols.sparc_id | Homepage, SRID column | INT(11) |
2 | Request ID | System generated from SPARCRequest | sub_service_requests.ssr_id | Homepage, SRID column | VARCHAR(255) |
3 | RMID | A unique numeric identifier that links a research study across multiple MUSC electronic research systems. | protocols.research_master_id | Homepage, RMID column | INT(11) |
4 | Short Title | An abbreviated form of the title used to identify your study/project | protocols.short_title | Homepage, Short Title column | VARCHAR(255) |
5 | Funding Source | System required field which indicates primary source of support for a study, which drives system pricing. | protocols.funding_source, protocols.potential_funding_source | SPARCDashboard, Protocol Information view. | VARCHAR(255) |
6 | Status | Communication indicator which displays progress, determined by service provider workflow | sub_service_requests.status | Homepage, Status column | VARCHAR(255) |
7 | Primary PI | Responsible person (aka Principal investigator) | project_roles.role = 'primary-pi' | Homepage, Principal Investigator column | VARCHAR(255) |
8 | Primary PI Affiliation | Institution, College, Department, Division of the responsible person | identities.professional_organization_id (professional_organizations.name) | SPARCDashboard, Profile Page, Affiliation | TEXT |
9 | Start Date | Estimated start date of your study (used by service providers to prioritize) | protocols.start_date | SPARCRequest Step 2 and SPARCDashboard Protocol Milestones | DATE |
10 | End Date | Estimated end date of your study (used by service providers to prioritize) | protocols.end_date | SPARCRequest Step 2 and SPARCDashboard Protocol Milestones | DATE |
11 | Approved Subsidy Total Amount | Total amount of monetary support approved for a study | subsidies.total_at_approval | SPARCDashboard, Admin Edit section, Subsidy table | INT(11) |
12 | Approved Subsidy % | Percent of Current Request Cost to be covered by Service Provider | subsidies.percent_subsidy | SPARCDashboard, Admin Edit section, Subsidy table | FLOAT |
13 | Subsidy Approval Date | The date the monetary support was approved | subsidies.approved_at | SPARCDashboard, Admin Edit section, Subsidy table | DATE |
14 | Total Fulfilled Amount ($) | The monetary support used to date | Calculated | N/A | N/A |
15 | Total Invoiced Amount ($) | The monetary total which has been flagged and invoiced in SPARCFulfillment | Calculated | N/A | N/A |
16 | Subsidy Residual | The remaining monetary support left for utilization (Approved Subsidy Total Amount - Total Fulfilled Amount) | Calculated | N/A | N/A |
Sample Report
Copyright © 2011-2026 MUSC Foundation for Research Development