Data Schema
Well

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 sourceId, meaning that the sourceId (tag identifier) must be globally unique.

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

  • CHOKE - %
  • WHP - psig (wellhead/tubing pressure)
  • WHT - degF (wellhead/tubing temp)
  • CHP - psig (casing pressure)
  • DHGP - psig (downhole gauge pressure)
  • DHGT - degF (downhole gauge temp)
  • OILRATE - STB/d
  • GASRATE - Mscf/d
  • GASLIFTINJECTIONRATE - Mscf/d
  • WATERRATE - STB/d
  • SANDRATE - g/s
  • PRESSUREUPSTREAM - psig (upstream choke pressure)
  • PRESSUREDOWNSTREAM - psig (downstream choke pressure)
  • WELLCYCLINGFLAG - unitless (flag indicating the cycling status of the well)
  • FLOWLINETEMPERATURE - degF
  • HPSEPARATORPRESSURE - psig
  • LPSEPARATORPRESSURE - psig

unit

String

Yes

Unit of measure. Note: UoM in this field must match the documented UoM for the measurement as described above



Updated 07 Nov 2024
Doc contributor
Did this page help you?