pplStationInventory

time

GMTtime(int)

The time the data was written to the Historical database.

offset

GMToffset(smallint)

The minute offset of this timezone from Greenwich Mean Time (GMT).

pipeline

nameType(varchar(32))

Name of the pipeline to which the node belongs.

station

nameType(varchar(32))

The name of the node record.

seqno

int

The sequence number of the node in the pipeline.

suctpres

float

The suction pressure at the node. This value will be -1 if there are no pipe segments upstream from this node.

discpres

float

The discharge pressure at the node. This value will be -1 if there are no pipe segments downstream from this node.

Temperature

float

The upstream temperature of the downstream pipe segment from this node.

cumLpack

float

The total linepack volume in the pipeline up to and including the upstream pipe segment to which the node is attached.

The value captured in this field does not take into account the impact of branching and merging in the pipeline.

mtrdayGSV1

float

The daily integration volume for meter 1.

mtrdayGSV2

float

The daily integration volume for meter 2.

mtrdayGSV3

float

The daily integration volume for meter 3.

volUnit

varchar(15)

The unit used for volume.

tempUnit

varchar(15)

The unit used for temperature.

presUnit

varchar(15)

The unit used for pressure.

ownSysId

int

The ID number of the node's owning system.

datasetId

int

The ID number of the node's dataset.

extension

NVARCHAR(MAX)

A field where extended station inventory data from the extension plugin is stored in string format.

cumulativeMass

float

The total mass in the pipeline up to and including the upstream pipe segment to which the node is attached.

The value captured in this field does not take into account the impact of branching and merging in the pipeline.

massUnit

varchar(15)

The unit used for mass.