EngineeringUnitCatalog

(PK) EUCKey

int NOT NULL

The unique numerical identifier of an engineering catalog unit. This value is automatically generated by the system when the engineering unit is added.

(FK) EUDKey

int NOT NULL

The unique numerical identifier of the dimension the unit belongs to. Foreign key to the EngineeringUnitDimension table.

(FK) EUSKey

int NOT NULL

The unique numerical identifier of the system of measure the unit belongs to. Foreign key to the EngineeringUnitSystem table.

Symbol

nvarchar(32) NOT NULL

Canonical (standard) symbol used by the system of measurement that the unit belongs to. May contain special characters, such as the degree symbol for temperature measurements (for example, 68°).

BasicSymbol

nvarchar(32) NOT NULL

Canonical (standard) symbol used by the system of measurement that the unit belongs to. May not contain special characters.

Description

nvarchar(80) NOT NULL

A more descriptive name for the unit.

IntegralDivisor

float NOT NULL

The factor to be applied when integrating a rate with the units [EngUnits/TimeUnit] to a quantity with units [EngUnits]. This factor is called the integral divisor. The default value of 1 assumes a time unit of seconds and ensures that a rate of [Unit/second] is correctly integrated to [Unit]. For a time unit of minutes, set the integral divisor value to 60; for a unit of hours, set the integral divisor value to 3600. The integral divisor is applied similarly to rates or quantities that are not expressed in terms of a time unit. For example, to convert watts to watt-hours, the integral divisor is 1/3600. To convert watts to kilowatt-hours, the integral divisor is 1/3600000.

ToBaseOffset

float NOT NULL

The offset used in linear conversion with respect to the base unit (b in the following line equation: y = m(x+b)).

ToBaseScaleFactor

float NOT NULL

The scale factor used in linear conversion with respect to the base unit (m in the following line equation: y = m(x+b)).

IsVisible

bit NOT NULL

Set to 1 if this unit is displayed when you are creating a new engineering unit, and trying to link it to an existing catalog unit. Default value = 1.

IsSystem

bit NOT NULL

Set to 1 if this unit is defined by the system. (For example, it was created by the RuntimePostData.sql script.) Default value = 0.