Wellbore Sucker Rod Pump

the wellbore sucker rod pump table describes rod pumps installed in the wellbore, used for rod pump modeling unlike the tubing hosted equipment tables (pcp, esp, gas lift valves, plunger), a sucker rod pump belongs directly to the wellbore docid\ xpqwcas8awdawyssmvjy6 the unique constraint on sucker rod pump entries is sourcewellboreid + sourceid variable data type unit of measure is nullable? default value description sourceid string no unique identifier of the pump, to enable upserts from wellview wvrod table, idrec column from openwells tbd sourcewellid string no source id for the well from wellview wvrod table, idwell column from openwells tbd sourcewellboreid string no source id for the wellbore from wellview wvrod table, idrecwellbore column from openwells tbd installdate datetime offset yes install date of the pump datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 surfacestrokelength double in no length of the surface stroke installmd double ft no install measured depth plungerdia double in no plunger diameter plungerlength double in no plunger length plungerclearance double in yes plunger clearance rodnumber integer no api rod number (unitless) data integrity checks condition response any non nullable field is null or empty record rejected (sourcewellid, sourcewellboreid) does not match an existing wellbore row skipped partial success on bulk ingest rows referencing an unknown wellbore 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 pump unknown wellbore suckerrodpump with sourceid 'xxx' was skipped wellbore with sourcewellid 'xxx' and sourcewellboreid 'xxx' was not found