Add HIE AV column to internal views and Open Data: Assessed Values

[wrridgeway]

Goal:

Feel free to work these as separate issues.

• Please add the HIE AV amount per PIN and tax year, currently in asmt_all.TOT30, as a new column in default.vw_pin_value. Update docs accordingly.
• Please also add it to open_data.vw_assessed_value, and as such add it add this column to the Open Data: Assessed Values dataset.

Context:

Our Open Data: Assessed Values data publishes AVs that are not quite the taxable AVs because these AVs have not yet had the HIE reduction applied. Example is TY2022, PIN 32062040080000: board_tot is $11,679 on open data and on the Assessor's website. But it had the HIE for $773 of AV, so its actual taxable AV is $10,906. (Note: tax.pin and PTAXSIM are fine. Its BOR final AV in tax.pin is $10,905).

[ccao-jardine]

Hey, looks like the HIE AVs never made it to Open Data - Assessed Values. Can you add mailed_hie, certified_hie, and board_hie to that asset?