Wellbore ESP Motor
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.
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 WellWell table. |
sourceWellboreId | String | - | No | - | Source ID for the wellbore. Must match the sourceId of a record in the WellboreWellbore 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 |
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 |