Skip to main content

Monthly forecast combined volumes

Monthly forecast combined volumes​

1. Integration overview​

Dataset Name: Monthly Forecast Combined Volumes
Secure View: FORECAST_COMBINED_VOLUMES_MONTHLY_SV
Delivery Mechanism: Snowflake Secure View via Private Share
Update Pattern: Immutable / Append-Only
Export Trigger:

  • User-triggered from ComboCurve UI
  • Triggered via ComboCurve Export v2 (Snowflake export)

Data Retention: 30 days

2. Business context (Oil & Gas Reservoir Engineering)​

This dataset provides monthly time-series volumes per well that combine measured production with forecasted volumes for common phases (Oil/Gas/Water) and tenant-configured custom streams.

A key feature of the client-facing secure view is stitched volumes:

  • *_PRODUCTION = measured volumes (where present)
  • *_FORECAST = modeled forecast volumes
  • *_STITCHED = view-computed combined series that:
    • returns 0 prior to first production record for the phase
    • returns production values where production exists
    • returns forecast values after the last production record for the phase

Stitched columns are computed in the secure view using ordered per-well rows and per-phase production boundaries.

4. Expected record uniqueness​

This dataset is append-only and may contain multiple exports for the same well and month.

The expected uniqueness constraint is:

(FORECAST_VOLUME_EXPORT_ID or PROJECT_ID, FORECAST_ID, USER_ID, EXPORT_DATE)

5. Client access pattern​

Query the secure view directly:

  • Primary access object: FORECAST_COMBINED_VOLUMES_MONTHLY_SV
  • Typical filters: FORECAST_VOLUME_EXPORT_ID (batch scoping); PROJECT_ID, FORECAST_ID, USER_ID, EXPORT_DATE (time window)

Example:

SELECT *
FROM SHARED_DATABASE.FORECAST_COMBINED_VOLUMES_MONTHLY_SV
WHERE PROJECT_ID = '<project_id>'
  AND FORECAST_ID = '<forecast_id>'
  AND DATE >= '2024-01-01';

Recommended filters:

  • FORECAST_VOLUME_EXPORT_ID (batch scoping)
  • PROJECT_ID
  • FORECAST_ID
  • USER_ID
  • DATE (time window)

6. Full schema definition (client-facing secure view)​

Below is the schema for FORECAST_COMBINED_VOLUMES_MONTHLY_SV, grouped into data categories for easier consumption.

Note: OIL_STITCHED, GAS_STITCHED, and WATER_STITCHED are computed in the view and do not exist in the base table.

6.1 Well & cross-reference identifiers​

ColumnData TypeDescription
WELL_NAMEVARCHARHuman-readable well name used in the source system.
WELL_NUMBERVARCHAREngineering well number or identifier assigned by the operator.
API14VARCHAR14-digit API number uniquely identifying the wellbore.
INPTIDVARCHARINPT (PIDX) unique identifier for the well.
CHOSENIDVARCHARChosen Energy cross-reference ID for the well.
ARIES_IDVARCHARWell identifier in ARIES economic software.
PHDWIN_IDVARCHARWell identifier in PHDWin reserves software.
PROJECT_IDVARCHARComboCurve project identifier.
FORECAST_IDVARCHARUnique ID of the forecast case that produced these volumes.
USER_IDVARCHARIdentifier of the user who executed the export.
WELL_IDVARCHARComboCurve master well identifier.
FORECAST_VOLUME_EXPORT_IDVARCHARGUID of the volume-export job.
EXPORT_DATETIMESTAMP_NTZUTC timestamp when the volume set was exported.
DATETIMESTAMP_NTZCalendar month represented by the row.

6.2 Monthly volumes (Oil/Gas/Water + stitched)​

ColumnData TypeDescription
OIL_PRODUCTIONFLOATMeasured monthly oil production.
OIL_FORECASTFLOATModel-forecast oil volume.
OIL_STITCHEDFLOATCombined oil volume (production where available; forecast beyond last production; 0 before first production).
GAS_PRODUCTIONFLOATMeasured monthly gas production.
GAS_FORECASTFLOATModel-forecast gas volume.
GAS_STITCHEDFLOATCombined gas volume (production where available; forecast beyond last production; 0 before first production).
WATER_PRODUCTIONFLOATMeasured monthly produced-water volume.
WATER_FORECASTFLOATModel-forecast produced-water volume.
WATER_STITCHEDFLOATCombined water volume (production where available; forecast beyond last production; 0 before first production).

6.3 User-defined CustomNumber streams (0–19)​

