Mass Appraisal (MA) Validation Tables

Version 6.1

Overview

All Mass Appraisal tables are defined in GNA. They are available from the following menus depending on whether multiple versions of a table can be created or the table is unique.

The table types that support multiple tables are found in GNA under Mass Appraisal > Table Maintenance. These tables include Building Structural Elements, Depreciation, Income Expense, Income Rental Detail, Land Adjustments, MRA Elements, and Sites.

The table types that are unique are found under Mass Appraisal > Table Maintenance > Single Entry tables. These tables are grouped by category and include Rounding, Multiple Distribution or Correlated Values, Neighborhood, Building Use, Building Drawing, Building Size Adjustment, Building Submodel, Income Added Items, Income Model, Income Categories, Income Quality Adjustments, Land Schedules, Land Use, Miscellaneous Structure Adjustments, Miscellaneous Structure Conditions, Miscellaneous Structure Grade, Miscellaneous Structure Use, MRA Model, Comparable Sale Items, Comparable Sale Parameters, Comparable Sale Distance, and Comparable Sale Time Adjustment.

User Validation Tables for Mass Appraisal can also be grouped in the User Validation Table Edition. These are found under Regular, Mass Appraisal, and Property Control.

What’s New

For What’s New Topics, refer to the Mass Appraisal What’s New compilation page that lists recently updated topics related to the Mass Appraisal module.

Table Categories

The Table Categories are used to indicate the sub-module and include All, Buildings, Comparable Sales, Income, Land and Miscellaneous Structures.

All

The tables defined under the All Categories can be used in multiple sub-modules; for example, the Depreciation tables are used in Building and Miscellaneous Structures validation tables.

• Correlated Values Distribution, also called Mixed Use Distribution Parameters (Table: MA_PARM_MULTDIST). See Mass Appraisal Coreeleated Values/ Mixed Use Validation Table.
• Depreciation Tables (Tables: MA_PARM_DEPR and VT_USR_<table_ name>, where <table_name> refers to the name you give the table). See Mass Appraisal Depreciation Table.
• Limited Assessment Value (Table: MA_PARM_L_ASSMT). Future Release.
• Mass Appraisal Sites (Tables: MA_PARM__<table_name>, where table_name refers to the name you give the table). See Mass Appraisal Sites Table.
• Neighborhood (Tables: MA_PARM_NHBD and VT_USR_NBHD). See Mass Appraisal Neighborhood Table
• Rounding (Tables: MA_PARM_MAROUND and VT_USR_MAROUND). See Mass Appraisal Rounding Table. See Mass Appraisal Rounding Table.

Buildings

The tables listed in this category are applicable to the Mass Appraisal Buildings sub-module only.

• Building Use Codes (Table: MA_PARM_BLDGUSE)
• Drawing Area (Table: MA_PARM_DRAWING)
• Occupancy
• Size Adjustments (Table: MA_PARM_SIZEADJT)
• Building Structural Elements (Table: MA_PARM_SETAB).
  The Building Structural Elements tables include the following element categories:
• Area Adjustment (code: m)
• Area Size Override (code: s)
• CAMA (code: a)
• Depreciation (code: s)
• Depreciation Table Override (code: d)
• Depreciation Override (code: o)
• Header (code: h)
• Feature, Boeckh and non-Boeckh method (code: f)
• Overall Adjustment (code: t)
• Quality Points (code: q)
• Rate Adjustments (code: r)

Multiple Regression Analysis (MRA) or Fair Market Value (FMV)

• Multiple Regression Analysis Elements Table: MA_MRA
• Multiple Regression Analysis Models Table: MA_MRA

Land

The tables in this category are applicable to the Mass Appraisal Land sub-module only.

• Land Adjustments (Table: MA_PARM_LANDADJT). See Land Adjustment Table.
• Land Rate Schedule (Table: MA_PARM_LANDSCHD). See Land Rate Schedule Table
• Land Use Codes (Table: MA_PARM_LANDUSE). See Land Use Table.

