# Completion and stimulation

Source: https://developers.novilabs.com/data/tables/completions/

> 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

Completion/stimulation state and summary parameters for a wellbore. 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.

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| `WELL_COMPLETION_ID` | integer |  | Surrogate key for the completion row. |
| `WELLBORE_KEY` | string |  | Foreign key to wellbore.wellbore\_key. |
| `COMPLETION_SEQUENCE` | integer |  | 1 = first completion; increment for recompletions/re-fracs. |
| `COMPLETION_STATE` | string |  | Completion lifecycle state (derived from events or operational tracking). |
| `COMPLETION_END_DATE` | date |  | Date completion operations ended (if known). |
| `PROPPANT_MASS` | number | lb | Total proppant mass injected during completion. |
| `FLUID_VOLUME` | number | gal | Total completion fluid volume injected, in gallons. |
| `STAGE_COUNT` | integer |  | 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` | integer | ft | Shallowest perforation depth (MD) in feet. |
| `PERFORATION_LOWER` | integer | ft | Deepest perforation depth (MD) in feet. |
| `PERFORATION_INTERVAL` | integer | ft | Perforation interval length in feet (perforation\_lower - perforation\_upper). |
| `SOAK_TIME_DAYS` | integer | day | 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. |
| `PROPPANT_LOADING` | number | lb/ft | Proppant mass per foot of lateral for the first completion, in lb/ft, computed by Novi rather than from `PROPPANT_MASS` and a lateral length here. 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 in `LATERAL_LENGTH_SOURCE`; the ratio need not equal `PROPPANT_MASS` / `LATERAL_LENGTH` on 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 when `PROPPANT_MASS` is 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_DESIGN` and `WELL_DETAIL` publish the same number as `PROPPANT_LOADING`. |
| `PROPPANT_CONCENTRATION` | number | lb/gal | Proppant mass, in pounds, per gallon of completion fluid for the first completion, computed by Novi rather than here from `PROPPANT_MASS` and `FLUID_VOLUME`, so it need not equal their quotient on the same row. 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_DESIGN` and `WELL_DETAIL` publish the same number as `PROPPANT_CONCENTRATION`. |
| `STAGE_SPACING` | number | ft | 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. Non-additive ratio, never sum across wellbores. WELLBORE carries that length as `LATERAL_LENGTH`, with its method in `LATERAL_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_DESIGN` and `WELL_DETAIL` publish the same number as `STAGE_SPACING`. |
| `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_AT` | timestamp |  | Timestamp the completion record was created in this system. |
| `UPDATED_AT` | timestamp |  | Timestamp of the most recent update to this completion record. |

## FRAC_FOCUS_SUMMARY

Summary of a FracFocus chemical disclosure for a hydraulic fracturing event. 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.

| Column | Description |
| --- | --- |
| `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. Additive. |
| `PROPPANT_MASS` | Total proppant mass in pounds. 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). Non-additive. |
| `CHECK_WATER_VOLUME` | Quality score for fluid volume reliability. Non-additive. |
| `CHECK_PROPPANT_MASS` | Quality score for proppant mass reliability. 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. 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. 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. 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). 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\_id for data lineage. |
| `CREATED_AT` | Timestamp the record was created. |
| `UPDATED_AT` | Timestamp of the most recent update. |

## FRAC_FOCUS_INGREDIENT

Detailed chemical ingredient from a FracFocus disclosure. One row per ingredient per disclosure. Contains original FracFocus fields (ff-prefixed) for trade name, supplier, purpose, CAS number, and concentration percentages.

| Column | Description |
| --- | --- |
| `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. 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\_id for data lineage. |
| `CREATED_AT` | Timestamp the record was created. |
| `UPDATED_AT` | Timestamp of the most recent update. |
