# Presentation views

Source: https://developers.novilabs.com/data/tables/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

Wide one-row-per-wellbore reporting view: the composition of `WELLBORE_HEADER`, `WELLBORE_PRODUCTION_SUMMARY`, `WELLBORE_COMPLETION_DESIGN` and `WELLBORE_SPACING_DETAIL`. Grain: one row per wellbore\_key. Every column is defined by the narrow view it comes from.

| Column | Description |
| --- | --- |
| `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. For regulatory schemes (API10/API14/UWI-DLS) this is the external regulatory id, API14 captures the sidetrack/event suffix (positions 11-14) that disambiguates per-wellbore borehole+event; the well-level well.native\_id carries the well-level root (API10 for US, UWI-DLS for Canada). Use the contiguous 14-digit API14 (digits only, no hyphens). For the PLANNED scheme (planned wellbores with no regulatory id yet) this is the Novi-internal id (the planned\_well\_id). The scheme is named by native\_id\_type, which conditionally validates this value's canonical format per scheme; this value is the third component of wellbore\_key. |
| `OPERATOR_ID` | Current operator of record. 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. Primary key for the permit record. |
| `WELL_COMPLETION_ID` | Surrogate key of the completion event this row collapsed to, the first completion. 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). 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). 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). 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). 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. 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. 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). 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. Use this for grouping peers; never group on a raw reported name. |
| `WELL_STATUS` | Current coarse lifecycle state of the well (derived from events). Includes 7 milestone-based values and 9 regulatory/operational ones; semantic overlaps (e.g. PERMITTED/`PERMIT_APPROVED`, DRILLING/SPUD, PRODUCING/ACTIVE, `SHUT_IN`/INACTIVE) are deliberately preserved as distinct values so you can tell which source vocabulary a row came from. Details live in well\_event. |
| `WELLBORE_STATUS` | Current lifecycle state for the wellbore (can differ from the well-level status). |
| `WELLBORE_STATUS_REPORTED` | Raw reported wellbore status value from the regulator filing, at wellbore grain (analogous to well.status\_reported but for a specific lateral / sidetrack / re-entry). 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). 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). It is the declared function, not current activity: a plugged or shut-in producer stays PRODUCER, so use `WELLBORE_STATUS` for activity. What the wellbore produces or handles is on `PRIMARY_STREAM`. Functions other than PRODUCER come only from a recognised filed code in `WELLBORE_TYPE_REPORTED`; without one (for example, every Texas wellbore) the value is PRODUCER or NULL, so counts of injection, disposal or storage wells are incomplete there. NULL when the source does not establish a function, for example a dry hole (`PRIMARY_STREAM` = DRY) or a service well whose filing does not say which service. |
| `WELLBORE_TYPE_REPORTED` | The well-type code the source supplies for the regulator filing, trimmed and otherwise as filed. Codes, case and spelling vary by jurisdiction; they are not a controlled vocabulary. NULL where the source supplies no code (currently all Texas wellbores and most in Kansas and West Virginia). `WELLBORE_TYPE_NORMALIZED` and `PRIMARY_STREAM` use this code where it is recognised and a coarser classification otherwise, so they can hold a value when this column is NULL. |
| `PRIMARY_STREAM` | What the wellbore produces or handles, as declared, from a controlled vocabulary (OIL, GAS, `OIL_AND_GAS`, WATER, BRINE, WASTE, HELIUM, CO2, STEAM, BITUMEN, LITHIUM, POTASH, CBM, POLYMER, SOLVENT, AIR, `ACID_GAS`, DRY). Pairs with `WELLBORE_TYPE_NORMALIZED`: GAS on a STORAGE or DISPOSAL wellbore is gas stored or disposed of, not produced. For gas producers use `WELLBORE_TYPE_NORMALIZED` = 'PRODUCER' AND `PRIMARY_STREAM` IN ('GAS', '`OIL_AND_GAS`', 'CBM'); `OIL_AND_GAS` is a compound value, and coalbed methane wells currently carry GAS. Declared purpose, not observed production: a well declared for oil stays OIL while it dewaters, and the value asserts nothing about volumes. DRY appears only where a filed code classifies the bore as a dry hole, and then `WELLBORE_TYPE_NORMALIZED` is NULL. NULL when the source does not establish a stream. |
| `DIRECTION` | Novi's resolved well slant: the first of these that applies. `U_TURN_HORIZONTAL` when the calculated slant is a U-turn; HORIZONTAL when a directional survey not marked as planned shows a horizontal path; the normalized reported (filed) slant; the calculated slant. For a well whose survey-based resolution is not available, the survey step is skipped and the filed slant comes first. The filed wording is in `DIRECTION_REPORTED`. |
| `DIRECTION_REPORTED` | Raw reported slant/direction value from the state regulatory agency (e.g., "Horizontal", "Directional"). |
| `DIRECTION_REPORTED_NORMALIZED` | State-reported direction after normalization to a controlled vocabulary. |
| `DIRECTION_CALCULATED` | Slant that Novi infers from evidence other than the filed slant, such as the wellbore trajectory. 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. Every populated row reads 'EPSG:4326' (WGS 84), so coordinates need no reprojection before use; the column is NULL where no coordinate is available. |
| `HEELPOINT_LATITUDE` | Latitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `HEELPOINT_LONGITUDE` | Longitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `LANDING_POINT_LATITUDE` | Latitude of the landing point in decimal degrees, WGS84. |
| `LANDING_POINT_LONGITUDE` | Longitude of the landing point in decimal degrees, WGS84. |
| `MIDPOINT_LATITUDE` | Latitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `MIDPOINT_LONGITUDE` | Longitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `BOTTOM_HOLE_LATITUDE` | Latitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `BOTTOM_HOLE_LONGITUDE` | Longitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `SPUD_DATE` | Date drilling began on this wellbore: the earliest SPUD event for the wellbore in `WELL_EVENT` (`EVENT_DT`, else `EFFECTIVE_DT`), truncated to a date in UTC. `WELL_EVENT` is the only source; NULL where it has no SPUD event for the wellbore. |
| `TD_DATE` | Date total depth was reached. 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. Two sources: pivot from the well\_event ledger (event\_type = COMPLETED), else the first completion's well\_completion.completion\_end\_date. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event\_dt is optional on the ledger so effective\_dt is the fallback, and the date-time is truncated in UTC. |
| `FIRST_PRODUCTION_DATE` | Date of first reported production (turn-in-line): the earliest TIL event for the wellbore in `WELL_EVENT` (`EVENT_DT`, else `EFFECTIVE_DT`), truncated to a date in UTC. `WELL_EVENT` is the only source; NULL where it has no TIL event for the wellbore. |
| `PA_DATE` | Date the wellbore was plugged and abandoned. 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. The as-built value is wellbore.tvd\_td once drilled. |
| `CUM_OIL_12_REPORTED` | Reported volumes only; excludes forecast volumes. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. Non-additive ratio, never sum across wellbores. Its denominator is the selected lateral length, `LATERAL_LENGTH` in this view, with its method in `LATERAL_LENGTH_SOURCE`; the ratio need not equal `PROPPANT_MASS` / `LATERAL_LENGTH` on every row. A peer-set figure is an average of ratios rather than a ratio of totals. Values above 9,000 lb/ft are nulled as physically impossible rather than clamped, so a NULL can mean no credible ratio exists for the well even when `PROPPANT_MASS` is present. Also NULL when Novi's selected lateral length for the well is unknown or zero. That nulling is the guarantee this column carries: the denominator is chosen per well from perforations, survey points or depth, and falls back to a surface-to-bottom-hole distance, so it is not a single stated method. |
| `PROPPANT_CONCENTRATION` | Proppant mass per gallon of completion fluid, slurry concentration, independent of lateral length, computed by Novi rather than from columns in this view. 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. Non-additive ratio, never sum across wellbores. That lateral length is `LATERAL_LENGTH` in this view, with its method in `LATERAL_LENGTH_SOURCE`; the value need not equal `LATERAL_LENGTH` divided by `STAGE_COUNT` on every row. NULL when the stage count is zero or that lateral length is unknown. Whole feet. No bounds are applied, so implausibly large or small values (a few under 20 ft) are possible and are published as computed. |
| `IS_CHILD` | True if this well is classified as a child well (drilled after nearby parent wells were producing). |
| `PARENT_COUNT` | Number of neighboring parent wells meeting spacing criteria. |
| `PARENT_DAYS_ONLINE` | Days the nearest parent well was online relative to this well's start. |
| `CLOSEST_WELL_XY` | XY distance to the closest lateral and staggered neighbor in feet. Non-additive. |
| `CLOSEST_TWO_AVG_XY` | Average XY distance to the two closest neighbors (includes staggered and stacked). 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). Non-additive. |
| `LATERAL_CLOSER_XY` | XY distance to the nearest well in the same lateral row. Non-additive. |
| `STAGGER_CLOSER_TANGENT` | Tangent distance to the nearest staggered well. Non-additive. |
| `STACK_CLOSER_Z` | Vertical distance to the nearest well in the same vertical stack. Non-additive. |
| `BOUNDEDNESS_SCORE` | Number of neighbor quadrants occupied by wells (0-8). Non-additive. |
| `LATEST_OIL_GRAVITY` | Most recent oil API gravity reported for the well this wellbore belongs to, in degrees API. 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`. NULL together with it. |
| `LATEST_GAS_GRAVITY` | Most recent gas specific gravity reported for the well this wellbore belongs to (air = 1.0). 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`. 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). 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon. |
| `OPERATOR_REPORTED` | The well's current operator as reported for the well: a name, not resolved to an OPERATOR row (`OPERATOR_ID` carries the resolved operator). 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. It does not change when the well later changes operator. NULL where no original operator is recorded. |
| `LATERAL_LENGTH` | Selected lateral length in feet: a manual override where one exists, otherwise the first populated of `LATERAL_LENGTH_CALCULATED_U_TURN`, `LATERAL_LENGTH_CALCULATED_PERF`, `LATERAL_LENGTH_CALCULATED_LP_TO_BHL`, `LATERAL_LENGTH_CALCULATED_KP_TO_BHL`, `LATERAL_LENGTH_CALCULATED_MD_TVD` and `LATERAL_LENGTH_CALCULATED_SHL_BHL`, in that order. The method varies by row and is named in `LATERAL_LENGTH_SOURCE`, so values are not comparable across rows without it. Non-additive. NULL when no method yields a value, and then `LATERAL_LENGTH_SOURCE` is NULL too. |
| `LATERAL_LENGTH_SOURCE` | Label of the method that produced `LATERAL_LENGTH`, such as 'Manual Override', 'PerforationTop-PerforationBottom' or 'Landing-Bottom'. Distinguishes methods that share a calculated column, such as landing point to bottom hole and landing point to measured depth. NULL when `LATERAL_LENGTH` is NULL. |
| `LAST_REFRAC_DATE` | Date of the most recent refrac (re-stimulation after the original frac) on the wellbore, from the REFRAC event in `WELL_EVENT`: the latest event\_dt, with effective\_dt as the fallback, truncated to a date in UTC. NULL when `WELL_EVENT` carries no REFRAC event for the wellbore, which includes every wellbore whose `REFRAC_COUNT` is 0. |
| `REFRAC_COUNT` | Carried from WELLBORE.`REFRAC_COUNT`. 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. 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. NULL when `DIRECTIONAL_SURVEY_AVAILABLE` is false or NULL, which includes every Canadian wellbore. |
| `WELLBORE_TYPE` | The wellbore's declared operational function. It equals `WELLBORE_TYPE_NORMALIZED` and has the same values, meaning and limits; read that column's description. NULL wherever `WELLBORE_TYPE_NORMALIZED` is NULL. |
| `COUNTY_CODE` | Five-digit FIPS code of the county (or parish in Louisiana) where the well is located (e.g., "48389" for Reeves County, Texas). The name is in COUNTY. |

## WELLBORE_HEADER

Identity, jurisdiction, geology, operator, status and lifecycle dates. Grain: One row per wellbore\_key.

| Column | Description |
| --- | --- |
| `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). 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. For regulatory schemes (API10/API14/UWI-DLS) this is the external regulatory id, API14 captures the sidetrack/event suffix (positions 11-14) that disambiguates per-wellbore borehole+event; the well-level well.native\_id carries the well-level root (API10 for US, UWI-DLS for Canada). Use the contiguous 14-digit API14 (digits only, no hyphens). For the PLANNED scheme (planned wellbores with no regulatory id yet) this is the Novi-internal id (the planned\_well\_id). The scheme is named by native\_id\_type, which conditionally validates this value's canonical format per scheme; this value is the third component of wellbore\_key. |
| `OPERATOR_ID` | Current operator of record. 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. Primary key for the permit record. |
| `NATIVE_ID_TYPE` | Identifier scheme of native\_id (API10, API14, UWI-DLS, or PLANNED). 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). 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). 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). 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. 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. 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). 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. Use this for grouping peers; never group on a raw reported name. |
| `WELL_STATUS` | Current coarse lifecycle state of the well (derived from events). Includes 7 milestone-based values and 9 regulatory/operational ones; semantic overlaps (e.g. PERMITTED/`PERMIT_APPROVED`, DRILLING/SPUD, PRODUCING/ACTIVE, `SHUT_IN`/INACTIVE) are deliberately preserved as distinct values so you can tell which source vocabulary a row came from. Details live in well\_event. |
| `WELLBORE_STATUS` | Current lifecycle state for the wellbore (can differ from the well-level status). |
| `WELLBORE_STATUS_REPORTED` | Raw reported wellbore status value from the regulator filing, at wellbore grain (analogous to well.status\_reported but for a specific lateral / sidetrack / re-entry). 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). 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). It is the declared function, not current activity: a plugged or shut-in producer stays PRODUCER, so use `WELLBORE_STATUS` for activity. What the wellbore produces or handles is on `PRIMARY_STREAM`. Functions other than PRODUCER come only from a recognised filed code in `WELLBORE_TYPE_REPORTED`; without one (for example, every Texas wellbore) the value is PRODUCER or NULL, so counts of injection, disposal or storage wells are incomplete there. NULL when the source does not establish a function, for example a dry hole (`PRIMARY_STREAM` = DRY) or a service well whose filing does not say which service. |
| `WELLBORE_TYPE_REPORTED` | The well-type code the source supplies for the regulator filing, trimmed and otherwise as filed. Codes, case and spelling vary by jurisdiction; they are not a controlled vocabulary. NULL where the source supplies no code (currently all Texas wellbores and most in Kansas and West Virginia). `WELLBORE_TYPE_NORMALIZED` and `PRIMARY_STREAM` use this code where it is recognised and a coarser classification otherwise, so they can hold a value when this column is NULL. |
| `PRIMARY_STREAM` | What the wellbore produces or handles, as declared, from a controlled vocabulary (OIL, GAS, `OIL_AND_GAS`, WATER, BRINE, WASTE, HELIUM, CO2, STEAM, BITUMEN, LITHIUM, POTASH, CBM, POLYMER, SOLVENT, AIR, `ACID_GAS`, DRY). Pairs with `WELLBORE_TYPE_NORMALIZED`: GAS on a STORAGE or DISPOSAL wellbore is gas stored or disposed of, not produced. For gas producers use `WELLBORE_TYPE_NORMALIZED` = 'PRODUCER' AND `PRIMARY_STREAM` IN ('GAS', '`OIL_AND_GAS`', 'CBM'); `OIL_AND_GAS` is a compound value, and coalbed methane wells currently carry GAS. Declared purpose, not observed production: a well declared for oil stays OIL while it dewaters, and the value asserts nothing about volumes. DRY appears only where a filed code classifies the bore as a dry hole, and then `WELLBORE_TYPE_NORMALIZED` is NULL. NULL when the source does not establish a stream. |
| `DIRECTION` | Novi's resolved well slant: the first of these that applies. `U_TURN_HORIZONTAL` when the calculated slant is a U-turn; HORIZONTAL when a directional survey not marked as planned shows a horizontal path; the normalized reported (filed) slant; the calculated slant. For a well whose survey-based resolution is not available, the survey step is skipped and the filed slant comes first. The filed wording is in `DIRECTION_REPORTED`. |
| `DIRECTION_REPORTED` | Raw reported slant/direction value from the state regulatory agency (e.g., "Horizontal", "Directional"). |
| `DIRECTION_REPORTED_NORMALIZED` | State-reported direction after normalization to a controlled vocabulary. |
| `DIRECTION_CALCULATED` | Slant that Novi infers from evidence other than the filed slant, such as the wellbore trajectory. 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. Every populated row reads 'EPSG:4326' (WGS 84), so coordinates need no reprojection before use; the column is NULL where no coordinate is available. |
| `HEELPOINT_LATITUDE` | Latitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `HEELPOINT_LONGITUDE` | Longitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `LANDING_POINT_LATITUDE` | Latitude of the landing point in decimal degrees, WGS84. |
| `LANDING_POINT_LONGITUDE` | Longitude of the landing point in decimal degrees, WGS84. |
| `MIDPOINT_LATITUDE` | Latitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `MIDPOINT_LONGITUDE` | Longitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `BOTTOM_HOLE_LATITUDE` | Latitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `BOTTOM_HOLE_LONGITUDE` | Longitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `SPUD_DATE` | Date drilling began on this wellbore: the earliest SPUD event for the wellbore in `WELL_EVENT` (`EVENT_DT`, else `EFFECTIVE_DT`), truncated to a date in UTC. `WELL_EVENT` is the only source; NULL where it has no SPUD event for the wellbore. |
| `TD_DATE` | Date total depth was reached. 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. Two sources: pivot from the well\_event ledger (event\_type = COMPLETED), else the first completion's well\_completion.completion\_end\_date. Aggregated with MIN because the ledger permits more than one event of a type per wellbore, and this view is one row per wellbore; event\_dt is optional on the ledger so effective\_dt is the fallback, and the date-time is truncated in UTC. |
| `FIRST_PRODUCTION_DATE` | Date of first reported production (turn-in-line): the earliest TIL event for the wellbore in `WELL_EVENT` (`EVENT_DT`, else `EFFECTIVE_DT`), truncated to a date in UTC. `WELL_EVENT` is the only source; NULL where it has no TIL event for the wellbore. |
| `PA_DATE` | Date the wellbore was plugged and abandoned. 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. The as-built value is wellbore.tvd\_td once drilled. |
| `OPERATOR_REPORTED` | The well's current operator as reported for the well: a name, not resolved to an OPERATOR row (`OPERATOR_ID` carries the resolved operator). 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. It does not change when the well later changes operator. NULL where no original operator is recorded. |
| `LATERAL_LENGTH` | Selected lateral length in feet: a manual override where one exists, otherwise the first populated of `LATERAL_LENGTH_CALCULATED_U_TURN`, `LATERAL_LENGTH_CALCULATED_PERF`, `LATERAL_LENGTH_CALCULATED_LP_TO_BHL`, `LATERAL_LENGTH_CALCULATED_KP_TO_BHL`, `LATERAL_LENGTH_CALCULATED_MD_TVD` and `LATERAL_LENGTH_CALCULATED_SHL_BHL`, in that order. The method varies by row and is named in `LATERAL_LENGTH_SOURCE`, so values are not comparable across rows without it. Non-additive. NULL when no method yields a value, and then `LATERAL_LENGTH_SOURCE` is NULL too. |
| `LATERAL_LENGTH_SOURCE` | Label of the method that produced `LATERAL_LENGTH`, such as 'Manual Override', 'PerforationTop-PerforationBottom' or 'Landing-Bottom'. Distinguishes methods that share a calculated column, such as landing point to bottom hole and landing point to measured depth. NULL when `LATERAL_LENGTH` is NULL. |
| `LAST_REFRAC_DATE` | Date of the most recent refrac (re-stimulation after the original frac) on the wellbore, from the REFRAC event in `WELL_EVENT`: the latest event\_dt, with effective\_dt as the fallback, truncated to a date in UTC. NULL when `WELL_EVENT` carries no REFRAC event for the wellbore, which includes every wellbore whose `REFRAC_COUNT` is 0. |
| `DIRECTIONAL_SURVEY_AVAILABLE` | True when directional survey stations are reported for the wellbore, false when none are. 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. NULL when `DIRECTIONAL_SURVEY_AVAILABLE` is false or NULL, which includes every Canadian wellbore. |
| `WELLBORE_TYPE` | The wellbore's declared operational function. It equals `WELLBORE_TYPE_NORMALIZED` and has the same values, meaning and limits; read that column's description. NULL wherever `WELLBORE_TYPE_NORMALIZED` is NULL. |
| `COUNTY_CODE` | Five-digit FIPS code of the county (or parish in Louisiana) where the well is located (e.g., "48389" for Reeves County, Texas). 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. 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`. 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. 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`. NULL together with it. |

