New Features in 21.2 Major Release

A new “soft delete” capability is now available in Encompass Data Connect Replication. Users can now identify loans that have been deleted and are stored in the Encompass ‘Trash’ folder, but have not been permanently deleted. These loans are known as “soft delete records”.

DPL-9235

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 21.2 will start at 10:00 PM on the day you receive and upgrade to Encompass 21.2. (Encompass 21.2 is currently scheduled to be available to all customers on June 12, 2021.) 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 21.2.

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

Loan Schema Field Mapping Files

The 21.2 schema is available to download from the following knowledge articles in the Ellie Mae Resource Center:

Microsoft (MS) SQL

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

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

Postgres

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

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

Field Updates Comparison Files

To compare the field updates in 21.1 with the field updates in 21.2, the DIFF file is available to download from the following knowledge articles in the Ellie Mae 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 21.2 are available to download from the following knowledge articles in the Ellie Mae Resource Center:

MS SQL

  • 21.2 Data Model (MS SQL) with PII (KA # 39548) - 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 21.2.

  • 21.2 Data Model (MS SQL) with no-PII (KA # 39549) - 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 21.2.

Postgres

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

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

 

  Previous Section: Introduction