Skip to main content
Eptura Knowledge Center

Database Schema Revision History V2026.01

  1. Last updated
  2. Save as PDF

v2026.01.002

The /webapp/projects/users/public/dt/v2026.01.002/sample-data/update-sample-data.duw makes these updates:

  • AD-17613 : restore the % security group to AI to support integration testing

The /webapp/projects/users/public/dt/v2026.01.002/schema/system/update-schema.duw makes these updates:

  • AD-23573: Add document attributes to former graphics fields
  • AD-23728 : add activity parameters to support Autodesk Design Automation
  • AD-23655: Recreate uuid triggers for rm and rm_trial lost during v2026.01 AFM_TEMP rebuild

And localization updates.

v2026.01.001

The /webapp/projects/users/public/dt/v2026.01.001/sample-data/update-sample-data.duw makes these updates:

  • AD-23228 : add AFMLEASETEST user
  • AD-22970 : Remove wildcard security group from all roles except ACTIVITY LICENSEE and SYSTEM ADMINISTRATOR (ACP) (restored to 4 - PROCESS OWNER in v2026.01.002 scripts)

The /webapp/projects/users/public/dt/v2026.01.001/schema-template/system/update-schema-template.duw makes these updates:

  • AD-22970 : Assign NOCLIENT group to SYSTEM ADMINISTRATOR (ACP)

The /webapp/projects/users/public/dt/v2026.01.001/schema/bldgops/update-schema.duw makes these updates:

  • AD-21989 : Update existing tables to support filters for lookup type questions.
  • AD-22039 : Update existing tables to save craftperson assignment who submitted checklist.
  • AD-21873 : Update existing tables to support answers of multiple responses from lookup type questions.
  • AD-22742 : Assign task to AbCloudBuildingOperations activity.
  • AD-23032 : Add Archived Work Requests and Resources task to AbCloudBuildingOperations activity.
  • AD-22661 : Register WR AI Summary handler as a workflow rule

The /webapp/projects/users/public/dt/v2026.01.001/schema/onsite/update-schema.duw makes these uupdates:

  • AD-22481 : OnSite configurations - offline support settings for surveys (Surveys general sync priority for Assessment module)

The /webapp/projects/users/public/dt/v2026.01.001/schema/project/update-schema.duw makes these updates:

  • AD-19493, AD-22498 : Remove limit for cost fields

The /webapp/projects/users/public/dt/v2026.01.001/schema/space/ad_22062_afm_ptasks.duw makes these uupdates:

  • AD-22062 : Update Allocations and Benchmarks task_file to org switcher
  • AD-22062 : Update Department reports task_id and task_file by inserting new ptasks, updating foreign keys, then deleting old ptasks

The /webapp/projects/users/public/dt/v2026.01.001/schema/space/ad_23338_afm_ptasks.duw makes these updates:

  • AD-23338 : Add Define Org Unit views to Cloud Space
  • AD-23338 : Update View Detailed Chargeback task_file to org switcher
  • AD-23338 : Update Define Organizations task_id to Define Divisions and Departments by inserting new ptasks, updating foreign keys, then deleting old ptasks
  • AD-23338 : Update Employee Location Departmental Analysis task_id to Employee Organizational Analysis by Location and task_file to org switcher by inserting new ptasks, updating foreign keys, then deleting old ptasks

The /webapp/projects/users/public/dt/v2026.01.001/schema/space/update-schema.duw makes these updates:

  • AD-22691 : Add org_id to em, gp tables.
  • AD-22833 : Add new fields for updateAreaTotals for org
  • AD-23157 : BOMA 2024 - Add Non-Allocated Tenant Area room categories and types

The /webapp/projects/users/public/dt/v2026.01.001/schema/system/update-schema.duw makes these updates:

  • AD-15122 : Remove "Echo" Web Service View
  • AD-22578 : Add new Security Group
  • AD-22578 : Add UUID columns for the table where there is no UUID column
  • AD-23387 : Add UUID column entry for hrmpct, the history/archive table of rmpct
  • AD-22650 : Fix typo in afm_tasks task_ids and axvw strings in Dutch
  • AD-18485 : Create hafm_data_event_log history table and archive workflow rule
  • AD-22811 : change run time for scheduled WFR
  • AD-23125 : add SchemaService WFR
  • AD-22960 : ptask and fields for Org Migration Wizard
  • AD-22062 : activity parameters for dp-org switcher
  • AD-19965 : Extending column length from 6 to 30 to accommodate Unicode encoded value of symbols
  • AD-22959 : Added new WFR for organizational units migration
  • AD-23385 : Add import for afm_groups - used for schema db
  • AD-22661 : Add activity parameter to enable WR AI Summarization feature
  • AD-22757 : Fix uuid column type from int to uniqueidentifier for rmcat and rmtype
  • AD-13171 : added .csv file to update enum-list using update-schema.duw
  • AD-22604 : Replaced deprecated language code iw_IL with modern he_IL for hebrew locale
  • AD-23006 : Add uuids to additional fields to support OnSite
  • AD-22767 : Change compatibility level in MSSQL
  • AD-23082 : update mssql compatibility level to new minimum version
  • AD-23228 : Add source-system tracking fields on ls for the Lease REST API
  • AD-22604 : update existing users locale from iw_IL to he_IL
  • AD-22980 : move afm_password_token to afm_secure schema
  • AD-22970 : Add NOCLIENT security group
  • AD-22663 : Remove Graphic (2060) from afm_type enum_list and migrate existing fields to Document (2165)
  • AD-23005 : Update activity parameter descriptions to use Autodesk Forma brand name
  • AD-22942 : Add UserPreferences workflow rule
  • AD-23428 : recreate UUID triggers to remove PUTLINE

The /webapp/projects/users/public/dt/v2026.01.001/schema/technologies/update-schema.duw makes these updates:

  • AD-20906 : Updated existing tables to set satisfaction column to not nullable.

The /webapp/projects/users/public/dt/v2026.01.001/schema/workplace/update-schema.duw makes these updates:

  • AD-22691 : update AbSpaceHotelling-MaxDaysAhead description
  • AD-22342 : update AbWorkplaceReservations-RemovePrivateMeetingInfo description
  • AD-22833 : new fields for team booking and neighborhood allocation
  • AD-22833 : update default value for target seat ratio
  • AD-22933 : new field for Workplace My Profile Privacy Settings