Horizontal Frac

the horizontal frac table provides details about unconventional horizontal fracture completions, for use in comparative analysis between wells the unique constraint on horizontal frac entries is uwi + date — re posting the same well and date upserts the existing record variable data type unit of measure is nullable? default value description uwi string no unique well identifier must match the uwi of a record in the well docid\ p xhbe4jqkjqemay7aol5 table date datetime offset no frac job date datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 averageeffectivespacing double ft yes average distance to offset wells at the time of completion mineffectivespacing double ft yes distance to the closest offset well at the time of completion type string yes completion type (plug n perf, sliding sleeve, etc) it is important to standardize values to enable grouped analysis fluidtype string yes completion fluid type (x link gel, slickwater, etc) it is important to standardize values to enable grouped analysis stimulatedlength double ft yes total length of the stimulated lateral stages int yes number of stages in the frac job totalfluid double bbl yes total fluid used in the frac job totalproppant double lb yes total proppant used in the frac job perforationcount int yes total perforation count in the frac job stagespacing double ft yes stage spacing in the frac job data integrity checks condition response uwi is null or empty record rejected uwi does not exist in the well table record rejected date is null record rejected common error messages api scenario error response add / upsert frac unknown uwi well was not found with uwi xxx