2024 - July Release

Hello!

Data Direct July 2024 release is now live. Below is the list of changes.

Features and Improvements

• A bunch of new tables added:
  • AssetRefrigerantLeakNotes: Captures the notes associated with the asset refrigerant leak records.
  • AssetRefrigerantLeakImmeasurableNotes: Captures the notes associated with the asset refrigerant leak immeasurable records.
  • workorder_reassignment_reasons: Captures the reassignment reasons associated with the workorders.
  • workorder_notes_new: A new table for workorder notes.
    • The new table (workorder_notes_new) has the id field as bigint to support higher values as we are approaching the current Id limit (2147483647) in the workorder_notes table.
    • We also added a CreatedByUserId field to the new table to capture the id of the User who created the Note record. The CreatedByUserId field will be populated going forward only, and will be left null for historical records.
    • The existing records from the workorder_notes table has been migrated to the workorder_notes_new table. Please use the workorder_notes_new table going forward.

The above changes will also be updated in the latest ERD diagram and on our Data Direct page.

Should you have questions, please contact SC Customer Support team or your respective CSM.