Daily Production

daily production collects the allocated and measured rates and pressures alongside artificial lift operating parameters for a well if daily rates are from a metered source (multiphase flow meter), allocated rate data should be supplied in the allocation docid\ ghnxhn hujvkhyolbsvc5 table if the well was not flowing for 24 hours on a given day, the number of downtime hours and the code/reason should be supplied daily production is related to the well, not the wellbore the uwi property from well docid\ p xhbe4jqkjqemay7aol5 is used as the primary key for daily production records, as systems of record for well construction are typically different than 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 date datetime offset no datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 oilrate double bbl/d no 0 0 oil flow rate gasrate double mscf/d no 0 0 formation gas flow rate (this should not include any injected gas) waterrate double bbl/d no 0 0 water flow 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 false whether the well is producing from the annulus instead of tubing choke integer 1/64ths yes choke setting wellheadtemperature double degf yes temperature at the wellhead gasliftinjectionrate double mscf/d yes, but required for gas lift wells gas injection rate (for gas lift wells) gaugepressure double psig yes downhole gauge pressure gaugetemperature double degf yes downhole gauge temperature espfrequency double hz yes, but required for esp wells esp frequency (for esp wells) espintakepressure double psig yes, but required for esp wells 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, but required for rod pump wells strokes per minute (for rod pump wells) srpintakepressure double psig yes, but required for rod pump wells rod intake pressure srpfluidload double lbf yes, but required for rod pump wells fluid load on the rod pump srpfillage double % yes, but required for rod pump wells sucker rod pump fillage downtimehours double hrs no 0 0 downtime hours downtimecode string yes coded downtime reason waterinjectionrate double bbl/d yes water injection rate (for water injection wells) (for water injection wells) gasinjectionrate double mscf/d yes gas injection rate (for gas injection wells) (for gas injection wells) pcpspeed double rpm yes pcp speed (for pcp wells) pcpintakepressure double psig yes pcp intake pressure (for pcp wells) pcpdischargepressure double psig yes pcp discharge pressure (for pcp wells) daily production notes a well must exist in the well table before daily production can be added for that well each well must have at least one daily production record or it will fail a data integrity check if a well fails a data integrity check values will not get computed for that well the daily production api will accept any value that has the correct data type for its respective field if a value is sent through the api that is considered bad data, the modeling engine will throw errors and not compute the model for that particular well when deleting a range of daily production records, the records for the start and end date provided will also be deleted artificial lift notes daily values for artificial lift are optional depending on the lift type specified in the main wellbore (if any) for natural flowing wells, all artificial lift values will be null downtime notes downtime hours and code will typically come from a hydrocarbon accounting system these values are optional if supplied, they will be used to identify the flowing status of a well on any given production day for example if downtimehours = 24 the well is if downtimehours is not supplied flowing status will be assumed using choke where 0 = the well is if downtimehours and choke are not supplied if primaryfluid = oil the oilrate will be used where 0 = the well is there is a limit of 255 characters for downtime codes data integrity checks condition response uwi is null or empty record rejected uwi does not exist record rejected if any non nullable field is null record rejected if lifttype = esp and required esp field(s) missing record rejected if lifttype = gas lift and required gas lift field(s) missing record rejected if lifttype = rod pump and required rod pump field(s) missing record rejected downtimecode > 255 characters record rejected