Understand the Accumulator Ticket Device (AccumulatorTicketDevice) table

msrepl_tran_version

uniqueidentifier

Unique record identifier.

time

GMTtime(int)

Ticket created 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)

The name of the associated device.

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.

startRawCounter

float

The starting raw accumulator reading.

endRawCounter

float

The ending raw accumulator reading.

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 observed density at the time of the write-up to the Historical database.

actdens

float

Actual density at the time of the write-up to the Historical database.

acttemp

float

Actual temperature at the time of the write-up to the Historical database.

actpres

float

Actual pressure at the time of the time of the write-up to the Historical database.

actflow

float

Actual flow rate at the time of the write-up to the Historical database.

mcf

float

Meter Correction Factor (MCF).

ctl

decimal(17,15)

Weighted Average Volume Correction Factor for Temperature (CTL).

cpl

decimal(17,15)

Weighted Average Volume Correction Factor for Pressure (CPL).

ctpl

float

Combined Temperature and Pressure Correction factor (CTPL).

expFlow

float

Expected flow information.

expPres

float

Expected pressure information.

IV

float

Indicated Volume (IV).

GV

float

Gross Volume (GV).

GSV

float

Gross Standard Volume (GSV).

origtemp

float

Original temperature before manual override.

origobsdens

float

Original observed density before manual override.

origdens

float

Original density before manual override.

origpres

float

Original pressure before manual override.

origflow

float

Original flow before manual override.

origctl

float

Original temperature correction factor before manual override.

origcpl

float

Original pressure correction factor before manual override.

origstartIV

float

Original start indicated volume before manual override.

origstartGSV

float

Original start GSV before manual override.

origendIV

float

Original end IV before manual override.

origendGSV

float

Original ending GSV before manual override.

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 pressure is manually overridden.

faf

char(1)

Defines whether 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 overridden.

fwat

char(1)

Defines whether the WAT is overridden.

fwap

char(1)

Defines whether the WAP is overridden.

fwamcf

char(1)

Defines whether the weighted average MCF is overridden.

fwaf

char(1)

Indicates whether or not the WAF has been overridden with a simulated value.

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.

fmcf

char(1)

Defines whether the meter correction factor can be manually overridden.

pressCorr

char(1)

Pressure correction.

tempCorr

char(1)

Temperature correction.

densCorr

char(1)

Density correction.

mcfCorr

char(1)

Meter correction factor.

origmcf

float

Original MCF before manual override.

ccmf

float

MCF multiplied by CTL and CPL.

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)

ID of the dataset to which the ticket belongs.

userName

varchar(32)

revisionTime

GMTtime(int)

The time that the modification was made.

usingVolCorr

char(1)

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

fctl

char(1)

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

fcpl

char(1)

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

fctpl

char(1)

This field specifies whether the Combined Temperature and Pressure Correction Factor (CTPL) was overridden when the Controller manually edited the completed ticket.

mass

float

This column provides the mass information.

massUnit

varchar(15)

Units in which the mass information is stored.