Understand the Tank Ticket Device (TankTicketDevice) table

msrepl_tran_version

uniqueidentifier

Unique record identifier.

time

GMTtime(int)

This provides the time the ticket was created, using Greenwich Mean Time (GMT).

offset

GMToffset(smallint)

GMT offset.

ticketno

varchar(15)

Ticket number.

nomId

int

batchXfer

nameType(varchar32)

The name of the batch transfer (batchXfer) record that generated the completed ticket.

deviceName

nameType(varchar32)

ScountIV

float

Start of batch transfer Indicated Volume (IV).

ecountIV

float

End of batch transfer IV.

scountGSV

float

Start of batch transfer Gross Standard Volume (GSV).

ecountGSV

float

End of batch transfer GSV.

waod

float

Weighted Average Observed Density (WAOD).

wad

float

Weighted Average Density (WAD).

wat

float

Weighted Average Temperature (WAT).

wap

float

Weighted Average Pressure (WAP).

waf

float

Weighted Average Flow rate (WAF) over the time period of the ticket.

wamcf

float

Weighted Average Meter correction factor (WAMCF).

actobsdens

float

Actual telemetered observed density.

actdens

float

Actual telemetered density.

acttemp

float

Actual telemetered temperature.

actpres

float

Actual telemetered pressure.

actflow

float

Actual telemetered flow.

mcf

float

Meter Correction Factor.

ctl

decimal (17,15)

Weighted Average Volume Correction Factor for Temperature (CTL).

cpl

decimal(17,15)

Weighted Average Volume Correction Factor for Temperature (CTL).

ctpl

float

Combined Temperature and Pressure Correction factor (CTPL).

expFlow

float

Expected pressure.

expPres

float

Expected flow.

IV

float

Gross uncalibrated volume.

GV

float

Gross Volume (GV).

GSV

float

Gross Standard Volume (GSV).

origtemp

float

Original temperature before the manual override.

origobsdens

float

Original observed density before the manual override.

origdens

float

Original density before the manual override.

origpres

float

Original pressure before the manual override.

origflow

float

Original flow before the manual override.

origctl

float

Original temperature correction factor before the manual override.

origcpl

float

Original pressure correction factor before the manual override.

origstartIV

float

Original starting IV.

origstartGSV

float

Original starting GSV.

origendIV

float

Original ending IV.

origendGSV

float

Original ending GSV.

faod

char(1)

Defines whether observed density is manually overridden.

fad

char(1)

Defines whether density is manually overridden.

fat

char(1)

Defines whether temperature is manually overridden.

fap

char(1)

Defines whether the pressure is manually overridden.

faf

char(1)

Defines whether the flow rate is manually overridden.

fwaod

char(1)

Defines whether weighted average observed density is manually overridden.

fwad

char(1)

Defines whether the weighted average density is manually overridden.

fwat

char(1)

Defines whether the WAT is manually overridden.

fwap

char (1)

Defines whether the WAP is manually overridden.

fwaf

char (1)

Defines whether the WAF is manually overridden.

fwamcf

char(1)

Defines whether weighted average meter correction factor is manually overridden.

fstart

char(1)

Defines whether the start volume can be manually overridden.

fend

char(1)

Defines whether the end volume can be manually overridden.

fIV

char(1)

Gross uncalibrated volume.

fGSV

char (1)

Net volume.

usingVolCorr

Char(1)

This field specifies whether this revision was recalculated using the volume correction library when the Controller manually edited the completed ticket.

Fmcf

Char(1)

This field specifies whether the MCF was overridden when the Controller manually edited the completed ticket.

fctl

Char(1)

This field specifies whether the Volume Correction Factor for Temperature (CTL) was overridden when the Controller manually edited the completed ticket.

fcpl

Char(1)

This field specifies whether the CPL was overridden when the Controller manually edited the completed ticket.

fcptl

Char(1)

This field specifies whether the CTPL was overridden when the Controller manually edited the completed ticket.

pressCorr

char (1)

Pressure correction.

tempCorr

char(1)

Temperature correction.

densCorr

char (1)

Density correction.

startLevel

varchar(15)

Provides the starting level information.

startLiqTemp

float

Provides the starting temperature of the product in the tank.

startAmbTemp

float

Provides the starting temperature of the surrounding environment.

startTempCorrFactor

float

The correction factor used on the starting temperature.

startShellTempCorrFactor

float

startLiqDensity

float

The starting density of the product in the tank.

startRoofSnowWeight

float

The starting weight of the snow on the roof of the tank.

startRoofSnowLevel

float

The level of the snow on the roof of the tank at the beginning of the period of measurement.

endLevel

varchar(15)

Provides the level of the product in the tank at the end of the period of measurement.

endLiqTemp

float

Provides the temperature of the product in the tank at the end of the period of measurement.

endAmbTemp

float

Provides the temperature of the surrounding environment at the end of the period of measurement.

endTempCorrFactor

float

Provides the temperature correction factor used at the end of the period of measurement.

endShellTempCorrFactor

float

endLiqDensity

float

Provides the density of the liquid at the end of the period of measurement.

endRoofSnowWeight

float

Provides the weight of the snow on the roof at the end of the period of measurement.

endRoofSnowLevel

float

Provides the level of the snow on the roof at the end of the period of measurement.

volUnit

varchar(15)

Units in which the volume information is stored.

densUnit

varchar(15)

Units in which the density information is stored.

tempUnit

varchar(15)

Units in which the temperature information is stored.

presUnit

varchar(15)

Units in which the pressure information is stored.

audit_trail_revision

int

ownsysID

tagIDtype(int)

ID of the system to which the ticket belongs.

datasetID

tagIDtype(int)

Dataset to which the ticket belongs.

userName

varchar(32)

The name of the user that made the modification.

revisionTime

GMTtime(int)

The time of the last revision.

mass

float

This column provides the mass information.

massUnit

varchar(15)

Units in which the mass information is stored.