## WELLBORE_COMPLETION_DESIGN

First-completion design plus intensity ratios. Grain: One row per wellbore\_key, first completion (completion\_sequence = 1).

| Column | Description |
| --- | --- |
| `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 outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `WELL_COMPLETION_ID` | Surrogate key of the completion event this row collapsed to, the first completion. Carried so a consumer can trace back to the source row and audit the collapse. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `COMPLETION_SEQUENCE` | Ordinal of the completion within the wellbore, ascending. 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. 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. Non-additive ratio, never sum across wellbores. It cannot be recomputed from this view, which does not carry its denominator, the selected lateral length, published as `LATERAL_LENGTH` on `WELLBORE_HEADER` and `WELL_DETAIL` with its method in `LATERAL_LENGTH_SOURCE`; a peer-set figure is an average of ratios rather than a ratio of totals. Values above 9,000 lb/ft are nulled as physically impossible rather than clamped, so a NULL can mean no credible ratio exists for the well even when `PROPPANT_MASS` is present. Also NULL when Novi's selected lateral length for the well is unknown or zero. That nulling is the guarantee this column carries: the denominator is chosen per well from perforations, survey points or depth, and falls back to a surface-to-bottom-hole distance, so it is not a single stated method. |
| `PROPPANT_CONCENTRATION` | Proppant mass per gallon of completion fluid, slurry concentration, independent of lateral length, computed by Novi rather than from columns in this view. 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. Non-additive ratio, never sum across wellbores. It cannot be recomputed from this view, which does not carry that lateral length; `WELLBORE_HEADER` and `WELL_DETAIL` publish it as `LATERAL_LENGTH`, with its method in `LATERAL_LENGTH_SOURCE`. NULL when the stage count is zero or that lateral length is unknown. Whole feet. No bounds are applied, so implausibly large or small values (a few under 20 ft) are possible and are published as computed. |
| `BASIN` | Basin name (e.g., Permian, Eagle Ford). |
| `SUBBASIN` | Subbasin name (e.g., Delaware, Midland). |
| `SOAK_TIME_DAYS` | Number of days between the end of the first completion and the start of production (the soak period). 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. |

## 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. 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.

| Column | Description |
| --- | --- |
| `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 outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `CUM_OIL_12_REPORTED` | Reported volumes only; excludes forecast volumes. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. |

