SPARCFulfillment Project Summary Report Data Dictionary and Sample Report (v3.6.1)

Wenjun He (Unlicensed) 17 (2162 days ago), Brigette White 7 (287 days ago), Kyle Hutson (Unlicensed) 7 (2229 days ago), Prathik Harikrishnan 5 (1240 days ago)

Report on a single study’s billable costs of fulfilled calendar visit clinical and non clinical services. It does not include participant customized visits. Report output includes the following headers and columns:

Headers:

SPARC (Study) ID
RMID
PI Name
Queried Dates (From/To)

Data Dictionary

No.	Column Name	Description	Database Name	Source	Type

No.	Column Name	Description	Database Name	Source	Type
Clinical Services		Services that provide direct patient care	sparc_request.services.one_time_fee = 0	SPARCCatalog Clinical services switch at service creation	TINYINT(1)
1	Arm Name	The name of the group or subgroup of participants in a clinical trial	arms.name	Participant Tracker header “Current Arm” column	VARCHAR(255)
2	Patient MRN	Participant's Medical Record Number	participants.mrn	Patient registry page "MRN" text field when creating a new participant.	VARCHAR(255)
3	Participant Status	Standing of patient progress	participants.status	Participant Tracker Tab “Status” column dropdown box	VARCHAR(255)
4	Invoiceable Visit Cost	Cost per visit of completed services. Lists out each visit in separate columns.	Sum(procedures.service_cost)	Calculated field	N/A
5	Per Patient Invoiceable total	Cost per patient of completed services	Sum(procedures.service_cost)	Calculated field	N/A
6	Arm Total	The total cost of the study arm	Sum(procedures.service_cost)	Calculated field	N/A
7	Clinical Services Invoiceable Total	The total cost of the clinical services completed	Sum(procedures.service_cost)	Calculated field	N/A
Non-clinical Services		Services that do not provide direct patient care of any type	services.one_time_fee = 1	SPARCCatalog Non-clinical services switch at service creation	TINYINT(1)
8	Service	The name of the study level activity	fulfillments.service_name	Request Page Non-clinical Services tab “Service” column	VARCHAR(255)
9	Quantity Completed	The number of how many study level activities have been completed	fulfillments.quantity	Request Page Non-clinical Services tab, List window, “Quantity” column	INT(11)
10	Quantity Type	Unit of measurement for Non-clinical services	line_items.quentity_type	Request Page Non-clinical Services tab, List window, “Quantity Type” column	VARCHAR(255)
11	Cost	The cost of the fulfilled clinical service	(fulfillments.service_cost)/100	Logic-drive cost from pricing map set up in SPARCCatalog and admin rate.	INT(11)
12	Non-clinical Services Invoiceable Total	Total cost for all Non-clinical services. Reports base cost. Does not calculate cost for multiple fulfillments of same services (e.g. Quantity Completed greater than 1 are not multiplied by the quantity)	Sum((fulfillments.service_cost)/100)	Calculated field	N/A
13	Study Total	Total cost for study fulfillments	Sum(procedures.service_cost + (fulfillments.service_cost)/100)	Calculated field	N/A

Sample Report

Excel: spreadsheet preview is finally here!

You can now display this file as a spreadsheet, instead of a PDF. Re-upload 190726- Project_Summary_Report.xlsx to display the new preview. You can access the file here.