Let's create a dbt test to add to the workbooks to flag when a PIN in the AHSAP program increases in AV more than 20% compared to its AV in the prior stage.
AHSAP PINs can be identified using vw_pin_township_class.
Context: the AHSAP program is administered by the Assessor and began in Tax Year 2022 to support affordable housing. This dbt test will help Valuations confirm accurate AV changes for properties in this program.
Let's create a dbt test to add to the workbooks to flag when a PIN in the AHSAP program increases in AV more than 20% compared to its AV in the prior stage.
AHSAP PINs can be identified using
vw_pin_township_class.Context: the AHSAP program is administered by the Assessor and began in Tax Year 2022 to support affordable housing. This dbt test will help Valuations confirm accurate AV changes for properties in this program.