Miscellaneous Structures

The tables in this category are applicable to the Mass Appraisal Miscellaneous Structures sub-module only and are described in the Mass Appraisal Miscellaneous Structures reference guide.

• Miscellaneous Structure Codes (Table: MA_PARM_MISCUSE)
• Miscellaneous Structure Condition (Table: MA_PARM_MISCCOND)
• Miscellaneous Structure Grade (Table: MA_PARM_MISCGRAD)
• Miscellaneous Structure Adjustments (Table: MA_PARAM_ MISCADJT)

Income

The tables in this category are applicable to the Mass Appraisal Income sub-module only and are described in the Mass Appraisal Income guide.

• Income Category Codes (Table: MA_PARM_INCOME)
• Income Expense Items (Table: <table_name>, where <table_name> is the name you have given the table).
• Income Overall Adjustments (Table: MA_PARM_INCADJ)
• Income Quality Adjustments (Table: MA_PARM_INCQUA)
• Income Model (Table MA_PARM_INCOME_MODEL)

Sales and Comparable Sales

The tables listed in this category are applicable to the Mass Appraisal Sales and Comparable Sales sub-module only and are described in the Mass Appraisal Comparable Sales and Sales reference guide.

• Comparable Sales Items (Table: MA_PARM_COMP_ADDFIELD)
• Comparable Sales Parameters (Table: MA_PARM_SALECOMP)
• Comparable Sales Time Adjustments (Table: MA_PARM_TIMEADJT)

Mass Appraisal Validation Table Action Icons

• New: You can create new Mass Appraisal Validation Tables for the following table types: Building Structural Elements, Depreciation, Income Expense, Income Rental Detail, Land Adjustments, MRA Elements, and Sites.These are found in GNA under Mass Appraisal > Table Maintenance.
  The tables that are accessed from the Single Entry menu are unique. For these table types, the New button is disabled.
  When you click New, the Exit button switches to Cancel; so that you can clear new data without closing the form. Once you click Save this button switches back to Exit.
• Save: Click Save to save a new record or any modifications to an existing one. For details on the database tables and parameters where the Mass Appraisal validation tables are saved, see Mass Appraisal Table Types by Category.
• Delete: Click Delete to remove a record. A confirmation message is displayed. Click Yes to continue or No to cancel.
• Codes: Click Codes to open the Mass Appraisal Validation Codes form. See Mass Appraisal Validation Codes.
• Resequence: Click Resequence to change the Sequence Number of the selected table.
  To change a Sequence Number:
  1. Launch GNA.
  2. Open the table with the Sequence Number that you want to change.
  3. Ensure that all required fields are filled in and saved; i.e, ensure that no fields are outlined in red.
  4. Click the Re-sequence button at the top of the form.
     The Resequence window opens.
  5. Enter a new sequence number in the Sequence field.
  6. Click OK.

Select All / Deselect All

In order to facilitate creating and maintaining values for Mass Appraisal tables and codes, all grids now include an option for selecting and / or deselecting all the items in a column.
Rather than scrolling through the entire column and selecting each option, you can select the option at the top of the column in order and select or deselect all items at the same time. This is a toggle. If all items in the column are selected, you can use this option to deselect all the items.

General Mass Appraisal Table Parameters

This section describes the parameters that are common to all Mass Appraisal validation tables.

Table Category

Table Categories are used to indicate the sub-module and include All, Buildings, Comparable Sales, Income, Land, and Miscellaneous Structures (Table: VT_SY_ MATBCAT).
The single entry tables are grouped by category in the tree view at the left of the table form.

Table Type

The Table Type is a classification within the Table Categories. The table type is automatically populated according to the selection that you make under the Table Maintenance or Single Entry menu. For some table types, multiple tables can be defined; these are distinguished by Table Name. For a list of the Table Types, see Mass Appraisal Table Types by Category on page 25.

Table Name

