Presentation views
Ten ready-joined views with one row per wellbore, month, test, or decline segment.
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.
WELL_DETAIL
Section titled “WELL_DETAIL”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
WELL_COMPLETION_IDSurrogate key of the completion event this row collapsed to, the first completion.WELL_SPACING_IDSurrogate key.
- Joins to
SELECT WELLBORE_KEY, WELL_KEY, NATIVE_ID, OPERATOR_ID, PERMIT_IDFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_DETAILLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_key. - 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_idcarries 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_reportedbut 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_STATUSfor activity. What the wellbore produces or handles is onPRIMARY_STREAM. Functions other than PRODUCER come only from a recognised filed code inWELLBORE_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_NORMALIZEDandPRIMARY_STREAMuse 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 useWELLBORE_TYPE_NORMALIZED= 'PRODUCER' ANDPRIMARY_STREAMIN ('GAS', 'OIL_AND_GAS', 'CBM');OIL_AND_GASis 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 thenWELLBORE_TYPE_NORMALIZEDis 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_HORIZONTALwhen 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 inDIRECTION_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, elseEFFECTIVE_DT), truncated to a date in UTC.More
WELL_EVENTis 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, elseEFFECTIVE_DT), truncated to a date in UTC.More
WELL_EVENTis 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_tdonce 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_LENGTHin this view, with its method inLATERAL_LENGTH_SOURCE; the ratio need not equalPROPPANT_MASS/LATERAL_LENGTHon 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 whenPROPPANT_MASSis 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_LENGTHin this view, with its method inLATERAL_LENGTH_SOURCE; the value need not equalLATERAL_LENGTHdivided bySTAGE_COUNTon 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_IDcarries 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_TVDandLATERAL_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 thenLATERAL_LENGTH_SOURCEis 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_LENGTHis 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_EVENTcarries no REFRAC event for the wellbore, which includes every wellbore whoseREFRAC_COUNTis 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_AVAILABLEis false or NULL, which includes every Canadian wellbore. - WELLBORE_TYPE
- The wellbore's declared operational function.
More
It equals
WELLBORE_TYPE_NORMALIZEDand has the same values, meaning and limits; read that column's description. NULL whereverWELLBORE_TYPE_NORMALIZEDis 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.
No columns match. Try a shorter word.
WELLBORE_HEADER
Section titled “WELLBORE_HEADER”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_KEYSurrogate 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
WELL_KEYjoinsWELL.WELL_KEY
SELECT WELLBORE_KEY, WELL_KEY, NATIVE_ID, OPERATOR_ID, PERMIT_IDFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_HEADERLIMIT 10- 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_idcarries 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_reportedbut 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_STATUSfor activity. What the wellbore produces or handles is onPRIMARY_STREAM. Functions other than PRODUCER come only from a recognised filed code inWELLBORE_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_NORMALIZEDandPRIMARY_STREAMuse 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 useWELLBORE_TYPE_NORMALIZED= 'PRODUCER' ANDPRIMARY_STREAMIN ('GAS', 'OIL_AND_GAS', 'CBM');OIL_AND_GASis 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 thenWELLBORE_TYPE_NORMALIZEDis 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_HORIZONTALwhen 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 inDIRECTION_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, elseEFFECTIVE_DT), truncated to a date in UTC.More
WELL_EVENTis 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, elseEFFECTIVE_DT), truncated to a date in UTC.More
WELL_EVENTis 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_tdonce drilled. - OPERATOR_REPORTED
- The well's current operator as reported for the well: a name, not resolved to an OPERATOR row (
OPERATOR_IDcarries 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_TVDandLATERAL_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 thenLATERAL_LENGTH_SOURCEis 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_LENGTHis 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_EVENTcarries no REFRAC event for the wellbore, which includes every wellbore whoseREFRAC_COUNTis 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_AVAILABLEis false or NULL, which includes every Canadian wellbore. - WELLBORE_TYPE
- The wellbore's declared operational function.
More
It equals
WELLBORE_TYPE_NORMALIZEDand has the same values, meaning and limits; read that column's description. NULL whereverWELLBORE_TYPE_NORMALIZEDis 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.
No columns match. Try a shorter word.
WELLBORE_COMPLETION_DESIGN
Section titled “WELLBORE_COMPLETION_DESIGN”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_IDSurrogate key of the completion event this row collapsed to, the first completion.
- Joins to
SELECT WELLBORE_KEY, NATIVE_ID, WELL_COMPLETION_ID, NATIVE_ID_TYPE, COMPLETION_SEQUENCEFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_COMPLETION_DESIGNLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_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 outsideNOVI_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 onWELLBORE_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 asWELLBORE_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_LENGTHonWELLBORE_HEADERandWELL_DETAILwith its method inLATERAL_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 whenPROPPANT_MASSis 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_HEADERandWELL_DETAILpublish it asLATERAL_LENGTH, with its method inLATERAL_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.
No columns match. Try a shorter word.
WELLBORE_PRODUCTION_SUMMARY
Section titled “WELLBORE_PRODUCTION_SUMMARY”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.
- Joins to
SELECT WELLBORE_KEY, NATIVE_ID, NATIVE_ID_TYPE, CUM_OIL_12_REPORTED, CUM_OIL_24_REPORTEDFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_PRODUCTION_SUMMARYLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_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 outsideNOVI_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 onWELLBORE_KEY. - NATIVE_ID_TYPE
- Identifier scheme of
NATIVE_ID(API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value asWELLBORE_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.
No columns match. Try a shorter word.
WELLBORE_DECLINE_PARAMETERS
Section titled “WELLBORE_DECLINE_PARAMETERS”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).
- Joins to
SELECT WELLBORE_KEY, NATIVE_ID, PRODUCTION_FORECAST_ID, NATIVE_ID_TYPE, PRODUCTION_STREAMFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_DECLINE_PARAMETERSLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_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 outsideNOVI_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 onWELLBORE_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 asWELLBORE_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).
No columns match. Try a shorter word.
WELLBORE_SPACING_DETAIL
Section titled “WELLBORE_SPACING_DETAIL”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
WELL_SPACING_IDSurrogate key.
- Joins to
SELECT WELLBORE_KEY, WELL_SPACING_ID, NATIVE_ID, NATIVE_ID_TYPE, IS_CHILDFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_SPACING_DETAILLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_key. - 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 outsideNOVI_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 onWELLBORE_KEY. - NATIVE_ID_TYPE
- Identifier scheme of
NATIVE_ID(API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value asWELLBORE_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).
No columns match. Try a shorter word.
WELLBORE_SUBSURFACE_PROPERTY
Section titled “WELLBORE_SUBSURFACE_PROPERTY”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
SUBSURFACE_PROPERTY_IDSurrogate key.
- Joins to
SELECT WELLBORE_KEY, SUBSURFACE_PROPERTY_ID, NATIVE_ID, SURVEY_STATION_ID, NATIVE_ID_TYPEFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_SUBSURFACE_PROPERTYLIMIT 10- 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.
- SUBSURFACE_PROPERTY_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 outsideNOVI_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 onWELLBORE_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 asWELLBORE_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).
No columns match. Try a shorter word.
WELLBORE_TEST_HISTORY
Section titled “WELLBORE_TEST_HISTORY”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
WELL_TEST_IDSurrogate key for the well test row.
- Joins to
SELECT WELLBORE_KEY, WELL_TEST_ID, NATIVE_ID, NATIVE_ID_TYPE, TEST_DATEFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_TEST_HISTORYLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_key. - 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 outsideNOVI_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 onWELLBORE_KEY. - NATIVE_ID_TYPE
- Identifier scheme of
NATIVE_ID(API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value asWELLBORE_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).
No columns match. Try a shorter word.
PRODUCTION_MONTHLY
Section titled “PRODUCTION_MONTHLY”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.
- Joins to
SELECT WELLBORE_KEY, NATIVE_ID, NATIVE_ID_TYPE, PRODUCTION_DATE, YEARFROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_MONTHLYLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_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 outsideNOVI_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 onWELLBORE_KEY. - NATIVE_ID_TYPE
- Identifier scheme of
NATIVE_ID(API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value asWELLBORE_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_PROJECTIONuses 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).
No columns match. Try a shorter word.
PRODUCTION_FORECAST_MONTHLY
Section titled “PRODUCTION_FORECAST_MONTHLY”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.
- Joins to
SELECT WELLBORE_KEY, PRODUCTION_FORECAST_ID, NATIVE_ID, NATIVE_ID_TYPE, SCENARIOFROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECAST_MONTHLYLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_key. - 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 outsideNOVI_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 onWELLBORE_KEY. - NATIVE_ID_TYPE
- Identifier scheme of
NATIVE_ID(API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value asWELLBORE_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 againstproduction_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_dateby 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.
No columns match. Try a shorter word.