Skip to content
Developers
Get an API token

Forecasts

Monthly production forecasts, Arps decline segments and parameters, and county supply projections.

View MarkdownOpen in Claude(opens in a new tab)

Views live in NOVI_DATA_ACCESS.NOVI_WELLS. Column descriptions are from the Wells data dictionary, release 26.4.3. Type is the data model’s logical type, and unit appears where the model declares one. For Snowflake column types, query NOVI_DATA_ACCESS.INFORMATION_SCHEMA.COLUMNS.

23 columns

Forecasted monthly production for a wellbore.

More about this view

One row per (wellbore_key, forecast_day, scenario). This projection currently ships monthly granularity only (period_granularity='monthly') and the P50 scenario only, the source is monthly and emits a single deterministic forecast. Stream rates (oil/gas/water) come from source; oil carries condensate combined, as the source oil does, and NGL and condensate are NULL. Cumulative columns aggregate over the forecast horizon. The year / month pair carries the PRODUCTION month each row represents, not a revenue month, and is the calendar axis for aligning rows with actual production and with production_forecast_arps_segment.segment_start_date. Do not align on forecast_day, which is a nominal period ordinal rather than elapsed time; see its description.

Sample query
SELECT PRODUCTION_FORECAST_ID, WELLBORE_KEY, PERIOD_GRANULARITY, FORECAST_DAY, YEAR
FROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECAST
LIMIT 10
Columns23
PRODUCTION_FORECAST_IDinteger
Identifier that groups the period rows of one forecast.
More

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

WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
PERIOD_GRANULARITYstring
Granularity of this forecast record.
More

A yearly record is a 12-month block counted from the first month of the wellbore's monthly series, not a calendar year.

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

For monthly records this is the month ordinal times 30, where the ordinal is 1-based (so month 1 encodes as 30); for weekly records, multiples of 7. The lowest value actually present in a given fact depends on which months that fact carries, a forecast-only projection whose historical months are excluded starts at whatever month the forecast begins, not at 30. NOT a count of elapsed days, dividing by 30 recovers the month index exactly, and real elapsed time drifts from it by roughly 0.44 days per month (about 264 days over a 600-month horizon). Same 1-based month ordinal as MONTHS_ON_PRODUCTION (times 30 for monthly records). 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.

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

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

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

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

SCENARIOstring
Forecast scenario.
More

This release publishes P50, the median forecast, only.

OIL_PER_DAYnumberbbl/d
Oil rate (bbl/d).
More

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

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

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

GAS_PER_DAYnumberMcf/d
Gas rate (Mcf/d).
More

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

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

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

NGL_PER_DAYnumberbbl/d
NGL rate (bbl/d).
More

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

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

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

WATER_PER_DAYnumberbbl/d
Water rate (bbl/d).
More

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

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

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

CONDENSATE_PER_DAYnumberbbl/d
Condensate rate (bbl/d).
More

Null wherever condensate is not carried separately; the rate may then be combined into oil_per_day, so a null does not establish that none 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_CONDENSATEnumberbbl
Cumulative condensate volume (bbl), null wherever condensate is not carried separately (it may then be combined into cumulative_oil), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More

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

FORECAST_DATEdate
First day of the calendar month whose production this row forecasts (e.g. 2034-03-01): the forecast production month, not the revenue month, which typically lags 1–2 months.
More

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

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

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

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_ATtimestamp
Source ingestion timestamp from the production forecast feed.
14 columns

An ARPS forecast segment refers to a specific time range for a single production stream of a wellbore.

More about this view

Each segment consists of a continuous number of days that share the same ARPS regime (for example, buildup, transition, or terminal). Segments are numbered starting from one and are ordered sequentially; they must not overlap within a specific combination of wellbore_key and production_stream.

Sample query
SELECT WELLBORE_KEY, PRODUCTION_FORECAST_ID, SEGMENT_UID, PRODUCTION_STREAM, SEGMENT_NUMBER
FROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECAST_ARPS_SEGMENT
LIMIT 10
Columns14
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
PRODUCTION_FORECAST_IDinteger
Forecast run to which this segment belongs.
More

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

