Completion and stimulation
Completion design, intensity ratios, and FracFocus disclosures.
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.
WELL_COMPLETION
Section titled “WELL_COMPLETION”Completion/stimulation state and summary parameters for a wellbore.
More about this view
One row per completion event per wellbore; a recompletion has the next COMPLETION_SEQUENCE. Mass/volume values represent total injected amounts (proppant_mass in lbs, fluid_volume in gal). PROPPANT_LOADING, PROPPANT_CONCENTRATION and STAGE_SPACING are first-completion ratios computed by Novi; fluid per foot is not published.
- Key columns
WELL_COMPLETION_IDSurrogate key for the completion row.
- Joins to
SELECT WELL_COMPLETION_ID, WELLBORE_KEY, COMPLETION_SEQUENCE, COMPLETION_STATE, COMPLETION_END_DATEFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_COMPLETIONLIMIT 10- WELL_COMPLETION_IDinteger
- Surrogate key for the completion row.
- WELLBORE_KEYstring
- Foreign key to
wellbore.wellbore_key. - COMPLETION_SEQUENCEinteger
- 1 = first completion; increment for recompletions/re-fracs.
- COMPLETION_STATEstring
- Completion lifecycle state (derived from events or operational tracking).
- COMPLETION_END_DATEdate
- Date completion operations ended (if known).
- PROPPANT_MASSnumberlb
- Total proppant mass injected during completion.
- FLUID_VOLUMEnumbergal
- Total completion fluid volume injected, in gallons.
- STAGE_COUNTinteger
- Number of frac stages completed.
More
Omit the field when the stage count is unknown. Do not store 0 for unknown, 0 is not a valid stage count.
- PERFORATION_UPPERintegerft
- Shallowest perforation depth (MD) in feet.
- PERFORATION_LOWERintegerft
- Deepest perforation depth (MD) in feet.
- PERFORATION_INTERVALintegerft
- Perforation interval length in feet (perforation_lower - perforation_upper).
- SOAK_TIME_DAYSintegerday
- Number of days between the end of the first completion and the start of production (the soak period).
More
NULL when the span is zero or negative, longer than 365 days, or shorter than 30 days where the first-production date is not known accurately. Do not sum across wellbores.
- PROPPANT_LOADINGnumberlb/ft
- Proppant mass per foot of lateral for the first completion, in lb/ft, computed by Novi rather than from
PROPPANT_MASSand a lateral length here.More
Non-additive ratio, never sum across wellbores. Its denominator is the lateral length Novi selected for the well, so a peer-set figure is an average of ratios rather than a ratio of totals. WELLBORE carries that length as
LATERAL_LENGTH, with its method inLATERAL_LENGTH_SOURCE; the ratio need not equalPROPPANT_MASS/LATERAL_LENGTHon every row. Values above 9,000 lb/ft are nulled as physically impossible rather than clamped, so a NULL can mean no credible ratio exists for the well even whenPROPPANT_MASSis present. Also NULL when Novi's selected lateral length for the well is unknown or zero. Truncated to whole lb/ft. Populated for the first completion only.WELLBORE_COMPLETION_DESIGNandWELL_DETAILpublish the same number asPROPPANT_LOADING. - PROPPANT_CONCENTRATIONnumberlb/gal
- Proppant mass, in pounds, per gallon of completion fluid for the first completion, computed by Novi rather than here from
PROPPANT_MASSandFLUID_VOLUME, so it need not equal their quotient on the same row.More
Non-additive ratio, never sum across wellbores. NULL when proppant mass or fluid volume is unknown or zero, and when the ratio exceeds 8 lb/gal, which Novi treats as not credible; values above 8 are nulled, not clamped. Rounded to 2 decimal places. Populated for the first completion only.
WELLBORE_COMPLETION_DESIGNandWELL_DETAILpublish the same number asPROPPANT_CONCENTRATION. - STAGE_SPACINGnumberft
- Average distance between frac stages of the first completion, in feet: the lateral length Novi selected for the well (the denominator of
PROPPANT_LOADING) divided by the first completion's stage count.More
Non-additive ratio, never sum across wellbores. WELLBORE carries that length as
LATERAL_LENGTH, with its method inLATERAL_LENGTH_SOURCE. NULL when the stage count is zero or the 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. Populated for the first completion only.WELLBORE_COMPLETION_DESIGNandWELL_DETAILpublish the same number asSTAGE_SPACING. - BASIN
- Basin name (e.g., Permian, Eagle Ford).
- SUBBASIN
- Subbasin name (e.g., Delaware, Midland).
- SOURCE_ID
- Foreign key to
source.source_idfor data lineage. - CREATED_ATtimestamp
- Timestamp the completion record was created in this system.
- UPDATED_ATtimestamp
- Timestamp of the most recent update to this completion record.
No columns match. Try a shorter word.
FRAC_FOCUS_SUMMARY
Section titled “FRAC_FOCUS_SUMMARY”Summary of a FracFocus chemical disclosure for a hydraulic fracturing event.
More about this view
One row per wellbore per frac sequence number. Contains processed/cleaned summary data from FracFocus along with Novi quality check scores and original ff-prefixed raw fields. Links to wellbore via wellbore_key; the wellbore's regulatory identifier is available on wellbore.native_id.
- Key columns
FRAC_FOCUS_SUMMARY_IDSurrogate key.
- Joins to
- Joined from
FRAC_FOCUS_INGREDIENT
SELECT FRAC_FOCUS_SUMMARY_ID, WELLBORE_KEY, SEQUENCE_NR, START_DATE, END_DATEFROM NOVI_DATA_ACCESS.NOVI_WELLS.FRAC_FOCUS_SUMMARYLIMIT 10- FRAC_FOCUS_SUMMARY_ID
- Surrogate key.
- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_key. - SEQUENCE_NR
- Sequence number of this frac event for the wellbore (0 = first).
- START_DATE
- Start date of the fracturing event.
- END_DATE
- End date of the fracturing event.
- DURATION_DAYS
- Duration of the fracturing event in days.
- FLUID_VOLUME
- Total fluid volume used in gallons.
More
Additive.
- PROPPANT_MASS
- Total proppant mass in pounds.
More
Additive.
- PROPPANT_MAIN_TYPE
- Main proppant type (e.g., "Sand").
- PROPPANT_MAIN_MESH
- Main proppant mesh size (e.g., "20/40").
- CHECK_DATE
- Quality score for date reliability (0-100; 100 = no inconsistencies).
More
Non-additive.
- CHECK_WATER_VOLUME
- Quality score for fluid volume reliability.
More
Non-additive.
- CHECK_PROPPANT_MASS
- Quality score for proppant mass reliability.
More
Non-additive.
- FF_
TOTAL_ BASE_ WATER_ VOLUME - Original FracFocus total base water volume in gallons.
- FF_
TOTAL_ BASE_ NON_ WATER_ VOLUME - Original FracFocus total non-water volume in gallons.
- FF_TVD
- Original FracFocus TVD in feet.
- FF_LATITUDE
- Original FracFocus latitude in decimal degrees, in the geodetic datum stated on the disclosure (NAD27, NAD83 or WGS84); the datum is unknown where the disclosure states none.
More
Coordinates in different datums are not directly comparable.
- FF_LONGITUDE
- Original FracFocus longitude in decimal degrees, in the geodetic datum stated on the disclosure (NAD27, NAD83 or WGS84); the datum is unknown where the disclosure states none.
More
Coordinates in different datums are not directly comparable.
- FF_OPERATOR
- Original FracFocus operator name.
- FF_PKEY
- Original FracFocus primary key.
- OFS_COMPANY_ORIGINAL
- Original oil field service company that performed the job.
- OFS_COMPANY_CURRENT
- Current identity of OFS company after M&A.
- REPORT_DATE
- Date the disclosure was first reported to FracFocus.
- FF_PROJECTION
- Geodetic datum of ff_latitude and ff_longitude as stated on the FracFocus disclosure.
More
NULL where the disclosure states none. Coordinates in different datums are not directly comparable.
- FF_VERSION
- Version of the FracFocus disclosure form the disclosure was filed on (e.g. 1.0-4.0).
More
The fields a disclosure carries differ between form versions. NULL where not stated. A label, not a measure: never aggregate.
- BASIN
- Basin name (e.g., Permian, Eagle Ford).
- SUBBASIN
- Subbasin name (e.g., Delaware, Midland).
- SOURCE_ID
- Foreign key to
source.source_idfor data lineage. - CREATED_AT
- Timestamp the record was created.
- UPDATED_AT
- Timestamp of the most recent update.
No columns match. Try a shorter word.
FRAC_FOCUS_INGREDIENT
Section titled “FRAC_FOCUS_INGREDIENT”Detailed chemical ingredient from a FracFocus disclosure.
More about this view
One row per ingredient per disclosure. Contains original FracFocus fields (ff-prefixed) for trade name, supplier, purpose, CAS number, and concentration percentages.
- Key columns
FRAC_FOCUS_INGREDIENT_IDSurrogate key.
SELECT FRAC_FOCUS_INGREDIENT_ID, WELLBORE_KEY, FRAC_FOCUS_SUMMARY_ID, FF_PKEY, SEQUENCE_NRFROM NOVI_DATA_ACCESS.NOVI_WELLS.FRAC_FOCUS_INGREDIENTLIMIT 10- FRAC_
FOCUS_ INGREDIENT_ ID - Surrogate key.
- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_key. - FRAC_FOCUS_SUMMARY_ID
- Foreign key to
frac_focus_summary.frac_focus_summary_id(parent disclosure). - FF_PKEY
- Original FracFocus primary key for the ingredient row.
- SEQUENCE_NR
- Sequence number linking to the parent FracFocusSummary.
- FF_PKEY_DISCLOSURE
- Original primary key of the parent FracFocus disclosure.
More
Required for traceability back to FracFocus source data.
- FF_TRADE_NAME
- Product trade name as reported by the supplier.
- FF_SUPPLIER
- Company that supplied the product for the frac job.
- FF_PURPOSE
- Purpose of the ingredient (e.g., Surfactant, Biocide, Proppant).
- FF_INGREDIENT_NAME
- Chemical ingredient name from FracFocus.
- FF_CAS_NUMBER
- Chemical Abstract Service identification number (CAS RN format: 2-7 digits, hyphen, 2 digits, hyphen, 1 check digit).
- FF_
PERCENT_ HIGH_ ADDITIVE - Percent of the ingredient in the trade name product (top of range from MSDS).
- FF_PERCENT_HF_JOB
- Percent of the ingredient in the total hydraulic fracturing volume by mass.
- FF_MASS_INGREDIENT
- Mass of this ingredient.
- FF_CLAIMANT_COMPANY
- Company claiming trade secret for this ingredient.
- BASIN
- Basin name (e.g., Permian, Eagle Ford).
- SUBBASIN
- Subbasin name (e.g., Delaware, Midland).
- SOURCE_ID
- Foreign key to
source.source_idfor data lineage. - CREATED_AT
- Timestamp the record was created.
- UPDATED_AT
- Timestamp of the most recent update.
No columns match. Try a shorter word.