MA Land Adjustment Tables

Mass Appraisal Land Adjustment Tables

[In Development]

Overview

The Mass Appraisal Land Adjustment Validation Tables are used for associating an adjustment with the land records. This can be based on any number of user-defined factors, such as shape, topography, or environmental hazards.

You can create as many land adjustment validation tables and codes as required.

The Element Category field Is used for selecting the type of adjustment table you are creating. These are described in the following sections:

Adjustment: This category is used for the general adjustments.
Feature: This category is used for including a description with the adjustments in the Land Information Adjustments tab.
Header: This category is used for adding a heading to the adjustment types in the Land Information Adjustments tab.
Rate Adjustment: This category is similar to the Adjustment category. The difference is that if you are setting up matrices or links, you can create groups of rate adjustments. These are used to facilitate the computation and data entry.

The Adjustment Type column on the Govern Land Information > Adjustments tab displays the Short Descriptions from the Mass Appraisal Validation Table for Land Adjustments. The Adjustment Code column displays the Short Descriptions from the Mass Appraisal Validation Code.

Common Setup for Land Adjustment Validation Tables and Codes

This section describes the common setup for all four element categories of the Mass Appraisal Land Validation Tables and Codes.

Accessing the Mass Appraisal Validation Tables for Land

The Mass Appraisal Validation Tables for Land are accessed from two different menus.

The Mass Appraisal Land Use and Land Schedule Tables are unique. These tables are accessed from the Single Entry table.
There can be multiple Mass Appraisal Land Adjustment Validation Tables. these tables are accessed from the Table Maintenance menu.

Accessing the MA Land Use and Land Schedule Validation Tables

To access this Mass Appraisal Validation Tables:

Launch GNA.
Select Application Configurations > Mass Appraisal > Table Maintenance > Single Entry.

Accessing the MA Land Adjustment Validation Tables

To access this Mass Appraisal Validation Tables:

Launch GNA.
Select Application Configurations > Mass Appraisal > Table Maintenance > Land Adjustment Table Maintenance.

Setting Up for Land Adjustment Validation Tables

The icons and configuration parameters described in this section are common to all Mass Appraisal Land Validation Tables.

Mass Appraisal Adjustment Validation Table Action Icons

All the land adjustment tables are listed in the tree view on the left of the Land Adjustment table form. They are listed by sequence number and long description, by default. You can change this to sequence and code or short description.
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.

When you create a Mass Appraisal Land Adjustment validation table:

Your table is added to the database and assigned the name VT_ USR_<xxx>, where <xxx> is the name you have given the table.
For example, VT_USR_NHBDADJT.Note: The table name can contain a maximum of eight characters.
Three columns are added to the MA_LAND table: xxx_CD, xxx_AM and xxx_OV where xxx is the name of the column you have created. For example, NHBDADJT_CD, NHBDADJT_AM and NHBDADJT_OV.
The adjustment codes, amounts and override values, entered on the Land Appraisal Information function are saved to these columns.
When the limit of 255 columns is reached in MA_LAND, new tables are created, such as MA_LAND_2, MA_LAND_3, etc.
A new record is created in MA_TABLES, listing the table name, year, table type, table category and column name.
A new record is created in VT_USR_MA_TABLES, listing the long description, short description, column name and year.

Save
Click Save to save a new record or any modifications to an existing one.
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.
Exit
Click Exit to close the Mass Appraisal Validation Table form.

Mass Appraisal Adjustment Validation Table Parameters

Year
The Year is displayed at the top of the tab for the table. As with all year-based parameters, the Mass Appraisal Validation Tables open to the current yeat as defined in GNA.
You can access tables for different years and have multiple versions of the same table open in multiple years. In order to access tables from different years, select the Year menu and enter the required year in the Current Year text box.
Short Description
The short description is used for fast data entry and lookups and is displayed on forms if space is too limited for the long description.
Long Description
The long description is used for lookups and on forms and reports.
The long description for the Land Adjustment validation table is displayed under the Adjustment Type column on the Land Appraisal Information form in Govern.
Table Type
This field displays the validation table type selected from the Code Selection list box and cannot be changed from the table form. For the Mass Appraisal Land Adjustment validation table forms, this field displays: landadjt – Land Adjustments.
Table Category
This field displays the table category. The category for the Mass Appraisal Land validation tables is Land.
Element Category
The Land Adjustment tables include the following element categories:

