VfcAccumHourly table
- Last UpdatedApr 24, 2025
- 2 minute read
This table holds the hourly information for each accumulator.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
time |
GMTtime |
This column provides the start time of the hourly record in Greenwich Mean Time (GMT). |
|
offset |
GMToffset |
This column provides information about the GMT offset for the time zone. |
|
accumName |
nameType |
This column provides the name of the accumulator. |
|
vfcName |
nameType |
This column provides the name of the associated virtualflowcomputer. |
|
startRawCounter |
float |
This column provides the raw accumulator reading at the start of the hour. |
|
endRawCounter |
float |
This column provides the raw accumulator reading at the end of the hour. |
|
IV |
float |
This column provides the Indicated Volume (IV) information. |
|
GSV |
float |
This column provides the Gross Standard Volume (GSV) information. |
|
CTL |
float |
This column provides the Temperature Correction factor for Liquids (CTL) information. |
|
CPL |
float |
This column provides the Pressure Correction factor for Liquids (CPL) information. |
|
CTPL |
float |
This column provides the combined Temperature and Pressure Correction factor for Liquids (CTPL) information. |
|
CCMF |
float |
The Corrected Combined Meter Factor (CCMF). It is calculated in the following way: the Meter Correction Factor (MCF) is multiplied by the Temperature Correction and Pressure Correction factor for Liquids. Note: The CCMF is equivalent to the Combined Correction Factor (CCF) in the American Petroleum Institute's Manual of Petroleum Measurement Standards (API MPMS) 12.2.2 (2003). |
|
MCF |
float |
This column provides the Meter Correction Factor. Note: The MCF is equivalent to the Meter Factor (MF) in API MPMS 12.2.2 (2003) |
|
hourlyIV |
float |
This column provides the hourly IV information. |
|
hourlyGSV |
float |
This column provides the hourly GSV information. |
|
hourly_wa_density |
float |
This column provides the hourly Weighted Average Density (WAD) information. |
|
hourly_wa_temp |
float |
This column provides the hourly Weighted Average Temperature (WAT) information. |
|
hourly_wa_press |
float |
This column provides the hourly Weighted Average Pressure (WAP) information. |
|
hourly_wa_mcf |
float |
This column provides the hourly Weighted Average Meter Correction Factor (WAMCF) information. |
|
hourly_wa_flowrate |
float |
This column provides the hourly Weighted Average Flow Rate (WAF) information. |
|
volUnit |
varchar(15) |
This column provides the unit in which the volume was recorded. |
|
densUnit |
varchar(15) |
This column provides the unit in which the density was recorded. |
|
tempUnit |
varchar(15) |
This column provides the unit in which the temperature was recorded. |
|
presUnit |
varchar(15) |
This column provides the unit in which the pressure was recorded. |
|
ownsysId |
tagIDType |
This column provides the ID associated with the owning system. |
|
datasetId |
tagIDtype |
This column provides the dataset ID information. |