SPARCRequest Wiki
Service Pricing Report Data Dictionary (SPARCRequest v3.12.1)
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 Display | 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-2020 MUSC Foundation for Research Development