Automed Valuation Model Layout AVM History

Automated Valuation Model (AVM) Layout

Field Name Field Description Data Type
Constellation_ID (CID) CID (Constellation Unique Identifier) varchar
FIPS Code (State/County) Numeric code to identify every County/State in the US. 1st 2 positions = State, last 3 positions = County varchar
Assessor’s Parcel Number (APN, PIN) Present if matched varchar
Property Full Street Address For Address components, see Property Address Fields on Assessment Tab of Public Records RLO. varchar
Property Unit Type Property Address Unit Designator. varchar
Property Unit Number For Address components, see Property Address Fields on Assessment Tab of Public Records RLO. varchar
Property City Name For Address components, see Property Address Fields on Assessment Tab of Public Records RLO. varchar
Property State Two-letter standard postal abbreviation varchar
Property Zip Code Five-digit postal zip code. varchar
Estimated Date The date the valuation was created varchar
Estimated Value The derived valuation for the subject property varchar
Confidence Score 100 – FSD_Score (description below) varchar
FSD Forecasted Standard Deviation. A statistical measure that represents the probability that the valuation falls within one standard deviation of the actual market value. For example: If the FSD for an HVE value estimate is 10%, there is a 68% (one standard deviation) probability that the actual market value will fall between +/-10% of the HVE value estimate. varchar
Price Range Min Low limit of the valuation range varchar
Price Range Max High limit of the valuation range varchar
Hashvalue Record hash value, updated hashvalue indicates if the record changed varchar
ModificationTimestamp When the record was updated TimeStamp
Hashvalue Record hash value, updated hashvalue indicates if the record changed varchar
Version varchar
Constellation AVM Whitepaper

AVM History Layout

Field Name Field Description Data Type
Constellation1_ID (CID) Unique Identifier in Constellation1 varchar
Record ID Source ID varchar
Fips Code Numeric code to identify every County/State in the US. 1st 2 positions = State, last 3 positions = County varchar
Assessor’s Parcel Number (APN, PIN) Present if matched varchar
Property House Number For Address components, see Property Address fields on Assessment Tab in Public Records RLO. varchar
Property Street Direction Left For Address components, see Property Address fields on Assessment Tab in Public Records RLO. varchar
Property Street Name For Address components, see Property Address fields on Assessment Tab in Public Records RLO. varchar
Property Street Suffix The recommended Official USPS Standardized Suffix Abbreviations varchar
Property Street Direction Right For Address components, see Property Address fields on Assessment Tab in Public Records RLO. varchar
Property Unit Type Property Address Unit Designator. varchar
Property Unit Number For Address components, see Property Address fields on Assessment Tab in Public Records RLO. varchar
Property City Name For Address components, see Property Address fields on Assessment Tab in Public Records RLO. varchar
Property State Two-letter standard postal abbreviation. varchar
Property Zip Code Five-digit postal zip code. varchar
YYYY_MM_Val Starting way back from 2019 July the derived valuation for the subject property in that month. We will have repeated columns for YYYY_MM_Val where YYYY = year (2019) and MM = month (07). Every month we will be adding a new column for that month with YYYY_MM_Val format number
YYYY_MM_Low Starting way back from 2019 July the low limit of the valuation range in year + month. We will have repeated columns for YYYY_MM_Val where YYYY = year (2019) and MM = month (07) Every month we will be adding a new column for that month with YYYY_MM_Low number
YYYY_MM_High Starting way back from 2019 July high limit of the valuation range in year + month. We will have repeated columns for YYYY_MM_Val where YYYY = year (2019) and MM = month (07). Every month we will be adding a new column for that month with YYYY_MM_High number
Full Detail information Confidential. Not for Distribution.