Overview
The Rates table contains negotiated rate information extracted from payer transparency in coverage files.Table Columns
Each column in the Rates table is described below with examples of the data it contains.| # | Column Name | Type | Description |
|---|---|---|---|
| 1 | schedule_id | string | Unique identifier for each fee schedule |
| 2 | schedule_line_id | string | Unique identifier for each rate line |
| 3 | billing_code | string | Procedure or service code |
| 4 | billing_code_type | string | Code classification system (CPT, HCPCS, DRG, etc.) |
| 5 | billing_code_modifier | array | Additional procedure modifier codes |
| 6 | billing_class | string | Professional or institutional billing |
| 7 | negotiated_type | string | Rate determination methodology |
| 8 | negotiation_arrangement | string | Payment structure (FFS, capitation, bundle) |
| 9 | setting | string | Care setting (inpatient, outpatient, both) |
| 10 | service_code | array | Additional service classification codes |
| 11 | additional_information | string | Supplementary rate information |
| 12 | severity_of_illness | string | Severity or risk adjustment indicators |
| 13 | expiration_date | string | Rate expiration date |
| 14 | name | string | Procedure or service name |
| 15 | description | string | Detailed procedure description |
| 16 | bundled_code_with_type_list | array | Codes bundled with primary billing code |
| 17 | negotiated_rate | float | Negotiated dollar amount |
| 18 | source_file_ids | array | Source transparency file identifiers |
| 19 | date_key | string | Data snapshot date (Partition key) |
| 20 | network_slug | string | Standardized network identifier (Partition key) |
Column Descriptions
Detailed descriptions and examples for each column will be provided below.schedule_id
Type: string Unique identifier for each fee schedule in the system. This links the rate to a specific payer’s fee schedule file and corresponds to the schedule_id in the providers table. Example Values:schedule_line_id
Type: string Unique identifier for each individual rate line within a schedule. This identifies a specific negotiated rate entry and allows for precise referencing of individual rate records. Example Values:billing_code
Type: string The procedure or service code for which the rate is negotiated. This is typically a CPT (Current Procedural Terminology) code, HCPCS code, or other standardized medical billing code. Example Values:billing_code_type
Type: string The classification system or type of the billing code. Each value represents a specific medical coding standard used in healthcare billing. Possible Values:CPT- Current Procedural TerminologyHCPCS- Healthcare Common Procedure Coding SystemICD- International Classification of DiseasesMS-DRG- Medicare Severity Diagnosis Related GroupAPR-DRG- All Patient Refined Diagnosis Related GroupAPC- Ambulatory Payment ClassificationCDT- Current Dental TerminologyNDC- National Drug CodeHIPPS- Health Insurance Prospective Payment SystemRC- Revenue CodeLOCAL- Local or payer-specific codeCSTM-ALL- Custom or all-inclusive code
billing_code_modifier
Type: array An array of modifier codes that provide additional information about how a service or procedure was performed. Modifiers can affect reimbursement rates and indicate special circumstances such as bilateral procedures, multiple surgeons, assistants, or equipment rentals. Multiple modifiers can be applied to a single billing code. Example Values:billing_class
Type: string Indicates whether the rate applies to professional or institutional services. This field has only two possible values, each representing a distinct billing category. Possible Values:professional- Services billed by individual physicians or practitioners (typically uses CMS-1500 form)institutional- Services billed by hospitals or facilities (typically uses UB-04 form)
negotiated_type
Type: string Specifies the methodology used to determine the negotiated rate. This field has a limited set of values, each representing a distinct rate calculation method. Possible Values:negotiated- A directly negotiated fixed ratefee schedule- Rate based on a predetermined fee schedulepercentage- Rate calculated as a percentage of a reference amount (e.g., percentage of Medicare)per diem- Daily rate for servicesderived- Rate derived or calculated from other rates
negotiation_arrangement
Type: string Defines the payment arrangement structure between the payer and provider. This field has only three possible values, each representing a fundamental payment model. Possible Values:ffs- Fee-for-service, payment for each individual service renderedcapitation- Fixed payment per patient or member, regardless of services providedbundle- Bundled payment covering a group of related services
setting
Type: string Indicates the care setting where the service is provided. This field has three possible values representing different service delivery contexts. Possible Values:outpatient- Services provided without an overnight hospital stayinpatient- Services provided with an overnight hospital stay or admissionboth- Rate applies to both inpatient and outpatient settings
service_code
Type: array An array of service codes that may provide additional classification or categorization for the billing code. These codes can supplement the primary billing code with extra context about the service being provided. Example Values:additional_information
Type: string Optional field for any supplementary information about the negotiated rate. This field is typically null but may contain notes, clarifications, or special conditions related to the rate when provided by the payer.severity_of_illness
Type: string Field intended to capture severity of illness indicators or risk adjustment factors. This field is currently null across all records but may be populated in future data sets to reflect patient acuity or complexity levels.expiration_date
Type: string The date when the negotiated rate expires or is no longer valid. A value of9999-12-31 indicates that the rate has no expiration date and remains valid indefinitely or until updated.
Example Values:
name
Type: string The name or description of the procedure, service, or billing code. This provides a human-readable label for the billing code to help identify what service the rate applies to. Example Values:description
Type: string A more detailed description of the procedure or service. This typically provides additional context or a fuller explanation compared to the name field, though it may sometimes contain the same information. Example Values:bundled_code_with_type_list
Type: array An array of billing codes that are bundled together with the primary billing code. Each entry is formatted ascode|type where the code is the billing code value and the type indicates the code system (e.g., RC for Revenue Code). This identifies all component services included in a bundled rate.
Example Values:
negotiated_rate
Type: float The actual dollar amount of the negotiated rate for the service or procedure. This represents the reimbursement amount agreed upon between the payer and provider. A value of 0.0 may indicate rates that are not disclosed or are calculated using alternative methods. Example Values:source_file_ids
Type: array An array of identifiers referencing the original transparency in coverage files from which this rate data was extracted. This enables traceability back to the source payer files. Example Values:date_key
Type: stringPartition: 0 The date representing when the data was processed or loaded into the system. This field is used as a partition key for data organization and querying efficiency. Currently represents a single snapshot date for the available data set. Example Values:
network_slug
Type: stringPartition: 1 A standardized identifier for the insurance network. This slug is used for consistent referencing and filtering of network data across the system. The slug typically includes the payer identifier and network name. This field corresponds to the network_slug in the providers table and links rates to specific networks. Example Values: