SF_GaugedTankTemplate
The table below provides pertinent information regarding the columns in the SF_GaugedTankTemplate table.
SF_GaugedTankTemplate Table Columns
| Column | Type |
|---|---|
| CaseID (PK, FK) | Nvarchar(40), not null |
| ID (PK) | Nvarchar(40), not null |
| Name | Nvarchar(128), null |
| Description | Nvarchar(128), null |
| Categories | Nvarchar(128), null |
| Layers | Nvarchar(128), null |
| AmbientTemperature | Float, null |
| BSW | Float, null |
| ComposiionTrackingBalanceFlag | Bit, null |
| CompositionTrackingDensity | Float, null |
| CompositionTrackingResults | Sql_variant, null |
| CostCenter | Nvarchar(252), null |
| Density | Float, null |
| DensityBalanceFlag | Bit, null |
| Diameter | Float, null |
| FloatingRoofAdjustment | Float, null |
| GrossVolume | Float, null |
| Height | Float, null |
| HighAlarm | Float, null |
| InferredStatus | Nvarchar(252), null |
| InventoryChange | Float, null |
| LevelGauge | Float, null |
| LiquidVaporSpace | Float, null |
| LowAlarm | Float, null |
| MmanualAdjustmentFlag | Bit, null |
| MassInventoryChange | Float, null |
| MassTolerance | Float, null |
| MassVaporSpace | Float, null |
| Material | Nvarchar(252), null |
| Maximum | Float, null |
| MeasuredMass | Float, null |
| Minimum | Float, null |
| MixingModel | Nvarchar(252), null |
| MolecularWeight | Float, null |
| NetVolume | Float, null |
| NetWeight | Float, null |
| ObjectStatus | Nvarchar(252), null |
| OpeningBSW | Float, null |
| OpeningDensity | Float, null |
| OpeningFloatingRoofAdjustment | Float, null |
| OpeningGrossVolume | Float, null |
| OpeningLevelGauge | Float, null |
| OpeningMaterial | Float, null |
| OpeningMeasurement | Float, null |
| OpeningNetVolume | Float, null |
| OpeningShellCorrectionFactor | Float, null |
| OpeningTemperature | Float, null |
| OpeningVCFFactor | Float, null |
| OpeningWaterLevelGauge | Float, null |
| OpeningWaterVolume | Float, null |
| PercentBSW | Float, null |
| Pressure | Float, null |
| ReconciledInfluence | Float, null |
| ReconciledMass | Float, null |
| ReconciledMassCorrection | Float, null |
| ReconciledMassImbalance | Float, null |
| ReconciledMassSolvability | Nvarchar(252), null |
| ReconciledMassTest1 | Float, null |
| ReconciledMassTest2 | Float, null |
| ReconciledMassTest3 | Float, null |
| ReconciledMassTest4 | Float, null |
| ReconciledMassTolerance | Float, null |
| ReconciledMassVariance | Float, null |
| ReconciledResidual | Float, null |
| ReconciledVolume | Float, null |
| ReconciledVolumeCorrection | Float, null |
| ReconciledVolumeImbalance | Float, null |
| ReconciledVolumeSolvability | Nvarchar(252), null |
| ReconciledVolumeTest1 | Float, null |
| ReconciledVolumeTest2 | Float, null |
| ReconciledVolumeTest3 | Float, null |
| ReconciledVolumeTest4 | Float, null |
| ReconciledVolumeTolerance | Float, null |
| ReconciledVolumeVariance | Float, null |
| ReconciledWeight | Float, null |
| RoofWeight | Float, null |
| SelfCalculatingFlag | Bit, null |
| ShellCorrectionFactor | Float, null |
| SigmafineBalanceMaximum | Float, null |
| StartingNetVolume | Float, null |
| StrapDens | Float, null |
| StrapTemp | Float, null |
| Temperature | Float, null |
| VCFFactor | Float, null |
| VolumeTolerance | Float, null |
| WaterLevelGauge | Float, null |
| WaterVolume | Float, null |