---
title: Wellbore ESP Motor
slug: wellbore-esp-motor
createdAt: 2023-03-22T19:17:25.000Z
---

The Wellbore ESP Motor table describes the motor assembly that drives an electric submersible pump. It is separate from the Wellbore ESP table, which describes the pump sections. One record covers the whole motor assembly: a tandem or triple motor is still a single record, its nameplate values are the combined ratings of all its motors, and **motorConfiguration** records how many motors those values cover.

The unique constraint on ESP motor entries is **sourceWellId + sourceWellboreId + sourceId**.

:::hint{type="warning"}
The wellbore referenced by **sourceWellId** and **sourceWellboreId** must be loaded before adding an ESP motor to it.
:::

| **Variable**        | **Data Type**   | **Unit of Measure** | **Is Nullable?** | **Default Value** | **Description**                                                                                                                 |
| ------------------- | --------------- | ------------------- | ---------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| sourceId            | String          | -                   | No               | -                 | Unique identifier of the ESP motor, to enable upserts                                                                           |
| sourceWellId        | String          | -                   | No               | -                 | Source ID for the well. Must match the sourceId of a record in the [Well](docId\:P-xHbe4jqKJQemay7aOL5) table.                  |
| sourceWellboreId    | String          | -                   | No               | -                 | Source ID for the wellbore. Must match the sourceId of a record in the [Wellbore](docId\:XPqwCAS8aWDaWyssmVjY6) table.          |
| make                | String          | -                   | Yes              | -                 | Manufacturer of the motor, up to 100 characters                                                                                 |
| model               | String          | -                   | Yes              | -                 | Model of the motor, up to 100 characters                                                                                        |
| nameplateAmps       | Double          | A                   | Yes              | -                 | Nameplate current rating of the motor assembly                                                                                  |
| nameplateHorsepower | Double          | hp                  | Yes              | -                 | Combined nameplate power rating of the motor assembly                                                                           |
| nameplateVoltage    | Double          | V                   | Yes              | -                 | Combined nameplate voltage rating of the motor assembly                                                                         |
| poleConfiguration   | String          | -                   | Yes              | -                 | Number of motor poles. One of: TWO\_POLE, FOUR\_POLE                                                                            |
| motorConfiguration  | String          | -                   | Yes              | -                 | Number of motors in the assembly. One of: SINGLE, TANDEM, TRIPLE. The nameplate values are the combined ratings of all of them. |
| motorType           | String          | -                   | Yes              | -                 | Type of motor. One of: INDUCTION (induction motor), PERMANENT\_MAGNET (permanent magnet motor)                                  |
| runDate             | Datetime Offset | -                   | No               | -                 | Date the motor was installed. Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000             |
| pullDate            | Datetime Offset | -                   | Yes              | -                 | Date the motor was pulled. Datetime offset (with timezone) in ISO 8601 format.                                                  |

***

# Data Integrity Checks

| **Condition**                                                                      | **Response**    |
| ---------------------------------------------------------------------------------- | --------------- |
| Any non-nullable field is NULL or empty                                            | Record Rejected |
| poleConfiguration, motorConfiguration or motorType is not one of its listed values | Record Rejected |
| (sourceWellId, sourceWellboreId) does not match an existing wellbore               | Row Skipped     |

:::hint{type="info"}
**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 ESP Motor | Unknown wellbore | EspMotor with sourceId 'xxx' was skipped: wellbore with sourceWellId 'xxx' and sourceWellboreId 'xxx' was not found |

