Data model
How the NOVI_WELLS views are grouped, what one row means in each, and how they join.
Novi UDM Data uses one data model, Novi’s Unified Data Model (UDM). Two keys connect almost everything: WELL_KEY for wells and WELLBORE_KEY for wellbores.
Reference lists such as operators have their own IDs, for example OPERATOR_ID.
The core rule: wells and wellbores
Section titled “The core rule: wells and wellbores”WELLhas one row per well.WELLBOREhas one row per wellbore.WELL1:NWELLBOREonWELL_KEY.- Production, completions, well tests, spacing, forecasts, and frac chemistry are recorded per wellbore and join on
WELLBORE_KEY. - If you join wellbore data to a well and add it up per well, check that you do not count the same volume twice.
Base views by domain
Section titled “Base views by domain”| Domain | View | One row per | Key |
|---|---|---|---|
| Wells and wellbores | WELL |
Well | WELL_ |
WELLBORE |
Wellbore (lateral, sidetrack, or re-entry) | WELLBORE_ |
|
SURFACE_ |
Surface location record of a well | SURFACE_ |
|
WELLBORE_ |
Wellbore, as a WKT LineString | TRAJECTORY_ |
|
DIRECTIONAL_ |
Survey station along a wellbore, ordered by measured depth | SURVEY_ |
|
| Production and tests | PRODUCTION |
Wellbore and period, monthly or weekly | WELLBORE_ + period |
WELL_ |
Well, carried on its lowest-sequence wellbore: reported roll-ups and forecast EUR | WELL_ |
|
WELL_ |
Wellbore and test date | WELL_ |
|
| Completion and stimulation | WELL_ |
Completion event of a wellbore | WELL_ |
FRAC_ |
FracFocus disclosure (wellbore and frac sequence number) | FRAC_ |
|
FRAC_ |
Ingredient of a disclosure | FRAC_ |
|
| Forecasts | PRODUCTION_ |
Wellbore, forecast period, and scenario | PRODUCTION_ groups one forecast’s rows |
PRODUCTION_ |
Arps segment of one stream of a wellbore | SEGMENT_ |
|
PRODUCTION_ |
Parameter set of a segment | SEGMENT_ |
|
SUPPLY_ |
County, production-start month, and month on production | SUPPLY_ |
|
| Spacing and subsurface | WELL_ |
Wellbore | WELL_ |
WELL_ |
Basin and subbasin | WELL_ |
|
SUBSURFACE_ |
Measurement point along a wellbore | SUBSURFACE_ |
|
| Permits and well events | PLANNED_ |
Public permit filing | PLANNED_ |
WELL_ |
Permit filing of a wellbore | PERMIT_ + WELLBORE_ |
|
WELL_ |
Lifecycle event of a well or wellbore | WELL_ |
|
| Acreage | COMPANY_ |
Leasehold parcel | COMPANY_ |
| Market and activity | RIG_ |
State, county, basin, and subbasin in an ISO week | RIG_ |
RIG_ |
Rig or frac fleet observation on an activity date | RIG_ |
|
PRICE_ |
Week, dated the Friday | PRICE_ |
|
| Reference lists | OPERATOR |
Company | OPERATOR_ |
OPERATOR_ |
Operator registration or presence in a jurisdiction | OPERATOR_ |
|
BASIN |
Basin and subbasin | BASIN, SUBBASIN |
|
SOURCE |
Data lineage record | SOURCE_ |
Every base view has SOURCE_ID, which joins to SOURCE and tells you which dataset a row came from.
Relationships
Section titled “Relationships”| From | Join on | To | Notes |
|---|---|---|---|
WELLBORE |
WELL_ |
WELL |
One well, many wellbores |
WELL |
OPERATOR_ |
OPERATOR |
Current operator of record |
SURFACE_ |
WELL_ |
WELL |
At most one row per well |
WELLBORE_, DIRECTIONAL_, WELL_, WELL_, WELL_, FRAC_, PRODUCTION, WELL_, PRODUCTION_, SUBSURFACE_ |
WELLBORE_ |
WELLBORE |
Wellbore-grain data |
PRODUCTION |
OPERATOR_ |
OPERATOR |
Operator of record for that period, not today’s operator |
SUBSURFACE_ |
SURVEY_ |
DIRECTIONAL_ |
Only rows with survey coverage |
FRAC_ |
FRAC_ |
FRAC_ |
Ingredients of one disclosure |
PRODUCTION_ |
PRODUCTION_ |
PRODUCTION_ |
Returns every month of that forecast |
PRODUCTION_ |
FORECAST_ = SEGMENT_ |
PRODUCTION_ |
Decline parameters of a segment |
WELL_ |
WELLBORE_, OPERATOR_ |
WELLBORE, OPERATOR |
Key is PERMIT_ + WELLBORE_ |
WELL_ |
WELL_, WELLBORE_ |
WELL, WELLBORE |
Well-level events have a NULL WELLBORE_ |
WELL_ |
PERMIT_ + WELLBORE_ |
WELL_ |
Join on both columns |
PLANNED_ |
MATERIALIZED_ = WELL_ |
WELL |
Set once the permitted well has been drilled |
PLANNED_, COMPANY_, OPERATOR_, RIG_ |
OPERATOR_ |
OPERATOR |
|
| Every base view | SOURCE_ |
SOURCE |
Lineage |
Views that join on shared columns
Section titled “Views that join on shared columns”These views share no key with the others. Combine them on the columns listed.
| View | Join on | How to use it |
|---|---|---|
BASIN |
BASIN, SUBBASIN |
Every view keyed by a well or wellbore carries BASIN and SUBBASIN, so filter on them directly |
PRICE_ |
DATE |
Prices are dated the Friday of each week. Match a date to the Friday of its week |
RIG_ |
COUNTY_, YEAR, WEEK |
Join to WELL on COUNTY_, the five-digit FIPS code. A county that spans basins has a row per basin, so sum by county and week first |
SUPPLY_ |
COUNTY_, MONTH_, MONTHS_ |
Join to WELL on COUNTY_, then pick the start month and month on production you need |
WELL_ |
BASIN, SUBBASIN |
The search radii and cutoffs behind a wellbore’s spacing values |
Presentation views
Section titled “Presentation views”The presentation views join base views for you. Where a value appears in both, the base view is authoritative. Their columns can change between releases as they are extended.
| View | One row per | Other keys |
|---|---|---|
WELL_ |
WELLBORE_ |
WELL_, OPERATOR_, PERMIT_, WELL_, WELL_ |
WELLBORE_ |
WELLBORE_ |
WELL_, OPERATOR_, PERMIT_ |
WELLBORE_ |
WELLBORE_ |
WELL_ |
WELLBORE_ |
WELLBORE_ |
None |
WELLBORE_ |
WELLBORE_, PRODUCTION_, PRODUCTION_, SEGMENT_ |
SEGMENT_, SEGMENT_ |
WELLBORE_ |
WELLBORE_ |
WELL_ |
WELLBORE_ |
WELLBORE_, LOCATION_, FORMATION |
SUBSURFACE_, SURVEY_ |
WELLBORE_ |
WELLBORE_, TEST_ |
WELL_ |
PRODUCTION_ |
WELLBORE_, YEAR, MONTH |
None |
PRODUCTION_ |
WELLBORE_, SCENARIO, YEAR, MONTH |
PRODUCTION_ |
WELL_DETAIL is the composition of WELLBORE_HEADER, WELLBORE_PRODUCTION_SUMMARY, WELLBORE_COMPLETION_DESIGN, and WELLBORE_SPACING_DETAIL.
The narrow views are not cheaper than WELL_DETAIL. They are just narrower to read.
Rules that keep numbers right
Section titled “Rules that keep numbers right”| Rule | Why |
|---|---|
Filter PRODUCTION and PRODUCTION_ on PERIOD_ |
PRODUCTION holds monthly and weekly rows; without the filter, totals count the same volume twice. PRODUCTION_ ships monthly rows only today; keep the filter so the query stays right if other granularities ship |
Collapse PRODUCTION to one row per wellbore and month before windowed math |
The view does not guarantee a single row per wellbore, year, and month |
Align wells on MONTHS_, not on date |
It counts calendar months from first production, starting at 1, including shut-in months |
| Check a well has month 1 before a fixed window such as months 1 to 60 | A few wells have no early records and start at 2 or later |
| Never add ratios such as GOR, WOR, or proppant per foot | Compute them per well or well-month, then average |
| Read percentage columns as fractions | 0.18 means 18% |
Never add EUR_ columns across horizons |
The 20, 30, and 50-year EUR columns overlap |
Count wells with COUNT(DISTINCT WELL_ |
One well can have several wellbores |
Name only the columns you need and filter on WELLBORE_, date, and granularity |
PRODUCTION has hundreds of millions of rows |
Units and conventions
Section titled “Units and conventions”- Volumes: oil, condensate, NGL, and water in barrels (bbl). Gas in thousand cubic feet (Mcf).
- BOE: 6 Mcf of gas = 1 barrel of oil equivalent.
- Depths and lengths: feet.
- Coordinates: decimal degrees, WGS 84 (EPSG:4326).
- Production streams on forecast segments:
oil,gas,water,ngl,condensate. - Forecast scenarios: this release publishes
P50, the median forecast, only.
See All views for every column, its type, and its unit.