Overview
The Core OEM SQL Data is a Certified Product Point Template for Power Plant Controllers defines optional telemetry Bazefield has available for advanced analysis of 10-minute data sets often provided by Power Plant Controller OEM SCADA systems. These points are not required for monitoring but can be helpful for more accurate month-end reporting, and situations where data coverage and quality is critical to the end-user. It is meant to compliment much of the OPC data found in the Core Real-Time Data template.
Template Definition
The Core OEM SQL template specifically holds all the critical “raw” pre-aggregated 10-minute data expected from most Power Plant Controller SCADA systems. Specifically, it is common for many vendors of PPCs to host an on-site SQL database with localized schema for the below points. Bazefield supports interfaces to all major OEM SQL databases to map OEM definitions and namespaces of the below points to the normalized point names provided in the table.
Minimum Requirements
In most power plant controllers, there will be a significant number points available beyond this list which are vendor or SCADA specific. This list represents the minimum, common list of critical data often available in ALL vendors and SCADA systems.
Details on the Point Names, Descriptions, and Types are below.
Required for Bazefield Core Dashboard functionality
Optional for common additional data streams/sources
Name | Description | Type | Unit | |
|---|---|---|---|---|
ActivePower.10m | Site active power from OEM SQL Database | SCADA (raw) | kW | |
ActivePowerMW.10m | Site active power from OEM SQL Database | SCADA (raw) | MW | |
CurrentA.10m | Phase A current from OEM SQL Database | SCADA (raw) | A | |
CurrentB.10m | Phase B current from OEM SQL Database | SCADA (raw) | A | |
CurrentC.10m | Phase C current from OEM SQL Database | SCADA (raw) | A | |
Frequency.10m | Frequency from OEM SQL Database | SCADA (raw) | Hz | |
PossiblePower.10m | Possible power from OEM SQL Database | SCADA (raw) | MW | |
PowerFactor.10m | Power factor from OEM SQL Database | SCADA (raw) | ||
ReactivePower.10m | Site reactive power from OEM SQL Database | SCADA (raw) | MVAR | |
TurbinesAvailable.10m | Number of turbines available from OEM SQL Database | SCADA (raw) | ||
TurbinesCommunicating.10m | Number of turbines communicating from OEM SQL Database | SCADA (raw) | ||
TurbinesCurtailed.10m | Number of turbines in curtailed state from OEM SQL Database | SCADA (raw) | ||
TurbinesHighWind.10m | Number of turbines in high wind cutout from OEM SQL Database | SCADA (raw) | ||
TurbinesLowWind.10m | Number of turbines in low wind cutout from OEM SQL Database | SCADA (raw) | ||
TurbinesOnline.10m | Number of turbines online/running, producing power, from OEM SQL Database | SCADA (raw) | ||
TurbinesStop.10m | Number of turbines stopped from OEM SQL Database | SCADA (raw) | ||
Voltage.10m | Site voltage from OEM SQL Database | SCADA (raw) | kV | |
WindDirection.10m | Site wind direction from OEM SQL Database | SCADA (raw) | Deg | |
WindSpeed.10m | Site wind speed from OEM SQL Database | SCADA (raw) | m/s |