September 2025.09: Schema breaking changes
The Property Attributes Mortgage product will be enhanced with new features for the September 2025 Release (v2025.09) that will require a breaking change to the Data Schema. Any additional information about the September breaking changes, including an updated data schema and sample data, is communicated via the Precisely Knowledge Communities.
The original release for this update has been changed from August release (v2025.08) to
September release (v2025.09) as communicated in the Precisely Knowledge Communities.
- Deprecated Fields: The following field values are no longer received therefore,
they will be removed from the product:
field_name
field_friendly_name
PHONE Owner Phone PHONE2 Owner-2 Phone PROP_LAND_VALCALC_IND Land Value Indicator PROP_IMP_VALCALC_IND Improve Value Indicator PROP_APNCNT Sale Parcel Count PROP_DEEDCD_PRIOR Prior Deed Code PROP_DEEDTYPE_PRIOR Prior Deed Type PROP_SELLCARRYBACK Seller Carry Back PROP_MTGREFICD Mortgage Refinance PROP_MTGASSUMPTIONAMT2 Mortgage Assumed Amount 2 PROP_MTGREFICD2 Mortgage Refinance 2 PROP_MTGDEEDCD3 Mortgage Deed 3 PROP_MTGASSUMPTIONAMT3 Mortgage Assume Amount 3 PROP_MTGREFICD3 Mortgage Refinance 3 PROP_STORIESCD
Building Stories Code - Synthetic Property Records: Synthetic property records will be added to the Property Attributes Mortgage product, and as a result a new field called SYN_PROP_RECORD will be used to identify these records in the data file. Synthetic property records typically represent housing cooperatives or condominium buildings and are derived by Precisely for the sole purpose of providing building characteristics to our clients. The SYN_PROP_RECORD field will be populated with a Y (yes) if the data row is a synthetic property created by Precisely.
- Source Address Fields: Four new fields will be added to represent the original situs (property) address from the local tax authority: SRC_ADDRESS, SRC_CITY, SRC_STATE, SRC_ZIPCODE. These fields will represent a third set of address components, in addition to the current billing address and situs (property) address fields, which go through a rigorous address hygiene process. The intent of adding these fields is to give our users an indication of how Precisely has improved addresses to provide an accurate geocode or coordinate within the product.
- Concatenated Owner Name Fields: Full concatenated owner names will be represented in two new fields for Owner 1 (OWNER_NAME) and Owner 2 (OWNER_NAME2) name.
- Length of following fields will be changed:
field_name field_friendly_name field_length OWNID Owner ID 12 OWNID2 Owner ID2 12 PROP_XMTVET Veteran Exemption 1 PROP_XMT_DISABLED Disabled Exemption 1 LAT Latitude 11,6 - Data Type and Length of following fields will be changed:
field_name field_friendly_name data_type field_length PROP_ST_LANDUSE Standardized Land Use Code TEXT 3 PROP_IND Land Use Condensed TEXT 2 BLDG_STORIES Building Stories Count DECIMAL 7,2 PROP_ACRES Property Acres DECIMAL 15,6 BATH_CT Number of Baths DECIMAL 7,2 PROP_BATHS Baths Count DECIMAL 7,2 ROOF_COVER Roof Cover TEXT 3 PROP_MTGINTRATE Mortgage Interest Rate DECIMAL 9,4 PROP_MTGINTRATE2 Mortgage Interest Rate 2 DECIMAL 9,4 PROP_MTGINTRATE3 Mortgage Interest Rate 3 DECIMAL 9,4 - Refer to the property_attributes_mortgage_data_schema_September_2025 for breaking change.