---
title: Horizontal Frac
slug: horizontal-frac
docTags: 
createdAt: 2025-03-24T14:53:38.900Z
---

The Horizontal Frac table provides details about unconventional horizontal fracture completions, for use in comparative analysis between wells.

The unique constraint on horizontal frac entries is **uwi + date** — re-posting the same well and date upserts the existing record.

| **Variable**            | **Data Type**   | **Unit of Measure** | **Is Nullable?** | **Default Value** | **Description**                                                                                                        |
| ----------------------- | --------------- | ------------------- | ---------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------- |
| uwi                     | String          | -                   | No               | -                 | Unique Well Identifier. Must match the uwi of a record in the [Well](docId\:P-xHbe4jqKJQemay7aOL5) table.              |
| date                    | DateTime Offset | -                   | No               | -                 | Frac job date. Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000                   |
| averageEffectiveSpacing | Double          | ft                  | Yes              | -                 | Average distance to offset wells at the time of completion                                                             |
| minEffectiveSpacing     | Double          | ft                  | Yes              | -                 | Distance to the closest offset well at the time of completion                                                          |
| type                    | String          | -                   | Yes              | -                 | Completion type (Plug-n-perf, sliding sleeve, etc). It is important to standardize values to enable grouped analysis.  |
| fluidType               | String          | -                   | Yes              | -                 | Completion fluid type (X-link Gel, Slickwater, etc). It is important to standardize values to enable grouped analysis. |
| stimulatedLength        | Double          | ft                  | Yes              | -                 | Total length of the stimulated lateral                                                                                 |
| stages                  | Int             | -                   | Yes              | -                 | Number of stages in the frac job                                                                                       |
| totalFluid              | Double          | bbl                 | Yes              | -                 | Total fluid used in the frac job                                                                                       |
| totalProppant           | Double          | lb                  | Yes              | -                 | Total proppant used in the frac job                                                                                    |
| perforationCount        | Int             | -                   | Yes              | -                 | Total perforation count in the frac job                                                                                |
| stageSpacing            | Double          | ft                  | Yes              | -                 | Stage spacing in the frac job                                                                                          |

***

# Data Integrity Checks

| **Condition**                        | **Response**    |
| ------------------------------------ | --------------- |
| uwi is NULL or empty                 | Record Rejected |
| uwi does not exist in the Well table | Record Rejected |
| date is NULL                         | Record Rejected |

***

# Common Error Messages

| **API**           | **Scenario** | **Error Response**              |
| ----------------- | ------------ | ------------------------------- |
| Add / Upsert frac | Unknown UWI  | well was not found with uwi xxx |