Excerpt

Available Views and Categories

Nine pre-defined Sigma Views and six Tenant Billing Views have been created on top of the Sigma database to expose the key groups of data.

Sigma Views

Sigma Bill Sigma Bill Sigma Database Items

View	Description	Data Availability
Sigma Best Available Consumption	The best available consumption based on the Accounts, Meters and Supplier Statements connected through a Supply Point.	5 years
*
Bills - Charges	The bills that have been loaded into Sigma, including individual charge lines, bill tags, batches and associated to all Sigma Items
Bills - Daily Consumption	Enriched daily consumption generated from bill totals, normalised to common units per account commodity and associated to all Sigma Items	5 years
Bills - Queries	All queries raised against bills within Sigma and associated to all Sigma Items	5 years
Sigma Bill Validation ResultsBills - Validation	The validation results for bills in Sigma and associated to all Sigma Items	5 years
Sigma Bills and Charges	The bills that have been loaded into Sigma, including individual charge lines, bill tags, batches and associated to all Sigma Items	5 years

Estate - Best Available Consumption - click for more details	The best available consumption for a supply point combined with independent Consumption Data Channels For Supply Point Consumption: - Data is sourced from meters, Bills and Supplier statements - Data is prioritised, and estimated according to flexible config - Data is converted to common unit of measurement, per commodity - Data is filled using “Missing Data Imputation” Machine Learning - Data is forecasted to current date - Data Enriched with Emissions, Associated data and degree days Data is also sourced from 'Consumption Data' channels nested under Organisation, Site Group or Site Items	5 years
Estate - Structure	All Sigma item types available for reporting	5 years
Sigma High Frequency Periodic Data	High frequency data loaded from periodic channels	14 months
Sigma Metered Estate - Supply Point Configuration	Provides access to Sigma items that relate to Supply Points
Meters - Daily Consumption	Enriched daily consumption data loaded in Sigma against both non-periodic and periodic channels, normalised to common units per commodity and associated to all Sigma Items	5 years
Sigma Meters - Data Monitoring Notifications	Data Monitoring Strategies and the Notifications that have been created for each Strategy	N/A

Tenant Billing Views

...

(In-Day Refresh)¹ Tenant Bill Charges

...

Useful for Tenant Billing Customers only. The Tenant bill charges that have been created by Sigma and associated to all Sigma Items

...

Tenant Bill Consumption

...

Useful for Tenant Billing Customers only. Enriched daily consumption generated from bill totals, normalised to common units per account commodity and associated to all Sigma Items

...

Tenant Bill Queries

...

Useful for Tenant Billing Customers only. All queries raised against bills within Sigma and associated to all Sigma Items

...

Tenant Bill Validation Results

...

Useful for Tenant Billing Customers only. The validation results for bills in Sigma and associated to all Sigma Items

...

Tenant Metered Consumption

...

Useful for Tenant Billing Customers only. Enriched daily consumption data loaded in Sigma against both non-periodic and periodic channels, normalised to common units per commodity and associated to all Sigma Items

...

(In-Day Refresh)¹Tenant Supply Point Configuration

...

Data available within these Views can be refreshed manually from within Sigma

To start building a report in Sigma EI, go to the main navigation bar on the left hand side, click Create > Report, select one of the nine Views and start using the drag and drop tool to build your data.

The data category access matrix below details of the categories available in each of the views.

Sigma Categories

...

Meters - High Frequency Consumption	High frequency data loaded from periodic channels	14 months
Monitoring Points - Daily Consumption***	Enriched daily consumption and cost data from Monitoring Points in Sigma (Only those that are held under Sites and Building Units)	5 years
Monitoring Points – High Frequency Consumption***	HH consumption and cost data from Monitoring Points in Sigma (Only those that are held under Sites and Building Units)	5 years

*Note: The Data Availability column defines the maximum age of the data which will be available in Energy Intelligence.

**Note: The Views use outer joins to join the entities to each other.

*** Note: Restricted access

Sigma Categories