## WELLBORE_DECLINE_PARAMETERS

Arps parameters per segment per stream, shaped for ARIES export. Grain: One row per (wellbore\_key, production\_forecast\_id, production\_stream, segment\_number).

| Column | Description |
| --- | --- |
| `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 outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `PRODUCTION_FORECAST_ID` | Forecast run to which this segment belongs. Use to group segments and parameters by a single forecast execution. May be NULL when no parent production\_forecast row exists for this segment. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `PRODUCTION_STREAM` | Which stream this segment forecasts (e.g., oil, gas, ngl, water, condensate). |
| `SEGMENT_UID` | Stable, immutable unique identifier for this segment. |
| `SEGMENT_NUMBER` | 1-based index of the segment within the stream for the wellbore\_key. |
| `KIND` | ARPS regime represented by this segment: - buildup: early-time pre-decline behavior, - transition: changeover period between regimes, - terminal: late-time decline segment. |
| `SEGMENT_CURVE_TYPE` | Type of decline curve applied in this segment. 'exponential' assumes constant nominal decline D; 'hyperbolic' uses exponent b (0&lt;b&lt;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). 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. Must be &gt;= 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). 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). NULL when the wellbore has no calendar anchor. See segment\_start\_date. |
| `B_FACTOR` | Arps hyperbolic exponent b for this segment. 0 = exponential, 1 = harmonic, 0 &lt; b &lt; 1 = hyperbolic. Non-additive, never average across wellbores. |
| `NOMINAL_DECLINE_RATE` | D\_nom, nominal decline parameter used in ARPS (1/day). 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)). 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)). 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. 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). Should be &lt;= 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). |

## WELLBORE_SPACING_DETAIL

Parent/child classification and neighbour distances for interference work. Grain: One row per wellbore\_key.

| Column | Description |
| --- | --- |
| `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 outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `IS_CHILD` | True if this well is classified as a child well (drilled after nearby parent wells were producing). |
| `PARENT_COUNT` | Number of neighboring parent wells meeting spacing criteria. |
| `PARENT_DAYS_ONLINE` | Days the nearest parent well was online relative to this well's start. |
| `CLOSEST_WELL_XY` | XY distance to the closest lateral and staggered neighbor in feet. Non-additive. |
| `CLOSEST_TWO_AVG_XY` | Average XY distance to the two closest neighbors (includes staggered and stacked). 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). Non-additive. |
| `LATERAL_CLOSER_XY` | XY distance to the nearest well in the same lateral row. Non-additive. |
| `STAGGER_CLOSER_TANGENT` | Tangent distance to the nearest staggered well. Non-additive. |
| `STACK_CLOSER_Z` | Vertical distance to the nearest well in the same vertical stack. Non-additive. |
| `BOUNDEDNESS_SCORE` | Number of neighbor quadrants occupied by wells (0-8). Non-additive. |
| `BASIN` | Basin name (e.g., Permian, Eagle Ford). |
| `SUBBASIN` | Subbasin name (e.g., Delaware, Midland). |

