Tables¶
This chapter describes the Power BI Operations table and column definitions.
Partitions¶
The Partitions table is used to create and manage partitions, allowing for the organization and division of groups and subscriptions based on data set access permissions.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for partitions |
| Name | text | Name of the partition |
| Description | text | Description of the partition |
Locations¶
The Locations table stores information about different locations within a building, including their characteristics, contact details, and geographic coordinates.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for locations |
| PartitionId | text | Identifier of the associated partition |
| Type | text | Type of location (e.g., campus, building, room, floor) |
| Label | text | Label or name for the location |
| TimeZone | text | Time zone of the location |
| Description | text | Description of the location |
| ExternalId | text | External identifier for the location |
| Coordinate_X | number | X-coordinate of the location |
| Coordinate_Y | number | Y-coordinate of the location |
| PrimaryContactName | text | Name of the primary contact for the location |
| PrimaryContactEmail | text | Email of the primary contact |
| PrimaryContactPhone | text | Phone number of the primary contact |
| HasPostalAddressId | text | Identifier of associated postal address |
| Tag_* | any | Each location-specific tag is represented as an individual column, making it effortless to access and filter data based on each tag |
| CreatedAt | datetime | Timestamp of creation |
| UpdatedAt | datetime | Timestamp of last update |
| CreatedBy | text | Creator of the location |
| UpdatedBy | text | Last updater of the location |
Note: Prefiltered tables are also available for Campus, Building, Floor, and Room location types.
LocationTags¶
The LocationTags table is used to store information about tags associated with various physical locations within smart buildings and infrastructure. Tags provide additional details and categorization for locations.
| Column Name | Data Type | Description |
|---|---|---|
| LocationId | text | The identifier for a specific location |
| TagName | text | The name of the tag associated with the location |
| TagValue | any | The value of the tag, which can be of various data types, providing specific information about the location |
EquipmentTypes¶
The EquipmentTypes table defines various types of equipment used within the building. It categorizes equipment types and provides descriptive details.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for equipment types |
| Type | text | Type of equipment |
| PartitionId | text | Identifier of the associated partition |
| Name | text | Name of the equipment type |
| Description | text | Description of the equipment type |
| Domain | text | Domain or category of the equipment type |
| Deprecated | text | Indicates if the equipment type is deprecated |
| Iri | text | Model description for the equipment type |
| HasParentTypeId | text | Identifier of the parent equipment type |
| HasParentType | text | Type of the parent equipment type |
| CreatedAt | datetime | Timestamp of creation |
| UpdatedAt | datetime | Timestamp of last update |
| CreatedBy | text | Creator of the equipment type |
| UpdatedBy | text | Last updater of the equipment type |
Equipment¶
The Equipment table contains detailed information about specific equipment within the building, such as devices, machinery, or systems.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for equipment |
| PartitionId | text | Identifier of the associated partition |
| EquipmentTypeId | text | Identifier of the associated equipment type |
| Name | text | Name of the equipment |
| Notes | text | Additional notes or information about equipment |
| ExternalId | text | External identifier for equipment |
| SerialNumber | text | Serial number of the equipment |
| Model | text | Model information for the equipment |
| ManufacturingYear | number | Year when the equipment was manufactured |
| ManufacturedBy | text | Manufacturer of the equipment |
| InstallationDate | datetime | Date when the equipment was installed |
| IsControlledById | text | Identifier of the controlling equipment |
| IsControlledByType | text | Type of the controlling equipment |
| IsPartOfId | text | Identifier of the parent equipment |
| IsPartOfType | text | Type of the parent equipment |
| FeedsId | text | Identifier of equipment feeds |
| FeedsType | text | Type of equipment feeds |
| LocationId | text | Identifier of the associated location |
| LocationType | text | Type of the associated location |
| CreatedAt | datetime | Timestamp of creation |
| UpdatedAt | datetime | Timestamp of last update |
| CreatedBy | text | Creator of the equipment |
| UpdatedBy | text | Last updater of the equipment |
Devices¶
The Devices table contains information about various devices within the building, including their specifications and connections.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for devices |
| PartitionId | text | Identifier of the associated partition |
| ModelName | text | Name or model of the device |
| SerialNumber | text | Serial number of the device |
| ProfileName | text | Name of the device's profile |
| ProfileNotes | text | Additional notes or details about the profile |
| HasGatewayType | text | Type of the associated gateway |
| HasGatewayId | text | Identifier of the associated gateway |
| HasLocationType | text | Type of the associated location |
| HasLocationId | text | Identifier of the associated location |
Points¶
The Points table contains individual datapoints collected from various building systems, such as sensors and meters.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for datapoints |
| PartitionId | text | Identifier of the associated partition |
| DeviceId | text | Identifier of the associated device |
| EquipmentId | text | Identifier of the associated equipment |
| PointGroupId | text | Identifier of the associated point group |
| Name | text | Name or label of the datapoint |
| Description | text | Description of the datapoint |
| DataType | text | Type of data collected (e.g., temperature, humidity) |
| IsActive | logical | Indicates if the datapoint is active or not |
| Unit | text | Measurement unit of the datapoint |
| SourceType | text | Type of point source (e.g., PointNB) |
| Minimum | number | Minimum value recorded for the datapoint |
| Maximum | number | Maximum value recorded for the datapoint |
| Precision | number | Precision or accuracy of the datapoint |
| CommandingSemantic | text | Semantic information for commanding the point |
| Function | text | Function or purpose of the datapoint |
| Tag_* | any | Each point-specific tag is represented as an individual column, making it effortless to access and filter data based on each tag value |
| CreatedAt | datetime | Timestamp of creation |
| UpdatedAt | datetime | Timestamp of last update |
PointTags¶
The PointTags table is designed to store information about tags associated with datapoints or measurements within the smart building and infrastructure system. These tags help categorize and provide context for datapoints.
| Column Name | Data Type | Description |
|---|---|---|
| PointId | text | The identifier for a specific datapoint or measurement |
| TagName | text | The name of the tag associated with the datapoint |
| TagValue | any | The value of the tag, which can vary in data type, providing specific information or context for the datapoint |
All tags defined with the data point are included, regardless of the value of the PointTagsFilter parameter, to reflect the data point configuration.
PointValues¶
The PointValues table stores the actual values of datapoints collected over time.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for datapoint values |
| PartitionId | text | Identifier of the associated partition |
| PointId | text | Identifier of the associated datapoint |
| Timestamp | datetime | Timestamp of the datapoint value |
| Value | text | Actual value recorded at the timestamp |
| QualityOfValue | numeric | Measurement reliability using the following values: 0: Good - Signifying high-quality, trustworthy data. 1: Bad - Generic Error - Denoting unclear or unspecified issues. 2: Bad - Communication Error - Indicating problems in data transmission. 3: Bad - Configuration Error - Relating to errors in system setup. 4: Bad - Off-Normal - Highlighting measurements outside expected parameters (user defined). 5: Bad - Gap - Identifying missing or incomplete data (user defined). |
EnergyMediumConsumptions¶
The EnergyMediumConsumptions table contains information about energy medium consumptions.
| Column Name | Data Type | Description |
|---|---|---|
| Id | text | Unique identifier for energy medium consumptions |
| PartitionId | text | Identifier of the associated partition |
| Name | text | Name of the energy medium consumption |
| Disciplines | record | Disciplines associated with the energy medium consumption |
| Reference | record | Reference information for the energy medium consumption |
EnergyMediumConsumptionValues¶
The EnergyMediumConsumptionValues table stores the values of energy medium consumptions over time.
| Column Name | Data Type | Description |
|---|---|---|
| MediumConsumptionId | text | Identifier of the associated energy medium consumption |
| PartitionId | text | Identifier of the associated partition |
| Timestamp | datetime | Timestamp of the energy medium consumption value |
| Value | number | Actual value recorded at the timestamp |
| Unit | text | Measurement unit of the energy medium consumption value |
EnergyMediumConsumptionEmissions¶
The EnergyMediumConsumptionEmissions table stores information about emissions associated with energy medium consumptions.
| Column Name | Data Type | Description |
|---|---|---|
| MediumConsumptionId | text | Identifier of the associated energy medium consumption |
| PartitionId | text | Identifier of the associated partition |
| Timestamp | datetime | Timestamp of the energy medium consumption emission |
| Value | number | Actual value recorded at the timestamp |
| Unit | text | Measurement unit of the energy medium consumption emission |
EnergyMediumConsumptionCosts¶
The EnergyMediumConsumptionCosts table stores information about costs associated with energy medium consumptions.
| Column Name | Data Type | Description |
|---|---|---|
| MediumConsumptionId | text | Identifier of the associated energy medium consumption |
| PartitionId | text | Identifier of the associated partition |
| Timestamp | datetime | Timestamp of the energy medium consumption cost |
| Value | number | Actual value recorded at the timestamp |
| Unit | text | Measurement unit of the energy medium consumption cost |