Adjustment
Feature
Header
Rate Adjustment

Mass Appraisal Land Adjustment Element Categories
Category	Description
a – Adjustments	Most adjustment s are created in this category. This is used for creating codes for each adjustment type and setting a value, percentage, amount, formula, or logical expression to apply to each.
r – Rate Adjustment	This category is used to modify the rate according to user-defined criteria such as heating type or air conditioning.
f – Feature	Informational: used to include a description in the structural element grid on the Building Structural Elements and Features form.
h – Header	Informational: used to include a header in the structural element grid for the next structural element tables. These tables are listed in order of sequence number.

Table Name
Enter a name for the table. The table name can be any combination of alphanumeric characters. You cannot use special characters with the exception of the underscore (_). The table name can be a maximum of eight characters. It must be in uppercase.

The Table Name is not displayed for the Header element category
Column Name
Enter a name for the column. The table is saved in MA_LAND by the column name and the year, as displayed in the Year parameter.
The Codes are saved to TEMPLATE_ADJ_CD, the Values are saved in TEMPLATE_ADJ_AM, and the Overrides are saved to TEMPLATE_ADJ_OV.

You can create more than one table with the same name if the column name is unique.

The Validation Codes are the same for all tables with the same Table Name.

You may want to create multiple tables with the same name if you want to reuse codes.

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 – Neighborhood
nbhd_proptype – Jurisdiction and Property Type
none – none
proptype – Property Type

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.

For details, refer to the Mass Appraisal General Information documentation.
Sequence
By default, this field displays a system-generated sequence number, created by adding one to the last sequence number. You can override the default if required.
The sequence numbers are used for ordering the adjustments in the Land Appraisal Adjustments tab on the Govern Land Adjustment Information form. They are used in the computation if Compute by Sequence is selected on the Mass Appraisal General Parameters form. Otherwise, if this option is left blank, the computation is performed according to the mathematical order of operation rules.

If the option is selected, calculations are performed in ascending order of sequence number; i.e., the tables with sequence numbers 1 and 2 are calculated before the table with sequence number 3, etc.

Ensure that if the calculated values for the table are dependent on the results of values defined in other tables, the table has a higher sequence number.

Operator
Select an operator, add, subtract, divide or multiply, from the drop-down list to use when applying the adjustments (Table: VTSYSTEM_MATH).
Percent or Amount
Select Percentage or Amount depending on how you want to calculate the values from Land Adjustment Validation Codes forms.
Formatting
Select one of the predefined formatting types from the drop-down list or click on the ellipsis button to create a new one.

The formatting applies to the display in Govern only. It does not change the value in the database.

You can select any formatting style. This is independent of the selection you make for the Amount or Percent parameter.

Force Unique Default Code
Select this option if you are creating a single Validation Code for the adjustment. The code is automatically displayed in the grid of the Adjustment tab on the Govern form.
This option is disabled if more than one code exists for the selected Adjustment table. If you create a second code, the option is unselected automatically.
Units Table Lookup
Select this option if you would like to apply the adjustment to the frontage, the depth, or to the total units. By default, it is applied to the total size. This option appears for the Adjustment and Rate Adjustment Categories only.
Land Schedules
This list box appears if Associate Land Adjustments to Land Schedules is selected on the Mass Appraisal General Parameters form. It lists all the land rate schedules from the Mass Appraisal Land Rate Schedule Validation Table. You can select as many schedules as required. In Govern, the user sees only the adjustments that apply to the selected land rate schedule that is selected on the Land Information > General tab.
Land Use
This list box appears if Associate Land Adjustments to Land Uses is selected on the Mass Appraisal General Parameters form. It lists all the land use codes from the Mass Appraisal Land Use Code Validation Table. You can select as many land uses as required. In Govern, the user sees only the adjustments that apply to the selected land rate schedule that is selected on the Land Information > General tab.
If neither option is selected on the Mass Appraisal General Parameters form, then neither list box is displayed. You cannot select both options.

is Required
Select the Is Required checkbox if the adjustment is required. This ensures that the user enters a value or selects a code for this adjustment. Otherwise, the record cannot be saved.
When you select this checkbox, the expression text box is displayed. True is entered in this text box by default.
Select the ellipsis button and open the Expression Selector if you prefer to enter an expression to make the adjustment required under a specific condition only. For example, you could make the adjustment required if the Total Land Value is less than a certain amount. Refer to the Mass Appraisal General Information documentation for details. See Is Required
Matrix / Link Sequence
A link or matrix can be used with the Land Adjustment validation tables for both the Adjustment and the Rate Adjustment element category.
Matrix
You can set up a single, double, triple or quadruple matrix when you need to evaluate several structural elements together in order to determine the land adjustment value.
To set up a matrix:

