During the upgrade from version 10.31.15, many Framework tables and fields were consolidated in order to enhance usability.
Previously in version 10.31.15, every account in the Framework had a tblAccountCollateral record, regardless of whether collateral information was populated. Now, in version 14.00.00, only the data from collateral records that were populated for the account in context is moved. For example, if collateral information is populated within tblAccountCollateral in version 10.31.15, all fields within the tblAccountCollateral table are moved to a new Collections.Collateral record for that account in version 14.00.00.
However, if multiple collateral fields are populated within tblAccountCollateral, tblAccountMortgage, and tblAccountSecured, only one set of data is retained during the upgrade. The data from tblAccountSecured overwrites the data within tblAccountMortgage, and the data from tblAccountMortgage overwrites the data within tblAccountCollateral, resulting in data loss in tblAccountCollateral and tblAccountMortgage.
Refer to the following matrix to determine how data is overwritten during the upgrade:
| Collections.Collateral | tblAccountCollateral | tblAccountAuto | tblAccountMortgage | tblAccountSecured |
| AddressLine1 | CollateralAddress | NULL | NULL | |
| AddressLine2 | CollateralAddress2 | NULL | NULL | |
| AddressLine3 | CollateralAddress3 | NULL | NULL | |
| City | CollateralCity | PropertyCity | PropertyCity | |
| CollateralValue | CollateralValue | Value | ||
| County | County | County | ||
| InsuranceCompany | InsuranceCompany | InsuranceCompany | ||
| OriginalAppraisalDate | OriginalAppraisalDate | OriginalAppraisalDate | ||
| PostalCode | CollateralPostal | PropertyPostal | PropertyPostal | |
| PropertyAddress | PropertyAddress | PropertyAddress | ||
| PurposeCode | PurposeCode | PurposeCode | ||
| State | CollateralState | State | PropertyState | PropertyState |
| Logic | Make, Year, Model or VIN is populated | PropertyAddress, PropertyCity, PropertyPostal or PropertyState is populated | PropertyAddress, PropertyCity, PropertyPostal or PropertyState is populated |
The following columns were consolidated during the upgrade between version 10.31.15 and 14.00.00:
 |
