Skip to content
Developers
Get an API token

Presentation views

Ten ready-joined views with one row per wellbore, month, test, or decline segment.

View MarkdownOpen in Claude(opens in a new tab)

These views join the base views for you, so the most common questions need no joins. Where a value appears both here and in a base view, the base view is authoritative. Their columns can change between releases as they are extended.

Views live in NOVI_DATA_ACCESS.NOVI_WELLS. Column descriptions are from the Wells data dictionary, release 26.4.3.

125 columns

Wide one-row-per-wellbore reporting view: the composition of WELLBORE_HEADER, WELLBORE_PRODUCTION_SUMMARY, WELLBORE_COMPLETION_DESIGN and WELLBORE_SPACING_DETAIL.

More about this view

Grain: one row per wellbore_key. Every column is defined by the narrow view it comes from.

Grain
one row per wellbore_key.
Key columns
Sample query
SELECT WELLBORE_KEY, WELL_KEY, NATIVE_ID, OPERATOR_ID, PERMIT_ID
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_DETAIL
LIMIT 10
Columns125
WELL_KEY
Foreign key to well.well_key, linking this wellbore to its parent well.
NATIVE_ID
Wellbore-level identifier.
More

For regulatory schemes (API10/API14/UWI-DLS) this is the external regulatory id, API14 captures the sidetrack/event suffix (positions 11-14) that disambiguates per-wellbore borehole+event; the well-level well.native_id carries the well-level root (API10 for US, UWI-DLS for Canada). Use the contiguous 14-digit API14 (digits only, no hyphens). For the PLANNED scheme (planned wellbores with no regulatory id yet) this is the Novi-internal id (the planned_well_id). The scheme is named by native_id_type, which conditionally validates this value's canonical format per scheme; this value is the third component of wellbore_key.

OPERATOR_ID
Current operator of record.
More

Historical changes should be captured as events (e.g., OPERATOR_CHANGE) or in a dedicated attribute history.

PERMIT_ID
Regulatory permit identifier as issued by the state/agency.
More

Primary key for the permit record.

WELL_COMPLETION_ID
Surrogate key of the completion event this row collapsed to, the first completion.
More

Carried so a consumer can trace back to the source row and audit the collapse.

WELL_SPACING_ID
Surrogate key.
NATIVE_ID_TYPE
Identifier scheme of native_id (API10, API14, UWI-DLS, or PLANNED).
More

API14 when a borehole/event suffix is available, otherwise API10 (e.g. single-wellbore wells or API10-only sources), UWI-DLS in Canada, or PLANNED for planned wellbores with no regulatory identifier yet. Second component of wellbore_key.

COUNTRY
Two-letter ISO 3166-1 alpha-2 country code where the wellbore is located (e.g., US, CA).
More

First component of wellbore_key; matches the parent well.country.

SEQUENCE_NUMBER
Ordinal distinguishing wellbores that share a native_id, part of the conformed identity (native_id + native_id_type + country + sequence_number).
More

It is 0 on every row in current data, no native_id yet resolves to more than one wellbore, and is retained because the identity is only unique with it.

WELL_NAME
Human-friendly well name (operator or regulatory naming).
More

Use for display; not a key.

FIELD_NAME
Name of the oil/gas field the well is in.
STATE
US state (USPS two-letter) or Canadian province/territory (Statistics Canada two-letter) code where the well is located.
COUNTY
Name of the county (or parish in Louisiana) where the well is located, as reported (e.g., "Reeves"); a name, never a code.
More

The FIPS code is in COUNTY_CODE. NULL when not reported.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
FORMATION
Canonical formation name used for analytics grouping.
More

Represents Novi's best estimate of the landing zone formation.

FORMATION_REPORTED
Formation name as reported by the data source (raw regulatory filing string).
FORMATION_REPORTED_NORMALIZED
Source-reported formation mapped to a controlled vocabulary.
FORMATION_CALCULATED
Novi-calculated formation based on wellbore geometry and formation tops (structural depth grids).
More

Used as the standard grouping key for peer comparison.

CURRENT_OPERATOR
Operator of record for this wellbore's well as of today, resolved to the canonical operator name, which is stored unmodified and may carry padding.
More

Use this for grouping peers; never group on a raw reported name.

WELL_STATUS
Current coarse lifecycle state of the well (derived from events).
More

Includes 7 milestone-based values and 9 regulatory/operational ones; semantic overlaps (e.g. PERMITTED/PERMIT_APPROVED, DRILLING/SPUD, PRODUCING/ACTIVE, SHUT_IN/INACTIVE) are deliberately preserved as distinct values so you can tell which source vocabulary a row came from. Details live in well_event.

WELLBORE_STATUS
Current lifecycle state for the wellbore (can differ from the well-level status).
WELLBORE_STATUS_REPORTED
Raw reported wellbore status value from the regulator filing, at wellbore grain (analogous to well.status_reported but for a specific lateral / sidetrack / re-entry).
More

Independent input from well.status_reported, wellbore status can differ from well status.

WELLBORE_STATUS_REPORTED_NORMALIZED
Reported wellbore status mapped to a controlled vocabulary, at wellbore grain (analogous to well.status_reported_normalized).
More

Distinct from wellbore.status (Novi-curated lifecycle enum); the reported/normalized pair preserves provenance for audit.

WELLBORE_TYPE_NORMALIZED
What the wellbore does: its declared operational function, from a controlled vocabulary (PRODUCER, INJECTOR, DISPOSAL, CYCLIC, STORAGE, OBSERVATION_TEST, and drainage and thermal-recovery roles).
More

It is the declared function, not current activity: a plugged or shut-in producer stays PRODUCER, so use WELLBORE_STATUS for activity. What the wellbore produces or handles is on PRIMARY_STREAM. Functions other than PRODUCER come only from a recognised filed code in WELLBORE_TYPE_REPORTED; without one (for example, every Texas wellbore) the value is PRODUCER or NULL, so counts of injection, disposal or storage wells are incomplete there. NULL when the source does not establish a function, for example a dry hole (PRIMARY_STREAM = DRY) or a service well whose filing does not say which service.

WELLBORE_TYPE_REPORTED
The well-type code the source supplies for the regulator filing, trimmed and otherwise as filed.
More

Codes, case and spelling vary by jurisdiction; they are not a controlled vocabulary. NULL where the source supplies no code (currently all Texas wellbores and most in Kansas and West Virginia). WELLBORE_TYPE_NORMALIZED and PRIMARY_STREAM use this code where it is recognised and a coarser classification otherwise, so they can hold a value when this column is NULL.

PRIMARY_STREAM
What the wellbore produces or handles, as declared, from a controlled vocabulary (OIL, GAS, OIL_AND_GAS, WATER, BRINE, WASTE, HELIUM, CO2, STEAM, BITUMEN, LITHIUM, POTASH, CBM, POLYMER, SOLVENT, AIR, ACID_GAS, DRY).
More

Pairs with WELLBORE_TYPE_NORMALIZED: GAS on a STORAGE or DISPOSAL wellbore is gas stored or disposed of, not produced. For gas producers use WELLBORE_TYPE_NORMALIZED = 'PRODUCER' AND PRIMARY_STREAM IN ('GAS', 'OIL_AND_GAS', 'CBM'); OIL_AND_GAS is a compound value, and coalbed methane wells currently carry GAS. Declared purpose, not observed production: a well declared for oil stays OIL while it dewaters, and the value asserts nothing about volumes. DRY appears only where a filed code classifies the bore as a dry hole, and then WELLBORE_TYPE_NORMALIZED is NULL. NULL when the source does not establish a stream.

DIRECTION
Novi's resolved well slant: the first of these that applies.
More

U_TURN_HORIZONTAL when the calculated slant is a U-turn; HORIZONTAL when a directional survey not marked as planned shows a horizontal path; the normalized reported (filed) slant; the calculated slant. For a well whose survey-based resolution is not available, the survey step is skipped and the filed slant comes first. The filed wording is in DIRECTION_REPORTED.

DIRECTION_REPORTED
Raw reported slant/direction value from the state regulatory agency (e.g., "Horizontal", "Directional").
DIRECTION_REPORTED_NORMALIZED
State-reported direction after normalization to a controlled vocabulary.
DIRECTION_CALCULATED
Slant that Novi infers from evidence other than the filed slant, such as the wellbore trajectory.
More

It is derived, not filed.

MD_TD
Measured depth at TD in feet.
TVD_TD
True vertical depth at TD in feet.
KB_ELEVATION
Kelly bushing elevation in feet above sea level.
SURFACE_LATITUDE
Surface hole latitude in decimal degrees, from the well's CURRENT surface location, the latest surveyed row per the collapse rule, not an arbitrary one.
SURFACE_LONGITUDE
Surface hole longitude in decimal degrees, from the well's CURRENT surface location, see the collapse rule.
CRS
Coordinate reference system for the latitude and longitude columns on this row, as an EPSG code.
More

Every populated row reads 'EPSG:4326' (WGS 84), so coordinates need no reprojection before use; the column is NULL where no coordinate is available.

HEELPOINT_LATITUDE
Latitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS.
HEELPOINT_LONGITUDE
Longitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS.
LANDING_POINT_LATITUDE
Latitude of the landing point in decimal degrees, WGS84.
LANDING_POINT_LONGITUDE
Longitude of the landing point in decimal degrees, WGS84.
MIDPOINT_LATITUDE
Latitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS.
MIDPOINT_LONGITUDE
Longitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS.
BOTTOM_HOLE_LATITUDE
Latitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS.
BOTTOM_HOLE_LONGITUDE
Longitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS.
SPUD_DATE
Date drilling began on this wellbore: the earliest SPUD event for the wellbore in WELL_EVENT (EVENT_DT, else EFFECTIVE_DT), truncated to a date in UTC.
More

WELL_EVENT is the only source; NULL where it has no SPUD event for the wellbore.

TD_DATE
Date total depth was reached.
More

Same rule as SPUD_DATE. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event_dt is optional on the ledger so effective_dt is the fallback, and the date-time is truncated in UTC.

COMPLETION_DATE
Date the wellbore was completed.
More

Two sources: pivot from the well_event ledger (event_type = COMPLETED), else the first completion's well_completion.completion_end_date. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event_dt is optional on the ledger so effective_dt is the fallback, and the date-time is truncated in UTC.

FIRST_PRODUCTION_DATE
Date of first reported production (turn-in-line): the earliest TIL event for the wellbore in WELL_EVENT (EVENT_DT, else EFFECTIVE_DT), truncated to a date in UTC.
More

WELL_EVENT is the only source; NULL where it has no TIL event for the wellbore.

PA_DATE
Date the wellbore was plugged and abandoned.
More

Same rule as SPUD_DATE. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event_dt is optional on the ledger so effective_dt is the fallback, and the date-time is truncated in UTC.

PROPOSED_TVD
Proposed true vertical depth as declared in the permit application, in feet.
More

The as-built value is wellbore.tvd_td once drilled.

CUM_OIL_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Oil volume accumulated through the twelfth month on production. It may include condensate. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_OIL_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Oil volume accumulated through the twenty-fourth month on production. It may include condensate. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_OIL_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Oil volume over the well's full reported history. It may include condensate. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_GAS_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Gas volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_GAS_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Gas volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_GAS_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Gas volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_WATER_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Water volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_WATER_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Water volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_WATER_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Water volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_BOE_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_BOE_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_BOE_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

PEAK_MONTH_OIL_INDEX
Index on the months-on-production axis of the month in which combined oil and condensate volume peaked.
More

The peak is selected on the combined volume, so on a condensate-rich well this can name a different month than an oil-only peak would. Ties resolve to the earliest such month. Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_OIL_AMOUNT
Combined oil and condensate volume in that peak month.
More

A volume, not a rate. Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_GAS_INDEX
Index on the months-on-production axis of the month in which gas volume peaked.
More

Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_GAS_AMOUNT
Gas volume in that peak month.
More

Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_WATER_INDEX
Index on the months-on-production axis of the month in which water volume peaked.
More

Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_WATER_AMOUNT
Water volume in that peak month.
More

Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_BOE_INDEX
Index on the months-on-production axis of the month in which barrel-of-oil-equivalent volume peaked.
More

The monthly BOE this peak is selected on is oil and gas at 6 Mcf = 1 BOE and EXCLUDES condensate, unlike the cumulative BOE columns, which include it, so on a condensate-rich well the peak month can differ from the one a condensate-inclusive BOE would select. Non-additive. Null when no month carried a positive total: a zero maximum is not a peak.

PEAK_MONTH_BOE_AMOUNT
Barrel-of-oil-equivalent volume in that peak month, as oil and gas at 6 Mcf = 1 BOE.
More

EXCLUDES condensate and NGL, a narrower basis than the cumulative BOE columns, which include condensate. Non-additive across wellbores. Null when no month carried a positive total: a zero maximum is not a peak.

CUM_LIFE_GOR
Life-to-date producing gas-oil ratio: life gas over life liquid, where the liquid denominator is the oil that cum_oil_life_reported carries, which may include condensate.
More

Null when that liquid total is zero, so a gas-only well has no value here rather than an infinite one. Rounded to two decimal places. NON-ADDITIVE, never sum or average across wellbores; recompute from the underlying volumes. Recomputing it needs cum_gas_life_reported and cum_oil_life_reported, which are not guaranteed present on the same row.

LAST_REPORTED_MONTHS_ON_PRODUCTION
Index on the months-on-production axis of the last month with reported production.
More

An index, not a count: it identifies a month, it does not total them. Reported rather than derived from the monthly production fact, and not guaranteed to agree with an index computed from it. Non-additive.

LAST_REPORTED_MONTH
First day of the last month in which the well reported a positive combined volume of oil, condensate, gas, flared gas and water.
More

A month whose volumes are all zero or unreported does not count, so a well that has gone to zero carries the last month before it did. Reported rather than derived from the monthly production fact, and not guaranteed to equal a month computed from it. Non-additive. Null when no month qualifies.

COMPLETION_SEQUENCE
Ordinal of the completion within the wellbore, ascending.
More

This view is first-completion grain, so it is 1 on every row; recompletions and re-fracs are not projected here.

COMPLETION_STATE
Completion lifecycle state (derived from events or operational tracking).
COMPLETION_END_DATE
Date completion operations ended (if known).
PROPPANT_MASS
Total proppant mass injected during completion.
FLUID_VOLUME
Total completion fluid volume injected, in gallons.
STAGE_COUNT
Number of frac stages completed.
More

Omit the field when the stage count is unknown. Do not store 0 for unknown, 0 is not a valid stage count.

PERFORATION_UPPER
Shallowest perforation depth (MD) in feet.
PERFORATION_LOWER
Deepest perforation depth (MD) in feet.
PERFORATION_INTERVAL
Perforation interval length in feet (perforation_lower - perforation_upper).
PROPPANT_LOADING
Proppant mass per foot of lateral, computed by Novi rather than from columns in this view.
More

Non-additive ratio, never sum across wellbores. Its denominator is the selected lateral length, LATERAL_LENGTH in this view, with its method in LATERAL_LENGTH_SOURCE; the ratio need not equal PROPPANT_MASS / LATERAL_LENGTH on every row. A peer-set figure is an average of ratios rather than a ratio of totals. Values above 9,000 lb/ft are nulled as physically impossible rather than clamped, so a NULL can mean no credible ratio exists for the well even when PROPPANT_MASS is present. Also NULL when Novi's selected lateral length for the well is unknown or zero. That nulling is the guarantee this column carries: the denominator is chosen per well from perforations, survey points or depth, and falls back to a surface-to-bottom-hole distance, so it is not a single stated method.

PROPPANT_CONCENTRATION
Proppant mass per gallon of completion fluid, slurry concentration, independent of lateral length, computed by Novi rather than from columns in this view.
More

Non-additive ratio, never sum across wellbores. NULL when proppant mass or fluid volume is unknown or zero, and when the ratio exceeds 8 lb/gal, which Novi treats as not credible; values above 8 are nulled, not clamped. Rounded to 2 decimal places.

STAGE_SPACING
Average distance between frac stages of the first completion, in feet: the lateral length Novi selected for the well divided by the first completion's stage count.
More

Non-additive ratio, never sum across wellbores. That lateral length is LATERAL_LENGTH in this view, with its method in LATERAL_LENGTH_SOURCE; the value need not equal LATERAL_LENGTH divided by STAGE_COUNT on every row. NULL when the stage count is zero or that lateral length is unknown. Whole feet. No bounds are applied, so implausibly large or small values (a few under 20 ft) are possible and are published as computed.

