EMV Recovery Portal Integration (EM Impact)

Contents

Overview

MAV customers have access to the EMV Recovery Portal integration to automate the calculation and submission of recovery data into the portal. This is now also known as the EM-Impact portal now.

The data used for the submission to the EMV Recovery Portal data comes from the Recovery Cases' Affected Private Assets and the Infrastructure assessments. The logic used for each metric can be viewed in the Metric Specifications section below.

NOTE: The EM IMPACT report will exclude cases and infrastructure assessments that are Resolved or Closed. Please set the status to "No Action Required"


Submission Process

To submit metrics to the EMV Recovery Portal, follow this process.

NOTE: The only default Victorian Council Positions to have access to these reports are the MRM and Deputy MRM. If you do not either position, you will not see the reports in the new report folder EMV Recovery Portal

If needed your Crisisworks user administrator can edit your position to add the additional security policy called "Access to EMV Recovery Portal Reporting."

Step 1: Prepare your event

When EMV request data to be provided, EMV will inform you of their event code that you must enter into your own Crisisworks event record. You only need to do this once, this same code will be used every time your submit recovery over a long period of time. This code is needed before your run your report and is needed for the data to be received by EMV in a timely manner. 

  1. Click the event name from the Event Selector or select View Event from the Event Selector drop down list
  2. Click Edit
  3. Enter the EMV event name into the Code field, and press Save. (the EM Impact event code is supplied to you by ERV)
    The code may be something like: Dec/Jan 2024 floods and storms    or   February 2024 storms and fires

Step 2: Review your private asset data

The private asset data is supplied for a number of metrics, and a report exists to help you understand what will be included and excluded from the metrics. The private asset data is entered from within the case records which has many choices such as caravans, fences, pumps, water tanks etc 

  1. Click Overview, then click Reports to enter the reports system
  2. Navigate to the EMV Recovery Portal category
  3. Select the EMV Recovery Portal: Private Asset Detail report
  4. Be sure the correct Event is specified 
  5. If you are involved in a cluster, be sure to include the correct Region.
  6. Configure the columns you wish to expose and click Run

When running this report, you can configure it to show or hide various columns, and group by various columns. On first run, it may be useful to run the entire report grouped by Property Type to get an overview of the data you have along with what will be included.

Look for numbers that are excluded from a metric that appears to contain valid metrics. Some examples:

  • It is possible for Recovery Case records to not have a Property Type field set, and this will cause it to be excluded from some results.
  • The EMV submission process does not currently support customised Property Types, Damage Levels or Private Asset Types, so if these have been customised within Crisisworks then check that important data is not assigned to those types. If a new category needs to be added to the EMV report, contact Crisisworks support to modify the report,

You can enable the optional "Cases" column to get a hyperlink to a Recovery Case report for each line item, which will allow you to identify the individual case data comprising it.

Step 3: Review Infrastructure Assessments report

The other detail report to run when reviewing your data prior to submission is the Recovery Infrastructure Assessments report

  1. Click Overview, then click Reports to enter the reports system
  2. Navigate to the Recovery Reports category
  3. Select the Recovery Reports: Recovery Infrastructure Assessments report
  4. Be sure the correct Event is specified 
  5. If you are involved in a cluster, be sure to include the correct Region.
  6. Configure the columns you wish to expose and click Run

When running this report, you can configure it to show or hide various columns, and group by various columns. On first run, it may be useful to run the entire report grouped by Infrastructure Type to get an overview of the data you have along with what will be included.

Step 4: Run a summary report

Run the summary report to generate the statistics for EMV.

  1. Click Overview, then click Reports to enter the reports system
  2. Navigate to the EMV Recovery Portal category
  3. Select the EMV Impact Portal: Summary 2021 report
  4. Be sure that the correct Event is selected
  5. If you are involved in a cluster, be sure to include the correct Region.
  6. Configure the metrics you wish to expose and click Run

When the report finishes, you can review the numbers for accuracy.

The logic used for each metric can be viewed in the Metric Specifications section below

Step 5: Submit to EMV

