/
Service Pricing Report Data Dictionary (SPARCRequest v3.12.1)

SPARCRequest Wiki

Service Pricing Report Data Dictionary (SPARCRequest v3.12.1)

Data Dictionary

No.

Column Name

Description

Database Name

Source

Type

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