Daily Production

daily production collects the allocated rates, pressures, and artificial lift operating parameters for a well, one record per well per day if daily rates come from a metered source (e g a multiphase flow meter), supply the allocated rate data in the allocation docid\ ghnxhn hujvkhyolbsvc5 table instead daily production is related to the well, not the wellbore the uwi property from well docid\ p xhbe4jqkjqemay7aol5 is the key for daily production records, because systems of record for well construction are typically different from allocation systems the unique constraint for daily production is uwi + date 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 production date datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 oilrate double stb/d no 0 0 oil rate gasrate double mscf/d no 0 0 formation gas rate must not include any injected gas waterrate double stb/d no 0 0 water rate tubingpressure double psig no 0 0 tubing / wellhead pressure casingpressure double psig no 0 0 casing pressure linepressure double psig yes line pressure (downstream of choke) isannularflow boolean yes whether that day's production is through the annulus instead of tubing for gas lifted wells, this is discovered automatically isdualflow boolean yes false whether the well was flowing through both the tubing and the annulus on the day of production choke integer % or 64ths yes choke opening wellheadtemperature double degf yes temperature at the wellhead gasliftinjectionrate double mscf/d yes gas lift injection rate (for gas lift wells) gaugepressure double psig yes downhole gauge pressure not the esp or srp intake pressure — those have their own fields below gaugetemperature double degf yes downhole gauge temperature espfrequency double hz yes esp frequency (for esp wells) espintakepressure double psig yes esp intake pressure (for esp wells) espamps double amperes yes esp current (for esp wells) espvolts double volts yes esp voltage (for esp wells) espdischargepressure double psig yes esp discharge pressure (for esp wells) espmotortemperature double degf yes esp motor temperature (for esp wells) espvibration double g (gravity) yes esp vibration (for esp wells) srpstrokespermin double spm yes strokes per minute (for rod pump wells) srpintakepressure double psig yes pump intake pressure (for rod pump wells) srpfluidload double lbf yes fluid load on the rod pump (for rod pump wells) srpfillage double % yes sucker rod pump fillage (for rod pump wells) pcpspeed double rpm yes pcp speed (for pcp wells) pcptorque double lbf ft yes pcp torque (for pcp wells) pcpintakepressure double psig yes pcp intake pressure (for pcp wells) pcpdischargepressure double psig yes pcp discharge pressure (for pcp wells) downtimehours double hrs yes 0 0 downtime hours (0 24) downtimecode string yes coded downtime reason (max 255 characters) waterinjectionrate double stb/d yes for water injection wells only water injection rate gasinjectionrate double mscf/d yes for gas injection wells only — not gas lift gas lift injection gas belongs in gasliftinjectionrate above gasinjectionrate is not gas lift gasinjectionrate is only for dedicated gas injection wells (type = injector, fluid = gas) if your well is gas lifted, the injected gas goes in gasliftinjectionrate supplying gas lift gas as gasinjectionrate is a common mistake and will corrupt modeling results for the well likewise, waterinjectionrate is only for water injection wells (type = injector, fluid = water) daily production notes a well must exist in the well docid\ p xhbe4jqkjqemay7aol5 table before daily production can be added for it each well needs at least one daily production record; wells without any will fail a data integrity check and will not be modeled the api accepts any value of the correct data type it does not judge whether a value is physically sensible — bad data will surface later as modeling errors for that well when deleting a range of daily production records, the records on the start and end dates are also deleted (the range is inclusive) artificial lift notes the lift specific fields (gas lift, esp, srp, pcp) are optional as far as the api is concerned, but the modeling engine requires them for wells of the corresponding lift type gas lift wells need gasliftinjectionrate, esp wells need espfrequency and espintakepressure, and rod pump wells need srpstrokespermin, srpintakepressure, srpfluidload, and srpfillage for natural flowing wells, leave all artificial lift values null downtime notes downtime hours and code typically come from a hydrocarbon accounting system both are optional if supplied, they identify the flowing status of the well on each production day, and partial downtime days are converted to 24 hour rates using a downtime correction factor data integrity checks condition response uwi is null or empty record rejected uwi does not exist in the well table record rejected any non nullable field is null record rejected common error messages api scenario error response add / upsert production unknown uwi uwi xxx does not exist fetch production unknown uwi well with uwi xxx was not found