Enter a name for the table. This must start with a letter, but otherwise can be any combination of alphanumeric and underscore characters.

• The table name must start with an alphabetic character.
• It cannot exceed eight characters in length.
• It cannot contain any special character except an underscore ( _ )

Column Name

Enter a name for the column. The same rules apply to the table name and the column name

Short Description

Enter a short description for the table.

Long Description

Enter a long description for the table. This is used for look-ups and is displayed on forms and reports.

Lookup Group Type

Select one of the following Lookup Group Types from the drop-down list.

• juris_inc_nbh – Jurisdiction and Income Neighborhood.
• juris_nbhd – Jurisdiction and Neighborhood.
• juris_nbhd_prop – Jurisdiction, Neighborhood, and Property Type
• juris_proptype – Jurisdiction, Neighborhood, and Property Type
• jurisdiction – Jurisdiction
• nbhd – Neighborhoold
• nbhd_proptype – Jurisdiction and Property Type
• none – none
• proptype – Property Type

See Mass Appraisal Lookup Group Types.

These codes are made up of various combinations of the following:

• Jurisdiction: VT_USR_JURISD. The Jurisdiction User Validation Table is associated with the property on the Property Control, Property Information form.
• Neighborhood: VT_USR_NEIGHBOR: The Neighbor User Validation Table is populated by the Mass Appraisal Neighborhood Table. It is associated with the property on the Parcel Area form.
• Income Neighborhood: VT_USR_INCNBHD: The Income Neighbor User Validation Table is also populated by the Mass Appraisal Neighborhood Table. It is associated with the property on the Parcel Area form.
• Property Type: VT_USR_PROPTYPE:The Property Type User Validation table is associated with the property on the Property Control Legal Information form.

See Mass Appraisal Lookup Group Types.

Number Format

You can apply a Number Format to a value in order to display a value in a currency format, as a percentage, with a required number of decimals. mask to apply to the calculated value showed in the grids (adjustments and elements). See Number Format Editor.

Do Not Display

Select this option to hide the table on the Govern user form. The table is used in the calculation but cannot be viewed or modified in Govern.

Apply a Field Mask to the Code

You can apply a field mask to a code, in order to validate user data entry. For example, you could use the Year field mask in order to ensure that users enter four digits in a field requesting a year.
The following conditions apply:
This option is only available for the Feature element categories for the following forms:

• Building Structural Elements
• Land Adjustments
• Income Rental Detail

It is only available if no table name is associated with the Mass Appraisal table.

Only masks with numeric values can be applied.

It appears only when no table name is assigned to the Mass Appraisal Table. The reason for this is that it is only applicable when no codes are associated with the table.

When you select the option, Apply a Mask to the Code, a drop-down list appears. This list contains all the field masks defined in the Field Mask Editor in GNA. When the option is selected, it is mandatory to select a field mask.

If the user enters data, on the Govern form, that does not match the format defined in the mask an error appears.
In the following scenario, the Year field mask is applied to the Description code in the Building Structural Elements table.
To apply the mask:

1. Launch GNA.
2. Select Application Configurations > Mass Appraisal > Table Maintenance > Building Structural Elements Table.
3. Click New to create a new Building Structural Elements table.
4. Select f – Feature Item from the Element Category drop-down list.
5. Leave the Table Name field blank.
6. Select the models from the Apply to models list.
   Alternatively, select the property types from the Apply to Property Types list.
7. Select Apply a Mask to the Code.
8. Select Year from the Field Mask drop-down list.
9. Click Save.

To verify that the field mask is applied in Govern.

1. Launch Govern.
2. Open a Profile that contains Building Structural Elements.
3. Open the Buildings form.
4. Perform a search for a property that contains the models or property types associated with the Feature table.
5. Select the Building Structural Elements entity.
6. Enter data in the field does not match the mask.
7. Ensure that a validation error appears.Only the field masks that are created with numeric values and no alphabetic characters appear in the list.
8. Enter data in the correct format.
9. Click Save.