IS_CHILD
True if this well is classified as a child well (drilled after nearby parent wells were producing).
PARENT_COUNT
Number of neighboring parent wells meeting spacing criteria.
PARENT_DAYS_ONLINE
Days the nearest parent well was online relative to this well's start.
CLOSEST_WELL_XY
XY distance to the closest lateral and staggered neighbor in feet.
More

Non-additive.

CLOSEST_TWO_AVG_XY
Average XY distance to the two closest neighbors (includes staggered and stacked).
More

Non-additive.

WELLS_IN_RADIUS
Count of all wells within the neighbor distance radius.
WELLS_IN_RADIUS_AVG_XY
Total wells in radius converted to a distance = 2 * MaxNeighborDistance / (1 + WellsInRadius).
More

Non-additive.

LATERAL_CLOSER_XY
XY distance to the nearest well in the same lateral row.
More

Non-additive.

STAGGER_CLOSER_TANGENT
Tangent distance to the nearest staggered well.
More

Non-additive.

STACK_CLOSER_Z
Vertical distance to the nearest well in the same vertical stack.
More

Non-additive.

BOUNDEDNESS_SCORE
Number of neighbor quadrants occupied by wells (0-8).
More

Non-additive.

LATEST_OIL_GRAVITY
Most recent oil API gravity reported for the well this wellbore belongs to, in degrees API.
More

Oil and gas gravities are reported independently and may come from different tests. NULL when none is reported.

LATEST_OIL_GRAVITY_TEST_DATE
Date of the latest well test, on any wellbore of the well, that reports an oil gravity: the test behind LATEST_OIL_GRAVITY.
More

NULL together with it.

LATEST_GAS_GRAVITY
Most recent gas specific gravity reported for the well this wellbore belongs to (air = 1.0).
More

Not necessarily from the same test as LATEST_OIL_GRAVITY. NULL when none is reported.

LATEST_GAS_GRAVITY_TEST_DATE
Date of the latest well test, on any wellbore of the well, that reports a gas specific gravity: the test behind LATEST_GAS_GRAVITY.
More

NULL together with it.

SOAK_TIME_DAYS
Number of days between the end of the first completion and the start of production (the soak period).
More

NULL when the span is zero or negative, longer than 365 days, or shorter than 30 days where the first-production date is not known accurately. Do not sum across wellbores.

EUR_OIL_20YR
Forecast estimated ultimate recovery of oil through the first 20 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_20YR
Forecast estimated ultimate recovery of gas through the first 20 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_20YR
Forecast estimated ultimate recovery of water through the first 20 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_20YR
Forecast estimated ultimate recovery through the first 20 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

EUR_OIL_30YR
Forecast estimated ultimate recovery of oil through the first 30 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_30YR
Forecast estimated ultimate recovery of gas through the first 30 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_30YR
Forecast estimated ultimate recovery of water through the first 30 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_30YR
Forecast estimated ultimate recovery through the first 30 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

EUR_OIL_50YR
Forecast estimated ultimate recovery of oil through the first 50 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_50YR
Forecast estimated ultimate recovery of gas through the first 50 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_50YR
Forecast estimated ultimate recovery of water through the first 50 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_50YR
Forecast estimated ultimate recovery through the first 50 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

OPERATOR_REPORTED
The well's current operator as reported for the well: a name, not resolved to an OPERATOR row (OPERATOR_ID carries the resolved operator).
More

May hold a placeholder where no operator is assigned. A current value, not a history. NULL where no operator is reported.

OPERATOR_ORIGINAL
The well's operator as of first production: a name, not resolved to an OPERATOR row.
More

It does not change when the well later changes operator. NULL where no original operator is recorded.

LATERAL_LENGTH
Selected lateral length in feet: a manual override where one exists, otherwise the first populated of LATERAL_LENGTH_CALCULATED_U_TURN, LATERAL_LENGTH_CALCULATED_PERF, LATERAL_LENGTH_CALCULATED_LP_TO_BHL, LATERAL_LENGTH_CALCULATED_KP_TO_BHL, LATERAL_LENGTH_CALCULATED_MD_TVD and LATERAL_LENGTH_CALCULATED_SHL_BHL, in that order.
More

The method varies by row and is named in LATERAL_LENGTH_SOURCE, so values are not comparable across rows without it. Non-additive. NULL when no method yields a value, and then LATERAL_LENGTH_SOURCE is NULL too.

LATERAL_LENGTH_SOURCE
Label of the method that produced LATERAL_LENGTH, such as 'Manual Override', 'PerforationTop-PerforationBottom' or 'Landing-Bottom'.
More

Distinguishes methods that share a calculated column, such as landing point to bottom hole and landing point to measured depth. NULL when LATERAL_LENGTH is NULL.

LAST_REFRAC_DATE
Date of the most recent refrac (re-stimulation after the original frac) on the wellbore, from the REFRAC event in WELL_EVENT: the latest event_dt, with effective_dt as the fallback, truncated to a date in UTC.
More

NULL when WELL_EVENT carries no REFRAC event for the wellbore, which includes every wellbore whose REFRAC_COUNT is 0.

REFRAC_COUNT
Carried from WELLBORE.REFRAC_COUNT.
More

Number of refracs (re-stimulations after the original frac) reported for this wellbore's well; 0 when none is reported. Reported by the source, not counted from WELL_EVENT, which carries only the most recent REFRAC event, so a well with a count of 2 or 3 still has one REFRAC event. NULL when no count is reported, which includes every Canadian wellbore.

DIRECTIONAL_SURVEY_AVAILABLE
True when directional survey stations are reported for the wellbore, false when none are.
More

Reported by the source rather than computed from DIRECTIONAL_SURVEY_STATION, so the two can briefly disagree while a new survey loads. NULL when survey coverage is not reported, which includes every Canadian wellbore.

PLANNED_AS_DRILLED_SURVEY
Whether the wellbore's directional survey is a planned trajectory (PLANNED) or one measured in the drilled hole (AS_DRILLED), as the source reports it.
More

NULL when DIRECTIONAL_SURVEY_AVAILABLE is false or NULL, which includes every Canadian wellbore.

WELLBORE_TYPE
The wellbore's declared operational function.
More

It equals WELLBORE_TYPE_NORMALIZED and has the same values, meaning and limits; read that column's description. NULL wherever WELLBORE_TYPE_NORMALIZED is NULL.

COUNTY_CODE
Five-digit FIPS code of the county (or parish in Louisiana) where the well is located (e.g., "48389" for Reeves County, Texas).
More

The name is in COUNTY.

63 columns

Identity, jurisdiction, geology, operator, status and lifecycle dates.

More about this view

Grain: One row per wellbore_key.

Grain
One row per wellbore_key.
Key columns
  • WELLBORE_KEY Surrogate key for the wellbore row, a stable string composed as {country}:{native_id_type}:{native_id}:{sequence_number} (e.g. US:API14:42123405670000:0).
Joins to
Sample query
SELECT WELLBORE_KEY, WELL_KEY, NATIVE_ID, OPERATOR_ID, PERMIT_ID
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_HEADER
LIMIT 10
Columns63
WELLBORE_KEY
Surrogate key for the wellbore row, a stable string composed as {country}:{native_id_type}:{native_id}:{sequence_number} (e.g. US:API14:42123405670000:0).
More

Consistent with this row's country, native_id_type, native_id, and sequence_number.

WELL_KEY
Foreign key to well.well_key, linking this wellbore to its parent well.
NATIVE_ID
Wellbore-level identifier.
More

For regulatory schemes (API10/API14/UWI-DLS) this is the external regulatory id, API14 captures the sidetrack/event suffix (positions 11-14) that disambiguates per-wellbore borehole+event; the well-level well.native_id carries the well-level root (API10 for US, UWI-DLS for Canada). Use the contiguous 14-digit API14 (digits only, no hyphens). For the PLANNED scheme (planned wellbores with no regulatory id yet) this is the Novi-internal id (the planned_well_id). The scheme is named by native_id_type, which conditionally validates this value's canonical format per scheme; this value is the third component of wellbore_key.

OPERATOR_ID
Current operator of record.
More

Historical changes should be captured as events (e.g., OPERATOR_CHANGE) or in a dedicated attribute history.

PERMIT_ID
Regulatory permit identifier as issued by the state/agency.
More

Primary key for the permit record.