ColumnData TypeDescription
CUSTOMNUMBER0_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber0.
CUSTOMNUMBER0_FORECASTFLOATForecast volume for user-defined CustomNumber0.
CUSTOMNUMBER1_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber1.
CUSTOMNUMBER1_FORECASTFLOATForecast volume for user-defined CustomNumber1.
CUSTOMNUMBER2_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber2.
CUSTOMNUMBER2_FORECASTFLOATForecast volume for user-defined CustomNumber2.
CUSTOMNUMBER3_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber3.
CUSTOMNUMBER3_FORECASTFLOATForecast volume for user-defined CustomNumber3.
CUSTOMNUMBER4_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber4.
CUSTOMNUMBER4_FORECASTFLOATForecast volume for user-defined CustomNumber4.
CUSTOMNUMBER5_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber5.
CUSTOMNUMBER5_FORECASTFLOATForecast volume for user-defined CustomNumber5.
CUSTOMNUMBER6_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber6.
CUSTOMNUMBER6_FORECASTFLOATForecast volume for user-defined CustomNumber6.
CUSTOMNUMBER7_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber7.
CUSTOMNUMBER7_FORECASTFLOATForecast volume for user-defined CustomNumber7.
CUSTOMNUMBER8_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber8.
CUSTOMNUMBER8_FORECASTFLOATForecast volume for user-defined CustomNumber8.
CUSTOMNUMBER9_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber9.
CUSTOMNUMBER9_FORECASTFLOATForecast volume for user-defined CustomNumber9.
CUSTOMNUMBER10_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber10.
CUSTOMNUMBER10_FORECASTFLOATForecast volume for user-defined CustomNumber10.
CUSTOMNUMBER11_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber11.
CUSTOMNUMBER11_FORECASTFLOATForecast volume for user-defined CustomNumber11.
CUSTOMNUMBER12_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber12.
CUSTOMNUMBER12_FORECASTFLOATForecast volume for user-defined CustomNumber12.
CUSTOMNUMBER13_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber13.
CUSTOMNUMBER13_FORECASTFLOATForecast volume for user-defined CustomNumber13.
CUSTOMNUMBER14_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber14.
CUSTOMNUMBER14_FORECASTFLOATForecast volume for user-defined CustomNumber14.
CUSTOMNUMBER15_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber15.
CUSTOMNUMBER15_FORECASTFLOATForecast volume for user-defined CustomNumber15.
CUSTOMNUMBER16_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber16.
CUSTOMNUMBER16_FORECASTFLOATForecast volume for user-defined CustomNumber16.
CUSTOMNUMBER17_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber17.
CUSTOMNUMBER17_FORECASTFLOATForecast volume for user-defined CustomNumber17.
CUSTOMNUMBER18_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber18.
CUSTOMNUMBER18_FORECASTFLOATForecast volume for user-defined CustomNumber18.
CUSTOMNUMBER19_PRODUCTIONFLOATMeasured monthly volume for user-defined CustomNumber19.
CUSTOMNUMBER19_FORECASTFLOATForecast volume for user-defined CustomNumber19.

6.4 Project custom streams (0–19)​

