New Features in 21.3 Major Release

To help improve users’ ETL (extract, transform, load) process, the Loan Checksum table is now available to users. This reference table lists the loan data tables and indicates when loans were last updated. Users can now refer to this table and identify only recently updated loans rather than scanning the entire loan data table. This reduces the time it takes to complete the ETL process. Previously, users needed to scan every loan data table for the applicable loan change date. Since there is a large number of loan data tables, the process was slower and impacted overall Data Connect performance.

DPL-11422

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.3 will start at 10:00 PM on the day you receive and upgrade to Encompass 21.3. 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.3.

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.3 Major Release.

Loan Schema Field Mapping Files

The 21.3 schema is available to download from the following knowledge articles in the Resource Center:

Microsoft (MS) SQL

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

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

Postgres

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

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

Field Updates Comparison Files

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

MS SQL

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

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

Postgres

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

  • 21.3 Data Model (Postgres) with no-PII (KA # 39950) - 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.3.

 

  Previous Section: Introduction