View Categories	Bills - Charges	Bills - Daily Consumption	Bills - Queries	*Bills - Validation*	Estate - Best Available Consumption	Estate - Structure	Estate -Supply Point Configuration	*Meters - Daily Consumption*	Meters -Data Monitoring Notifications	Meters - High Frequency Consumption	Monitoring Points - Daily Consumption	Monitoring Points - HH Consumption
Account	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y
Account Property	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y

Y

Bill

Y

Bill Charge

Y

Bill Cost Centre

Y

Bill Tag

Y

Building Unit

Y

Building Unit Property

Y

Bulk Bill Batch

Y

Bulk Bill Batch Property

Y

Channel

Y

Channel HF Data

Y

Channel Property

Y

Consumption/Consumption & Emissions

Y

Consumption Data Channel

Y

Contract

Y

Contract Property

Y

Cost Centre

Y

Meter

Y

Meter Property

Y

Monitoring

Strategy

Point

Y

Notifications

Y

Organisation

Monitoring Point Property

Y

Monitoring Point Issues

Y

Monitoring Point Items

Y

Monitoring Strategy

Y

Notifications

Y

Organisation

Property

Y

Provider

Y

Organisation Property

Y

Provider

Y

Query

Y

Site

Y

Site Group

Y

Site Property

Y

Site Group Property

Y

Supply Point

Y

Supply Point Property

Y

Time

Y

Time of Day (Periodic Channel Data Datetime)

Y

Validation Result

Y

Sigma Best Available Consumption View

...

