TimeSeries Configuration
The TimeSeries Configuration table is the master registry of historian tags. Historian tags are digital IDs which relate to a specific measurement on a specific well. The TimeSeries History table is related to this configuration registry table by sourceId.
Each timeseries configuration entry belongs to a single well. The well is specified in this table as sourceWellId. Each well can have 1 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 Well From Wellview Table: wvwellheader - use idwell column From OpenWells Table: cd_well - use 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. Note: UoM in this field must match the documented UoM for the measurement as described above |
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.
- 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
- WHP - psig (wellhead/tubing pressure)
- CHP - psig (casing pressure)
- DHGP - psig (downhole gauge pressure)
- PRESSUREUPSTREAM - psig (upstream choke pressure / flowine pressure)
- PRESSUREDOWNSTREAM - psig (downstream choke pressure)
- HPSEPARATORPRESSURE - psig
- LPSEPARATORPRESSURE - psig
- WHT - degF (wellhead/tubing temp)
- DHGT - degF (downhole gauge temp)
- FLOWLINETEMPERATURE - degF
- CHOKE - %
- WELLCYCLINGFLAG - unitless (flag indicating the cycling status of the well)
- ESP_VSD_HEAT_SINK_TEMP - degF
- ESP_VSD_BUS_VOLTAGE - volts
- ESP_VSD_CURRENT - amps
- ESP_VSD_VOLTAGE - volts
- ESP_MOTOR_CURRENT - amps
- ESP_MOTOR_FREQUENCY - hz
- ESP_MOTOR_TEMPERATURE - degF
- ESP_MOTOR_VOLTAGE - volts
- 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
