Well Production Method

the well production method table provides an optional, manual override of prodx's computed production method for a well over a period of time prodx's auto detection is generally reliable, but some lift formats are hard to infer from daily production data alone — plunger lift, gas assisted plunger lift, plunger assisted gas lift, and dual natural flow (simultaneous casing and tubing flow) records in this table force the lift type for the period defined a null enddate means the production method applies indefinitely the sourceid must be unique for the well — the unique constraint is sourcewellid + sourceid variable data type unit of measure is nullable? default value description sourceid string no unique identifier of the entry, to enable upserts sourcewellid string no source id for the well from wellview wvwellheader table, idwell column from openwells cd well table, well id column lifttype string no artificial lift type to force natural flow annular natural flow dual natural flow gas lift annular gas lift plunger lift plunger assisted gas lift gas assisted plunger lift rod pump esp pcp startdate datetime offset no start of the period the lift type applies datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 enddate datetime offset yes end of the period the lift type applies null means the lift type applies indefinitely datetime offset (with timezone) in iso 8601 format data integrity checks condition response sourcewellid does not exist in the well table record rejected and current batch aborted any non nullable field is null record rejected if any record in a post references an unknown sourcewellid , the whole batch is aborted — records earlier in the payload are not committed common error messages api scenario error response add / upsert production method unknown sourcewellid well with source id xxx was not found, current batch aborted