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.