Primary key value assigned to uniquely identify each Program Area

Primary key value assigned to uniquely identify each Municipality

Reporting year for the measure Result

One of the MBNCanada-defined municipal service areas that the Measure belongs to

Name of the MBNCanada partner municipality providing the Measure data

Measure number assigned by MBNCanada to uniquely identify each Measure Name

Measure name as it appears in the MBNCanada Data Warehouse

Value of Numerator inputted into the MBNCanada Data Warehouse for calculating Result, if applicable. It is usually what is before the word “per” in the Measure Name. For percent type measures, it is usually what follows the word “Percent of” in the Measure Name. Look at the Measure Name for a clue as to the unit of measure.

Value of Denominator inputted into the MBNCanada Data Warehouse for calculating Result, if applicable. It is usually what follows the word “per” in the Measure Name. For percent type measures, it is usually the total of what follows the word “Percent of” in the Measure Name without the constraint. Look at the Measure Name for a clue as to the unit of measure.

Result for the Measure. The result can be inputted directly into the MBNCanada Data Warehouse or calculated as Numerator / Denominator. Look at the Measure Name for a clue as to the unit of measure.

Yes/No flag indicating whether the Measure is an MBNCanada Board measure which are included in the annual printed report

Yes/No flag indicating whether the Measure is publicly reportable and can be used in any type of reporting by all MBNCanada partners using identifiers

Measure category assigned to each Measure according to MBNCanada’s benchmarking framework

Year that the Measure was created and first reported on

1. CSV
2. XML
3. JSON