TimeSeries Configuration
Summary
The TimeSeries Configuration table is the master registry of historian tags. A historian tag is a digital ID that identifies a specific measurement on a specific well. The TimeSeries HistoryTimeSeries History table relates to this registry by sourceId.
Each configuration entry belongs to a single well, specified as sourceWellId. Each well can have one tag of each measurement type (e.g. WHP, OILRATE).
The unique constraint on this table is (sourceWellId + sourceId + measurement).
TimeSeries Configuration for a given sourceId must be added to the system before attempting to add TimeSeries History to that sourceTimeSeriesId.
Variable | Data Type | Is Nullable? | Description |
|---|---|---|---|
sourceWellId | String | No | Source ID for the well From WellView: wvwellheader table, idwell column From OpenWells: cd_well table, well_id column |
sourceId | String | No | Time series tag identifier OSI PI Use Tag ID: xxx.yyy.zzz OSI PI AF use AttributeID: \\server\\element\\attributeID |
measurement | String | No | See section below for possible values |
unit | String | Yes | Unit of measure. The UoM in this field must match the documented UoM for the measurement, as listed below. |
Time Series Measurement Values
Time series measurements must be provided from the following list of possible values. ProdX forces standardization to enable high frequency data to be used in modeling and comparative visualization.
Rates
- OILRATE - STB/d
- GASRATE - Mscf/d
- GASLIFTINJECTIONRATE - Mscf/d (actual gas lift injection rate)
- GASLIFTINJECTIONRATESETPOINT - Mscf/d (control system gas lift injection rate setpoint)
- WATERRATE - STB/d
- SANDRATE - g/s
Pressures
- WHP - psig (wellhead/tubing head pressure)
- CHP - psig (casing pressure)
- DHGP - psig (downhole gauge pressure)
- DHGP_DISCHARGE - psig (downhole gauge pressure at pump discharge)
- PRESSUREUPSTREAM - psig (upstream choke pressure / flowline pressure)
- PRESSUREDOWNSTREAM - psig (downstream choke pressure tubing side)
- PRESSURE_DOWNSTREAM_ANNULUS - psig (downstream choke pressure annulus side)
- HPSEPARATORPRESSURE - psig
- LPSEPARATORPRESSURE - psig
Temperatures
- WHT - degF (wellhead/tubing temp)
- CHT - degF (casing temp)
- DHGT - degF (downhole gauge temp)
- FLOWLINETEMPERATURE - degF
Other
- CHOKE - %
- WELLCYCLINGFLAG - unitless (flag indicating the cycling status of the well)
ESP
Drive
- ESP_VSD_HEAT_SINK_TEMP - degF
- ESP_VSD_BUS_VOLTAGE - volts
- ESP_VSD_CURRENT - amps
- ESP_VSD_VOLTAGE - volts
Motor
- ESP_MOTOR_CURRENT - amps
- ESP_MOTOR_FREQUENCY - hz
- ESP_MOTOR_TEMPERATURE - degF
- ESP_MOTOR_VOLTAGE - volts
Controller
- ESP_HIGH_SPEED_CLAMP - hz
- ESP_LOW_SPEED_CLAMP - hz
- ESP_CURRENT_LIMIT - amps
- ESP_CURRENT_SETPOINT - amps
- ESP_CONTROL_MODE - unitless (1 = Frequency mode, 2 = PID Rate control, 3 = PID Amps control)
General
- ESP_INTAKE_PRESSURE - psig
- ESP_DISCHARGE_PRESSURE - psig
- ESP_FLUID_TEMPERATURE - degF
- ESP_RUNTIME - hours (hours of cumulative runtime today)
- ESP_VIBRATION_X - g
- ESP_VIBRATION_Y - g
Sucker Rod Pump
- SRP_POLISHED_ROD_LOAD - lb
- SRP_POLISHED_ROD_POSITION - in
- SRP_PUMP_FILLAGE - %
- SRP_PUMP_INTAKE_PRESSURE - psig
- SRP_STROKE_RATE - strokes/min
- SRP_RUNTIME - minutes (minutes of cumulative runtime today)
Plunger
- PLUNGER_EVENT - unitless (valve open = 0, valve closed = 1, or plunger arrived = 2)
Deprecated
The following values are still accepted for backwards compatibility but should not be used in new integrations:
- SANDIND
- CONDRATE
- FLOWLINEPRESSURE
Data Integrity Checks
Condition | Response |
|---|---|
sourceWellId does not exist in the Well table | Record Rejected and current batch aborted |
measurement is not one of the values above | Record Rejected |
Any non-nullable field is NULL | Record Rejected |
If any record in a POST references an unknown sourceWellId, the whole batch is aborted — records earlier in the payload are not committed.
Common Error Messages
API | Scenario | Error Response |
|---|---|---|
Add / Upsert configuration | Unknown sourceWellId | Well with source id xxx was not found, current batch aborted |