## WELLBORE_SUBSURFACE_PROPERTY

Rock properties and landing-zone geometry at one measurement point. Grain: One row per (wellbore\_key, location\_type, formation).

| Column | Description |
| --- | --- |
| `WELLBORE_KEY` | Foreign key to wellbore.wellbore\_key, the canonical anchor for every subsurface\_property row. 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 outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `SURVEY_STATION_ID` | Optional foreign key to directional\_survey\_station.survey\_station\_id. Populated when the wellbore has a matching directional survey station for the row's location type; NULL when the parent wellbore has no directional-survey coverage. Use wellbore\_key as the always-populated anchor. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `LOCATION_TYPE` | Type of measurement point along the wellbore, as an integer code. 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. 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. 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. Unit and range are not defined. Non-additive. |
| `COMPETENCY_OF_NET` | Competency averaged over net pay cutoffs, on the same scale as competency\_avg. 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). |

## WELLBORE_TEST_HISTORY

Well-test rates and flowing and shut-in pressures. Grain: One row per (wellbore\_key, test\_date).

| Column | Description |
| --- | --- |
| `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 outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `TEST_DATE` | Date on which the well test was performed. |
| `REPORT_DATE` | Date when the test was first reported. May differ from test\_date. |
| `OIL_RATE` | 24-hour oil production rate in barrels per day. Semi-additive: do not sum across wellbores. |
| `GAS_RATE` | 24-hour gas production rate in Mcf per day. Semi-additive: do not sum across wellbores. |
| `WATER_RATE` | 24-hour water production rate in barrels per day. Semi-additive: do not sum across wellbores. |
| `FLOWING_WELLHEAD_PRESSURE` | Pressure at the wellhead while flowing during the test. Semi-additive. |
| `SHUT_IN_WELLHEAD_PRESSURE` | Pressure at the wellhead while shut-in during the test. Semi-additive. |
| `BOTTOM_HOLE_PRESSURE` | Bottom hole pressure during the test. Semi-additive. |
| `OIL_GRAVITY` | API gravity of produced oil in degrees, measured at standard conditions (60°F). Conventional buckets: &lt;22.3 = heavy, 22.3–31.1 = medium, &gt;31.1 = light, &gt;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. 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). |

## PRODUCTION_MONTHLY

Monthly volumes by stream across calendar, producing and economic time axes. 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.

| Column | Description |
| --- | --- |
| `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 outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `PRODUCTION_DATE` | First day of the month for this record. 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. 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 &gt;= 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. After the first index every calendar month advances it by one whether or not the month produced, so it is a calendar index, unique and contiguous per wellbore, and never a count of producing months. The elapsed-time axis for type-curve analysis: it aligns wells of different vintages on months since first production rather than on absolute date (year/month). Elapsed, not produced, a shut-in month still advances it. `SUPPLY_PROJECTION` uses the same 1-based convention, so cohort joins line up. |
| `OIL` | Oil volume produced at the wellhead for the period, measured in barrels (bbl). |
| `GAS` | Natural gas volume produced at the wellhead for the period, measured in thousand cubic feet (Mcf). |
| `WATER` | Produced water volume for the period, measured in barrels (bbl). |
| `GAS_FLARED` | Natural gas volume flared in the period, measured in thousand cubic feet (Mcf). 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). |

