SPARCRequest Wiki
Cost Analysis Report (SPARCRequest v3.12.1)
- Evan Martinez
- Kyle Hutson (Unlicensed)
- Brigette White
This report provides a snapshot of your protocol costs related to the requested services.
No. | Column Name | Description | Database Name | Source | Type | |
|---|---|---|---|---|---|---|
Study Total | ||||||
1
|
Category | Study ARM | Total Cost Per Arm | N/A | N/A | VARCHAR(255) |
Non-Clinical Services | Total Cost of Non-Clinical Services Per Study | N/A | N/A | VARCHAR(255) | ||
Grand Total | The Total Combined Cost of all study ARMs and non-clinical services | N/A | N/A | Calculated Value | ||
2 | Total Per Study | Cost per category | N/A | N/A | Calculated Value | |
Clinical Services (Overview) | ||||||
3 | ARM Name | The name of the group or subgroup of participants in a clinical trial. | arms.name | SPARCRequest Step 3 and SPARCDashboard Admin Edit Clinical Services Tab | VARCHAR(255) | |
4 | Quantity Type | Unit of measurement to describe the quantity amount (hours, each, slides, etc) | pricing_maps.quantity_type | SPARCCatalog Service Pricing Map | VARCHAR(255) | |
5 | Service Rate | The fee associated to the procedure. | services.full_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) | |
6 | Your Cost | The amount that your study will be charged including any research discounts or service provider determined cost (override pricing). | pricing_maps.federal_rate/100 or pricing_maps.corporate_rate/100 or pricing_maps.member_rate/100 or pricing_maps.other_rate/100 or (admin_rates.admin_cost)/100 | SPARCCatalog Service Pricing Map or rate modified in ‘Your Cost’ on SPARCDashboard Admin Edit Clinical Services Tab | DECIMAL(12,4) INT(11) | |
7 | Quantity | Quantity of service requested | line_items.quantity | SPARCRequest Step 3 and SPARCDashboard Admin Edit Non-clinical Services Tab | INT(11) | |
8 | Per Patient | Cost per patient = (Your Price)*(Quantity) for a given service | N/A | N/A | Calculated Value | |
9 | Per Study | Cost per study= (Cost Per Patient)*(Quantity) for a given service | N/A | N/A | Calculated Value | |
Clinical Services (with Visits) | ||||||
10 | Arm Name | The name of the group or subgroup of participants in a clinical trial. | line_items.quantity | SPARCRequest Step 3 and SPARCDashboard Admin Edit Clinical Services Tab | VARCHAR(255) | |
11 | Quantity Type | Unit of measurement to describe the quantity amount (hours, each, slides, etc) | pricing_maps.quantity_type | SPARCCatalog Service Pricing Map | VARCHAR(255) | |
12 | Service Rate | The fee associated to the procedure. | services.full_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) | |
13 | Your Cost | The amount that your study will be charged including any research discounts or service provider determined cost (override pricing). | pricing_maps.federal_rate/100 or pricing_maps.corporate_rate/100 or pricing_maps.member_rate/100 or pricing_maps.other_rate/100 or (admin_rates.admin_cost)/100 | SPARCCatalog Service Pricing Map or rate modified in ‘Your Cost’ on SPARCDashboard Admin Edit Clinical Services Tab | DECIMAL(12,4) INT(11) | |
14 | Subject | Total # of Participants per Arm | arms.subject_count | SPARCRequest Step 3 and SPARCDashboard Admin Edit Clinical Services Tab | INT(11) | |
15 | (Visit Name) | The number of times a service will occur for a given subject | visits.research_billing_qty | SPARCRequest Step 3 and SPARCDashboard Admin Edit Clinical Services Tab | BIGINT(20) | |
Non-clinical Services | ||||||
16 | Service Name | The name of the study level activity | services.name | SPARCCatalog Service Form | VARCHAR(255) | |
17 | Status | Communication indicator which displays progress, determined by service provider workflow. | sub_service_requests.status | SPARCDashboard Admin Edit Status Dropdown | VARCHAR(255) | |
18 | Service Rate | The fee associated to the study-level activity. | services.full_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) | |
19 | Your Cost | The amount that your study will be charged including any research discounts or service provider determined cost (override pricing). | pricing_maps.federal_rate/100 or pricing_maps.corporate_rate/100 or pricing_maps.member_rate/100 or pricing_maps.other_rate/100 or (admin_rates.admin_cost)/100 | SPARCCatalog Service Pricing Map or rate modified in ‘Your Cost’ on SPARCDashboard Admin Edit Non-Clinical Services Tab | DECIMAL(12,4) INT(11) | |
20 | Quantity | Quantity of service requested | line_items.quantity | SPARCRequest Step 3 and SPARCDashboard Admin Edit Non-Clinical Services Tab | INT(11) | |
21 | Quantity Type | Unit of measurement to describe the quantity amount (hours, each, slides, etc) | pricing_maps.quantity_type | SPARCCatalog Service Pricing Map | VARCHAR(255) | |
22 | Units per Quantity | Total units requested | line_items.units_per_quantity | SPARCRequest Step 3 and SPARCDashboard Admin Edit Non-Clinical Services Tab | DECIMAL(5,2) | |
23 | Unit Type | Unit of measurement to describe the category (i.e. weeks, days, samples, etc) | pricing_maps.unit_type | SPARCCatalog Service Pricing Map | VARCHAR(255) | |
24 | Total Per Study | The Total Cost per non-clinical service | N/A | N/A | Calculated Value | |
Copyright © 2011-2020 MUSC Foundation for Research Development