Create the Mass Appraisal validation tables needed for the matrix, as described later in this section.
On the validation table form of the table with the highest sequence number, select Matrix.
Select up to three tables for the matrix from the drop-down lists.
Click Codes and enter the appropriate code and value for each item.

The tables in the matrix must:

Have a table name.
Have a lower sequence number than the one for the selected adjustment table.
If you have multiple tables with the same table, but different column names, only the table with the lowest sequence number appears in the list.
This is done because all tables with the same table name have the same validation codes.

Link
Use the link to join two validation tables together and calculate a combined value. The calculation is based on the specified operator.
You can join a linked table to another table. However, the table with the lowest sequence number can have only one table linked to it. This is the table where the combined values appear.
Therefore, you can link table 3 to table 2 and table 2 to table 1. You cannot link both table 3 and table 2 to table 1.
To link Mass Appraisal validation tables:

Set up the tables you are linking according to the procedures described later on in this section.
On the validation table form for the table with the higher sequence number, select the Link option.
From the drop-down list, on this form, select the table with the lower sequence number.
You can only link a table with one that has a lower sequence number.

Average
Select Average to apply an average rate to linked Mass Appraisal Adjustment tables.
The rules for Linked tables apply to the Average.

Setting Up for Land Adjustment Validation Codes

The Mass Appraisal Land Adjustment validation codes are used for creating specific land adjustments for land and for associating names and values with each.

The validation codes for the selected land adjustment table are listed in the tree view on the left of the form. They are listed in alphabetical order.

Mass Appraisal Adjustment Validation Codes Action Icons

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
Click Save to save a new record or any modifications to an existing one.
Delete
Click Delete to remove a record. A confirmation message is displayed. Click Yes to continue or No to cancel.

Mass Appraisal Adjustment Validation Codes Parameters

Code
Enter a unique and descriptive code. The adjustment codes are displayed in drop-down lists, under the Adjustment Code column in the Adjustments grid on the Land Appraisal Information form in Govern, when the user clicks inside the column.
Short Description
Enter a short description. This is used for fast data entry and look-ups if space is limited on forms.
Long Description
Enter a long description. This is used for look-ups, on forms and is normally used for reporting.
Lookup By
If you are setting up the Site Validation codes by Lookup Group Type, create the lookup group types for jurisdictions, neighborhoods, income neighborhoods, or property types as applicable. Refer to the Mass Appraisal General Information documentation for details.
Matrix Code / Matrix Code 2 / Matrix Code 3
The Matrix Code fields appear if the Matrix option is selected on the Mass Appraisal Validation Table form and tables are selected from the drop-down lists. If three tables are selected, all three fields appear. If you select only two tables, only two codes appear on the form, and so on.
Select the Adjustment Codes for each table in the Matrix Code fields.
Adjustment
Enter a value for the adjustment as a flat Amount or Percentage, depending on the selection on the Mass Appraisal validation table form.

Adjustment Element Category Validation Tables and Codes

The Adjustment Element Category is used for creating the general land adjustments and codes.

CAMA Adjustment Element Category Validation Table

The setup for this element category is the same as the general setup for all Mass Appraisal Land Adjustment Validation Tables, with the exception of the Apply To drop-down list. See Common Setup for Land Adjustment Validation Tables and Codes.

The Units Table Lookup list is displayed only for the Mass Appraisal Adjustment and Rate Adjustment Element Categories. This is used selecting the type of measurement for the calculation.
Select the Units Table Lookup checkbox. Then, select one of the following:

Frontage: Applies the adjustment to the frontage only.
Depth: Applies the adjustment to the depth only.
Units: Applies the adjustment to the total units.

If no option is selected, the adjustment applies to the total size.

CAMA Adjustment Element Category Validation Codes

The setup for this element category is the same as the general setup for all Mass Appraisal Land Adjustment Validation Codes. See Common Setup for Land Adjustment Validation Tables and Codes.

Feature Element Category Validation Tables and Codes

The Feature Element Category is used for including a description with the adjustments in the Land Information Adjustments tab.
Land Adjustment Validation Tables: Feature Element Category

The Feature Element category has fewer parameters than the Adjustment or Rate Adjustment categories. This category is not used in the computation.
For details on completing the following parameters, see Common Setup for Land Adjustment Validation Tables and Codes:

Code
Short Description
Long Description
Table Type
Table Category
Element Category
Table Name
Column Name
Lookup Group Type
Sequence
Land Uses / Land Schedules

Feature Element Category Validation Codes

Code
Short and Long Description
Lookup By

Header Element Category Validation Tables

The Header Element Category is used for adding a heading to the adjustment types in the Land Information Adjustments tab. This is used for separating the adjustments into groups and making them easier to find This element category is not used in the computation. No validation codes are associated with it.

Land Adjustment Validation Tables: Header Element Category

The Header Element category has fewer parameters than the Adjustment or Rate Adjustment categories. It is used for informational purposes only. For details on completing the following parameters, see Common Setup for Land Adjustment Validation Tables and Codes on page 16:

Code
Short and Long Description
Table Type
Sequence
Short and Long Description
Table Category
Element Category
Land Uses / Land Schedules

Rate Adjustment Element Category

The Rate Adjustment Category is similar to the Adjustment category. The difference is that if you are setting up matrices or links, you can create groups of rate adjustments. These are used to facilitate the computation and data entry.
Land Adjustment Validation Tables: Rate Adjustment Element Category

Group
The Group option is designed to facilitate the setup of Rate Adjustment matrices and links. Enter a number in the Group field beside all tables that you want to include in the same group.
If you create groups, all tables in a matrix, link, or average must be in the same group.

Rate Adjustment Validation Codes

All the parameters used in the Rate Adjustment category are used in the Adjustment Category with the exception of the Group. For details about the common parameters, see Common Setup for Land Adjustment Validation Tables and Codes.

103-ma-parm-Tables-LandAdjust

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

MA – Tables – Links Option – Example A

Mass Appraisal Tables Links Option – Example A

Example A – Land Adjustment based on Location

In this example, location factor 2 is linked to factor 1 and location factor 3 is linked to factor 2.
The computation is done in reverse order.

Land Adjustment Setup

The following land adjustment tables (a) are used to create a Land Adjustment Matrix

Sequence	Table	Column	Description
752	LOCATION	L_01	Location Factor Average 1 of 3
754	LOCATION	L_02	Location Factor Average 2 of 3
756	LOCATION	L_03	Location Factor Average 3 of 3

In this example, the same location codes set up as percent are used.

Factor#1 – seq 752 Location Math = ‘+’ / Percent		Factor #2 – seq 754 Location LINK to 1 Math = ‘-‘ / Percent		Factor #3 – seq 756 Location LINK to 2 Math = ‘x’ / Percent
A=10% B=20% C=30%		A=10% B=20% C=30%		A=10% B=20% C= 30%

The records are processed (computed) in reverse order as such in this example.

	A Math = ‘+’	B Math = ‘-‘		C Math = ‘x’
Step 1		RESULT = 6	X	(B X C) / 100 (20 X 30)/100
Step 2		A – (A*result/100) 10-(0.60)
Step 3	RESULT = 9.40

Results

Results are displayed on the first sequence of the linked group

103-ma-parm-Tables-LinksOption-ExA

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

MA – Tables – Link Option

Mass Appraisal Tables – Link Option

Specification

Links are used to provide a single value based on multiple values processed mathematically together.

The resulting amount or percentage is applied to the land, building or building area value and displayed on the first sequence of the group.
The computation is done in reverse order.
The results are displayed on the lowest sequence of the link group

Difference between the Link and Average Options

Linked table code values will be processed together mathematically
Averaged table group values will be added together and divided by the number of entries in the average group.

Setup

The records are linked together by specifying the prior sequence record it is linked to.

The first record in the linked group does not have the option LINK checked.
The second record in the linked group has the option LINK checked and it is linked to the first record.
The third record in the linked group has the option LINK checked and it is linked to the second.
The fourth record in the linked group has the option LINK checked and it is linked to the third.
Repeat the pattern for all linked entries.

Example

Example A
Link Example A – LAND ADJUSTMENT LINKS (Table LOCATION)
In this example, the same table is use to provide percentage to the land adjustment sequences.

Computation

