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.
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.
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:
- Launch GNA.
- Open the table with the Sequence Number that you want to change.
- Ensure that all required fields are filled in and saved; i.e, ensure that no fields are outlined in red.
- Click the Re-sequence button at the top of the form.
The Resequence window opens.
- Enter a new sequence number in the Sequence field.
- 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 ( _ )
| NOTE: Not all the Mass Appraisal validation tables include the Table Name parameter. |
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:
- Launch GNA.
- Select Application Configurations > Mass Appraisal > Table Maintenance > Building Structural Elements Table.
- Click New to create a new Building Structural Elements table.
- Select f – Feature Item from the Element Category drop-down list.
- Leave the Table Name field blank.
- Select the models from the Apply to models list.
Alternatively, select the property types from the Apply to Property Types list.
- Select Apply a Mask to the Code.
- Select Year from the Field Mask drop-down list.
- Click Save.
To verify that the field mask is applied in Govern.
- Launch Govern.
- Open a Profile that contains Building Structural Elements.
- Open the Buildings form.
- Perform a search for a property that contains the models or property types associated with the Feature table.
- Select the Building Structural Elements entity.
- Enter data in the field does not match the mask.
- Ensure that a validation error appears.Only the field masks that are created with numeric values and no alphabetic characters appear in the list.
- Enter data in the correct format.
- 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.
| NOTE: When only one code is available and the Auto Select Unique Code option is selected, that code is used for the compute. This applies regardless of whether the user has previously selected another code. It applies, for example, if the code is changed in GNA, after the user set the code on the form.The update is made when the property record is opened and resaved or the Mass Appraisal Compute batch process is run. |
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:
| Quality |
Wall Height |
| 1 – Very Low |
5 ft. |
| 2 – Low |
7 ft. |
| 3 – Fair |
10 ft. |
| 4 – Average |
12 ft. |
| 5 – Good |
15 ft. |
| 6 – Very Good |
20 ft. |
| 7 – Excellent |
24 ft. and higher |
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:
- Launch GNA.
- Select Application Configurations > Mass Appraisal > Table Maintenance > Building Structural Elements Table.
- Select the 26030 – Wall Height Structural Element.
- Select Auto Select Code.
- Select With Expression.
- Click the ellipsis button beside the With Expression parameter and enter the expression.
his opens the Expression Selector.
- Enter the expression.Tip: You can test the expression with the Execute button.
- Click OK on the Expression Selector.
- Click Save on the Building Structural Elements table.
Verifying the Auto Select Expression in Govern
To verify the expression:
- Launch Govern.
- Open a Profile that contains the Building Structural Elements form.
- Open the Building Structural Elements form.
- 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.
- Load the record to the form.
- Select a code for the Quality.
- 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.
| NOTE: If you select the Is Required option for a code after the user has created property records, you must verify that a code is selected for those records. Otherwise, an error is raised and the compute fails. |
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:
- Launch GNA.
- Select Application Configurations > Mass Appraisal > Table Maintenance.
- Select the required table.
- Select the Is Required check box.
The text box and ellipsis button for the expression is displayed.
- Click the ellipsis button to open the Expression Selector.
By default, True is written in the Expression Selector text box.
- Replace True with an expression.
- Ensure that the Convert null parameters to default values check box is deselected.
- 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.
- Enter a value in the Parameter text box or text boxes.
- Click Execute.
The result of the expression is displayed in the Result text box.
You can also test the expression in Govern.
- Launch Govern.
- Select a Profile that contains the form.
- Open the form.
- As with all required fields in Govern, the field is outlined in red if a value is required.
- 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:
- Launch GNA.
- Select the Year menu.
This opens the Current Year text box.
- 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...
