Wellbore Tubing
The Wellbore Tubing table describes the tubing strings installed in a wellbore. Each record is one tubing string with its depth interval, diameters, and run/pull dates. ProdX uses tubing geometry to determine the flow path and compute bottomhole pressures.
The unique constraint on tubing entries is sourceWellboreId + sourceId.
Variable | Data Type | Unit of Measure | Is Nullable? | Default Value | Description |
|---|---|---|---|---|---|
sourceId | String | - | No | - | Source ID for the tubing string From WellView: wvtub table, idrec column From OpenWells: cd_assembly table, assembly_id column |
sourceWellId | String | - | No | - | Source ID for the well From WellView: wvtub table, idwell column From OpenWells: cd_assembly table, well_id column |
sourceWellboreId | String | - | No | - | Source ID for the wellbore From WellView: wvtub table, idrecwellbore column From OpenWells: cd_assembly table, wellbore_id column |
topMd | Double | ft | Yes | 0.0 | Top measured depth of the tubing string |
bottomMd | Double | ft | No | - | Bottom measured depth of the tubing string |
id | Double | in | No | - | Inner diameter of the tubing From WellView: wvtub table, SZIDNOMMINCALC column |
od | Double | in | No | - | Outer diameter of the tubing From WellView: wvtub table, SZODNOMMINCALC column |
roughness | Double | in | Yes | 0.0006 | Absolute roughness coefficient of the tubing material |
runDate | Datetime Offset | - | Yes | - | Date the tubing was run. Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000 |
pullDate | Datetime Offset | - | Yes | - | Date the tubing was pulled. Datetime offset (with timezone) in ISO 8601 format. |
Wellbore Tubing Notes
Tubing data is optional.
For wells with no tubing data and tubing pressures missing or atmospheric, the well model interprets casing flow.
For wells with no tubing data and tubing pressures greater than atmospheric, the well model interprets tubing flow, copying tubing properties and dimensions from the temporally adjacent tubing string.
Top Measured Depth Notes
If topMd is NULL, the system assumes 0 ft.
Roughness Notes
If roughness is NULL, the compute engine applies 0.0006 in its place.
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 tubing | Unknown wellbore | Tubing with sourceId 'xxx' was skipped: wellbore with sourceWellId 'xxx' and sourceWellboreId 'xxx' was not found |