Storm Information File
The Storm Information file contains data about all the completed storms from your outage management system. This historical information can then be used to calculate estimated restoration timelines for new storms that come.
| Column | Description |
|---|---|
| STORM_NAME |
Storm name. This can be a casual name, such as Sally or Mark, or something based on an established convention in your organization. Type: VARCHAR2(65) Can be empty?: No. |
| STORM_TYPE |
Storm type. This information will vary by utility. Oracle Energy and Water will work with you to define the values. Whatever STORM_TYPE values appear in the Storm Information file should be consistent with the storm types that are defined in the user interface configuration. For example, if you work with Oracle Energy and Water to configure the Storm ERT user interface to display storm type like "Thunder", "Tornado", "Flood", and "Snow", then the data sent to the STORM_TYPE field should match those values. Example Values:
Type: VARCHAR2(32) Can be empty?: Yes. |
| STORM_LEVEL |
Storm level or severity. This information will vary by utility. Oracle Energy and Water will work with you to define the values. Whatever STORM_LEVEL values appear in the Storm information file should be consistent with the "storm levels" that are defined in the user interface configuration. See Configure the Storm ERT Cloud Service for more details. For example, if you work with Oracle Energy and Water to configure the Storm ERT user interface to displays storm levels like "Minor", "Major", and "Severe", then the data sent in the STORM_LEVEL field should match those values. Example Values:
Type: VARCHAR2(32) Can be empty?: Yes. |
| STORM_START |
Storm start date and time. Type: DATE. See Date and Time Handling for details. Can be empty?: No. |
| STORM_END |
Storm end date and time. Type: DATE. See Date and Time Handling for details. Can be empty?: No. |
| ZONE1 |
Level 1 control zone for the storm. This information is similar to the information in the Control Zone File. The difference is that in this file, any zones specified are associated with a specific storm. Type: VARCHAR2(64) Can be empty?: No. |
| ZONE2 |
Level 2 control zone for the storm. This should be a subdivision of zone 1. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE3 |
Level 3 control zone for the storm. This should be a subdivision of zone 2. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE4 |
Level 4 control zone for the storm. This should be a subdivision of zone 3. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE5 |
Level 5 control zone for the storm. This should be a subdivision of zone 4. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE6 |
Level 6 control zone for the storm. This should be a subdivision of zone 5. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE7 |
Level 7 control zone for the storm. This should be a subdivision of zone 6. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE8 |
Level 8 control zone for the storm. This should be a subdivision of zone 7. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE9 |
Level 9 control zone for the storm. This should be a subdivision of zone 8. Type: VARCHAR2(64) Can be empty?: Yes. |
| ZONE10 |
Level 10 control zone for the storm. This should be a subdivision of zone 9. Type: VARCHAR2(64) Can be empty?: Yes. |
Example Storm Information File
"STORM_NAME"|"STORM_TYPE"|"STORM_LEVEL"|"STORM_START"|"STORM_END"|"ZONE1"|"ZONE2"|"ZONE3"|"ZONE4"|"ZONE5"|"ZONE6"|"ZONE7"|"ZONE8"|"ZONE9"|"ZONE10"
"9/05/24 Southern Region"|"THUNDER"|"NONE"|"2024-09-05 13:00:00"|"2024-09-08 20:19:44"|"UtilCo"|"Oracle City South"||||||||
"4/03/24 Southern Region"|"THUNDER"|"MAJOR"|"2024-04-03 16:00:00"|"2024-04-06 01:00:00"|"UtilCo"|"Oracle City South"||||||||
"1/09/24 Southern Region"|"THUNDER"|"MAJOR"|"2024-01-09 23:00:00"|"2024-01-10 11:00:00"|"UtilCo"|"Oracle City South"||||||||