Data Schema
Well

Horizontal Frac

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

Variable

Data Type

Unit of Measure

Is Nullable?

Default Value

Description

uwi

String

-

No

-

Unique well identifier. Must match the UWI from the Well 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 time of completion

minEffectiveSpacing

Double

ft

Yes

-

Distance to the closest offset 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 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



Updated 24 Mar 2025
Doc contributor
Did this page help you?