> ## Documentation Index > Fetch the complete documentation index at: https://docs.pricemedic.com/llms.txt > Use this file to discover all available pages before exploring further. # Rates Table > Negotiated rate data from transparency in coverage ## 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](#schedule_id) | string | Unique identifier for each fee schedule | | 2 | [schedule\_line\_id](#schedule_line_id) | string | Unique identifier for each rate line | | 3 | [billing\_code](#billing_code) | string | Procedure or service code | | 4 | [billing\_code\_type](#billing_code_type) | string | Code classification system (CPT, HCPCS, DRG, etc.) | | 5 | [billing\_code\_modifier](#billing_code_modifier) | array | Additional procedure modifier codes | | 6 | [billing\_class](#billing_class) | string | Professional or institutional billing | | 7 | [negotiated\_type](#negotiated_type) | string | Rate determination methodology | | 8 | [negotiation\_arrangement](#negotiation_arrangement) | string | Payment structure (FFS, capitation, bundle) | | 9 | [setting](#setting) | string | Care setting (inpatient, outpatient, both) | | 10 | [service\_code](#service_code) | array | Additional service classification codes | | 11 | [additional\_information](#additional_information) | string | Supplementary rate information | | 12 | [severity\_of\_illness](#severity_of_illness) | string | Severity or risk adjustment indicators | | 13 | [expiration\_date](#expiration_date) | string | Rate expiration date | | 14 | [name](#name) | string | Procedure or service name | | 15 | [description](#description) | string | Detailed procedure description | | 16 | [bundled\_code\_with\_type\_list](#bundled_code_with_type_list) | array | Codes bundled with primary billing code | | 17 | [negotiated\_rate](#negotiated_rate) | float | Negotiated dollar amount | | 18 | [source\_file\_ids](#source_file_ids) | array | Source transparency file identifiers | | 19 | [date\_key](#date_key) | string | Data snapshot date (Partition key) | | 20 | [network\_slug](#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:** ``` PM_SCHEDULE_10044RA3EFYLZ ``` ### 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:** ``` PM_SLINE_0001F_11UU6GW4KGZF2 PM_SLINE_0005F_ONXSK6YL4EM PM_SLINE_0012F_134PBWWI8WH0Q PM_SLINE_0014F_4IGB4FCC2D6 PM_SLINE_0015F_1VYCMDG17KX0V ``` ### 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:** ``` 0001F 0005F 0012F 0014F 0015F ``` ### 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 Terminology * `HCPCS` - Healthcare Common Procedure Coding System * `ICD` - International Classification of Diseases * `MS-DRG` - Medicare Severity Diagnosis Related Group * `APR-DRG` - All Patient Refined Diagnosis Related Group * `APC` - Ambulatory Payment Classification * `CDT` - Current Dental Terminology * `NDC` - National Drug Code * `HIPPS` - Health Insurance Prospective Payment System * `RC` - Revenue Code * `LOCAL` - Local or payer-specific code * `CSTM-ALL` - Custom or all-inclusive code **Example Values:** ``` CPT HCPCS MS-DRG ICD NDC ``` ### 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:** ``` [50, 62] [50, 80, AS] [26] [TC] [NU, RR, UE] [GP] [GN] [26, TC] [AU, AV, AW] [RR] ``` ### 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) **Example Values:** ``` professional institutional ``` ### 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 rate * `fee schedule` - Rate based on a predetermined fee schedule * `percentage` - Rate calculated as a percentage of a reference amount (e.g., percentage of Medicare) * `per diem` - Daily rate for services * `derived` - Rate derived or calculated from other rates **Example Values:** ``` negotiated fee schedule percentage per diem derived ``` ### 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 rendered * `capitation` - Fixed payment per patient or member, regardless of services provided * `bundle` - Bundled payment covering a group of related services **Example Values:** ``` ffs capitation bundle ``` ### 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 stay * `inpatient` - Services provided with an overnight hospital stay or admission * `both` - Rate applies to both inpatient and outpatient settings **Example Values:** ``` outpatient inpatient both ``` ### 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:** ``` [CSTM-00] ``` ### 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 of `9999-12-31` indicates that the rate has no expiration date and remains valid indefinitely or until updated. **Example Values:** ``` 9999-12-31 ``` ### 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:** ``` HEART FAILURE ASSESSED OSTEOARTHRITIS ASSESSED Community-aquired bacterial pn Comprehensive preoperative ass Melanoma follow up completed ( ``` ### 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:** ``` HEART FAILURE ASSESSED OSTEOARTHRITIS ASSESSED Community-aquired bacterial pneumonia assessed Comprehensive preoperative assessment performed fo r cataract surgery with intra Melanoma follow up completed (includes assessment of all of the following compon ``` ### 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 as `code|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:** ``` [0300|RC, 0301|RC, 0302|RC, 0303|RC, 0304|RC, 0305|RC, 0306|RC] [0300|RC, 0301|RC, 0303|RC, 0305|RC, 0306|RC, 0307|RC, 0309|RC] ``` ### 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:** ``` 75.0 100.0 0.0 ``` ### 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:** ``` [765] ``` ### date\_key **Type:** string\ **Partition:** 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:** ``` 2026-02-01 ``` ### network\_slug **Type:** string\ **Partition:** 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:** ``` 132_comprehensive_major_medical_network_cmmn_32R0 ```