NATIVE_ID_TYPE
Identifier scheme of native_id (API10, API14, UWI-DLS, or PLANNED).
More

API14 when a borehole/event suffix is available, otherwise API10 (e.g. single-wellbore wells or API10-only sources), UWI-DLS in Canada, or PLANNED for planned wellbores with no regulatory identifier yet. Second component of wellbore_key.

COUNTRY
Two-letter ISO 3166-1 alpha-2 country code where the wellbore is located (e.g., US, CA).
More

First component of wellbore_key; matches the parent well.country.

SEQUENCE_NUMBER
Ordinal distinguishing wellbores that share a native_id, part of the conformed identity (native_id + native_id_type + country + sequence_number).
More

It is 0 on every row in current data, no native_id yet resolves to more than one wellbore, and is retained because the identity is only unique with it.

WELL_NAME
Human-friendly well name (operator or regulatory naming).
More

Use for display; not a key.

FIELD_NAME
Name of the oil/gas field the well is in.
STATE
US state (USPS two-letter) or Canadian province/territory (Statistics Canada two-letter) code where the well is located.
COUNTY
Name of the county (or parish in Louisiana) where the well is located, as reported (e.g., "Reeves"); a name, never a code.
More

The FIPS code is in COUNTY_CODE. NULL when not reported.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
FORMATION
Canonical formation name used for analytics grouping.
More

Represents Novi's best estimate of the landing zone formation.

FORMATION_REPORTED
Formation name as reported by the data source (raw regulatory filing string).
FORMATION_REPORTED_NORMALIZED
Source-reported formation mapped to a controlled vocabulary.
FORMATION_CALCULATED
Novi-calculated formation based on wellbore geometry and formation tops (structural depth grids).
More

Used as the standard grouping key for peer comparison.

CURRENT_OPERATOR
Operator of record for this wellbore's well as of today, resolved to the canonical operator name, which is stored unmodified and may carry padding.
More

Use this for grouping peers; never group on a raw reported name.

WELL_STATUS
Current coarse lifecycle state of the well (derived from events).
More

Includes 7 milestone-based values and 9 regulatory/operational ones; semantic overlaps (e.g. PERMITTED/PERMIT_APPROVED, DRILLING/SPUD, PRODUCING/ACTIVE, SHUT_IN/INACTIVE) are deliberately preserved as distinct values so you can tell which source vocabulary a row came from. Details live in well_event.

WELLBORE_STATUS
Current lifecycle state for the wellbore (can differ from the well-level status).
WELLBORE_STATUS_REPORTED
Raw reported wellbore status value from the regulator filing, at wellbore grain (analogous to well.status_reported but for a specific lateral / sidetrack / re-entry).
More

Independent input from well.status_reported, wellbore status can differ from well status.

WELLBORE_STATUS_REPORTED_NORMALIZED
Reported wellbore status mapped to a controlled vocabulary, at wellbore grain (analogous to well.status_reported_normalized).
More

Distinct from wellbore.status (Novi-curated lifecycle enum); the reported/normalized pair preserves provenance for audit.

WELLBORE_TYPE_NORMALIZED
What the wellbore does: its declared operational function, from a controlled vocabulary (PRODUCER, INJECTOR, DISPOSAL, CYCLIC, STORAGE, OBSERVATION_TEST, and drainage and thermal-recovery roles).
More

It is the declared function, not current activity: a plugged or shut-in producer stays PRODUCER, so use WELLBORE_STATUS for activity. What the wellbore produces or handles is on PRIMARY_STREAM. Functions other than PRODUCER come only from a recognised filed code in WELLBORE_TYPE_REPORTED; without one (for example, every Texas wellbore) the value is PRODUCER or NULL, so counts of injection, disposal or storage wells are incomplete there. NULL when the source does not establish a function, for example a dry hole (PRIMARY_STREAM = DRY) or a service well whose filing does not say which service.

WELLBORE_TYPE_REPORTED
The well-type code the source supplies for the regulator filing, trimmed and otherwise as filed.
More

Codes, case and spelling vary by jurisdiction; they are not a controlled vocabulary. NULL where the source supplies no code (currently all Texas wellbores and most in Kansas and West Virginia). WELLBORE_TYPE_NORMALIZED and PRIMARY_STREAM use this code where it is recognised and a coarser classification otherwise, so they can hold a value when this column is NULL.

PRIMARY_STREAM
What the wellbore produces or handles, as declared, from a controlled vocabulary (OIL, GAS, OIL_AND_GAS, WATER, BRINE, WASTE, HELIUM, CO2, STEAM, BITUMEN, LITHIUM, POTASH, CBM, POLYMER, SOLVENT, AIR, ACID_GAS, DRY).
More

Pairs with WELLBORE_TYPE_NORMALIZED: GAS on a STORAGE or DISPOSAL wellbore is gas stored or disposed of, not produced. For gas producers use WELLBORE_TYPE_NORMALIZED = 'PRODUCER' AND PRIMARY_STREAM IN ('GAS', 'OIL_AND_GAS', 'CBM'); OIL_AND_GAS is a compound value, and coalbed methane wells currently carry GAS. Declared purpose, not observed production: a well declared for oil stays OIL while it dewaters, and the value asserts nothing about volumes. DRY appears only where a filed code classifies the bore as a dry hole, and then WELLBORE_TYPE_NORMALIZED is NULL. NULL when the source does not establish a stream.

DIRECTION
Novi's resolved well slant: the first of these that applies.
More

U_TURN_HORIZONTAL when the calculated slant is a U-turn; HORIZONTAL when a directional survey not marked as planned shows a horizontal path; the normalized reported (filed) slant; the calculated slant. For a well whose survey-based resolution is not available, the survey step is skipped and the filed slant comes first. The filed wording is in DIRECTION_REPORTED.

DIRECTION_REPORTED
Raw reported slant/direction value from the state regulatory agency (e.g., "Horizontal", "Directional").
DIRECTION_REPORTED_NORMALIZED
State-reported direction after normalization to a controlled vocabulary.
DIRECTION_CALCULATED
Slant that Novi infers from evidence other than the filed slant, such as the wellbore trajectory.
More

It is derived, not filed.

MD_TD
Measured depth at TD in feet.
TVD_TD
True vertical depth at TD in feet.
KB_ELEVATION
Kelly bushing elevation in feet above sea level.
SURFACE_LATITUDE
Surface hole latitude in decimal degrees, from the well's CURRENT surface location, the latest surveyed row per the collapse rule, not an arbitrary one.
SURFACE_LONGITUDE
Surface hole longitude in decimal degrees, from the well's CURRENT surface location, see the collapse rule.
CRS
Coordinate reference system for the latitude and longitude columns on this row, as an EPSG code.
More

Every populated row reads 'EPSG:4326' (WGS 84), so coordinates need no reprojection before use; the column is NULL where no coordinate is available.

HEELPOINT_LATITUDE
Latitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS.
HEELPOINT_LONGITUDE
Longitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS.
LANDING_POINT_LATITUDE
Latitude of the landing point in decimal degrees, WGS84.
LANDING_POINT_LONGITUDE
Longitude of the landing point in decimal degrees, WGS84.
MIDPOINT_LATITUDE
Latitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS.
MIDPOINT_LONGITUDE
Longitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS.
BOTTOM_HOLE_LATITUDE
Latitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS.
BOTTOM_HOLE_LONGITUDE
Longitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS.
SPUD_DATE
Date drilling began on this wellbore: the earliest SPUD event for the wellbore in WELL_EVENT (EVENT_DT, else EFFECTIVE_DT), truncated to a date in UTC.
More

WELL_EVENT is the only source; NULL where it has no SPUD event for the wellbore.

TD_DATE
Date total depth was reached.
More

Same rule as SPUD_DATE. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event_dt is optional on the ledger so effective_dt is the fallback, and the date-time is truncated in UTC.

COMPLETION_DATE
Date the wellbore was completed.
More

Two sources: pivot from the well_event ledger (event_type = COMPLETED), else the first completion's well_completion.completion_end_date. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event_dt is optional on the ledger so effective_dt is the fallback, and the date-time is truncated in UTC.

FIRST_PRODUCTION_DATE
Date of first reported production (turn-in-line): the earliest TIL event for the wellbore in WELL_EVENT (EVENT_DT, else EFFECTIVE_DT), truncated to a date in UTC.
More

