SPARCRequest Wiki
SPARCFulfillment Project Summary Report Data Dictionary and Sample Report (v3.7.0)
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 |
|---|---|---|---|---|---|
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
