SPARCRequest Wiki
Service Pricing Report Data Dictionary (SPARCRequest v3.13.0)
Report of service prices, with options to include Rate Types, Pricing Map Display and Effective Dates and Additional Codes (e.g., CPT, Revenue, Order, EAPID)
Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | Institution | The institution where the service is being provided (Level 1) | organizations.name | SPARCCatalog, institution to which the service belongs to | VARCHAR(255) |
2 | Provider | The entity providing the service (Level 2) | organizations.name | SPARCCatalog, provider to which the service belongs to | VARCHAR(255) |
3 | Program | The program where the service is being provided (Level 3) | organizations.name | SPARCCatalog, program to which the service belongs to | VARCHAR(255) |
4 | Core | The core where the service is being provided (Level 4) | organizations.name | SPARCCatalog, core to which the service belongs to | VARCHAR(255) |
5 | Service | The name of the procedure or study level activity | services.name | SPARCCatalog Service Form | VARCHAR(255) |
6 | Service Status | Whether a service is displayed in SPARCRequest | services.is_available | SPARCCatalog Service Form, "Display in SPARC" switch | VARCHAR(255) |
7 | CPT Code | Current Procedural Terminology code; standardized alphanumeric procedure codes used to report services and bill | services.cpt_code | SPARCCatalog Service Form Epic Interface table | VARCHAR(255) |
8 | Revenue Code | Code for location-specific revenue to be collected | services.revenue_code | SPARCCatalog Service Form Epic Interface table | VARCHAR(255) |
9 | Order Code | Order code associated with specific service | services.order_code | SPARCCatalog Service Form Epic Interface table | VARCHAR(255) |
10 | EAP ID | Epic Procedure Code | services.eap_id | SPARCCatalog Service Form Epic Interface table | VARCHAR(255) |
11 | Full Rate | The fee associated to the procedure or study level activity | services.full_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) |
12 | Federal Rate | The fee associated to the procedure or study level activity with the federal discount included | services.federal_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) |
13 | Corporate Rate | The fee associated to the procedure or study level activity with the Corporate discount included | services.corporate_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) |
14 | Other Rate | The fee associated to the procedure or study level activity with the manually entered discount included | services.other_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) |
15 | Member Rate | The fee associated to the procedure or study level activity with the member discount included | services.member_rate | SPARCCatalog Service Form Pricing section: current effective Pricing Map | DECIMAL(12,4) |
16 | Pricing Map Display Date | Date when a pricing setup is displayed in SPARCRequest | pricing_maps.display date | SPARCCatalog Service Form Pricing section: current effective Pricing Map Display Date | DATE |
17 | Pricing Map Effective Date | Date when a pricing setup goes into effect in SPARCRequest | pricing_maps.effective_date | SPARCCatalog Service Form Pricing section: current effective Pricing Map Effective Date | DATE |
Sample Report
Copyright © 2011-2025 MUSC Foundation for Research Development