WELL_EVENT is the only source; NULL where it has no TIL event for the wellbore.

PA_DATE
Date the wellbore was plugged and abandoned.
More

Same rule as SPUD_DATE. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event_dt is optional on the ledger so effective_dt is the fallback, and the date-time is truncated in UTC.

PROPOSED_TVD
Proposed true vertical depth as declared in the permit application, in feet.
More

The as-built value is wellbore.tvd_td once drilled.

OPERATOR_REPORTED
The well's current operator as reported for the well: a name, not resolved to an OPERATOR row (OPERATOR_ID carries the resolved operator).
More

May hold a placeholder where no operator is assigned. A current value, not a history. NULL where no operator is reported.

OPERATOR_ORIGINAL
The well's operator as of first production: a name, not resolved to an OPERATOR row.
More

It does not change when the well later changes operator. NULL where no original operator is recorded.

LATERAL_LENGTH
Selected lateral length in feet: a manual override where one exists, otherwise the first populated of LATERAL_LENGTH_CALCULATED_U_TURN, LATERAL_LENGTH_CALCULATED_PERF, LATERAL_LENGTH_CALCULATED_LP_TO_BHL, LATERAL_LENGTH_CALCULATED_KP_TO_BHL, LATERAL_LENGTH_CALCULATED_MD_TVD and LATERAL_LENGTH_CALCULATED_SHL_BHL, in that order.
More

The method varies by row and is named in LATERAL_LENGTH_SOURCE, so values are not comparable across rows without it. Non-additive. NULL when no method yields a value, and then LATERAL_LENGTH_SOURCE is NULL too.

LATERAL_LENGTH_SOURCE
Label of the method that produced LATERAL_LENGTH, such as 'Manual Override', 'PerforationTop-PerforationBottom' or 'Landing-Bottom'.
More

Distinguishes methods that share a calculated column, such as landing point to bottom hole and landing point to measured depth. NULL when LATERAL_LENGTH is NULL.

LAST_REFRAC_DATE
Date of the most recent refrac (re-stimulation after the original frac) on the wellbore, from the REFRAC event in WELL_EVENT: the latest event_dt, with effective_dt as the fallback, truncated to a date in UTC.
More

NULL when WELL_EVENT carries no REFRAC event for the wellbore, which includes every wellbore whose REFRAC_COUNT is 0.

DIRECTIONAL_SURVEY_AVAILABLE
True when directional survey stations are reported for the wellbore, false when none are.
More

Reported by the source rather than computed from DIRECTIONAL_SURVEY_STATION, so the two can briefly disagree while a new survey loads. NULL when survey coverage is not reported, which includes every Canadian wellbore.

PLANNED_AS_DRILLED_SURVEY
Whether the wellbore's directional survey is a planned trajectory (PLANNED) or one measured in the drilled hole (AS_DRILLED), as the source reports it.
More

NULL when DIRECTIONAL_SURVEY_AVAILABLE is false or NULL, which includes every Canadian wellbore.

WELLBORE_TYPE
The wellbore's declared operational function.
More

It equals WELLBORE_TYPE_NORMALIZED and has the same values, meaning and limits; read that column's description. NULL wherever WELLBORE_TYPE_NORMALIZED is NULL.

COUNTY_CODE
Five-digit FIPS code of the county (or parish in Louisiana) where the well is located (e.g., "48389" for Reeves County, Texas).
More

The name is in COUNTY.

LATEST_OIL_GRAVITY
Most recent oil API gravity reported for the well this wellbore belongs to, in degrees API; the same on every wellbore of the well.
More

Oil and gas gravities are reported independently and may come from different tests. NULL when none is reported.

LATEST_OIL_GRAVITY_TEST_DATE
Date of the latest well test, on any wellbore of the well, that reports an oil gravity: the test behind LATEST_OIL_GRAVITY.
More

NULL together with it.

LATEST_GAS_GRAVITY
Most recent gas specific gravity reported for the well this wellbore belongs to (air = 1.0); the same on every wellbore of the well.
More

Not necessarily from the same test as LATEST_OIL_GRAVITY. NULL when none is reported.

LATEST_GAS_GRAVITY_TEST_DATE
Date of the latest well test, on any wellbore of the well, that reports a gas specific gravity: the test behind LATEST_GAS_GRAVITY.
More

NULL together with it.

19 columns

First-completion design plus intensity ratios.

More about this view

Grain: One row per wellbore_key, first completion (completion_sequence = 1).

Grain
One row per wellbore_key, first completion (completion_sequence = 1).
Key columns
  • WELL_COMPLETION_ID Surrogate key of the completion event this row collapsed to, the first completion.
Sample query
SELECT WELLBORE_KEY, NATIVE_ID, WELL_COMPLETION_ID, NATIVE_ID_TYPE, COMPLETION_SEQUENCE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_COMPLETION_DESIGN
LIMIT 10
Columns19
NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

WELL_COMPLETION_ID
Surrogate key of the completion event this row collapsed to, the first completion.
More

Carried so a consumer can trace back to the source row and audit the collapse.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
COMPLETION_SEQUENCE
Ordinal of the completion within the wellbore, ascending.
More

This view is first-completion grain, so it is 1 on every row; recompletions and re-fracs are not projected here.

COMPLETION_STATE
Completion lifecycle state (derived from events or operational tracking).
COMPLETION_END_DATE
Date completion operations ended (if known).
PROPPANT_MASS
Total proppant mass injected during completion.
FLUID_VOLUME
Total completion fluid volume injected, in gallons.
STAGE_COUNT
Number of frac stages completed.
More

Omit the field when the stage count is unknown. Do not store 0 for unknown, 0 is not a valid stage count.

PERFORATION_UPPER
Shallowest perforation depth (MD) in feet.
PERFORATION_LOWER
Deepest perforation depth (MD) in feet.
PERFORATION_INTERVAL
Perforation interval length in feet (perforation_lower - perforation_upper).
PROPPANT_LOADING
Proppant mass per foot of lateral, computed by Novi rather than from columns in this view.
More

Non-additive ratio, never sum across wellbores. It cannot be recomputed from this view, which does not carry its denominator, the selected lateral length, published as LATERAL_LENGTH on WELLBORE_HEADER and WELL_DETAIL with its method in LATERAL_LENGTH_SOURCE; a peer-set figure is an average of ratios rather than a ratio of totals. Values above 9,000 lb/ft are nulled as physically impossible rather than clamped, so a NULL can mean no credible ratio exists for the well even when PROPPANT_MASS is present. Also NULL when Novi's selected lateral length for the well is unknown or zero. That nulling is the guarantee this column carries: the denominator is chosen per well from perforations, survey points or depth, and falls back to a surface-to-bottom-hole distance, so it is not a single stated method.

PROPPANT_CONCENTRATION
Proppant mass per gallon of completion fluid, slurry concentration, independent of lateral length, computed by Novi rather than from columns in this view.
More

Non-additive ratio, never sum across wellbores. NULL when proppant mass or fluid volume is unknown or zero, and when the ratio exceeds 8 lb/gal, which Novi treats as not credible; values above 8 are nulled, not clamped. Rounded to 2 decimal places.

STAGE_SPACING
Average distance between frac stages of the first completion, in feet: the lateral length Novi selected for the well divided by the first completion's stage count.
More

Non-additive ratio, never sum across wellbores. It cannot be recomputed from this view, which does not carry that lateral length; WELLBORE_HEADER and WELL_DETAIL publish it as LATERAL_LENGTH, with its method in LATERAL_LENGTH_SOURCE. NULL when the stage count is zero or that lateral length is unknown. Whole feet. No bounds are applied, so implausibly large or small values (a few under 20 ft) are possible and are published as computed.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOAK_TIME_DAYS
Number of days between the end of the first completion and the start of production (the soak period).
More

NULL when the span is zero or negative, longer than 365 days, or shorter than 30 days where the first-production date is not known accurately. Do not sum across wellbores.

40 columns

Production roll-ups as the source of record reports them per well, carried rather than recomputed: cumulative oil, gas, water and BOE at the 12-month, 24-month and life horizons; the peak producing month for each stream; life-to-date gas-oil ratio; and the index of the last month with reported production; and forecast EUR at 20, 30 and 50 years per stream, which is a forecast rather than reported production.

More about this view