For more information about using Field Masks in GNA, see Field Masks

Automatically Selecting a Code

There are several ways that you can use the Auto Select feature to automatically display a code on a Govern user form.
There are two options:

• Auto Select Unique Code
• Auto Select With Expression

Auto Select Unique Code

Select this option under the following conditions:

• You are creating a single Validation Code for the table. In this case, the code is automatically displayed in the grid on the Govern form.
• You are creating multiple Validation Codes for the table. Nevertheless, the code is used in a Matrix or Link and only one code is possible.

Auto Select Code with Expression

Use the Auto Select with Expression option in order to automatically display the appropriate code, on a user form, when there is more than one possibility. You need to add an expression. The expression is typically based on the user entry in a previous field.

This is illustrated in the following scenario. The Building Structural Elements table contains multiple structural elements including one for Quality and one for Wall Height. You can write an expression in oder to display the code for Wall Height that corresponds to the code that is selected for Quality.
Note: Building Structural Elements are displayed in order of sequence number on the Building Structural Elements form in Govern. The expression must be written so that the element that is automatically selected has a higher sequence number than the element on which it is dependent.

The same rule applies to Site Adjustments, Land Adjustments, and MRA elements. The automatically selected element must have a higher sequence number than the element on which it is dependent.

If the elements are used in multiple models, ensure that the sequence numbers are correct in all models.

Scenario: Auto Select Code With Expression

This scenario illustrates the use of the Auto Select Code With Expression feature on the Building Structural Elements form.

Prerequisites

The Quality and Wall Height codes must be set up in GNA on the Building Structural Elements table form in GNA. The same model must be selected for these codes under Apply to Models on this forms.
The user opens the Building Structural Elements form in Govern for the required record.

A code is automatically selected based on what the user selects for the Quality element. In this case, the user selects Fair for the Quality and 20 ft. is automatically selected for the Wall Height. The following table shows how the codes for the Wall Height are automatically selected, based on the user input for the Quality:

Expression

The expression for this scenario is written as follows:
Case(@attrR_QUAL_CD,
‘1’, ’05’,
‘2’, ‘7’,
‘3’, ’10’,
‘4’, ’12’,
‘5’, ’15’,
‘6’, ’20’,
‘7’, ’24’)

The numbers on the left, 1 to 7, correspond to the codes for the attribute Quality. The numbers on the right correspond to the wall height. The code is used rather than a description.

The setup for this scenario is as follows:

1. Launch GNA.
2. Select Application Configurations > Mass Appraisal > Table Maintenance > Building Structural Elements Table.
3. Select the 26030 – Wall Height Structural Element.
4. Select Auto Select Code.
5. Select With Expression.
6. Click the ellipsis button beside the With Expression parameter and enter the expression.
   his opens the Expression Selector.
7. Enter the expression.Tip: You can test the expression with the Execute button.
8. Click OK on the Expression Selector.
9. Click Save on the Building Structural Elements table.

Verifying the Auto Select Expression in Govern

To verify the expression:

1. Launch Govern.
2. Open a Profile that contains the Building Structural Elements form.
3. Open the Building Structural Elements form.
4. Perform a search and select a record that contains one of the models listed under Apply to Models on the Building Structural Elements table in GNA.
5. Load the record to the form.
6. Select a code for the Quality.
7. Ensure that the corresponding code is selected for the Wall Height.

Mass Appraisal Modules

The Auto Select features are available for the following Mass Appraisal modules:

• Building Structural Elements
• Land Adjustments
• Site Adjustments
• MRA

The expression is added to the required Mass Appraisal table in GNA. A code is automatically selected in Govern, based on the user input.

Is Required

The Is Required checkbox is available on multiple Mass Appraisal tables. It is used to ensure that the user selects a code or enters a value when completing a Govern form. For example, you could make it mandatory for users to select a value for the quality of an element, such as good, average, or poor, when completing the MRA form for a property.

