Encompass Data Connect - Updates to Features in 25.4 Release

Loan Schema Updates

To minimize any downtime and disruption experienced when upgrading the schema and data in your current production instance, the schema upgrade process for Encompass Data Connect is as follows:

  • The Encompass Data Connect schema upgrade process for 25.4 will start at 10:00 PM on the day you receive and upgrade to Encompass 25.4. (Encompass 25.4 is currently scheduled to be available to all customers on November 8, 2025.) This schema upgrade process will take approximately four (4) hours on this day.

All of these Data Connect Schema upgrades are scheduled based on when you receive Encompass 25.4. The PDL will be available to connect, but the connections will be slow while schema is updated to the 25.4 changes.

The Encompass Data Connect Schema has been updated to include the new fields added, regulatory updates, and changes to existing fields, in the Encompass 25.4 release.

Loan Schema Field Mapping Files

The 25.4 schema is available to download from the following knowledge articles in the Resource Center. The Loan Schema Field Mapping file's 25.4 New Fields tab contains the new fields and new tables that are added as part of Encompass 25.4.

Microsoft (MS) SQL

  • Loan Schema Field Mapping with PII (MS SQL) (KA # 000116211) - For PII (with encryption) MS SQL users, a file detailing the mapping of Encompass Data Connect 25.4 fields to the corresponding fields in the Encompass Loan Schema.

  • Loan Schema Field Mapping, No-PII (MS SQL) (KA # 000116212) -​ ​For no-PII (no encryption) MS SQL users, a file detailing the mapping of Encompass Data Connect 25.4 fields to the corresponding fields in the Encompass Loan Schema.

Postgres

  • Loan Schema Field Mapping with PII (Postgres) (KA # 000116213) - For PII (with encryption) and Postgres users, a file detailing the mapping of Encompass Data Connect 25.4 fields to the corresponding fields in the Encompass Loan Schema.

  • Loan Schema Field Mapping, No-PII (Postgres) (KA # 000116214) -​ ​For no-PII (no encryption) and Postgres users, a file detailing the mapping of Encompass Data Connect 25.4 fields to the corresponding fields in the Encompass Loan Schema.

Field Updates Comparison Files

To compare the field updates in 25.3 with the field updates in 25.4, the DIFF file is available to download from the following knowledge articles in the Resource Center:

Tip: SQL scripts assume that schema name is elliedb.

MS SQL

Postgres

Data Model Files

The SQL files used to help create tables for Encompass Data Connect 25.4  are available to download from the following knowledge articles in the Resource Center:

MS SQL

  • 25.4 Data Model (MS SQL) with PII (KA # 000116219) - For PII (with encryption) and MS SQL users, a file containing MS SQL files to be used to help create tables for Encompass Data Connect 25.4.

  • 25.4 Data Model (MS SQL) with no-PII (KA # 000116220) - For PII (with no encryption) and MS SQL users, a file containing MS SQL files to be used to help create tables for Encompass Data Connect 25.4.

Postgres

  • 25.4 Data Model (Postgres) with PII   (KA # 000116221) - For PII (with encryption) and Postgres users, a file containing SQL files to be used to help create tables for Encompass Data Connect 25.4.

  • 25.4 Data Model (Postgres) with no-PII (KA # 000116222) - For PII (with no encryption) and Postgres users, a file containing SQL files to be used to help create tables for Encompass Data Connect 25.4.

 

  Previous Section: Introduction