Address and Property Product Announcements

 View Only

Enrich Data Schema Template change

  • 1.  Enrich Data Schema Template change

    Posted 06-14-2024 09:04
    Edited by Product Communications 06-14-2024 09:04

    June 14, 2024

    Enrich Data Schema Template Change           

    Abstract

    This announcement is to inform you of a change to the Enrich Precisely Data Schema template. This update will only affect the format of the Data Schema Excel File that is provided within the "documentation" folder of the product zip package.  There will be no change to the Data product files. This update will be made to the following products for their October 2024 releases.

    ·         United States Address FabricTM Data

    ·         Canada Address FabricTM Data

    ·         Serviceability Extended Attributes (SEA)

    ·         Parcel Boundaries  

    ·         Property Attributes Mortgage (PAM)

    ·         Property Historical Sales (PHS)

    ·         Property Graph USA

    Please read this message in its entirety if you license one of the products listed above.


    Overview of Features and Functionality
     

    The Data Schema file will be presented in a new template format to support Precisely software and cloud solution initiatives. This update will only affect the format of the Data Schema Excel File that is provided within the "documentation" folder of the product zip package.  There will be no change to the Data product files. This new format supports Precisely's continued goal of interoperable and standardized data products, across the entire Enrich Data Portfolio.

    A description of the format changes is described below. Also, please see the attached sample October Data Schemas for all product mentioned above. 

    Data Schema Template Changes

    ·         Please note the new field column definitions on the "Notices" tab. Some of these fields are specific for use with Precisely Software Solutions.

    ·         All CHAR and VARCHAR field types are now represented as TEXT.

    ·         Data type and length are now in two separate columns.

    ·         For USA Address FabricTM Data, the three separate tabs labeled as "Data Schema," "Changelog Data Schema," and "Low Conf Data Schema," will now be represented as one tab called "Data Schema."

    ·         For the CAN Address FabricTM Data, the two separate tabs labeled as "Data Schema" and "Changelog Data Schema" will now be represented as one tab called "Data Schema."

    ·         For Parcel Boundaries, a new tab called "Field Value Key" will be added. This field is not populated at this time and is reserved for any future needs.

    ·         The following fields were added, removed, or had name changes on the "Data Schema" and "Field Value Key" tabs.

     

    Product

    Data Schema Tab

    Data Schema File Change

    New Field Name

    Old Field Name

    Parcel Boundaries

    Data Schema

    Field added

    sequence_number

     

    Add Fabric USA
    Add Fabric CAN
    SEA
    PAM
    PHS

    Data Schema

    Field added

    table_friendly_name

     

    Add Fabric USA
    Add Fabric CAN
    SEA
    Parcel Boundaries
    Property Graph

    Data Schema

    Field added

    field_friendly_name

     

    All Products

    Data Schema

    Field added

    index

     

    All Products

    Data Schema

    Field added

    primary_key

     

    Parcel Boundaries

    Data Schema

    Field added

    field_value_key_reference

     

    All Products

    Data Schema

    Field added

    type_code

     

    All Products

    Data Schema

    Field added

    table_name

     

    Add Fabric USA
    Add Fabric CAN
    SEA
    Parcel Boundaries
    Property Graph

    Data Schema

    Field added

    grouping

     

    Add Fabric USA
    Add Fabric CAN
    SEA
    PAM
    PHS
    Property Graph

    Data Schema

    Field name change

    sequence_number

    Seq.

    All Products

    Data Schema

    Field name change

    product_table_name

    Table Name

    Parcel Boundaries
    Property Graph

    Data Schema

    Field name change

    table_friendly_name

    Table Friendly Name

    All Products

    Data Schema

    Field name change

    field_name

    Field Name

    All Products

    Data Schema

    Field name change

    data_type

    Data Type (Length)

    All Products

    Data Schema

    Field name change

    field_length

    Data Type (Length)

    Add Fabric USA
    Add Fabric CAN
    SEA
    PAM
    PHS
    Property Graph

    Data Schema

    Field name change

    field_value_key_reference

    Field Value Key Reference

    All Products

    Data Schema

    Field name change

    description

    Description

    PAM
    PHS

    Data Schema

    Field name change

    field_friendly_name

    Long Name

    PAM
    PHS

    Data Schema

    Field name change

    grouping

    Information Type

    SEA
    Property Graph

    Field Value Key

    Field removed

     

    Table Friendly Name

    PAM

    Field Value Key

    Field removed

     

    Information Type

    PHS

    Field Value Key

    Field removed

     

    Data Type

    PHS

    Field Value Key

    Field removed

     

    Long Name

    Add Fabric USA
    Add Fabric CAN
    SEA
    PAM
    PHS
    Property Graph

    Field Value Key

    Field name change

    table_name

    Table Name

    Add Fabric USA
    Add Fabric CAN
    SEA
    PAM
    PHS
    Property Graph

    Field Value Key

    Field name change

    field_name

    Field Name

    Add Fabric USA
    Add Fabric CAN
    SEA
    PAM
    PHS
    Property Graph

    Field Value Key

    Field name change

    value

    Value

    Add Fabric USA
    Add Fabric CAN
    SEA
    PAM
    PHS
    Property Graph

    Field Value Key

    Field name change

    description

    Description



    We appreciate your partnership and use of Precisely products!

    Availability

    October 31, 2024

    Contact Information

    If you would like technical assistance, please contact the Precisely Global Support team at https://support.precisely.com/

    Any questions relating to this announcement can be directed to:

    Amy Metz

    Product Management Director

    amy.metz@precisely.com  

    www.precisely.com

    Copyright © 2016, 2024 Precisely. All rights reserved.