SPARCFulfillment Funding Source Auditing Report Data Dictionary and Sample Report (v3.6.1)

This report lists studies (e.g., service requests) that have had funding source changes within the queried time frame when there are also fulfilled clinical or non-clinical services for any timeframe.

Filter options include:

Editable title
Funding Source Date Changes To and From
Organization
Protocol
Sorting By Protocol ID or Primary PI
Sorting Order By Ascending or Descending

Report output includes the chosen parameters Dates, Organizations (Selected or All) and Protocols (Selected or All) and the following columns:

No.	Column Name	Description	Database Name	Source	Type

No.	Column Name	Description	Database Name	Source	Type
1	RMID	Unique numeric identifier that links a research study across multiple MUSC electronic research systems	SPARC protocols.research_master_id	Protocol page RMID column	INT
2	Protocol ID	System generated from SPARCRequest	SPARC protocols.sparc_id	SPARCDashboard study Homepage SRID column	INT
3	Request ID	Sub Service Request ID	SPARC sub_service_requests.ssr_id	SPARCDashboard study Homepage SRID column	VARCHAR(255)
4	Status	Sub Service Request Status	SPARC sub_service_requests.status	SPARCDashboard study Homepage Status column	VARCHAR(255)
5	Short Title	An abbreviated form of the title used to identify your study/project	SPARC protocols.short_title	SPARCDashboard study Homepage Short Title column	VARCHAR(255)
6	Proposal Funding Status	Indicates whether or not funding has been applied for or obtained for the project	SPARC protocols.funding_status	SPARCDashboard, Protocol Information Page	VARCHAR(255)
7	Funding Start Date	Date funding starts for the project	SPARC protocols.funding_start_date	SPARCDashboard, Protocol Information Page	DATETIME
8	Funding Source	System required field which indicates primary source of support for a study, which drives system pricing	SPARC protocols.funding_source	SPARCDashboard, Protocol Information Page	VARCHAR(255)
9	Previous Funding Source	Previous funding source selected for the project before the change was made to the new, current source	SPARC audits.audited_changes	SPARC audits table	TEXT
10	Funding Source Change Date	Date funding source was changed	SPARC audits.created_at	SPARC audits table	DATETIME
11	Primary PI	Responsible person (aka Principal investigator)	SPARC project_roles.role = 'primary-pi'	SPARCDashboard, Protocol Information Page	VARCHAR(255)
12	Primary PI Affiliation	Institution, College, Department, Division of the responsible person	SPARC identities.professional_organization_id (professional_organizations.name)	SPARCDashboard, Profile Page, Affiliation	TEXT
13	Billing/Business Manager(s)	Person responsible for reviewing and paying invoices	SPARC project_roles.role = 'business-grants-manager'	SPARCDashboard Authorized Users Table	VARCHAR(255)
14	Core/Program	The level of organization in which the service belongs. One row is listed for each different Core/Program’s services according to funding source change date.	SPARC services.organization_id	SPARCCatalog Provider/ Program/Core Setup; SPARCFulfillment Participant Tracker (displays Core for services in participant appointments)	VARCHAR(255)
15	Services	List of affected the Core/Program’s services SPARCFulfillment for the project. These are services with fulfillments/procedures completed for any date.	SPARC services.name	SPARCDashboard Study Admin Edit Clinical Services/Non-clinical Services Tabs; SPARCFulfillment completed services within Participant Tracker Appointments and Non-clinical Services Tabs	VARCHAR(255)
16	Invoiced?	“Yes” is displayed if any of Core/Program’s fulfilled/completed services have been invoiced	procedures.invoiced, fulfillments.invoiced	Participant Tracker Appointments/Calendar “Invoiced” Column and Non-clinical Services tab, Fulfillment List, “Invoiced” Column	TINYINT