To submit the report to EMV:

  1. Click Share from the bottom of the EMV Recovery Portal: Summary report
  2. Select EMV Recovery Portal from the list of share targets
  3. For the Summary field, enter a summary note that will apply for all metrics in the report
  4. Specify additional metadata as appropriate for the submission
  5. Click Submit to submit the data

After submission, Crisisworks will prepare and send the data to EMV, and you will be notified by email and via an audit log entry when the integration completes, see the next section for examples


Troubleshooting

Feedback on success or failure

After each submission, Crisisworks records a receipt message from EMV's Recovery Portal within Crisisworks. and notifies the submitter via the audit log and via email (if the user's profile is configured to receive email). If an error occurred, an error message will be included in the email and audit log message.

The following shows examples of a successful notification message. If a failure occurred, the audit message will indicate a failure, and the email message will contain details of the failure.

Audit message exampleEmail message example

Error messages

Most of the errors you are likely to encounter are from EMV's Recovery Portal, and below are the common responses and the steps you can take to correct them.

EMV Error MessageMeaningHow to fix
ERROR: Open Impact Assessment NOT found for this Incident

The Event Code you specify must match an open event within EMV's Recovery Portal. 

You will see this error if you didn't specify an event code, if the code is incorrectly entered, or if a configuration problem at EMV doesn't recognise that your council is involved in this event.

  1. Check with EMV that they are expecting your council to report data for this event.
  2. Check the "assessment name" you received from EMV is entered into the "code" field of your Crisisworks event.
  3. Contact EMV for more assistance.
ERROR: No matching Incident found
ERROR: Metric not assigned to Submitted Reporting Agency + Impacted Area for this Incident

When EMV assigns a council to report data for an incident, it needs to assign metrics to be reported by that council. 

These errors will occur if EMV has failed to assign the correct metrics to your council.

  1. Contact EMV and ask them to check that your council is assigned the correct metrics. The list of metrics appears below in this document.
ERROR: Metric not assigned to Reporting Agency + Impacted Area for this Incident
ERROR: Metric Group, Name and Reference NOT found

Crisisworks submits data to EMV based on an established list of metric names.

This error message will occur if metric names are changed within EMV's Recovery Portal. Renaming metrics within the portal goes against the API established for the integration, and either EMV will need to rename their metrics back to the agreed list, or Crisisworks will need to be updated to match to the new names.

  1. Contact EMV and ask them to rename their metrics back to the agreed names.
  2. If this cannot happen, have EMV contact Datalink with the new details.
ERROR: Impact Portal Error - Too many metrics have this name or reference - Please contact EMV
ERROR: Missing required key 'client_id'Crisisworks does not have the correct OAuth credentials for the recovery portal.
  1. Contact Datalink and have them liaise with EMV to obtain a valid OAuth2 client_id and client_secret.

If you encounter other error messages, then contact Datalink's service desk for assistance. 

Metric Specifications

The following metrics are available to be submitted.

To find these records in the data-grids you can use the CQL search queries within the private assets data grid.

#

Metric Name

Metric Value

Data SourcesCalculationEMV Data Dictionary
Community Facilities
EMV-1

Facilities Damaged

COUNT

Infrastructure Assessment (IA)

  1. IA has active status
  2. IA has type of 'Council Facility' or 'Council Property'
  3. IA damage is one of 
    1. 'Damaged - Habitable / Functioning'
    2. Unknown - Requires Assessment

All buildings/sites/facilities located on DELWP crown land managed by either DELWP, committees of management, or where councils are acting as committee of management’s.
EMV-2

Facilities Damaged (Loss Value)

DOLLARS

Infrastructure Assessment (IA)Same as EMV-1All buildings/sites/facilities located on DELWP crown land managed by either DELWP, committees of management, or where councils are acting as committee of management’s.
EMV-3

Facilities Destroyed

COUNT

Infrastructure Assessment (IA)
  1. IA has active status
  2. IA has type of 'Council Facility' or 'Council Property'
  3. IA damage is one of 
    1. 'Inaccessible / Non Functioning',
    2. 'Partially Destroyed'
    3. 'Totally Destroyed'

Freehold land, privately owned operated asset.
Community facility is any structure that:
- Provides for the delivery of a community service
- Provides for any community sporting, recreational, wellbeing, social club activity

A community facility can be classified into the following categories:
- Privately owned and managed
- Government owned and managed
- Government owned and privately managed

Examples include:
- Public halls
- Library
- Living and Learning Centres
- Aquatic and Recreation Facilities
- Sports Pavilions
- Churches

Destroyed indicates building is not structurally sound and is unsafe for any type of use – area to be closed to public until recovered.

EMV-4

Facilities Destroyed (Loss value)

DOLLARS

Infrastructure Assessment (IA)

Same as EMV-3As above
Council EPAs
EMV-5

Bridges damaged

COUNT

Infrastructure Assessment (IA)
  1. IA has active status
  2. IA has type of 'Bridge'
  3. IA damage is one of 
    1. Damaged - Habitable / Functioning
    2. Inaccessible / Non-Functioning
    3. Partially Destroyed
    4. Totally Destroyed
    5. Unknown - Requires Assessment
A bridge is a structure that is built over a railway, river, or road so that people or vehicles can cross from one side to the other. Damage would indicate that bridge has structural damage and will require a structural assessment prior to being available for use by the public. Bridge categories include: - Traffic/Road Bridge - Pedestrian Bridge/Overpass - Railway Bridge
EMV-6

Road Reserves

COUNT

Infrastructure Assessment (IA)
  1. IA has active status
  2. IA has type of 'Road Reserve'
  3. IA damage is one of 
    1. Damaged - Habitable / Functioning
    2. Inaccessible / Non-Functioning
    3. Partially Destroyed
    4. Totally Destroyed
    5. Unknown - Requires Assessment
A road reserve is a legally described area within which facilities such as roads, footpaths, and associated features may be constructed for public travel. It is the total area between boundaries shown on a cadastral plan
EMV-7

Road Reserves (distance)

KM

Infrastructure Assessment (IA)Same as EMV-6A road reserve is a legally described area within which facilities such as roads, footpaths, and associated features may be constructed for public travel. It is the total area between boundaries shown on a cadastral plan
EMV-8

Roads damaged

COUNT

Infrastructure Assessment (IA)
  1. IA has active status
  2. IA has type of 'Road'
  3. IA damage is one of 
    1. Damaged - Habitable / Functioning
    2. Inaccessible / Non-Functioning
    3. Partially Destroyed
    4. Totally Destroyed
    5. Unknown - Requires Assessment
A road is a thoroughfare, route, or way on land between two places that has been paved or otherwise improved to allow travel by motor vehicle, or bicycle. All roads (made and unmade) under the management and/or ownership of a Council. Does not include: - Private Roads - Footpaths - Off road bicycle paths/trails/tracks - Fire Access Tracks in reserves/parks
EMV-9

Roads damaged (distance)

KM

Infrastructure Assessment (IA)Same as EMV-8A road is a thoroughfare, route, or way on land between two places that has been paved or otherwise improved to allow travel by motor vehicle, or bicycle. All roads (made and unmade) under the management and/or ownership of a Council. Does not include: - Private Roads - Footpaths - Off road bicycle paths/trails/tracks - Fire Access Tracks in reserves/parks
Councils
EMV-10

Trails/walkways (damaged)

COUNT

Infrastructure Assessment (IA)
  1. IA has active status
  2. IA has type of 'Trails/Walkway'
  3. IA damage is one of 
    1. Damaged - Habitable / Functioning
    2. Inaccessible / Non-Functioning
    3. Partially Destroyed
    4. Totally Destroyed
    5. Unknown - Requires Assessment
A defined path (made or unmade) that is designated primarily for walking and/or passive leisure activity. Trails and walkways are often located in proximity of reserves, natural features (e.g. rivers), linear parks, wetland areas, open space areas and sporting grounds. They may also include boardwalk structures, concrete paths and footpaths. Does not include: - Shopping centre strips/walkways - Bus stop areas
EMV-11

Trails/walkways (distance)

KM

Infrastructure Assessment (IA)Same as EMV-10A defined path (made or unmade) that is designated primarily for walking and/or passive leisure activity. Trails and walkways are often located in proximity of reserves, natural features (e.g. rivers), linear parks, wetland areas, open space areas and sporting grounds. They may also include boardwalk structures, concrete paths and footpaths. Does not include: - Shopping centre strips/walkways - Bus stop areas
Primary Residences
EMV-12

Primary Residences (Damaged)

COUNT

Recovery Case (RC), Private Asset (PA)
  1. RC has active status
  2. PA has active status
  3. PA type is 'A Primary Place of Residence'
  4. PA damage is one of 
    1. 'Damaged - Habitable / Functioning'
    2. Unknown - Requires Assessment

A private residential building (house, unit, apartment, caravan etc.) that is used as a primary place of residence for a person or persons (family). Damaged indicates damaged, but still habitable. Not a: - Holiday property (house, house, unit, apartment, caravan etc.) - Private business office - Commercial property / storage container / factory - Out buildings – sheds, garages, stables etc.
EMV-13

Primary Residences (Destroyed)

COUNT

Recovery Case (RC), Private Asset (PA)
  1. RC has active status
  2. PA has active status
  3. PA type is 'A Primary Place of Residence'
  4. PA damage is one of
    1. 'Inaccessible / Non Functioning',
    2. 'Partially Destroyed'
    3. 'Totally Destroyed'
A private residential building (house, unit, apartment, caravan etc.) that is used as a primary place of residence for a person or persons (family). Destroyed indicates damaged, no longer habitable. Not a: - Holiday property (house, house, unit, apartment, caravan etc.) - Private business office - Commercial property / storage container / factory - Out buildings – sheds, garages, stables etc.
Total Residences
EMV-14

Total Residences (Damaged)

COUNT

Recovery Case, Private Asset
  1. RC has active status
  2. PA has active status
  3. PA type is ticked as 
    [x] A Primary Place of Residence
    Which can be one of: Flats/Units, Caravans,Other Dwelling, Holiday House, Holiday Rental
  4. PA damage is one of 
    1. 'Damaged - Habitable / Functioning'
    2. 'Unknown - Requires Assessment'

This will be the sum of all primary residences damaged and any other privately owned residences (those not included in the definition for primary e.g. holiday properties). Does not include: - Private business office - Commercial property / storage container / factory - Out buildings – sheds, garages, stables etc. Damaged indicates damaged, but still habitable.
EMV-15

Total Residences (Destroyed)

COUNT

Recovery Case, Private Asset
  1. RC has active status
  2. PA has active status
    PA type is ticked as 
    [x] A Primary Place of Residence
    Which can be one of: Flats/Units, Caravans,Other Dwelling, Holiday House, Holiday Rental
  3. PA damage is one of
    1. 'Inaccessible / Non Functioning',
    2. 'Partially Destroyed'
    3. 'Totally Destroyed'
This will be the sum of all primary residences damaged and any other privately owned residences (those not included in the definition for primary e.g. holiday properties). Does not include: - Private business office - Commercial property / storage container / factory - Out buildings – sheds, garages, stables etc. Destroyed indicates damaged, no longer habitable.
Business
EMV-16

Loss value (non-building) - Financial loss

DOLLARS

Recovery Case, Private Asset
  1. RC has active status
  2. PA has active status
  3. RC has property type of 'Commercial, Industrial or Business'
  4. PA type is 
    1. 'Business Economic Impact'
  5. PA damage is one of 
    1. Damaged - Habitable / Functioning
    2. Inaccessible / Non-Functioning
    3. Partially Destroyed
    4. Totally Destroyed
    5. Unknown - Requires Assessment
May include: - significant inventory and equipment - economic losses including loss of trade due to the event. Does not include buildings or infrastructure
Business buildings (excl. farming)
EMV-17

Damaged loss value (excl. agriculture)

DOLLARS

Recovery Case, Private Asset
  1. RC has active status
  2. PA has active status
  3. RC has property type of 'Commercial, Industrial or Business'
  4. PA damage is 
    1. 'Damaged - Habitable / Functioning'
    2. 'Unknown - Requires Assessment'

  5. PA type is one of
    1. Boats

    2. Caravans

    3. Flats/Units

    4. Holiday Rental

    5. Other Facility

    6. Other Structure

    7. Sheds

    8. Shops/Factories