Previous to version 6.1, this check box could be selected or deselected. The corresponding code or entry was required or not. With version 6.1, an expression is associated with the checkbox. This gives you the flexibility to attach a condition, making a selection or entry necessary only under certain circumstances. For example, you could make it a requirement to select an adjustment when the total value of the property is below a specific amount.

The expression can be simple or complex. At the default level, it is set to True when the check box is selected. An entry is always required. Otherwise, the check box is deselected. No entry is required. (The expression is set to False in this case, but it cannot be seen on the MA Table form.) The expression can include a single attribute or multiple attributes. For example, you can make a code a requirement when the combined Building and Land Value are equal to or greater than a specific amount. You can associate the expression with a date or a date and an attribute. You can add or variable, or if statement, or a variable. Any combination of attributes, system IDs, or functions can be included.

Available Tables

The Is Required checkbox is available on the following tables:
Building Structural Elements (BSE): All categories except Header.

• MA Site
• Fair Market Value (FVM) or Market Regression Analysis (MRA)
• Land Adjustments
• Income Rental Detail, all categories with the exception of Header.

Requirements

The following are required for the expression:

• As with all expressions, the attributes and system IDs included in the expression must be part of the entity. The attributes do not need to added to the form.
• The expression must evaluate to True.
• The expression must be valid. Otherwise, if the user does not select a required item, an exception is launched.
• For the Is Required check box, the Convert null parameters to default values check box must be deselected.

To add an expression to the Is Required checkbox:

1. Launch GNA.
2. Select Application Configurations > Mass Appraisal > Table Maintenance.
3. Select the required table.
4. Select the Is Required check box.
   The text box and ellipsis button for the expression is displayed.
5. Click the ellipsis button to open the Expression Selector.
   By default, True is written in the Expression Selector text box.
6. Replace True with an expression.
7. Ensure that the Convert null parameters to default values check box is deselected.
8. Click OK.

To test the expression:

As with all expressions, any parameters that are included in the expression are displayed on the right under Parameters.

1. Enter a value in the Parameter text box or text boxes.
2. Click Execute.

The result of the expression is displayed in the Result text box.
You can also test the expression in Govern.

1. Launch Govern.
2. Select a Profile that contains the form.
3. Open the form.
4. As with all required fields in Govern, the field is outlined in red if a value is required.
5. Save the form without entering a value.

When you hover your mouse over the field, the Required Field tooltip is displayed, if the expression valid.
However, if the expression is not valid, a message is displayed stating that the expression failed:
Regardless of whether or not the expression failed, the user can save the form as long as a value is entered in the required field.

Mass Appraisal Validation Codes

The icons and many of the parameters on the Mass Appraisal Validation Codes form are the same for all table types. These are described in this section. For further details, see the description for the specific table.

To access the Mass Appraisal Validation Codes, click the Codes icon on the Validation Table form.

Mass Appraisal Validation Code Action Buttons

New: When you click New, the Exit button switches to Cancel; so that you can clear new data without closing the form. Once you click Save this button switches back to Exit.
Save: If you modify a value, such a rate that can impact multiple property records, a prompt appears, when you click the Save button:
If you answer No to the prompt, the MODIF_STAMP field for the applicable table is set to NULL for all records affected by the modification.

Mass Appraisal Validation Codes Parameters

Short Description

Enter a short description.

Long Description

Enter a long description. This is used for look-ups and is displayed on forms and reports.

Setting the Current Year

The Year field on the tab of the Mass Appraisal User Validation Table Editor form displays the current year in GNA. The current year is the last year that was set in GNA.
To change the year:

1. Launch GNA.
2. Select the Year menu.
   This opens the Current Year text box.
3. Enter a new year.

The next form that you open is set to the new year and this year is displayed on the tab for that form. Note that this action does not change the year of any form that was open previously. This means that you can have multiple versions of a form open in different years.

103-ma-parm-Tables

(0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.

Loading...