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 WellboreWellbore.

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