The information is extracted from the technical computation specifications. Click here to access the full Land Value or Building Value computation technical documentation.
Land
We perform the link calculation of MA_LAND.(MA_TABLES.COLUMN_NAME)_AM by selecting all MA_TABLES.LANDADJT_LINK = -1
The link operation is based on the MA_TABLES.MATHS operator (+,-,X,/) AND MA_TABLES.PCT_AMT and is performed and stored on the column pointed by MA_TABLES_LAND.ADJT_POINTER based on the number of entries..
All the other columns are set to NULL.

Example: MA_TABLES has 5 land adjustment rates and MA_LAND has the following values
MA_LAND.ADJ10_AM = 8
MA_LAND.ADJ20_AM = 2
MA_LAND.ADJ30_AM = 6
MA_LAND.ADJ40_AM = 0.6
MA_LAND.ADJ50_AM = 3

First Link is calculated as (8+2) X 0.6 = 6 so the result will be stored in MA_LAND.ADJ10_AM

Second link is calculated as 6-3 = 3 so the result will be stored in MA_LAND.ADJ30_AM
MA_LAND.ADJ10_AM = 6
MA_LAND.ADJ20_AM = NULL
MA_LAND.ADJ30_AM = 3
MA_LAND.ADJ40_AM = NULL
MA_LAND.ADJ50_AM = NULL

Building

103-ma-parm-Tables-LinksOption

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

MA MRA FMV

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

[Version 6.1]

Overview

The MRA Elements table is used for defining the elements on which the MRA or Fair Market Value of the building or property is based.
Before creating a Fair Market Value Elements validation table, you need to set up the Fair Market Value MRA Model Tables and Codes.

MRA Elements Table

Table Type

This parameter displays the validation table type selected from the Code Selection list box. For the MRA Elements Validation Codes form, this is MRA Elements.

Table Name

Enter a name for the table. The system creates a table called VT_USR_<table name>, where table name is the name you have entered. The table name can be any combination of alphanumeric characters and must start with a alphabetical character. You cannot use special characters.

Sequence

By default, this parameter displays the last sequence number plus one. The sequence determines the order the market element is displayed on the MRA form in Govern.

Short Description

The short description is used for fast data entry and look-ups and is displayed on forms if space is too limited for the long description. The short description for the validation table appears on the caption for the Codes form and under the Market Element Name column of the Fair Market Value Information form in Govern.

Long Description

The long description is used for look-ups and is displayed on forms and reports.

Column Name

Enter a name for the column. The table is saved in MA_BUILDINGS by this column name and by year it is created.

Table Category

This parameter displays the Table Category. The category for the Fair Market Value Models and Elements is Market (Table: VT_SY_ MATBCAT).

Apply to MRA Models

This list box displays the MRA (or Fair Market Value) Models defined on the MRA Model Validation Codes form. Select the model or models for which you are creating the elements.

Formatting

Select the Value Format mask to apply to the calculated value showed in the grids (adjustments and elements). See Value Format Editor.

MRA Elements Table Codes

Table Name

This parameter displays the table name for the current validation table.

Element Code

Enter a name for the structural element code. The structural element codes are displayed on theMA – MRAform in Govern. The user selects a code by clicking in the parameter and selecting an item from the drop-down list. The applicable value is displayed in the Values column.

Short Description

The short description is displayed on forms.

Long Description

The long description is displayed for look-ups and on forms and reports.

Value Expression

Click the ellipsis button to open the Expression editor and create an expression for the element code.

103-ma-parm-Tables-MRA

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

MA – Tables Lookup by Matrix ex. B

Mass Appraisal Tables Lookup by Matrix – Example B

Example B

Land Rate Adjustment ‘r’ with Matrix Lookup

MATRIX B – Rate Adj. ‘r’ + % using different tables
The following land adjustment tables were used to create the Matrix

Level	Table	Column	Description
742	MATB_1	MatrixB_1	Code A, B, C
744	MATB_2	MatrixB_2	Code A, B, C
746	MATB_3	MatrixB_3	Code 1, 2, 3 with MATRIX option Level 742 + 744