SEGMENT_UIDinteger
Stable, immutable unique identifier for this segment.
PRODUCTION_STREAMstring
Which stream this segment forecasts (e.g., oil, gas, ngl, water, condensate).
SEGMENT_NUMBERinteger
1-based index of the segment within the stream for the wellbore_key.
KINDstring
ARPS regime represented by this segment: - buildup: early-time pre-decline behavior, - transition: changeover period between regimes, - terminal: late-time decline segment.
SEGMENT_CURVE_TYPEstring
Type of decline curve applied in this segment.
More

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

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

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

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

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

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

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

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

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

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.

PRODUCTION_FORECAST_ARPS_SEGMENT_PARAMETER

Section titled “PRODUCTION_FORECAST_ARPS_SEGMENT_PARAMETER”
11 columns

Parameter values associated with a single ARPS forecast segment.

More about this view

These parameters describe decline behavior and rates for the segment referenced by forecast_segment_id. Units for rates should match the stream's production rate (e.g., bbl/d, mcf/d). Decline rates are per-day fractions unless otherwise noted.

Joins to
Sample query
SELECT FORECAST_SEGMENT_ID, SEGMENT_PARAMETER_UID, B_FACTOR, EFFECTIVE_DECLINE_RATE_TANGENT, EFFECTIVE_DECLINE_RATE_SECANT
FROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECAST_ARPS_SEGMENT_PARAMETER
LIMIT 10
Columns11
FORECAST_SEGMENT_IDinteger
Foreign key to the ARPS segment this parameter set applies to.
More

Must reference an existing ProductionForecastArpsSegment.segment_uid.

SEGMENT_PARAMETER_UIDinteger
Stable unique identifier for this parameter row.
B_FACTORnumber
Hyperbolic decline exponent b. >0 for hyperbolic; b=1 is harmonic; values typically in (0, 2].
More

Only relevant when the segment curve type is hyperbolic/harmonic.

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

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

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

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

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

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

SEGMENT_START_RATEnumber
q_start, production rate at the beginning of the segment (same units as stream, e.g., bbl/d or mcf/d).
SEGMENT_END_RATEnumber
q_end, production rate at the end of the segment (same units as stream).
More

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

SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_ATtimestamp
Timestamp the record was created.
UPDATED_ATtimestamp
Timestamp of the most recent update.
14 columns

County-level type curve projections for oil and gas supply modeling.

More about this view

One row per county per production-start-month cohort per months-on-production. Provides average forecasted production rates and volumes per well for horizontal wells that started producing since 2010.

Key columns
Joins to
Sample query
SELECT SUPPLY_PROJECTION_ID, COUNTY_CODE, MONTH_OF_PRODUCTION_START, MONTHS_ON_PRODUCTION, DATE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.SUPPLY_PROJECTION
LIMIT 10
Columns14
SUPPLY_PROJECTION_ID
Surrogate key.
COUNTY_CODE
FIPS county code.
MONTH_OF_PRODUCTION_START
First day of the month in which the cohort started producing.
MONTHS_ON_PRODUCTION
Month index from first production.
More

Uses the same convention as PRODUCTION.MONTHS_ON_PRODUCTION: 1 = the first month on production, or 0 for a distinguished incomplete first month before full month 1. For supply projections the first index represents the cohort's first month on production.

DATE
Calendar date for this data point.
YEAR_OF_PRODUCTION_START
Year the cohort started producing.
OIL_PER_MONTH_PROJECTED
Average forecasted oil production per well for this month.
More

A per-well average, so it is non-additive: summing it across cohorts or months does not give a total volume.

OIL_PER_DAY_PROJECTED
Average forecasted oil production rate per well per day.
More

Non-additive (rate average).

GAS_PER_MONTH_PROJECTED
Average forecasted gas production per well for this month.
More

A per-well average, so it is non-additive: summing it across cohorts or months does not give a total volume.

GAS_PER_DAY_PROJECTED
Average forecasted gas production rate per well per day.
More

Non-additive (rate average).

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
UPDATED_AT
Timestamp of the most recent update.