Provide Input Configurable Data for Grid Insights

The input configurable data specified below is used for the Grid Insights - Transformer Load Monitoring subject area. If you want to keep the default settings of this data, no action is necessary. However, you can change the default settings. For example, you may want to modify the labels that describe the load range of the transformers, or modify the start and end ranges associated with each label.

If you want to change the default, you must provide an updated file in CSV format to Oracle Energy and Water. Use the information in the tables below to understand each column and default values, and how the can be changed. When you are ready, place the CSV file in your Oracle Cloud Infrastructure Object Storage. Oracle Energy and Water will then configure the data and sync it with the Oracle Energy and Water Data Intelligence platform.

Input Configurable Data

Column	Description
A1_RANGE_CONFIG_CD	A hard coded value of "TLM-RANGE". "TLM" refers to transformer load management. Allowed Value: TLM-RANGE Type: VARCHAR2(30 CHAR) Can be empty?: No.
A1_RANGE_CONFIG_SEQ	A unique sequence from 1-8. This determines the sequence for the labels in the A1_RANGE_LABEL column. Type: NUMBER Can be empty?: No.
A1_RANGE_LABEL	A label describing the load range of the transformer. There are five default labels available. The names of the labels can be changed, and up to eight labels can be used. Default Values: Under Loaded Normal Watch List Overload Immediate Type: VARCHAR2(30 CHAR) Can be empty?: No.
A1_START_RANGE	Start range of the TLM range. Type: NUMBER Can be empty?: No.
A1_END_RANGE	End range of the TLM range. Type: NUMBER Can be empty?: No.
A1_RANGE_DESCR	A description of the TLM range, expressed in the following form: >A1_START_RANGE and <=A1_END_RANGE This means that the start range value is not included in the range, but the end range value is included. For example, based on the default values below, if the transformer capacity load capacity rises to 120%, then it would fall in the 70% to 120% range. No gaps are permitted between each range. For example, you cannot have one range end at <=70% and then have the next range start at >71%. The next range must start at >70%. Default Values: >0% and <=70% >70% and <=120% >120% and <=140% >140% and <=180% >180% and <=1000% Type: VARCHAR2(100 CHAR)
A1_WEEKLY_COUNT	A count of hours to be met to classify a transformer as any bucket in weekly mode. Type: NUMBER Can be empty?: No.
A1_MONTHLY_COUNT	A count of hours to be met to classify a transformer as any bucket in monthly mode. Type: NUMBER Can be empty?: No.

Default Configuration

The default configuration shown below is in place to put transformers into five categories, such as Under Loaded, Normal, Watch List, Overload, and Immediate based on their load. This configuration is required only for the Grid Insights - Transformer Load Monitoring subject area that is available in the Grid Insights data.

This image shows an example of categories for transformers.

As an administrator, you can configure up to eight buckets and modify the start and end range for their classification. Any changes to this configuration after the insights data is loaded into target requires a full data refresh of Transformer Load Management-related Insights. Otherwise, customers will observe their change in the subsequent load, and the existing data will have no impact on this configuration change.