SoftPro Select 4.0.0 (4.0.30302.9) - 3/9/2015 - Part 9 of 9
The Closing Disclosure Form (CDF) requirements have affected the database structure.
DATABASE STRUCTURE
The CDF data structure mimics the HUD data structure:
|
HUD Table |
CDF Equivalent |
|
pfm.HUD |
pfm.CDF |
|
pfm.HUDLine |
pfm.CDFLine |
|
pfm.HUDCharge |
pfm.CDFCharge |
|
pfm.HUDPayee |
pfm.CDFPayee |
|
pfm.HUDPayor |
pfm.CDFPayor |
|
pfm.HUD1Disbursement |
pfm.CDFDisbursement |
|
pfm.HUD1Receipt |
pfm.CDFReceipt |
|
pfm.HUDOption |
pfm.CDFOptions |
Database Schema - HUD Data
There are no changes. Everything remains the same with v4.0.
· Data is stored exactly where it was in v3.0.
· No changes are required to custom HUDs.
Database Schema - CDF Data
· New tables have been created for all objects used on CDF pg 2 and 3.
· Most CDF Pg 1, 4, and 5 data is in existing Loan and Contact tables.
pfm.CDFLine table fields
· SectionNumber stores the section letter and line number. Example: A.01
· Number stores the line number as an integer. Example: 1
· SectionType joins to zref.CDFSectionType for letter or description.
All 5 amount columns from page 2 are stored here: BuyerPaidAtClosing, BuyerPaidBeforeClosing, SellerPaidAtClosing, SellerPaidBeforeClosing, and PaidByOthers.
· Amount (sum of all amount columns)
Custom Settlement Statements & HUDs
· Existing settlement statements will not work for CDF orders.
· Existing HUDs will work for HUD orders.
· CDF customizations are very limited by the Final Rule.
· Having a custom HUD doesn’t necessarily mean you need a custom CDF.
· Standard settlement statements are available in the application.
Database Schema - Revenue
· A new CDF reference has been added in pt.RevenueDetail.
· Other columns are written as they have been in HUD orders.
· If revenue reports do not reference HUDLine column, they should not require changes. Example:
Database Schema - Premiums
New fields have been added to the Title Insurance Premiums screen:
Policy Register/Remittance Reports
· Underwriters want the real final premiums, not the alternate version disclosed on the CDF
· Those existing final premium fields are unchanged for CDF orders
· Therefore, no changes are needed for these reports
· The only change to the system requirements for v4.0 is to the minimum recommended screen resolution for the client, which has changed from 1024x768 to 1366x768.
· Note: Support for SQL Server 2005 and Windows XP will be dropped in the next major release (v4.1). Both will continue to be supported for all versions of v4.0.