Total cost of damage to impacted business buildings and infrastructure. Excludes inventory, equipment, economic losses etc.
EMV-18

Destroyed loss count (excl. agriculture)

COUNT

Recovery Case, Private Asset
  1. RC has active status
  2. PA has active status
  3. RC has property type of 'Commercial, Industrial or Business'
  4. PA damage is 
    1. 'Inaccessible / Non-Functioning',
    2. 'Partially Destroyed'
    3. 'Totally Destroyed'
  5. PA type is one of
    1. Boats

    2. Caravans

    3. Flats/Units

    4. Holiday Rental

    5. Other Facility

    6. Other Structure

    7. Sheds

    8. Shops/Factories

Total cost of impacted business buildings and infrastructure (excluding agriculture) that have been destroyed.
EMV-19

Destroyed loss value (excl. agriculture)

DOLLARS

Recovery Case, Private Assetsame as EMV-18The total number of impacted business buildings that have been destroyed. (Further analysis required as to what type of business and whether they are able to trade.)

Data Dictionary

The following terms are used in this integration.

General terms



Destroyed

From EMV's data dictionary:

Destroyed indicates damaged, no longer habitable.

Damaged

From EMV's data dictionary:

Damaged indicates damaged, but still habitable.

Primary Residences

From EMV's data dictionary:

A private residential building (house, unit, apartment, caravan etc.) that is used as a primary place of residence for a person or persons (family). Not a: - Holiday property (house, house, unit, apartment, caravan etc.) - Private business office - Commercial property / storage container / factory - Out buildings – sheds, garages, stables etc.

Total Residences

From EMV's data dictionary:

The sum of all primary residences damaged and any other privately owned residences (those not included in the definition for primary e.g. holiday properties). Does not include: - Private business office - Commercial property / storage container / factory - Out buildings – sheds, garages, stables etc.


Built-in Lookup Classifications

The following built-in lookups in Crisisworks are mapped to EMV.

Damage Level

KeyLabel

Included as "Damaged"

Where both metrics are required

Included as "Destroyed"

Where both metrics are required

Included as "Damaged"

When only damaged is required

1Damaged - Habitable / FunctioningYesNoYes
2Inaccessible / Non-FunctioningNoYesYes
3Partially DestroyedNoYesYes
4Totally DestroyedNoYesYes
5Unknown - Requires Assessment

Yes

No Yes
6Not DamagedNoNoNo

Property Type

KeyLabel
propertyUseCommercialCommercial, Industrial or Business
propertyUseResidentialResidential
propertyUseResidentialPrimaryResidential - Primary
propertyUseResidentialSecondaryResidential - Secondary
propertyUseResidentialUnclassifiedResidential - Unclassified
propertyUseAccommodationAccommodation / B&B
propertyUseFarmFarming
propertyUseGovernmentGovernment Building
propertyUseCommunityCommunity Facility
propertyUseInfrastructureInfrastructure
propertyUseVacantVacant Land
propertyUseOtherOther

Private Asset Type

KeyDefault Label
housePrimary Place of Residence
holiday-houseHoliday House
holiday-rentalHoliday Rental
flatFlats/Units
caravanCaravans
dwelling-otherOther Dwelling
shopShops/Factories
govGovernment
communityCommunity Centre(s)
facility-otherOther Facility
fencingFencing
shedShed/s
tankTank
structure-otherOther Structure
dairyDairy
irrigationIrrigation Pumps
machineryMachinery
equipment-otherOther Equipment
carCars
boatBoats
bikeBikes
trailersTrailers
vehicle-otherOther Vehicle
otherOther

Metadata

Report metadata contain fields for accuracy and credibility, which have been adopted from the AIDR Manual 14 on Post Disaster Survey and Assessment.

Name
Accuracy
Not reliable
Incomplete and/or generally unreliable
Incomplete but generally reliable
Fairly complete and reliable
Mainly complete and reliable
Complete and reliable
Credibility
Unknown
Improbably
Doubtful
Possibly true
Probably true
Confirmed