Category	Description
Account	All the utility billing accounts that have been created in Sigma
Account Property	All the properties that have been defined and associated to an Account in Sigma (Note - Only accounts linked to sites are available.)
Bill	Details of all the EDI and Manual bills that have been entered into Sigma (Note - Tenant Bills are not shown)
Bill Charge	The Bill charge data entered into Sigma. A row is returned for each charge on a Bill.
Bill Cost Centre	The applicable apportionment factors for each effective Cost Centre defined for the bill. (Note - If a single Cost Centre has a split factor during the period of a bill, a weighted average will be calculated based on the number* of days in the bill period that each individual factor is applicable.)
Building Unit	Details of building units defined in Sigma (Note - Only building units linked to sites are available)
Bill Tag	The Bill Tags used in a Sigma Bill. Each item of information within a Bill is stored as a 'Bill Tag' for the type of Bill e.g. the Bill Tags in an electricity bill will differ from those in a gas bill. They can be used to provide information about a particular value in a bill. A row is returned for each Bill Tag populated in a Bill.
Building Unit Property	The User defined properties that are associated to a Building Unit within Sigma
Bulk Bill Batch	The batches of bills that have been loaded into Sigma
Bulk Bill Batch Property	The User defined properties that are associated to a bulk bill batch within Sigma
Consumption / Consumption & Emissions (Best Available View only)	The Consumption data that has been loaded for a Channel that includes Periodic, Non-periodic and Account (for bills) channels. Only Channels with the following Channel Data Types will be included: Consumption, Consumption By Mass, Energy Consumption, Volumetric Consumption and Volume Channel The emission conversion factors e.g. Cons CO2 are sourced from the GOV.UK website ‘Government emission conversion factors for greenhouse gas company reporting’ or custom values if they have been entered
Consumption Data Channel	The consumption or emissions data that has been loaded for a Consumption Data Channel
been entered
Consumption Data Channel	The consumption or emissions data that has been loaded for a Consumption Data Channel
Channel	The periodic or non-periodic channels that exist in Sigma and are associated with a meter. The channel holds the data coming from the meter
Channel HF Data	Periodic channel raw data at the granularity and units as loaded into Sigma. For example, Half Hourly consumption data
Channel Property	The User defined properties that are associated to a channel within Sigma
Contract	The Contracts that have been loaded into Sigma
Contract Property	The User defined properties that are associated to a contract within Sigma
Cost Centre	The Cost Centres defined for an Account, to facilitate apportionment of bills, as required for accounting purposes
Meter	The Meters that have been defined in Sigma (Note - Sub meters are included, but virtual meters are excluded)
Meter Property	The User defined properties that are associated to a Meter within Sigma
Monitoring Strategy	The Monitoring Strategies that exist in the Data Monitoring Activity
Notifications	The Notifications created for each Monitoring Strategy
Organisation	The periodic or non-periodic channels that exist in Sigma and are associated with a meter. The channel holds the data coming from the meterChannel HF Data details of each Organisation defined in Sigma
Organisation Property	Periodic channel raw data at the granularity and units as loaded into Sigma. For example, Half Hourly consumption data	Channel Property	The	The User defined properties that are associated to a channel an Organisation within Sigma
Contract Provider	The Contracts Providers that have been loaded into SigmaContract Property defined in Sigma – these usually represent utility supplier, data aggregators, meter operators and data collectors
Query	The User defined properties that are associated to a contract within Sigma	Cost Centre	The Cost Centres defined for an Account, to facilitate apportionment of bills, as required for accounting purposes
Meter	The Meters that have been defined in Sigma (Note - Sub meters are included, but virtual meters are excluded)
Meter Property queries that have been raised in Sigma against an Account
Site	The sites that have been defined in Sigma. These represent the physical location of a property
Site Group	The site groups that have been created in Sigma in order to group individual sites together
Site Group Property	The User defined properties that are associated to a site group within Sigma
Site Property	The User defined properties that are associated to a Meter site within Sigma
Monitoring Strategy	The Monitoring Strategies that exist in the Data Monitoring Activity
Notifications	The Notifications created for each Monitoring Strategy
OrganisationSite	The details of each Organisation defined in Sigma	Organisation Property	The sites that have been defined in Sigma. These represent the physical location of a property
Site Group	The site groups that have been created in Sigma in order to group individual sites together
Site Group Property	The User defined properties that are associated to an Organisation a site group within Sigma
ProviderSite Property	The Providers that have been defined in Sigma – these usually represent utility supplier, data aggregators, meter operators and data collectorsQuery User defined properties that are associated to a site within Sigma
Supply Point	The queries that have been raised in Sigma against an Account	Site	The sites supply points that have been defined in Sigma – i.e. These represent the physical location of a property
Site Group	The site groups that have been created in Sigma in order to group individual sites together
Site Group Property the MPAN (electricity) or MPR (gas)
Supply Point Property	The User defined properties that are associated to a site group within Sigma
Site Property	The User defined properties that are associated to a site within Sigma
Site supply point within Sigma
Time	A number of different time related options (e.g. month, year etc.) to help consolidate your data into periods of time
Time of Day (Periodic Channel Data Datetime)	A set of fields to identify the time of day that data represents. Only available in the Sigma High Frequency Periodic Data view
Validation Result	The sites that have been defined in Sigma. These represent the physical location of a property	Site Group	The site groups	The results that have been created in Sigma in order to group individual sites together
Site Group Property	The User defined properties that are associated to a site group within Sigma
Site Property	The User defined properties that are associated to a site within Sigma
Supply Point	The supply points that have been defined in Sigma – i.e. the MPAN (electricity) or MPR (gas)
Supply Point Property	The User defined properties that are associated to a supply point within Sigma
Time	A number of different time related options (e.g. month, year etc.) to help consolidate your data into periods of time
Time of Day (Periodic Channel Data Datetime)	A set of fields to identify the time of day that data represents. Only available in the Sigma High Frequency Periodic Data view
Validation Result	The results that have been created as a result of performing bill validation within Sigmaas a result of performing bill validation within Sigma

Tenant Billing Views

