The Power Meter Raw Data report provides unaltered raw power data from SaskPower's systems. This report is essential for users who need to conduct in-depth analysis or create custom reports based on detailed power consumption data.
Overview
The Power Meter Raw Data report pulls raw data directly from SaskPower’s systems and compiles it into a comprehensive report. This data includes power consumption, peak demand, and power factor values, among other metrics. Below are the key columns included in the report and their descriptions:
- saskpower_child_account: The unique SaskPower account number for the sub-account within SaskPower's systems. It remains consistent for a given account.
- meter_number: The SaskPower meter number, which can change if a meter is replaced at the site.
- service_address: The address on file with SaskPower for the meter.
- consumption: The amount of power consumed.
- peak_demand: The peak power demand recorded.
- power_factor: The power factor recorded.
- value_timestamp: The timestamp when the value was recorded.
Parameters for the Report
Start Date: The start date for the data you want to retrieve.
End Date: The end date for the data you want to retrieve.
SaskPower Sub Account ID (Optional): The specific sub-account ID if you want to filter the data for an individual site.
Note: When not filtering by sub-account ID, the system can only allow a one-week range between the start and end dates due to the volume of data. When selecting for an individual site, this constraint is lifted.
Example Report Layout
Conclusion
The Power Meter Raw Data report is an invaluable tool for detailed power consumption analysis and custom reporting. By using this report, users can gain deeper insights into their power usage patterns and make data-driven decisions for optimizing power efficiency.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article