The following Matrix is created (Repeated for each different code in the MATRIX Table

Code	MATB_1	MATB_2	Exclude Value	Use Default	Adjustment Value
1	Default	Default			01
	A	A	X
	A	B		X
	A	C			21
	B	A			25
	B	B			24
	B	C			23
	C	A	X
	C	B		X
	C	C		X
2	repeat combination
3	for each code

Result in Land Adjustment Form

Selecting Code B in level 742 and Code A in level 744 and Code 1 level 746 will result in the value 25.

103-ma-parm-Tables-Matrix-EX-b

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

MA – Tables Lookup by Matrix Option

Mass Appraisal Tables Lookup by Matrix Option

Specification

The Matrix is used to provide a multi-level combination of codes valuation.

The matrix option is available in Land Adjustments and Building Structural Elements
The matrix is setup on the last sequence of the Matrix group combination
The value is displayed on this sequence in Govern’s Land Adjustment and Building Structural Element grids
Table and Columns used as a Matrix Level must have a lower computation sequence
The Matrix can be setup with tables using the same MA lookup groups
The Matrix can be used with tables using UNIT/AREA lookup (roadmap)

When using the same table and column in Land and Building …

See Allow Multiple Sequence to Use the Same Column for different models (when Associate SE to Model is selected)

See also Link, Average and Group Options

Setup

Matrix are setup in Govern Administrator (GNA), Application Configurations, Land Adjustments or Building Structural Elements.
The tables or sequences used must be lower in sequence than the table sequence where the matrix is setup.

Examples

Example B
Land Rate Adjustment Tables ‘r’ with Matrix Lookup

103-ma-parm-Tables-Matrix

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

MA – Rounding Tables

Mass Appraisal Rounding Table

Overview

Use the Mass Appraisal Rounding Validation Table to set the nearest value to round to for mass appraisal values. You can set different options for rounding the following Mass Appraisal values:
Values Rounding occurs on

Appraised Value: Appraised Value
Assessment Value: Total Value
Building Area Size: Area of each structural element
Building Values: Replacement Cost New Less Depreciation (RCNLD)
Comparable Sales: Comparable Value
Gross Living Area Market: Gross Living Area Market Adjustment
Income Values: DIR/GRM Income Values
Land Values: Total Land Value
Lookup Area Size: Values entered in Up to Units fields are rounded.
Market Value (MRA): Total Value
Misc. Structures Values: Miscellaneous Structures Total Value

You can set up different rounding values by lookup group. For example, you can different expressions for rounding values according to jurisdiction and neighborhood.

The Mass Appraisal Rounding table is saved in the database as follows:

In MA_TABLES by year and the table name maround
In VT_USR_MA_TABLE by year, short description, long description and a maround0 as the code

Codes are saved to:

VTUSR.MAROUND
MA_PARM_MAROUND

Accessing the Rounding Validation Table

To access the Rounding Validation Table:

Launch GNA.
Select Application Configurations > Mass Appraisal > Table Maintenance > Single Entry.
The Rounding Table is listed at the top of the treeview as all -maround.
Select all-maround.

Rounding Validation Table Icons

The New, Save, and Delete icons are disabled for the Mass Appraisal Rounding table. This is a single system table. You cannot create a new table, or new codes or delete the existing table or codes. You can change the lookup group and the expression for the rounding.
Codes: Click the Codes icon to view or modify the rounding codes.

Rounding Validation Table 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.
Table Type: This field displays Rounding Table or this table type.
Table Category: This field displays the table category. The category for the Rounding validation table is All Categories (Table: VTSY.MATBCAT).
Lookup Group Type: Select a lookup group type for the rounding. This can be any of the following.
The same lookup group type applies to all rounding codes.

Rounding Validation Codes

A validation code exists for each Mass Appraisal value listed under type of Rounding validation code for each type of value that requires rounding. The value for the rounding is defined as an expression.

Rounding Validation Codes Icons

The New and Delete icons are disabled. You can create only one rounding code for each value. The values are defined in the system table: VTSY.MARND.
If you modify any information, the Save and Cancel icons are displayed.

Rounding Validation Codes Parameters

To set up the rounding values:

Click the Codes icon on the Mass Appraisal Rounding validation table form.
Select a value from the treeview on the left:
Create the lookup group types for jurisdictions, neighborhoods, income neighborhoods, or property types as applicable. See Lookup Group Type.
Select the ellipsis button to open the Expression Selector.
Enter an expression for the rounding.

For example, enter 100 to round the value up to the nearest $100. Values are rounded up. $12,548 is rounded to $12,500. $12,560 is rounded to $12,600.
You could create a more complex expression using any combination of attributes, values, or functions.

103-ma-parm-Tables-Rounding

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