## PRODUCTION_FORECAST_MONTHLY

Monthly forecast rates and cumulatives by stream, per scenario. 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.

| Column | Description |
| --- | --- |
| `WELLBORE_KEY` | Foreign key to wellbore.wellbore\_key. |
| `PRODUCTION_FORECAST_ID` | Identifier that groups the period rows of one forecast. Shared by those rows, so it is not unique per row. |
| `NATIVE_ID` | Regulatory identifier of the wellbore this row belongs to, the same value as `WELLBORE_HEADER`.`NATIVE_ID`, so the row can be joined to data outside `NOVI_WELLS`. Its scheme (API10, API14, UWI-DLS, UWI-NTS or PLANNED) is `NATIVE_ID_TYPE`. Not a unique bore key: an API10 does not distinguish the bores of a multi-lateral, so join rows on `WELLBORE_KEY`. |
| `NATIVE_ID_TYPE` | Identifier scheme of `NATIVE_ID` (API10, API14, UWI-DLS, UWI-NTS or PLANNED), the same value as `WELLBORE_HEADER`.`NATIVE_ID_TYPE`. |
| `SCENARIO` | Forecast scenario percentile. 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. For monthly records this is the month ordinal times 30, where the ordinal is 1-based (so month 1 encodes as 30); for weekly records, multiples of 7. The lowest value actually present in a given fact depends on which months that fact carries, a forecast-only projection whose historical months are excluded starts at whatever month the forecast begins, not at 30. NOT a count of elapsed days, dividing by 30 recovers the month index exactly, and real elapsed time drifts from it by roughly 0.44 days per month (about 264 days over a 600-month horizon). Note this is a different basis from production.months\_on\_production: a day index, not a month index. Use forecast\_day to order rows within this fact. Do NOT use it as an alignment key against production\_forecast\_arps\_segment.day\_start (real calendar days) or for discounting; align on year / month, or on the segment's segment\_start\_date / segment\_end\_date. |
| `YEAR` | Calendar year of the production month this forecast row represents. 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. 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). 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. 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). 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. 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). 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. 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. On yearly records, the first day of the first month of the 12-month block; not 1 January. On monthly records it joins to production.production\_date by value; on yearly records it matches only the block's first month. |
| `FORECAST_MONTH` | 1-based index of the month within the wellbore's monthly series of consecutive months, 1 being the series' earliest month. 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. |
