| Script Version | From Maven Version | Description |
|---|
| 4.0.68 | 21.1.15 | Removed unique constraint from IsMainImage column in SaleAttachment table. |
| 4.0.67 | | - Removed 2000 character limit from EnvironmentalConcernsDefault, AppraiserCommentsDefault columns in AppraisalFieldSet table.
- Removed 2000 character limit from EnvironmentalConcerns, AppraiserComments columns in Appraisal table.
|
| 4.0.66 | | ChangedRequiredValue column in ClickFormsRuleSetFieldItem table from int to varchar. |
| 4.0.65 | | Added OtherContributionTypeFR column to OtherContributionType table. |
| 4.0.64 | | - Added UserForSale, UseForSubject columns to <
- Added ClickFormsCheckClass table.
- Added ClickFormsFieldReferenceClass table.
- Added ClickFormsRuleSet table.
- Added RatingType table.
- Added SecondaryAttributeValue table.
- Added ClickFormsRuleSetCheck table.
- Added ClickFormsRuleSetFieldItem table.
- Added SaleRating table.
|
| 4.0.63 | | - Added ValuationModelReportTempate table.
- Added ReportTemplate column to AppraisalAVM table.
- Removed AppraiserTemplate and EvaluatorTemplate columns from ValuationModel table.
|
| 4.0.62 | | - UpdatedFileContents column in SaleAttachment table from text to varchar(max).
- Added unique index to OtherContributionTypeName column in OtherContributionType table.
|
| 4.0.61 | | Added DefaultValue, StartNewLine, and Width columns to CustomFieldSetFieldType table. |
| 4.0.60 | | Added ModelEvaluationResult table. |
| 4.0.59 | 20.08.05 | - Added AppraisalFilesRevision table.
- Added RevisionNumber column to AppraisalBase table.
|
|
|
| 4.0.58 | | - Updated length of Township, Section, and Range fields in the Appraisal table from 10 to 50 characters.
- Added LandValueDefault table.
|
| 4.0.57 | | Added IsDwelling column to SaleImprovement table. |
| 4.0.56 | | Added Subject Index Padding to SystemConfiguration table. |
| 4.0.55 | | Added Subject Index configuration to SystemConfiguration table. |
| 4.0.54 | | Added LandAdjustmentMethod to ValuationModel table. |
| 4.0.53 | | Added “Requires Revaluation” as an AppraisalStatusClass. |
| 4.0.52 | | Added WipEntity table. |
| 4.0.51 | | Made User SID nullable to handle Azure AD accounts added in 40050. |
| 4.0.50 | | Added support for Azure AD accounts to the InternalUser table |
| 4.0.49 | 19.09.26 | Add field MaxComparisonAgeMonths to ValuationModel |
| 4.0.48 | | - Add CanEnterOtherContributions to UserProfile
- Add OtherContributionType table
- Add OtherContributionX fields to the Appraisal table
|
| 4.0.47 | | Add new table RatingMatrix, RatingMatrixItem, and RatingMatrixScore |
| 4.0.46 | | Add new weight fields to SaleMatchRule (AddressWeight, CityWeight, TaxIdRecordingWeight, TotalThresholdEx) |
| 4.0.45 | | Add OriginalAllocatedDollarPerAcre and OverrideReason to table AppraisalLand |
| 4.0.44 | | - Add UseRatioValues to ValuationModel
- Add new table AppraisalLandSalesComparison
|
| 4.0.43 | | - Create New Maven Security Roles for the API:
- UAAR_MavenApi
- UAAR_MavenApiWrite
|
| 4.0.42 | | - Add AttributeTypeId to ValueationModelSubjectCriteria and ValueationModelSubjectCriteria tables
- Rename SalesComparisonModelComparisonValue to ScaModelComparisonValue (two different migrations, same version number)
|
| 4.0.41 | | Add ER Foreign Key constraints |
| 4.0.40 | 19.06.12 | Add New ER Land Type and ER Factor fields |
| 4.0.39 | | Add support for a Valuation Request |
| 4.0.38 | 19.0 4.10 | - Add French fields to response tables
- Update stored procedures to support posting sales containing French values
|
| 4.0.37 | | Add fields to support overriding Improvement values in Maven |
| 4.0.36 | | Add “Plat” as an Attachment Type |
| 4.0.35 | | Add FinalValueRounding |
| 4.0.34 | | Added Sale Criteria independent from Subject Criteria |
| 4.0.33 | 19.01.16 | Add new setup tables for Improvement Attributes |
| 4.0.31 | | Add new SCA Model feature to “Auto Select Sales” |
| 4.0.30 | 18.12.17 | - Mapped NonRealtyAllocation into the appraisal tables when posting.
- Mapped Fee from Appraisal Tracking Form to the Appraiser Table.
|
| 4.0.4 – 4.0.29 | | Maven Development |
| 4.0.3 | | Fix AppraisalContextJoin rows that prevented improvement data from being properly posted. |
| 4.0.1 – 4.0.2 | | First Maven scripts. Adds new database roles, tables, and views. |
| 3.3.3 | | Changed how Appraisals are uploaded to increase performance. |
| 3.3.2 | | Change how attachments are downloaded to increase performance |
| 3.3.1 | | Update PostRecord stored procedure to work better with FireDac |
| 3.2.28 | | Fix bug that caused the sizes of un-downloaded attachments to be incorrect. |
| 3.2.27 | | Add a stored procedure for adding attachments to existing sales |
| 3.2.26 | | Fix bugs affecting posting appraisals when fields were too long |
| 3.2.25 | | Add support for “Analyse Income” report. |
| 3.2.24 | | Fix bug in GetSaleXML |
| 3.2.23 | | Add additional field to the Appraisal tables. |
| 3.2.22 | | Added new tables for Saved Comments that will be pushed out to ClickForms. |
| 3.2.21 | | Added anew KMLPresent field for use in the Sales Grid. |
| 3.2.20 | | Changed Datatype used for KML field in FlatSale |
| 3.2.19 | | Added a new KML field to the SaleMap table for storing property boundaries. |
| 3.2.18 | | - This script is not required for a DataLog client update.
- Removes (if present) duplicate MapPoints for sales that can cause a sale to appear twice in search results.
- Adds an unique table constraint to prevent future duplicate MapPoints for a single sale.
|
| 3.2.17 | | - This script is not required for a DataLog client update.
- Speeds up the loading of list choices on the Enterprise search screens by removing unneeded table joins from the access views in the database.
|
| 3.2.16 | | - This script is not required for a DataLog client update.
- Fixes a bug in the mapping of ClickFORMS Appraisal data. Township data was being put into the Highest and Best Improved field and zip code data was placed in the section field.
|
| 3.2.15 | | Updates the Post procedure to correctly handle unicode strings from DataLog |
| 3.2.14 | | - Changes for the Permanent Planting Tables
- Add Columns YearPlanted, PlantingAcres, RcnAcres, DepreciationDollarTotal, DepreciationDollarPerYear, DepreciationPhysicalPercentTotal, DepreciationPhysicalPercentPerYear, and DepreciationOtherPercentTotal to the SalePermP table
- Add New Column IncomePrice to the SaleIncomeTotals Table
|
| 3.2.13 | | Alter view FlatSale to include the SaleMap.SalePoint geography column as SalePoint |
| 3.2.12 | | Add the Post date of the sale to the data returned by an enterprise search. The user can add this data to the grid using the “File Modify Data” column. |
| 3.2.11 | | - Add the Long/Lat fields to table FieldReferenceClassEx
- Update table FieldReferenceClassEx setting the DataSize to 2 for the State attribute of the GrantorDetails and GranteeDetails nodes
- Update the Response Fingerprint row in table SystemConfiguration because of the changes to table FieldReferenceClassEx
|
| 3.2.10 | | - Create the FTSearchCatalog fulltext catalog
- Create a fulltext index on the CommentText column in the SaleComment table
- Create function GetFTSearchSaleIds
|
| 3.2.9 | | - Add Timber to table LandQualityClass
- Update the Response Fingerprint row in table SystemConfiguration because of the changes to table LandQualityClass
|
| 3.2.8 | | - Add the missing SaleIncomeTotals fields to table FieldReferenceClassEx
- Update table FieldReferenceClassEx setting the NodeName to SaleIncomeTotals for the SourceIsActual field
- Add Timber to table LandUseClass
- Add YieldRate column to SaleIncomeTotals tables and update stored procedures
- Update the Response Fingerprint row
|
| 3.2.7 | | - Alter procedure WriteRecord to rollback the transaction if an error occurs
- Alter procedure PostRecord to remove unnecessary rollback
- Alter view FlatSale to include the SaleLandTotals.TotalDeededDollarPerAcre field
|
| 3.2.6 | | - Make the PersonAddress.StateId column nullable
- Alter view FlatSale to include Mail Merge fields
|
| 3.2.5a | | - Create the new Permanent Planting tables (SalePermP) Existing Improvement Data is converted.
- Alter view FlatSale to include the SalePermPTotals table
- Delete existing Improvement based Permanent Planting tables and fields
- Grant execute permission for stored procedure WriteAppraisalFiles to the UAAR_User role
- Change the Depreciation Percentage columns data type from int to money in SaleImprovement
- Create the new Financing Details tables
- Create the new PersonAddress tables
- Create the SaleMap table
- Update table FieldReferenceClassEx setting the DataVersion to 4 for all new SalePermP, FinancingDetails, and PersonAddress fields
- Update the Response Fingerprint row
|
| 3.2.4 | | - Drop all the response X tables trigger to update the Response Fingerprint row in table SystemConfiguration
- Create procedure UpdateResponseFingerprint
|
| 3.2.3 | | - Add table SecondaryPropertyType
- Add table SecondaryLandUse
- Add View SaleAllPropertyTypesView
- Add View SaleAllLandUsesView
|
| 3.2.2 | | - Revoke execute on DeleteSale to UAAR_User
- Add the Post Appraisal CLK Files row to table SystemConfiguration
- Rename table AppraisalPDF to AppraisalFiles
- Add new CLK columns to table AppraisalFiles
- Drop procedure WriteAppraisalXMLHolder
- Create procedure WriteAppraisalFilesHolder
- Create procedure WriteAppraisalXML
- Alter procedure PostAppraisal
- Alter procedure WriteAppraisalFiles
- Alter procedure DeleteAppraisal
|
| 3.2.1 | | - Add column UnitTypeName to table RangeImprovement
- Add table SaleAllocation
- Create the new Permanent Planting Type tables
- Add table ImprovementPermP
- Add table PermPSubVariety
- Add the Permanent Planting row to the ImprovementKindClass table
- Set the PrintOrder to -1 for rows with a ChildNodeName in the FieldReferenceClassEx table
- Add Permanent Planting fields to table FieldReferenceClassEx
- Alter procedure GetSaleXML for the new Permanent Planting tables
- Add View ImprovementPermPAllVarietiesAccessView
|
| 3.2.0 | | - Create procedure FindRangeEntryKeys
- Add Improvement TotalLife fields to table FieldReferenceClassEx
- Update the Response Fingerprint row
|
