Release 6.1

[v6.1] Is Required: The IsRequired option appears on all Mass Appraisal Table forms. It is used for making it mandatory for the user to select a value for the current form. You can now add an expression and make the option mandatory only under certain circumstances. For example, you could make it a requirement for a user to select an adjustment if a property value is less than a specific amount. See Is Required
[v6.1] Lookup Group Types: You can now create Mass Appraisal validation tables and codes based on a combination of jurisdictions, neighborhoods, and property types. This means that you can create different rates and values for different property types within specific neighborhoods and jurisdictions. See Mass Appraisal Lookup Group Types.
The Mass Appraisal Neighborhood table can be set up By Jurisdiction. This setup is defined from an option, rather than a Lookup Group. See Mass Appraisal Neighborhood Table.
[v6.1] As with all tables and parameters that are saved by year, you can access the Mass Appraisal Validation tables for different years by changing the Current Year in GNA. See Setting the Current Year.
[v6.1] Apply predefined Number formats on calculated values.
[v6.1] You can change the Sequence Number of the following MA tables, with the Re-sequence button:

The Mass Appraisal validation tables and codes are saved by year and are defined by category, table type and table name. This section lists the table types, by category and provides a reference to the database tables and parameters where they are saved.

Display a Description with the Building Drawing Code

This is a milestone version of Mass Appraisal as all administration and computation functions are developed and operating on OpenForms 6.1. This version is not backward compatible.
Important changes and improvements were made to the data model (impact on the database), system functions (system and user tables…) and administration tools.

Batch Computation

• The Mass Appraisal Computation will now be performed even if the HISTORY FLAG is set to YES. Prior to this version, no computation took place when using the batch compute.
• A parcel range was added to the batch process selection criteria.
• For the batch computation used with the Govern Scheduler, a change was made to reload the mass appraisal parameters when the ALL_STAMP is set to NULL meaning that a change was made in parameters that may impact value. Please note that if changes are made to the parameters while the batch computation is already running, the parameters will not be reloaded.

Default Alignment on Text and Numeric Attributes

• By default, all numeric attributes are right aligned and all text attributes are left aligned.
• See What’s New in Standard Features and Forms for more information

Number Formatting for Appraisal Table Elements

• You can now define how values are formatted in the Land, building Structural Elements, Site, MRA, and Income Adjustment grids.
• Any number format defined in the Number Format Editor can be applied to any of the values in the grid.
• For details on creating and applying number formats, see the Number Format Editor

Lookup Group Types in Neighborhood

[6.1] Major changes have been made to (Table: MA_PARM_NBHD) and its associated Table/Code maintenance windows. As a result of the redesign it is now possible for the Neighborhood to have two possible Look Up Group Types

• By Property Type
• By Jurisdiction

NOTE: When you change the check value of the “By Jurisdiction” control and Save, the following will occur, a deletion of all MA_PARM_NBHD records FOR ALL YEARS. This means that all Neighborhood data will no longer be available. See corrective actions below.

Mass Appraisal Lookup Groups

[6.1] This new feature adds a user defined look-up group to most appraisal tables so that different rates and adjustments can be entered by a group combination.

• For more information, see Mass Appraisal Link Group Table
• When creating the MA Tables, users will have to select a group type recorded in [MA_TABLE] .[LOOKUP_GROUP_TYPE] using the VT_SYSTEM validation TABLE_NAME = ‘MALKGRP’ or use none.
• This replaces prior Jurisdiction and Neighborhood look-ups.

Site is Mandatory for all Appraisal Components

[6.1] A site number is now mandatory for income, buildings, land, mra, miscellaneous structure and personal property.

Site is a Multi-Field Combination

[6.1] The site can now be composed of multiple (MA_SITE) fields concatenated together to provide different combinations (ex: Property Use, Land Use, Property Exemption)

• New Govern Standard MA_SITE_DESC calculated attribute field in Business Entities (BED)
• Changed SYSTEM query maSiteList in use for reporting, display, split merge balancing and Site Lookup in appraisal components (Land, Buildings, MRA, Income, Misc. Structures (see roadmap) and Personal Property)

Long versus Short Description

• In most tables used by Mass Appraisal, the long description is used as a default.

Do not display Option

• New Option to prevent the display of a table sequence.

Forced Unique Default Code Option

• Used when there is only one code in a given table. No user interaction will be needed to select this code.

Is Required

• The Is Required flag in Mass Appraisal Table was changed to use an expression.
• To facilitate the conversion of existing parameter tables, a new field was created [MA_TABLES.IS_REQUIRED_EXPRESSION]
• By default, when the field will be created, the value will be FALSE.

Features Table Category

• The expression was added to the the features table category that can be used with queries or attributes to show a feature coming from another area or based on conditions.
• It can also be used in a Matrix
• Masks can be applied to Features Table Elements

Apply To Units/Units Look-Up

• This was merged with the UNITS LOOK-UP and will contain predefined codes and business entity fields with a lower in sequence. (validate)

Simulation (deprecated)

• No longer available in version 6.1 as the same results can be accomplished using the Import / Export tools.

Daemon Hybrid Mode for Appraisal Computation (deprecated)

• No longer in use. Version 6.0 and prior was a hybrid version working with Govern for Windows 10.8 Daemon for Appraisal value computation and Govern Administrator 10.8 for table and configuration.

Database (see impact list)

• Land Additional Info Table and Business Entity was merged into Land.
• Building Additional Info Table and Business Entity was merged into Building.
• Simulation column was removed
• Land Adjustment Template fields were removed
• MRA Element Template fields were removed
• Override Fields were added for Land, Land Adjustents, Building, Misc. Structure, Income and MRA.
• Current PID field added to MA_BUILDINGS

Exclude from Roll text box

• Since version 6.0, the Exclude from Roll text box now displays one of the following, corresponding to the selection in the Value On field on the Appraisal Linking form : Building Only, Land Only, or All Values.

Parameters no longer used

• Compatibility SE Compute
• Compatibility SE Compute Year Effective
• Optimize Computation Speed
• Round by Drawing Code
• Skip Rates Interpolation

New Conversion Menu

• During the upgrade to 6.1, Mass appraisal tables will be copied to ma_xxx to ma_xxxBACKUP.
• A new menu for conversions is available in GNA where the user can convert tables on demand. As a best practice, start with a single table for 1 year instead of all.