Data Requirements

Each data type has a required set of attributes that must be included in the imported or entered data. All data is keyed off of the borehole UWI and observation number in the Completion Header. UWI and completion observation number are required for all data types. Data cannot be imported or saved unless all required fields have valid values.

The table below summarizes the additional required attributes for each.

Data Type

Required Attributes
(in addition to UWI and Completions Observation Number)

Borehole-level data

Treatment Summary

Start and end depths, treatment type

Treatment Material (under Treatment Summary)

Description type

Stage-level data

Stimulation

Stage number, start and end depths

Material (under Stimulation)

Stage number, description type

Perforation Header

Stage number, start and end depths

Perforations (under Perforation Header)

Stage number, start and end depths

Data Rules

The following rules apply to all data:

  • The start depth must be smaller than the end depth
  • Depth ranges cannot overlap
  • No required field (attribute) can be empty
  • No duplicate UWIs.
  • No duplicate observation numbers for a single borehole.
  • No duplicate key identifiers for any data type.
  • Names cannot be longer than 255 characters

If any of these rules are not met, the data will not be loaded. The reason that the data was skipped or was in error is recorded in the Load Status Report.