Cumulative volume columns end in _REPORTED: reported volumes only, no forecast. Grain: one row per wellbore_key, carried on the well's lowest-sequence bore. A value this view does not carry is one the source of record does not report, and NULL means exactly that, not that a window was incomplete. IP rates, the 3- and 6-month windows, the 12-month ratios and the producing-time columns are no longer projected here; compute them from PRODUCTION_MONTHLY, which owns those definitions. Oil as reported includes condensate; whether forecast EUR oil does is not defined.

Grain
one row per wellbore_key, carried on the well's lowest-sequence bore.
Sample query
SELECT WELLBORE_KEY, NATIVE_ID, NATIVE_ID_TYPE, CUM_OIL_12_REPORTED, CUM_OIL_24_REPORTED
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_PRODUCTION_SUMMARY
LIMIT 10
Columns40
NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
CUM_OIL_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Oil volume accumulated through the twelfth month on production. It may include condensate. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_OIL_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Oil volume accumulated through the twenty-fourth month on production. It may include condensate. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_OIL_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Oil volume over the well's full reported history. It may include condensate. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_GAS_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Gas volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_GAS_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Gas volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_GAS_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Gas volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_WATER_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Water volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_WATER_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Water volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_WATER_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Water volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_BOE_12_REPORTED
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_BOE_24_REPORTED
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_BOE_LIFE_REPORTED
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

PEAK_MONTH_OIL_INDEX
Index on the months-on-production axis of the month in which combined oil and condensate volume peaked.
More

The peak is selected on the combined volume, so on a condensate-rich well this can name a different month than an oil-only peak would. Ties resolve to the earliest such month. Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_OIL_AMOUNT
Combined oil and condensate volume in that peak month.
More

A volume, not a rate. Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_GAS_INDEX
Index on the months-on-production axis of the month in which gas volume peaked.
More

Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_GAS_AMOUNT
Gas volume in that peak month.
More

Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_WATER_INDEX
Index on the months-on-production axis of the month in which water volume peaked.
More

Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_WATER_AMOUNT
Water volume in that peak month.
More

Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_BOE_INDEX
Index on the months-on-production axis of the month in which barrel-of-oil-equivalent volume peaked.
More

The monthly BOE this peak is selected on is oil and gas at 6 Mcf = 1 BOE and EXCLUDES condensate, unlike the cumulative BOE columns, which include it, so on a condensate-rich well the peak month can differ from the one a condensate-inclusive BOE would select. Non-additive. Null when no month carried a positive total: a zero maximum is not a peak.

PEAK_MONTH_BOE_AMOUNT
Barrel-of-oil-equivalent volume in that peak month, as oil and gas at 6 Mcf = 1 BOE.
More

EXCLUDES condensate and NGL, a narrower basis than the cumulative BOE columns, which include condensate. Non-additive across wellbores. Null when no month carried a positive total: a zero maximum is not a peak.

CUM_LIFE_GOR
Life-to-date producing gas-oil ratio: life gas over life liquid, where the liquid denominator is the oil that cum_oil_life_reported carries, which may include condensate.
More

Null when that liquid total is zero, so a gas-only well has no value here rather than an infinite one. Rounded to two decimal places. NON-ADDITIVE, never sum or average across wellbores; recompute from the underlying volumes. Recomputing it needs cum_gas_life_reported and cum_oil_life_reported, which are not guaranteed present on the same row.

LAST_REPORTED_MONTHS_ON_PRODUCTION
Index on the months-on-production axis of the last month with reported production.
More

An index, not a count: it identifies a month, it does not total them. Reported rather than derived from the monthly production fact, and not guaranteed to agree with an index computed from it. Non-additive.

LAST_REPORTED_MONTH
First day of the last month in which the well reported a positive combined volume of oil, condensate, gas, flared gas and water.
More

A month whose volumes are all zero or unreported does not count, so a well that has gone to zero carries the last month before it did. Reported rather than derived from the monthly production fact, and not guaranteed to equal a month computed from it. Non-additive. Null when no month qualifies.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
EUR_OIL_20YR
Forecast estimated ultimate recovery of oil through the first 20 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_20YR
Forecast estimated ultimate recovery of gas through the first 20 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_20YR
Forecast estimated ultimate recovery of water through the first 20 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_20YR
Forecast estimated ultimate recovery through the first 20 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

EUR_OIL_30YR
Forecast estimated ultimate recovery of oil through the first 30 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_30YR
Forecast estimated ultimate recovery of gas through the first 30 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_30YR
Forecast estimated ultimate recovery of water through the first 30 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_30YR
Forecast estimated ultimate recovery through the first 30 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

EUR_OIL_50YR
Forecast estimated ultimate recovery of oil through the first 50 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_50YR
Forecast estimated ultimate recovery of gas through the first 50 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_50YR
Forecast estimated ultimate recovery of water through the first 50 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_50YR
Forecast estimated ultimate recovery through the first 50 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

22 columns

Arps parameters per segment per stream, shaped for ARIES export.

More about this view

Grain: One row per (wellbore_key, production_forecast_id, production_stream, segment_number).

Grain
One row per (wellbore_key, production_forecast_id, production_stream, segment_number).
Sample query
SELECT WELLBORE_KEY, NATIVE_ID, PRODUCTION_FORECAST_ID, NATIVE_ID_TYPE, PRODUCTION_STREAM
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_DECLINE_PARAMETERS
LIMIT 10
Columns22
NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

PRODUCTION_FORECAST_ID
Forecast run to which this segment belongs.
More

Use to group segments and parameters by a single forecast execution. May be NULL when no parent production_forecast row exists for this segment.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
PRODUCTION_STREAM
Which stream this segment forecasts (e.g., oil, gas, ngl, water, condensate).
SEGMENT_UID
Stable, immutable unique identifier for this segment.
SEGMENT_NUMBER
1-based index of the segment within the stream for the wellbore_key.
KIND
ARPS regime represented by this segment: - buildup: early-time pre-decline behavior, - transition: changeover period between regimes, - terminal: late-time decline segment.
SEGMENT_CURVE_TYPE
Type of decline curve applied in this segment.
More

'exponential' assumes constant nominal decline D; 'hyperbolic' uses exponent b (0<b<1 typical; b=1 is harmonic); 'linear' is a buildup-phase ramp where rate increases linearly from segment_start_rate to segment_end_rate over (day_stop - day_start) days (no decline math applies). 'linear' is only valid when kind='buildup'.

DAY_START
Inclusive day index where this segment begins, in real calendar days since first production (0 = first day of production).
More

This is the axis the segment's Arps parameters were fitted against and is the correct axis for evaluating the curve within this fact. It is NOT comparable to production_forecast.forecast_day, which is a nominal 30-day month ordinal rather than a day count; matching the two drifts by a median of 129 days and up to 236, well-specific and uncorrectable by a constant. To align this fact with production_forecast, use segment_start_date / segment_end_date against year / month.

DAY_STOP
Inclusive day index where this segment ends, in real calendar days since first production.
More

Must be >= day_start for valid datasets (cannot be enforced portably in standard JSON Schema). Same axis and same caveats as day_start; (day_stop - day_start) is the segment duration in days, used by the 'linear' segment_curve_type ramp.

SEGMENT_START_DATE
Calendar date on which this segment begins, inclusive (YYYY-MM-DD).
More

The alignment axis between this fact and production_forecast: a monthly forecast row belongs to the segments whose [segment_start_date, segment_end_date] range overlaps its year/month. Anchors the fitted curve to real calendar time, which is what evaluating a segment against actual monthly production requires. NULL when the wellbore has no calendar anchor (no first-production date), in which case consumers must fall back to the relative day_start / day_stop offsets.

SEGMENT_END_DATE
Calendar date on which this segment ends, inclusive (YYYY-MM-DD).
More

NULL when the wellbore has no calendar anchor. See segment_start_date.

B_FACTOR
Arps hyperbolic exponent b for this segment.
More

0 = exponential, 1 = harmonic, 0 < b < 1 = hyperbolic. Non-additive, never average across wellbores.

NOMINAL_DECLINE_RATE
D_nom, nominal decline parameter used in ARPS (1/day).
More

Constant for exponential; initial value for hyperbolic at segment start.

EFFECTIVE_DECLINE_RATE_TANGENT
D_eff (tangent), effective decline rate using the tangent (instantaneous) approximation over a 1-day interval (dimensionless fraction in [0,1)).
More

