Procedure - property_attributes_assessment - Latest

Property Attributes Assessment Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Properties > Property Features
Product
Property Attributes Assessment
Version
Latest
ft:locale
en-US
Product name
Property Attributes Assessment
ft:title
Property Attributes Assessment Getting Started Guide
Copyright
2025
First publish date
2020
ft:lastEdition
2025-10-31
ft:lastPublication
2025-10-31T06:20:47.591000
Note: It is critical that you apply every monthly change file in the correct sequence and without skipping any delivery. Missing even a single month's changes may cause your master dataset to become inconsistent or invalid. We also recommend performing a full data delivery at least once a year to reset the baseline and ensure consistency across all applied changes.

To apply the change file correctly, you must:

  • Retain your last month’s full dataset.
  • Have the change-only file for the current month.
  • Use the PAID field as the primary key.
  • Use the CHANGE_TYPE field in the change file:
    • A = Add (New record)
    • D = Delete (Remove record)
    • U = Update (Modify existing record)

Procedure:

  1. Delete Records:
    Identify all the records in the change file with change_type = 'D'. These represent records that should no longer exist in the dataset. Use the PAID to match and delete these from your master table.
    DELETE FROM master_data
WHERE paid IN (
    SELECT paid FROM change_data WHERE change_type = 'D'
);
  2. Insert New Records:
    Fetch records from the change file where change_type is 'A'. These entries are new and should be added to your current dataset.
    INSERT INTO master_data (paid, col1, col2, col3, ...)
SELECT paid, col1, col2, col3, ...
FROM change_data
WHERE change_type = 'A';
  3. Update Existing Records:
    For records where change_type is 'U', update the corresponding attributes in the master dataset with values from the change file, using PAID as the matching key.
    UPDATE master_data AS m
SET col1 = c.col1,
    col2 = c.col2,
    col3 = c.col3,
    ...
FROM change_data AS c WHERE m.paid = c.paid AND c.change_type = 'U';

Workflow diagram: