Data Schema

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
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
WHT- degF
DHGP - psig
DHGT - degF
OILRATE - STB/d
GASRATE - Mscf/d
WATERRATE- STB/d
SANDRATE - g/s
PRESSUREUPSTREAM - psig
PRESSUREDOWNSTREAM - psig
unit
String
Yes
Unit of measure
﻿

Updated 13 Nov 2023

Did this page help you?

Well Sucker Rod Pump

TimeSeries History

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 WHT- degF DHGP - psig DHGT - degF OILRATE - STB/d GASRATE - Mscf/d WATERRATE- STB/d SANDRATE - g/s PRESSUREUPSTREAM - psig PRESSUREDOWNSTREAM - psig
unit	String	Yes	Unit of measure