For exponential decline, D_eff_tangent = 1 - e^{-D_nom}. This is the point-in-time derivative of the decline curve; use effective_decline_rate_secant for the average-interval approximation.

EFFECTIVE_DECLINE_RATE_SECANT
D_eff (secant), effective decline rate using the secant (average-interval) approximation over a 1-day interval (dimensionless fraction in [0,1)).
More

For exponential decline, D_eff_secant = 1 - (q(t+1)/q(t)). Secant is the discrete-period average decline; needed for ARIES export and reproducibility alongside the tangent approximation.

SEGMENT_START_RATE
Production rate at the start of this segment.
More

This is qi for the first DECLINE segment, not necessarily segment_number = 1, which may be a buildup segment. Non-additive.

SEGMENT_END_RATE
q_end, production rate at the end of the segment (same units as stream).
More

Should be <= q_start for decline segments (cannot be enforced portably here).

SEGMENT_PARAMETER_UID
Stable unique identifier for this parameter row.
BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
17 columns

Parent/child classification and neighbour distances for interference work.

More about this view

Grain: One row per wellbore_key.

Grain
One row per wellbore_key.
Key columns
Sample query
SELECT WELLBORE_KEY, WELL_SPACING_ID, NATIVE_ID, NATIVE_ID_TYPE, IS_CHILD
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_SPACING_DETAIL
LIMIT 10
Columns17
WELL_SPACING_ID
Surrogate key.
NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
IS_CHILD
True if this well is classified as a child well (drilled after nearby parent wells were producing).
PARENT_COUNT
Number of neighboring parent wells meeting spacing criteria.
PARENT_DAYS_ONLINE
Days the nearest parent well was online relative to this well's start.
CLOSEST_WELL_XY
XY distance to the closest lateral and staggered neighbor in feet.
More

Non-additive.

CLOSEST_TWO_AVG_XY
Average XY distance to the two closest neighbors (includes staggered and stacked).
More

Non-additive.

WELLS_IN_RADIUS
Count of all wells within the neighbor distance radius.
WELLS_IN_RADIUS_AVG_XY
Total wells in radius converted to a distance = 2 * MaxNeighborDistance / (1 + WellsInRadius).
More

Non-additive.

LATERAL_CLOSER_XY
XY distance to the nearest well in the same lateral row.
More

Non-additive.

STAGGER_CLOSER_TANGENT
Tangent distance to the nearest staggered well.
More

Non-additive.

STACK_CLOSER_Z
Vertical distance to the nearest well in the same vertical stack.
More

Non-additive.

BOUNDEDNESS_SCORE
Number of neighbor quadrants occupied by wells (0-8).
More

Non-additive.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
43 columns

Rock properties and landing-zone geometry at one measurement point.

More about this view

Grain: One row per (wellbore_key, location_type, formation).

Grain
One row per (wellbore_key, location_type, formation).
Key columns
Sample query
SELECT WELLBORE_KEY, SUBSURFACE_PROPERTY_ID, NATIVE_ID, SURVEY_STATION_ID, NATIVE_ID_TYPE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_SUBSURFACE_PROPERTY
LIMIT 10
Columns43
WELLBORE_KEY
Foreign key to wellbore.wellbore_key, the canonical anchor for every subsurface_property row.
More

Populated for all rows; the optional survey_station_id provides finer station-grain attachment when available.

NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

SURVEY_STATION_ID
Optional foreign key to directional_survey_station.survey_station_id.
More

Populated when the wellbore has a matching directional survey station for the row's location type; NULL when the parent wellbore has no directional-survey coverage. Use wellbore_key as the always-populated anchor.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
LOCATION_TYPE
Type of measurement point along the wellbore, as an integer code.
More

Part of the natural key: it disambiguates multiple measurements on one wellbore. Measured on current data the values are 7 (94.7% of rows), 1 (5.3%) and 4 (0.008%); the codes are not decoded on this view, so treat it as an opaque discriminator rather than a readable label.

FORMATION
Novi's best estimate of the actual target formation.
REPORTED_FORMATION
Target formation as reported by the state.
GRID_FORMATION
Formation based on subsurface grid studies.
STRUCTURAL_DEPTH
Depth of the top of the formation (TVDSS).
POROSITY_AVG
Effective porosity in percentage (porosity units).
PERMEABILITY_AVG
Average permeability calibrated to core and production matching, in millidarcies.
PERMEABILITY_HEIGHT_AVG
Average permeability times gross thickness (kh product) in millidarcy-feet.
POROSITY_HEIGHT_AVG
Average porosity times gross thickness (phi-h product).
THICKNESS_AVG
Gross isopach (formation thickness) in feet.
SW_AVG
Average water saturation as a percentage.
TOC_AVG
Average total organic carbon as a percentage.
VCLAY_AVG
Average volume of clay as a percentage.
BVI_AVG
Average bulk volume irreducible water as a percentage.
NTG_AVG
Net-to-gross ratio (dimensionless).
BRITTLENESS_AVG
Average brittleness of the formation, as an index whose unit and range are not defined; not a 0-1 fraction or a percentage.
More

Non-additive.

COMPETENCY_AVG
Average rock competency of the formation, as an index whose unit and range are not defined; not a 0-1 fraction.
More

Non-additive.

STOIIP_AVG
Stock tank oil initially in place, million barrels per section (sq. mi).
GIIP_AVG
Gas initially in place, billion cubic feet per section (sq. mi).
POROSITY_OF_NET
Porosity averaged over net pay cutoffs.
PERMEABILITY_OF_NET
Permeability averaged over net pay cutoffs, in millidarcies.
PERMEABILITY_HEIGHT_OF_NET
Permeability-height product over net pay cutoffs, in millidarcy-feet.
POROSITY_HEIGHT_OF_NET
Porosity-height product over net pay cutoffs.
THICKNESS_OF_NET
Net pay thickness in feet.
SW_OF_NET
Water saturation over net pay cutoffs.
TOC_OF_NET
TOC over net pay cutoffs.
VCLAY_OF_NET
Volume of clay over net pay cutoffs.
BVI_OF_NET
Irreducible water over net pay cutoffs.
BRITTLENESS_OF_NET
Brittleness averaged over net pay cutoffs within the formation, on the same scale as brittleness_avg.
More

Unit and range are not defined. Non-additive.

COMPETENCY_OF_NET
Competency averaged over net pay cutoffs, on the same scale as competency_avg.
More

Unit and range are not defined. Non-additive.

STOIIP_OF_NET
Oil in place over net pay cutoffs.
GIIP_OF_NET
Gas in place over net pay cutoffs.
PERCENT_IN_ZONE
Percentage of lateral in the grid formation.
DISTANCE_FROM_TOP
Feet from top of formation, based on grids and survey.
DISTANCE_FROM_BASE
Feet from base of formation, based on grids and survey.
NORMALIZED_DISTANCE_TO_TOP
Value 0-1 where 0 = drilled at top of zone, 1 = drilled at base of zone.
BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
16 columns

Well-test rates and flowing and shut-in pressures.

More about this view

Grain: One row per (wellbore_key, test_date).

Grain
One row per (wellbore_key, test_date).
Key columns
Sample query
SELECT WELLBORE_KEY, WELL_TEST_ID, NATIVE_ID, NATIVE_ID_TYPE, TEST_DATE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_TEST_HISTORY
LIMIT 10
Columns16
WELL_TEST_ID
Surrogate key for the well test row.
NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
TEST_DATE
Date on which the well test was performed.
REPORT_DATE
Date when the test was first reported.
More

May differ from test_date.

OIL_RATE
24-hour oil production rate in barrels per day.
More

Semi-additive: do not sum across wellbores.

GAS_RATE
24-hour gas production rate in Mcf per day.
More

Semi-additive: do not sum across wellbores.

WATER_RATE
24-hour water production rate in barrels per day.
More

Semi-additive: do not sum across wellbores.

FLOWING_WELLHEAD_PRESSURE
Pressure at the wellhead while flowing during the test.
More

Semi-additive.

SHUT_IN_WELLHEAD_PRESSURE
Pressure at the wellhead while shut-in during the test.
More

Semi-additive.

BOTTOM_HOLE_PRESSURE
Bottom hole pressure during the test.
More

Semi-additive.

OIL_GRAVITY
API gravity of produced oil in degrees, measured at standard conditions (60°F).
More

Conventional buckets: <22.3 = heavy, 22.3–31.1 = medium, >31.1 = light, >50 = condensate. Property of the fluid sample at this test event.

