IOCE Data API¶

Access and query the Integrated Outpatient Code Editor (IOCE) data tables.

Overview¶

The IOCE Data API provides read-only access to the 48 underlying data tables used by the CMS IOCE software. This includes reference tables for HCPCS, APCs, diagnosis codes, and various edit/mapping tables.

Base Path: /api/v1/ioce-data

Authentication: Required for all endpoints (Bearer token)

Endpoints¶

List Tables¶

List all available IOCE tables organized by category.

Endpoint: GET /ioce-data/tables

Response:

{
  "tables": {
    "Core Reference Tables": [
      {
        "name": "hcpcs_index",
        "db_table": "ioce_hcpcs_index",
        "description": "HCPCS code index for NCCI edits"
      },
      // ...
    ],
    // ...
  },
  "total_tables": 48
}

Get Table Data¶

Retrieve data from a specific IOCE table with pagination and filtering.

Endpoint: GET /ioce-data/tables/{table_name}

Path Parameters:

Parameter	Type	Required	Description
`table_name`	string	Yes	The name of the table (e.g., `data_hcpcs`)

Query Parameters:

Parameter	Type	Required	Description
`skip`	integer	No	Number of records to skip (default: 0)
`limit`	integer	No	Maximum records to return (default: 50, max: 1000)
`search`	string	No	Search term (searches across all text columns)
`effective_date`	string	No	Filter by effective date (YYYY-MM-DD)
`buffer`	string	No	Filter by buffer column value

Response:

Returns the table data along with column metadata.

{
  "table_name": "data_hcpcs",
  "columns": [
    { "name": "hcpcs", "type": "character varying", "nullable": false },
    // ...
  ],
  "data": [
    { "hcpcs": "00100", "si": "T", ... }
  ],
  "count": 15000
}

Get Table Columns¶

Get detailed column metadata for a specific IOCE table.

Endpoint: GET /ioce-data/tables/{table_name}/columns

Path Parameters:

Parameter	Type	Required	Description
`table_name`	string	Yes	The name of the table

Response:

Returns column definitions including types, nullability, and descriptions.

Search HCPCS¶

Search for a HCPCS code across multiple IOCE tables.

Endpoint: GET /ioce-data/search/hcpcs/{hcpcs_code}

Path Parameters:

Parameter	Type	Required	Description
`hcpcs_code`	string	Yes	The HCPCS code to search for

Response:

Returns a dictionary of tables containing the code and the matching records.

Get Stats¶

Get summary statistics for IOCE data.

Endpoint: GET /ioce-data/stats/summary

Response:

Returns record counts for all tables and version information.

Get NCCI Pairs¶

Get National Correct Coding Initiative (NCCI) code pairs.

Endpoint: GET /ioce-data/ncci-pairs

Query Parameters:

Parameter	Type	Required	Description
`code1`	string	No	Filter by Column 1 HCPCS code
`code2`	string	No	Filter by Column 2 HCPCS code
`version`	integer	No	Filter by OCE version number
`skip`	integer	No	Number of records to skip
`limit`	integer	No	Maximum records to return

Response:

Returns a list of NCCI code pairs with details.