Understand the TankInventory table

time

GMTtime

Time of snapshot.

offset

GMToffset

Offset of local timezone that was in effect at time of snapshot.

tankID

nameType

Tank ID.

prodType

nameType

Product type in tank.

prodGroup

nameType

Product group in tank.

GrSV

doubleType

Gross Standard Volume (GSV).

GrOV

doubleType

Gross Observed Volume (GOV).

gravity

doubleType

American Petroleum Institute (API) gravity.

temperature

doubleType

Temperature.

vcf

doubleType

Volume Correction Factor.

tankLevel

varchar(12)

Tank level.

volRoom

doubleType

Volume to fill.

volMoveable

doubleType

Volume to pump.

etatime

GMTtime

Estimated time of arrival (ETA) at tank target.

hourGOV

doubleType

Hourly GOV.

hourGSV

doubleType

Hourly GSV.

snapShotType

char(1)

Snapshot type.

Snapshots can be one of the following types:

• H = Hourly

• P = Product type change

• L = The lmsInventory routine was run

• F =An fnput was performed

revised

boolType

If true, this snapshot has been edited.

pipeline

nameType

Name of pipeline.

rtuName

nameType

Name of Remote Terminal Unit (RTU).

tnknum

int

Tank number.

snowlevel

varchar(12)

Snow level.

ambientTemp

doubleType

Ambient temperature.

tempUnit

varchar(15), null

The unit of measure for temperature.

densUnit

varchar (15), null

The unit of measure for density.

presUnit

varchar(15),  null

The unit of measure for pressure.

volUnit

varchar(15), null

The unit of measure for volume.

lenUnit

varchar(15), null

The unit of measure for length.

thickUnit

varchar(15), null

The unit of measure for thickness.

depthUnit

varchar(15),  null

The unit of measure for depth.

heightUnit

varchar(15),  null

The unit of measure for height.

ownSysId

tagIDtype, not null

The owning system ID for the tank.

datasetId

tagIDtype, not null

The dataset ID for the tank.

grp

nameType, null

The group of the tank.

station

nameType, null

The station attached to the tank.