GAS_SPECIFIC_GRAVITY
Specific gravity of produced gas relative to air, air = 1.0.
More

A property of the fluid sample at this test event, not of the wellbore: a wellbore with several tests has several values, and the most recent one is a derivation rather than this column. Dry pipeline gas is typically 0.55–0.70; richer casinghead and condensate-associated gas runs higher, and values above roughly 1.0 indicate a heavy, NGL-rich stream. Non-additive: never sum, and average only with volume weighting. Sparse by design, NULL means this test reported no gas gravity, which is the common case, while the absence of a row means no test. minimum: 0 is a physical floor, consistent with the other measures on this entity; it is not a range check. Sources that range-guard the value (the primary US source discards readings outside 0.5–1.5) do so before it reaches this column, and a source that does not is not caught here.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
19 columns

Monthly volumes by stream across calendar, producing and economic time axes.

More about this view

Grain: One row per (wellbore_key, year, month), monthly granularity only. Actual and forecast months OVERLAP and are not reconciled: a wellbore can have a row in PRODUCTION_MONTHLY and a row in PRODUCTION_FORECAST_MONTHLY for the same (wellbore_key, year, month). Novi does not trim the forecast to begin after the last producing month, and the overlap WIDENS over time: new production records are appended while the forecast's timeframe stays as generated, so the number of overlapping months grows until the forecast is regenerated. Do not hard-code a cutover month. Do not sum the two for a period, pick one, or take actuals where they exist and forecast only beyond them.

Grain
One row per (wellbore_key, year, month), monthly granularity only.
Sample query
SELECT WELLBORE_KEY, NATIVE_ID, NATIVE_ID_TYPE, PRODUCTION_DATE, YEAR
FROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_MONTHLY
LIMIT 10
Columns19
NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
PRODUCTION_DATE
First day of the month for this record.
More

A convenience column equivalent to (year, month), the production fact does not require it, so (year, month) is the grain and this column may be null on an otherwise valid source row. Derive it rather than depend on it.

YEAR
Calendar year of this production record (UTC).
MONTH
Calendar month number of this production record (1–12).
PRODUCING_DAYS
Number of days in this period during which the wellbore was actively producing OR injecting.
More

Bounded by period length (0–31 monthly, 0–7 weekly). 0 days legitimately implies zero produced + zero injected volumes (maintenance, shut-in, plugged). For injection-only wells (SWD, EOR injectors), an active-injection period reports producing_days >= 1 even though produced volumes are zero.

CALENDAR_DAYS
Number of calendar days represented for this period (1–31 monthly, exactly 7 weekly).
CUMULATIVE_PRODUCING_DAYS
Cumulative number of producing days since production start.
MONTHS_ON_PRODUCTION
Calendar-month index of the row relative to the wellbore's first month on production, 1-based: 1 = the first month on production whether or not it is partial.
More

After the first index every calendar month advances it by one whether or not the month produced, so it is a calendar index, unique and contiguous per wellbore, and never a count of producing months. The elapsed-time axis for type-curve analysis: it aligns wells of different vintages on months since first production rather than on absolute date (year/month). Elapsed, not produced, a shut-in month still advances it. SUPPLY_PROJECTION uses the same 1-based convention, so cohort joins line up.

OIL
Oil volume produced at the wellhead for the period, measured in barrels (bbl).
GAS
Natural gas volume produced at the wellhead for the period, measured in thousand cubic feet (Mcf).
WATER
Produced water volume for the period, measured in barrels (bbl).
GAS_FLARED
Natural gas volume flared in the period, measured in thousand cubic feet (Mcf).
More

Used for emissions and regulatory reporting.

IS_OIL_FROM_PRODUCTION_SHARING
True if oil production data is from a proprietary source.
IS_GAS_FROM_PRODUCTION_SHARING
True if gas production data is from a proprietary source.
IS_WATER_FROM_PRODUCTION_SHARING
True if water production data is from a proprietary source.
BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
18 columns

Monthly forecast rates and cumulatives by stream, per scenario.

More about this view

Grain: One row per (wellbore_key, scenario, year, month), monthly granularity only. Actual and forecast months OVERLAP and are not reconciled: a wellbore can have a row in PRODUCTION_MONTHLY and a row in PRODUCTION_FORECAST_MONTHLY for the same (wellbore_key, year, month). Novi does not trim the forecast to begin after the last producing month, and the overlap WIDENS over time: new production records are appended while the forecast's timeframe stays as generated, so the number of overlapping months grows until the forecast is regenerated. Do not hard-code a cutover month. Do not sum the two for a period, pick one, or take actuals where they exist and forecast only beyond them.

Grain
One row per (wellbore_key, scenario, year, month), monthly granularity only.
Sample query
SELECT WELLBORE_KEY, PRODUCTION_FORECAST_ID, NATIVE_ID, NATIVE_ID_TYPE, SCENARIO
FROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECAST_MONTHLY
LIMIT 10
Columns18
PRODUCTION_FORECAST_ID
Identifier that groups the period rows of one forecast.
More

Shared by those rows, so it is not unique per row.

NATIVE_ID
Regulatory identifier of the wellbore this row belongs to, the same value as WELLBORE_HEADER.NATIVE_ID, so the row can be joined to data outside NOVI_WELLS.
More

Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is NATIVE_ID_TYPE. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on WELLBORE_KEY.

NATIVE_ID_TYPE
Identifier scheme of NATIVE_ID (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as WELLBORE_HEADER.NATIVE_ID_TYPE.
SCENARIO
Forecast scenario percentile.
More

Novi currently produces P50 (most likely) only, so this column holds 'P50' on every row today; it is part of the grain so that other scenarios can be added.

FORECAST_DAY
Period index relative to initial production (IP), expressed in nominal day units.
More

For monthly records this is the month ordinal times 30, where the ordinal is 1-based (so month 1 encodes as 30); for weekly records, multiples of 7. The lowest value actually present in a given fact depends on which months that fact carries, a forecast-only projection whose historical months are excluded starts at whatever month the forecast begins, not at 30. NOT a count of elapsed days, dividing by 30 recovers the month index exactly, and real elapsed time drifts from it by roughly 0.44 days per month (about 264 days over a 600-month horizon). Note this is a different basis from production.months_on_production: a day index, not a month index. Use forecast_day to order rows within this fact. Do NOT use it as an alignment key against production_forecast_arps_segment.day_start (real calendar days) or for discounting; align on year / month, or on the segment's segment_start_date / segment_end_date.

YEAR
Calendar year of the production month this forecast row represents.
More

Not the revenue month, revenue conventionally lags production by 1–2 months. Together with month, this is the alignment axis against actual production and against production_forecast_arps_segment.segment_start_date. On yearly records, the calendar year of forecast_date, the first month of the 12-month block.

MONTH
Calendar month number (1–12) of the production month this forecast row represents.
More

Not the revenue month. See year. On yearly records, the calendar month of forecast_date, the first month of the 12-month block.

OIL_PER_DAY
Oil rate (bbl/d).
More

May carry oil and condensate as a single combined rate, in which case condensate_per_day is null; a populated oil rate beside a null condensate rate therefore does not assert that no condensate is forecast. Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.

CUMULATIVE_OIL
Cumulative oil volume (bbl), combined with condensate on the same rows as oil_per_day (cumulative_condensate is then null), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More

It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.

GAS_PER_DAY
Gas rate (Mcf/d).
More

Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.

CUMULATIVE_GAS
Cumulative gas volume (Mcf), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More

It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.

WATER_PER_DAY
Water rate (bbl/d).
More

Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.

CUMULATIVE_WATER
Cumulative water volume (bbl), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More

It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
FORECAST_DATE
First day of the calendar month whose production this row forecasts (e.g. 2034-03-01): the forecast production month, not the revenue month, which typically lags 1–2 months.
More

On yearly records, the first day of the first month of the 12-month block; not 1 January. On monthly records it joins to production.production_date by value; on yearly records it matches only the block's first month.

FORECAST_MONTH
1-based index of the month within the wellbore's monthly series of consecutive months, 1 being the series' earliest month.
More

On monthly records, the month this row forecasts, equal to forecast_day / 30. On yearly records, the last month present in the 12-month block: the year ordinal times 12, or less for a final partial year. An ordinal index, not a calendar month: see month for the calendar month.