New in this Release - property_historical_sales - Latest

Property Historical Sales Release Notes

Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > Property Features
Product
Property Historical Sales
Version
Latest
Language
English
Product name
Property Historical Sales
Title
Property Historical Sales Release Notes
Copyright
2024
First publish date
2020
Last updated
2024-11-28
Published on
2024-11-28T05:45:31.950413

Data schema structure

The structure of the Property Historical Sales Data Schema has been changed to support Precisely's Data Integrity Suite and SaaS solutions. The changes are as follows:

  • Please refer to the field column definitions on the Notices worksheet. Some of these fields are specific for use with Precisely Software Solutions.
  • All CHAR and VARCHAR fields types are represented as TEXT.
  • Data type and length are added in two separate columns.
  • The following new field columns have been added to the Data Schema:
    • product_table_name
    • index
    • primary_key
    • type_code
    • table_name
  • The following field column names are changed:
    Old field column name New field column name
    Table Name table_friendly_name
    Information Type grouping
    Seq. sequence_number
    Field Name field_name
    Long Name field_friendly_name
    Data Type (Length) data_type
    Data Type (Length) field_length
    Field Value Key field_value_key_reference
    Description description

Additionally, new database loadable files built from the new Data Schema structure, can be downloaded using the links provided in the Property Historical Sales Getting Started Guide.