Wellbore Gas Lift Valves

for gas lift wells, valve information is important to accurately compute gas lift performance, optimization, and bottomhole pressure in the absence of gas lift valve data, injection is assumed at the lowest point in the well with adequate delta pressure from injection to production to support gas passage in the presence of gas lift valve data, the preferred method is to calculate downhole opening and closing pressures from the r ratio and test rack opening pressure if those values are missing, the designed surface opening and closing pressures are used to determine which valves are open, which is less accurate different valve types have different data requirements and assumptions, so a valve type field is not required in the input schema pressure operated valves — the most thorough calculation is performed when test rack opening pressure and r are provided alongside a positive port size nominal valve size increases accuracy; 1 5" is assumed when it is null when test rack opening pressure and r are not provided, simplified calculations are performed from the surface opening and closing pressures, which carry an inherent assumption about surface pressures under designed conditions dummy valves — inferred when port size, surface opening pressure, and surface closing pressure are all 0 orifice valves — inferred when port size is > 0 and surface opening and closing pressures are 0 a gas lift valve belongs to a tubing string the unique constraint on gas lift valve entries is sourcetubingid + sourceid the tubing string referenced by sourcetubingid must be loaded before adding valves to it variable data type unit of measure is nullable? default value description sourceid string no unique identifier of the valve, to enable upserts from wellview wvtubcompmandrelinsert table, idrec column sourcewellid string no source id for the well must match the sourceid of a record in the well docid\ p xhbe4jqkjqemay7aol5 table from wellview wvtubcompmandrelinsert table, idwell column sourcewellboreid string no source id for the wellbore must match the sourceid of a record in the wellbore docid\ xpqwcas8awdawyssmvjy6 table sourcetubingid string no source id of the tubing string in which the valve is installed must match the sourceid of a wellbore tubing docid\ t6sgy9y9xnvabpqnnqotq record from wellview wvtubcomp table, idrecparent column rundate datetime offset no run date of the valve datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 from wellview wvtubcompmandrelinsert table, dttmrun column pulldate datetime offset yes pull date of the valve datetime offset (with timezone) in iso 8601 format from wellview wvtubcompmandrelinsert table, dttmpull column glvstation integer yes station number of the valve valve 1 is typically the deepest (commonly the orifice valve) from wellview wvtubcompmandrel table, stationno column installmd double ft no install depth of the valve from wellview wvtubcomp table, depthtopcalc column testrackopenpressure double psig yes test rack opening pressure (ptro) of the valve from wellview wvtubcompmandrelinsert table, trorun column surfaceopenpressure double psig no designed surface opening pressure of the valve from wellview wvtubcompmandrelinsert table, pressurfgaugeopen column surfaceclosepressure double psig no designed surface closing pressure of the valve from wellview wvtubcompmandrelinsert table, pressurfgaugeclose column portsize double /64 inch no port size of the valve from wellview wvtubcompmandrelinsert table, szport column r double yes r ratio area of the valve port divided by the effective bellows area nominalvalvesize double in yes nominal valve size, e g 1", 1 5", 1 75" when null, 1 5" is assumed data integrity checks condition response any non nullable field is null or empty record rejected (sourcewellid, sourcewellboreid, sourcetubingid) does not match an existing tubing row skipped partial success on bulk ingest rows referencing an unknown tubing string are skipped while the remaining rows are written the error response names each skipped row an error response therefore does not mean nothing was written common error messages api scenario error response add / upsert valve unknown tubing gasliftvalve with sourceid 'xxx' was skipped tubing with sourcewellid 'xxx' and sourcewellboreid 'xxx' and sourcetubingid 'xxx' was not found