ColumnData TypeDescription
_PROJECT_CUSTOM_STREAM_0_PRODUCTIONFLOATMeasured monthly volume for project custom stream 0.
_PROJECT_CUSTOM_STREAM_0_FORECASTFLOATForecast volume for project custom stream 0.
_PROJECT_CUSTOM_STREAM_1_PRODUCTIONFLOATMeasured monthly volume for project custom stream 1.
_PROJECT_CUSTOM_STREAM_1_FORECASTFLOATForecast volume for project custom stream 1.
_PROJECT_CUSTOM_STREAM_2_PRODUCTIONFLOATMeasured monthly volume for project custom stream 2.
_PROJECT_CUSTOM_STREAM_2_FORECASTFLOATForecast volume for project custom stream 2.
_PROJECT_CUSTOM_STREAM_3_PRODUCTIONFLOATMeasured monthly volume for project custom stream 3.
_PROJECT_CUSTOM_STREAM_3_FORECASTFLOATForecast volume for project custom stream 3.
_PROJECT_CUSTOM_STREAM_4_PRODUCTIONFLOATMeasured monthly volume for project custom stream 4.
_PROJECT_CUSTOM_STREAM_4_FORECASTFLOATForecast volume for project custom stream 4.
_PROJECT_CUSTOM_STREAM_5_PRODUCTIONFLOATMeasured monthly volume for project custom stream 5.
_PROJECT_CUSTOM_STREAM_5_FORECASTFLOATForecast volume for project custom stream 5.
_PROJECT_CUSTOM_STREAM_6_PRODUCTIONFLOATMeasured monthly volume for project custom stream 6.
_PROJECT_CUSTOM_STREAM_6_FORECASTFLOATForecast volume for project custom stream 6.
_PROJECT_CUSTOM_STREAM_7_PRODUCTIONFLOATMeasured monthly volume for project custom stream 7.
_PROJECT_CUSTOM_STREAM_7_FORECASTFLOATForecast volume for project custom stream 7.
_PROJECT_CUSTOM_STREAM_8_PRODUCTIONFLOATMeasured monthly volume for project custom stream 8.
_PROJECT_CUSTOM_STREAM_8_FORECASTFLOATForecast volume for project custom stream 8.
_PROJECT_CUSTOM_STREAM_9_PRODUCTIONFLOATMeasured monthly volume for project custom stream 9.
_PROJECT_CUSTOM_STREAM_9_FORECASTFLOATForecast volume for project custom stream 9.
_PROJECT_CUSTOM_STREAM_10_PRODUCTIONFLOATMeasured monthly volume for project custom stream 10.
_PROJECT_CUSTOM_STREAM_10_FORECASTFLOATForecast volume for project custom stream 10.
_PROJECT_CUSTOM_STREAM_11_PRODUCTIONFLOATMeasured monthly volume for project custom stream 11.
_PROJECT_CUSTOM_STREAM_11_FORECASTFLOATForecast volume for project custom stream 11.
_PROJECT_CUSTOM_STREAM_12_PRODUCTIONFLOATMeasured monthly volume for project custom stream 12.
_PROJECT_CUSTOM_STREAM_12_FORECASTFLOATForecast volume for project custom stream 12.
_PROJECT_CUSTOM_STREAM_13_PRODUCTIONFLOATMeasured monthly volume for project custom stream 13.
_PROJECT_CUSTOM_STREAM_13_FORECASTFLOATForecast volume for project custom stream 13.
_PROJECT_CUSTOM_STREAM_14_PRODUCTIONFLOATMeasured monthly volume for project custom stream 14.
_PROJECT_CUSTOM_STREAM_14_FORECASTFLOATForecast volume for project custom stream 14.
_PROJECT_CUSTOM_STREAM_15_PRODUCTIONFLOATMeasured monthly volume for project custom stream 15.
_PROJECT_CUSTOM_STREAM_15_FORECASTFLOATForecast volume for project custom stream 15.
_PROJECT_CUSTOM_STREAM_16_PRODUCTIONFLOATMeasured monthly volume for project custom stream 16.
_PROJECT_CUSTOM_STREAM_16_FORECASTFLOATForecast volume for project custom stream 16.
_PROJECT_CUSTOM_STREAM_17_PRODUCTIONFLOATMeasured monthly volume for project custom stream 17.
_PROJECT_CUSTOM_STREAM_17_FORECASTFLOATForecast volume for project custom stream 17.
_PROJECT_CUSTOM_STREAM_18_PRODUCTIONFLOATMeasured monthly volume for project custom stream 18.
_PROJECT_CUSTOM_STREAM_18_FORECASTFLOATForecast volume for project custom stream 18.
_PROJECT_CUSTOM_STREAM_19_PRODUCTIONFLOATMeasured monthly volume for project custom stream 19.
_PROJECT_CUSTOM_STREAM_19_FORECASTFLOATForecast volume for project custom stream 19.

6.5 UI label mapping​

Most columns appear in the ComboCurve UI under a simple title-cased version of the column name (OIL_PRODUCTION → "Oil", GAS_FORECAST → "Gas Forecast"). The exceptions are the cross-reference identifiers and the custom-stream columns below.

Watch out for these:

  • Custom streams are user-named. The CUSTOMNUMBER{0–19}_* columns carry the company's user-defined stream label in the UI (for example "NGL Yield"), not "Custom Number 0". The underlying token is camelCase (customNumber0) — contrast the snake_case CUSTOM_NUMBER_0 form used in the production-volume datasets.
  • Project custom streams are off by one. _PROJECT_CUSTOM_STREAM_{i}_* is 0-indexed in the column name, but the UI default label is 1-indexed — _PROJECT_CUSTOM_STREAM_0_* shows as "Project Custom Stream 1".
Snowflake columnComboCurve UI label
INPTIDINPT ID
CHOSENIDChosen ID
API14API 14
ARIES_IDAries ID
PHDWIN_IDPhdWin ID

7. Incremental consumption best practices​

Pull only new or changed records​

For scheduled ingestion, pull rows where EXPORT_DATE is after your last run, or scope to a single export batch by FORECAST_VOLUME_EXPORT_ID.

SELECT *
FROM FORECAST_COMBINED_VOLUMES_MONTHLY_SV
WHERE EXPORT_DATE > DATEADD(day, -1, CURRENT_TIMESTAMP);
SELECT *
FROM FORECAST_COMBINED_VOLUMES_MONTHLY_SV
WHERE FORECAST_VOLUME_EXPORT_ID = '<export-guid>';

Deduplicate by the secure-view key​

Treat (FORECAST_VOLUME_EXPORT_ID or PROJECT_ID, FORECAST_ID, USER_ID, EXPORT_DATE) as the record key when loading into your target. Multiple exports for the same well and month are expected across batches.

8. Operational notes​

  • Data is immutable once exported.
  • Multiple exports of the same well and month are expected across batches.
  • The secure view computes stitched columns for Oil/Gas/Water based on per-well production boundaries.