Dict-Physical

View VMF_ReadingByHourNoAggregations

Card of view VMF_ReadingByHourNoAggregations

Name	VMF_ReadingByHourNoAggregations
Comment	See documentation on MF_ReadingByHourNoAggregations in the StarsEnergy package.
Dimensional Type	Fact

SQL query of the view VMF_ReadingByHourNoAggregations

select
MD_Point_SurrogateKey,
MD_Date_DateInteger,
MD_Time_TimeInteger,
MD_UnaggRead_SurrogateKey,
MD_Unit_SurrogateKey,
MD_ThingM_SurrogateKey,
MD_Source_SurrogateKey,
MD_Vend_SurrogateKey,
MD_Room_SurrogateKey,
MD_Building_SurrogateKey,
MD_MQual_SurrogateKey,
MF_UnaggRead_Count
from
MF_ReadingByHourNoAggregations

List of outgoing view references of the view VMF_ReadingByHourNoAggregations

ViewReference_202

VMD_Point

ViewReference_203

VMD_UnitOfMeasurement

ViewReference_204

VMD_ThingMeasured

ViewReference_205

VMD_Source

ViewReference_206

VMD_Vendor (Shortcut)

ViewReference_207

VMD_Room (Shortcut)

ViewReference_208

VMD_Building (Shortcut)

ViewReference_209

VMD_MeasurementQuality

ViewReference_210

VMD_TimeToHour

ViewReference_211

VMD_Date (Shortcut)

ViewReference_212

VMD_UnaggregatableReading

List of diagrams containing the view VMF_ReadingByHourNoAggregations

ViewsEnergyDiagram

List of permissions of the view VMF_ReadingByHourNoAggregations

SELECT,VIEW DEFINITION

EnergyReader

List of view columns of the view VMF_ReadingByHourNoAggregations

MD_Point_SurrogateKey

numeric

MD_Date_DateInteger

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

MD_Time_TimeInteger

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift.

MD_UnaggRead_SurrogateKey

numeric

MD_Unit_SurrogateKey

numeric

MD_ThingM_SurrogateKey

numeric

MD_Source_SurrogateKey

numeric

MD_Vend_SurrogateKey

numeric

Foreign key linking to a row in MD_Vendor, providing information on the vendor whose device was used to take a given measurement.

MD_Room_SurrogateKey

numeric

MD_Building_SurrogateKey

numeric

MD_MQual_SurrogateKey

numeric

Many systems associate quality ratings with measurements, and this foreign key allows that relationship to be implemented here. Supported qualities include: Good, Bad, Uncertain.

MF_UnaggRead_Count

int

Count of measurements, if available, that lie behind a given value. Defaults to 1.

Rows in this table are linked to a reading, so the counts here should normally be sliced by reading (e.g., reading X occurred Y times during period Z). Without the reading text, the count is not very useful.

Home