View	Description	Data Availability
Tenant Billing - Bill Consumption (IDR)^3*	Useful for Tenant Billing Customers only. Daily consumption generated from bill totals, and associated to all Sigma Items	5 years
Tenant Billing - Bill Queries	Useful for Tenant Billing Customers only. All queries raised against Tenant bills within Sigma and associated to all Sigma Items	5 years
Tenant Billing - Bill Validation	Useful for Tenant Billing Customers only. The validation results for Tenant bills in Sigma and associated to all Sigma Items	5 years
Tenant Billing – Bills and Charges (IDR)³	Useful for Tenant Billing Customers only. The Tenant bill charges that have been created by Sigma and associated to all Sigma Items	5 years
Tenant Billing - Meter Consumption	Useful for Tenant Billing Customers only. Enriched daily consumption data loaded in Sigma against both non-periodic and periodic channels, normalised to common units per commodity and associated to all Sigma Items	5 years
Tenant Billing - Supply Point Configuration (IDR)³	Useful for Tenant Billing Customers only. Provides access to Tenant billing Sigma items that relate to Supply Points	5 years

*in Day Refresh

Data available within these Views can be refreshed manually from within Sigma

To start building a report in Sigma EI, go to the main navigation bar on the left hand side, click Create > Report, select one of the nine Views and start using the drag and drop tool to build your data.

The data category access matrix below details of the categories available in each of the views.

Tenant Billing Categories

View Categories

(In-Day Refresh) Tenant

Tenant Billing - Bill Consumption

(

In-Day Refresh) Tenant Bills and Charges

IDR)^3*	Tenant Bill

Consumption

ing - Bill Queries	Tenant Billing - Bill

Queries

Validation	Tenant Bill

Validation Results

ing – Bills and Charges (IDR)³	Tenant

Metered

Billing - Meter Consumption	Tenant Billing - Supply Point

Configuration

Configuration (IDR)³
Building Unit

Y

	Y	Y	Y	Y	Y	Y
Building Unit Property	Y	Y	Y	Y	Y	Y

Y

Channel						Y
Channel Property						Y
Consumption

Y

	Y				Y
Contract

Y

	Y	Y	Y	Y	Y	Y
Contract Property

Y

	Y	Y	Y	Y	Y	Y
Meter				Y	Y	Y
Meter Property				Y	Y	Y
Organisation

Y

	Y	Y	Y	Y	Y	Y
Organisation Property	Y	Y	Y	Y	Y	Y

Y

Query		Y
Site	Y	Y	Y	Y	Y	Y

Y

Site Group

Y

	Y	Y	Y	Y	Y	Y
Site Property	Y	Y	Y	Y	Y	Y

Y

Site Group Property

Y

	Y	Y	Y	Y	Y	Y
Supply Point

Y

	Y	Y	Y	Y	Y	Y
Supply Point Property

Y

	Y	Y	Y	Y	Y	Y
Tariff

Y

YYYYY

Tariff Entry						Y
Tariff Cost Definition Entry						Y
Tenant

Y

	Y	Y	Y	Y	Y	Y
Tenant Account

Y

	Y	Y	Y	Y	Y	Y
Tenant Account Property

Y

	Y	Y	Y	Y	Y	Y
Tenant AdHoc Charge						Y
Tenant Bill

Y

	Y	Y	Y	Y
Tenant Bill Charge				Y
Tenant Bill Cost Centre	Y			Y

Y


Tenant Billing Group	Y	Y	Y	Y	Y	Y
Tenant Property	Y

Tenant Property

Y	Y	Y	Y	Y
Tenant Provider	Y	Y	Y

Time

Y	Y	Y
Time	Y	Y	Y	Y	Y
Validation Result			Y

Available Sigma Tenant Billing Categories

...

Versions Compared

Old Version 39

New Version Current

Key

Available Views and Categories

Sigma Views

Tenant Billing Views

Sigma Categories

Sigma Categories

Sigma Best Available Consumption View

Tenant Billing Views

Tenant Billing Categories

Available Sigma Tenant Billing Categories

Page Comparison

Versions Compared

Old Version 39

New Version Current

Key

Available Views and Categories

Sigma Views

Tenant Billing Views

Sigma Categories

Sigma Categories

Sigma Best Available Consumption View

Tenant Billing Views

Tenant Billing Categories

Available Sigma Tenant Billing Categories