If data exists in one or more columns that are consolidated during the upgrade, only one set of data is retained. All other data is lost. |
| Old Column Name | New Column Name |
| tblCoborrower.CB1Relationship | Collections.AccountRelationship.RelationshipToPrimary |
| tblCoborrower.CB2Relationship | |
| tblCoborrower.CB3Relationship | |
| tblCoborrower.CB4Relationship | |
| tblAccountCollateral.AppraisalAmount | Collections.Collateral.AppraisValue |
| tblAccountMortgage.AppraisValue | |
| tblAccountCollateral.CollateralCity | Collections.Collateral.City |
| tblAccountMortgage.PropertyCity | |
| tblAccountSecured.PropertyCity | |
| tblAccountAuto.Value | Collections.Collateral.CollateralValue |
| tblAccountCollateral.CollateralValue | |
| tblAccountMortgage.County | Collections.Collateral.County |
| tblAccountSecured.County | |
| tblAccountAuto.InsuranceCompany | Collections.Collateral.InsuranceCompany |
| tblAccountMortgage.InsuranceCompany | |
| tblAccountCollateral.AppraisalDate | Collections.Collateral.OriginalAppraisalDate |
| tblAccountMortgage.AppraisalDate | |
| tblAccountCollateral.CollateralPostal | Collections.Collateral.PostalCode |
| tblAccountMortgage.PropertyPostal | |
| tblAccountSecured.PropertyPostal | |
| tblAccountMortgage.PropertyAddress | Collections.Collateral.PropertyAddress |
| tblAccountSecured.PropertyAddress | |
| tblAccountAuto.PurposeCode | Collections.Collateral.PurposeCode |
| tblAccountCollateral.PurposeCode | |
| tblAccountAuto.State | Collections.Collateral.State |
| tblAccountCollateral.CollateralState | |
| tblAccountMortgage.PropertyState | |
| tblAccountSecured.PropertyState | |
| tblBorrowerAddress.ADD1Address1 | Core.Address.Address1 |
| tblBorrowerAddress.ADD2Address1 | |
| tblBorrowerAddress.ADD3Address1 | |
| tblCoborrowerAddress.CB1ADD1Address1 | |
| tblCoborrowerAddress.CB1ADD2Address1 | |
| tblCoborrowerAddress.CB1ADD3Address1 | |
| tblCoborrowerAddress.CB2ADD1Address1 | |
| tblCoborrowerAddress.CB2ADD2Address1 | |
| tblCoborrowerAddress.CB2ADD3Address1 | |
| tblCoborrowerAddress.CB3ADD1Address1 | |
| tblCoborrowerAddress.CB3ADD2Address1 | |
| tblCoborrowerAddress.CB3ADD3Address1 | |
| tblCoborrowerAddress.CB4ADD1Address1 | |
| tblCoborrowerAddress.CB4ADD2Address1 | |
| tblCoborrowerAddress.CB4ADD3Address1 | |
| tblBorrowerAddress.ADD1Address2 | Core.Address.Address2 |
| tblBorrowerAddress.ADD2Address2 | |
| tblBorrowerAddress.ADD3Address2 | |
| tblCoborrowerAddress.CB1ADD1Address2 | |
| tblCoborrowerAddress.CB1ADD2Address2 | |
| tblCoborrowerAddress.CB1ADD3Address2 | |
| tblCoborrowerAddress.CB2ADD1Address2 | |
| tblCoborrowerAddress.CB2ADD2Address2 | |
| tblCoborrowerAddress.CB2ADD3Address2 | |
| tblCoborrowerAddress.CB3ADD1Address2 | |
| tblCoborrowerAddress.CB3ADD2Address2 | |
| tblCoborrowerAddress.CB3ADD3Address2 | |
| tblCoborrowerAddress.CB4ADD1Address2 | |
| tblCoborrowerAddress.CB4ADD2Address2 | |
| tblCoborrowerAddress.CB4ADD3Address2 | |
| tblBorrowerAddress.ADD1Address3 | Core.Address.Address3 |
| tblBorrowerAddress.ADD2Address3 | |
| tblBorrowerAddress.ADD3Address3 | |
| tblCoborrowerAddress.CB1ADD1Address3 | |
| tblCoborrowerAddress.CB1ADD2Address3 | |
| tblCoborrowerAddress.CB1ADD3Address3 | |
| tblCoborrowerAddress.CB2ADD1Address3 | |
| tblCoborrowerAddress.CB2ADD2Address3 | |
| tblCoborrowerAddress.CB2ADD3Address3 | |
| tblCoborrowerAddress.CB3ADD1Address3 | |
| tblCoborrowerAddress.CB3ADD2Address3 | |
| tblCoborrowerAddress.CB3ADD3Address3 | |
| tblCoborrowerAddress.CB4ADD1Address3 | |
| tblCoborrowerAddress.CB4ADD2Address3 | |
| tblCoborrowerAddress.CB4ADD3Address3 | |
| tblBorrowerAddress.ADD1City | Core.Address.City |
| tblBorrowerAddress.ADD2City | |
| tblBorrowerAddress.ADD3City | |
| tblCoborrowerAddress.CB1ADD1City | |
| tblCoborrowerAddress.CB1ADD2City | |
| tblCoborrowerAddress.CB1ADD3City | |
| tblCoborrowerAddress.CB2ADD1City | |
| tblCoborrowerAddress.CB2ADD2City | |
| tblCoborrowerAddress.CB2ADD3City | |
| tblCoborrowerAddress.CB3ADD1City | |
| tblCoborrowerAddress.CB3ADD2City | |
| tblCoborrowerAddress.CB3ADD3City | |
| tblCoborrowerAddress.CB4ADD1City | |
| tblCoborrowerAddress.CB4ADD2City | |
| tblCoborrowerAddress.CB4ADD3City | |
| tblBorrowerAddress.ADD1Country | Core.Address.Country |
| tblBorrowerAddress.ADD2Country | |
| tblBorrowerAddress.ADD3Country | |
| tblCoborrowerAddress.CB1ADD1Country | |
| tblCoborrowerAddress.CB1ADD2Country | |
| tblCoborrowerAddress.CB1ADD3Country | |
| tblCoborrowerAddress.CB2ADD1Country | |
| tblCoborrowerAddress.CB2ADD2Country | |
| tblCoborrowerAddress.CB2ADD3Country | |
| tblCoborrowerAddress.CB3ADD1Country | |
| tblCoborrowerAddress.CB3ADD2Country | |
| tblCoborrowerAddress.CB3ADD3Country | |
| tblCoborrowerAddress.CB4ADD1Country | |
| tblCoborrowerAddress.CB4ADD2Country | |
| tblCoborrowerAddress.CB4ADD3Country | |
| tblBorrowerAddress.ADD1Postal | Core.Address.PostalCode |
| tblBorrowerAddress.ADD2Postal | |
| tblBorrowerAddress.ADD3Postal | |
| tblCoborrowerAddress.CB1ADD1Postal | |
| tblCoborrowerAddress.CB1ADD2Postal | |
| tblCoborrowerAddress.CB1ADD3Postal | |
| tblCoborrowerAddress.CB2ADD1Postal | |
| tblCoborrowerAddress.CB2ADD2Postal | |
| tblCoborrowerAddress.CB2ADD3Postal | |
| tblCoborrowerAddress.CB3ADD1Postal | |
| tblCoborrowerAddress.CB3ADD2Postal | |
| tblCoborrowerAddress.CB3ADD3Postal | |
| tblCoborrowerAddress.CB4ADD1Postal | |
| tblCoborrowerAddress.CB4ADD2Postal | |
| tblCoborrowerAddress.CB4ADD3Postal | |
| tblBorrowerAddress.ADD1State | Core.Address.State |
| tblBorrowerAddress.ADD2State | |
| tblBorrowerAddress.ADD3State | |
| tblCoborrowerAddress.CB1ADD1State | |
| tblCoborrowerAddress.CB1ADD2State | |
| tblCoborrowerAddress.CB1ADD3State | |
| tblCoborrowerAddress.CB2ADD1State | |
| tblCoborrowerAddress.CB2ADD2State | |
| tblCoborrowerAddress.CB2ADD3State | |
| tblCoborrowerAddress.CB3ADD1State | |
| tblCoborrowerAddress.CB3ADD2State | |
| tblCoborrowerAddress.CB3ADD3State | |
| tblCoborrowerAddress.CB4ADD1State | |
| tblCoborrowerAddress.CB4ADD2State | |
| tblCoborrowerAddress.CB4ADD3State | |
| tblBorrower.Email | Core.EmailAddress.EmailAddress |
| tblBorrowerEmail.EM1Email | |
| tblBorrowerEmail.EM2Email | |
| tblBorrowerEmail.EM3Email | |
| tblBorrowerEmail.EM4Email | |
| tblBorrowerEmail.EM5Email | |
| tblCoborrower.CB1Email | |
| tblCoborrower.CB2Email | |
| tblCoborrower.CB3Email | |
| tblCoborrower.CB4Email | |
| tblCoborrower.CB1AccountNumber | Core.Person.AccountNumber |
| tblCoborrower.CB2AccountNumber | |
| tblCoborrower.CB3AccountNumber | |
| tblCoborrower.CB4AccountNumber | |
| tblBorrower.BirthDate | Core.Person.BirthDate |
| tblCoborrower.CB1BirthDate | |
| tblCoborrower.CB2BirthDate | |
| tblCoborrower.CB3BirthDate | |
| tblCoborrower.CB4BirthDate | |
| tblCoborrower.CB1DeathDate | Core.Person.DeceasedDate |
| tblCoborrower.CB2DeathDate | |
| tblCoborrower.CB3DeathDate | |
| tblCoborrower.CB4DeathDate | |
| tblCoborrower.CB1Employer | Core.Person.Employer |
| tblCoborrower.CB2Employer | |
| tblCoborrower.CB3Employer | |
| tblCoborrower.CB4Employer | |
| tblBorrower.FirstName | Core.Person.FirstName |
| tblCoborrower.CB1FirstName | |
| tblCoborrower.CB2FirstName | |
| tblCoborrower.CB3FirstName | |
| tblCoborrower.CB4FirstName | |
| tblBorrower.FullName | Core.Person.FullName |
| tblCoborrower.CB1FullName | |
| tblCoborrower.CB2FullName | |
| tblCoborrower.CB3FullName | |
| tblCoborrower.CB4FullName | |
| tblBorrower.Gender | Core.Person.Gender |
| tblCoborrower.CB1Gender | |
| tblCoborrower.CB2Gender | |
| tblCoborrower.CB3Gender | |
| tblCoborrower.CB4Gender | |
| tblBorrower.LastName | Core.Person.LastName |
| tblCoborrower.CB1LastName | |
| tblCoborrower.CB2LastName | |
| tblCoborrower.CB3LastName | |
| tblCoborrower.CB4LastName | |
| tblBorrower.MiddleName | Core.Person.MiddleName |
| tblCoborrower.CB1MiddleName | |
| tblCoborrower.CB2MiddleName | |
| tblCoborrower.CB3MiddleName | |
| tblCoborrower.CB4MiddleName | |
| tblCoborrower.CB1MotherMaidenName | Core.Person.MotherMaidenName |
| tblCoborrower.CB2MotherMaidenName | |
| tblCoborrower.CB3MotherMaidenName | |
| tblCoborrower.CB4MotherMaidenName | |
| tblCoborrower.CB1ID | Core.Person.PersonNumber |
| tblCoborrower.CB2ID | |
| tblCoborrower.CB3ID | |
| tblCoborrower.CB4ID | |
| tblBorrower.Prefix | Core.Person.Prefix |
| tblCoborrower.CB1Prefix | |
| tblCoborrower.CB2Prefix | |
| tblCoborrower.CB3Prefix | |
| tblCoborrower.CB4Prefix | |
| tblBorrower.SecurityPassword | Core.Person.SecurityPassword |
| tblCoborrower.CB1SecurityPassword | |
| tblCoborrower.CB2SecurityPassword | |
| tblCoborrower.CB3SecurityPassword | |
| tblCoborrower.CB4SecurityPassword | |
| tblBorrower.SecurityQuestionAnswer | Core.Person.SecurityQuestionAnswer |
| tblCoborrower.CB1SecurityQuestionAnswer | |
| tblCoborrower.CB2SecurityQuestionAnswer | |
| tblCoborrower.CB3SecurityQuestionAnswer | |
| tblCoborrower.CB4SecurityQuestionAnswer | |
| tblBorrower.SecurityQuestionCode | Core.Person.SecurityQuestionCode |
| tblCoborrower.CB1SecurityQuestionCode | |
| tblCoborrower.CB2SecurityQuestionCode | |
| tblCoborrower.CB3SecurityQuestionCode | |
| tblCoborrower.CB4SecurityQuestionCode | |
| tblBorrower.Suffix | Core.Person.Suffix |
| tblCoborrower.CB1Suffix | |
| tblCoborrower.CB2Suffix | |
| tblCoborrower.CB3Suffix | |
| tblCoborrower.CB4Suffix | |
| tblBorrower.TaxIDCode | Core.Person.TaxIDCode |
| tblCoborrower.CB1TaxIDCode | |
| tblCoborrower.CB2TaxIDCode | |
| tblCoborrower.CB3TaxIDCode | |
| tblCoborrower.CB4TaxIDCode | |
| tblBorrower.SSN | Core.Person.TIN |
| tblCoborrower.CB1SSN | |
| tblCoborrower.CB2SSN | |
| tblCoborrower.CB3SSN | |
| tblCoborrower.CB4SSN | |
| tblBorrower.Title | Core.Person.Title |
| tblCoborrower.CB1Title | |
| tblCoborrower.CB2Title | |
| tblCoborrower.CB3Title | |
| tblCoborrower.CB4Title | |
| tblBorrowerPhone.WorkExtension | Core.Phone.Extension |
| tblCoborrowerPhone.CB1WorkExtension | |
| tblCoborrowerPhone.CB2WorkExtension | |
| tblCoborrowerPhone.CB3WorkExtension | |
| tblCoborrowerPhone.CB4WorkExtension | |
| tblBorrowerPhone.PH1Phone | Core.Phone.PhoneNumber |
| tblBorrowerPhone.PH2Phone | |
| tblBorrowerPhone.PH3Phone | |
| tblBorrowerPhone.PH4Phone | |
| tblBorrowerPhone.PH5Phone | |
| tblCoborrowerPhone.CB1PH1Phone | |
| tblCoborrowerPhone.CB1PH2Phone | |
| tblCoborrowerPhone.CB1PH3Phone | |
| tblCoborrowerPhone.CB1PH4Phone | |
| tblCoborrowerPhone.CB1PH5Phone | |
| tblCoborrowerPhone.CB2PH1Phone | |
| tblCoborrowerPhone.CB2PH2Phone | |
| tblCoborrowerPhone.CB2PH3Phone | |
| tblCoborrowerPhone.CB2PH4Phone | |
| tblCoborrowerPhone.CB2PH5Phone | |
| tblCoborrowerPhone.CB3PH1Phone | |
| tblCoborrowerPhone.CB3PH2Phone | |
| tblCoborrowerPhone.CB3PH3Phone | |
| tblCoborrowerPhone.CB3PH4Phone | |
| tblCoborrowerPhone.CB3PH5Phone | |
| tblCoborrowerPhone.CB4PH1Phone | |
| tblCoborrowerPhone.CB4PH2Phone | |
| tblCoborrowerPhone.CB4PH3Phone | |
| tblCoborrowerPhone.CB4PH4Phone | |
| tblCoborrowerPhone.CB4PH5Phone |