EPC document or URL attached

[matt-austin-andrews]

Hi there,

We plan to display a metrics about "No EPC document" at BI tools (Looker). The users request to check whether it has EPC document/URL upload to Reapit or not.

Here's the screenshot at Reapit:

Currently, I can't see this field is available at Reapit by viewing PROPERTIES at Snowflake. Can you add a column such as "Certificate(Yes/No)", "Certificate No", Start Date", "End Date", "Supplier"?

Many thanks, Jessie

Specification

• Project: Analytics Schema
• This data is incorrectly being presented in the PROPERTY_LETTINGS_CERTIFICATES view model. To resolve:
• Add new PROPERTY_SALES_CERTIFICATES view model that is a duplicate of the lettings one but with only certificates relating to sales (or dual marketed) properties
• At some point in the future we can then remove the SALES certificate data from the lettings view model (comms required)

[plittlewood-rpt]

Hi @matt-austin-andrews you'll currently find this data (incorrectly) in the PROPERTY_LETTINGS_CERTIFICATES view. I think rather than renaming the view which would be a breaking change, the best thing to do here is to add a new view model specifically for EPC certificates (something like PROPERTY_EPC_CERTIFICATES), OR separate certificates for Sales properties out into a PROPERTY_SALES_CERTIFICATES view model. We'll discuss this on our refinement session later today.

[github-actions[bot]]

This issue has been updated and moved to our ‘Near Term’ column (typically completed within 0 - 4 months). We have assessed the effort required and outlined a technical specification - please take the time to review this detail. When we're ready to schedule the issue, it will be assigned to the relevant board where you can continue to track its progress to completion. For more information on our processes, please click here

[matt-austin-andrews]

Hi Pete,

Thank you for the update. I will get in touch at the next few weeks regarding the new view.

Jessie

[matt-austin-andrews]

Hi there,

Considering the ticket was created at the beginning last month, any update news? Will you create a new view model?

Kind regards, Jessie

[plittlewood-rpt]

HI @matt-austin-andrews yes the specification has been updated and this is now in our Near Term column and will be picked up in line with our development processes. We are going to add a new view and at some point in the future will remove the incorrect data from the lettings certificates view