MA – Tables – Averages option

Mass Appraisal Tables – Averages Option

Specification

Averages are used to provide a single value based on the average of multiple entries.
Can be setup for Land Adjustments and Buildings Rate and Cama adjustments

See also Links Options

Setup

Averages are setup with the first entry in the group.
For instance, Sequence 100, 200 and 300 should be averaged.

  • Sequence 200 will be set to average and linked to 100.
  • Sequence 300 will be set to average and linked to 100.

 

Example

Example A – Land Adjustment Averages – Amount

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

Sequence Table Column Description
810 QUALAVG A_01 Quality 1 of 3
812 QUALAVG A_02 Quality 2 of 3
814 QUALAVG A_03 Quality 3 of 3

In this example, the same quality average table is used. Sequence 814 is linked to 810 and 812 is linked with 810.

Quality #1
Math = ‘+’ / Amount
Quality #2
Math = ‘+’ Amount
Quality #3
Math = ‘+’ / Amount
A=50000
B=25000
C=10000
A=50000
B=25000
C=10000
A=50000
B=25000
C=10000

The result = 50,000 + 25,000 + 10,000 = 85,000
85,000 / 3 = 28,333.33 rounded to 28, 334.

Computation

Average Calculation

Click here for the complete Land Value or Building Value Computation page.

Land

We perform the average calculation of MA_LAND.(MA_TABLES.COLUMN_NAME)_AM by selecting all MA_TABLES.LANDADJT_AVG = -1
The average 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 = 7
MA_LAND.ADJ20_AM = 5
MA_LAND.ADJ30_AM = 8.5
MA_LAND.ADJ40_AM = 3
MA_LAND.ADJ50_AM = 9.5

COMPUTATION_SEQ | COLUMN_NAME | LANDADJT_AVG | LANDADJT_POINTER
10 ADJ10 NULL NULL
20 ADJ20 -1 10
30 ADJ30 NULL NULL
40 ADJ40 -1 10
50 ADJ50 -1 30
Average is calculated as (7+5+3)/3 = 5 so the result will be stored in MA_LAND.ADJ10_AM
Average is calculated as (8.5+9.5)/2 = 9 so the result will be stored in MA_LAND.ADJ30_AM
After this step the values are
MA_LAND.ADJ10_AM = 5, MA_LAND.ADJ20_AM = NULL, MA_LAND.ADJ30_AM = 9, MA_LAND.ADJ40_AM = NULL, MA_LAND.ADJ50_AM = NULL

 

 

103-ma-parm-Tables-Averages

 

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

 

 

MA – Tables – Group Option

Mass Appraisal Tables – Group Option

Overview

The group option is available only for land adjustments.
Groups calculation is based on all land adjustments with a GROUP and uses MA_LAND.(MA_TABLES.COLUMN_NAME)_AM by selecting all MA_TABLES.LANDADJT_GROUP NOT NULL
The goal of the group rate calculation is to come up with one rate adjustment for all groups.
The resulting rate adjustment is stored on the first entry having a group. Conceptually, the system process each entry in a group to come up with a group total.
The final value is the average of all group totals

Example MA_TABLES has 6 land adjustment rates that have groups and MA_LAND has the following values
MA_LAND.ADJ10_AM = 1
MA_LAND.ADJ20_AM = 2
MA_LAND.ADJ30_AM = 3
MA_LAND.ADJ40_AM = 4
MA_LAND.ADJ50_AM = 5
MA_LAND.ADJ50_AM = 6

COMPUTATION_SEQ | COLUMN_NAME | LANDADJT_GROUP | MATHS | PCT_AMT
10 ADJ10 100 + a
20 ADJ20 100 + a
30 ADJ30 100 X a
40 ADJ40 200 + a
50 ADJ50 200 X a
60 ADJ60 200 + a

First group is calculated as (1+2) X 3= 6
Second group (4X5) + 6 = 26
Group average is performed (26+6) /2 = 16 so the result will be stored in MA_LAND.ADJ10_AM.
NOTE: The MATHS operator is ignored for the first amount of each group.

MA_LAND.ADJ10_AM = 16
MA_LAND.ADJ20_AM = NULL
MA_LAND.ADJ30_AM = NULL
MA_LAND.ADJ40_AM = NULL
MA_LAND.ADJ50_AM = NULL
MA_LAND.ADJ60_AM = NULL.

 

 

103-ma-parm-Tables-GroupOption

 

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

 

MA – Shared Table and Column Names

 

CAMA Creating Elements with the Same Table and Column Name

Overview

In Govern OpenForms, you can create two or more Mass Appraisal Building Structural Elements or Land Adjustments that have the same table name, but different column names. This can be useful for creating a breakdown by percentage for elements or adjustments.

It is possible to create two or more tables that have both the same table name and the same column name. However, this is not a recommended setup. The following conditions apply:
Building Structural Elements are applied to different models.

  • All Models must be different, not just the combination.
  • Land Adjustments are applied to different land uses or land schedules.
  • All land uses or schedules must be different, not just the combination.

The tables have different sequence numbers.
This is not a recommended configuration. If two or more elements share the same table and column name, they can be overriden with the worng element if a user makes a change in Govern.

For a pdf version of this page, open the following document.
SameColumnDifferentModel.pdf

Configuration for Building Structural Elements

To use this feature, ensure that the Apply Structural Elements to Models option is selected in GNA.
To enable this option.

  1. Launch GNA.
  2. Select Application Configurations > Mass Appraisal > MA General Parameters.
  3. Select Page 2.
  4. Select the Associate SE to Models option.
  5. Click Save.

Configuration for Land Adjustments

Land Adjustments can be associated with either Land Uses or Land Schedules.
To enable one of these options:

  1. Launch GNA.
  2. Select Application Configurations > Mass Appraisal > MA General Parameters.
  3. Select Page 2.
  4. Select one of the following:
    Associate Land Adj. to Land Uses.
    Associate Land Adj. to Land Schedules
  5. Click Save.

 

Creating Mass Appraisal Tables with the Same Table and Column Name

Building Structural Elements

To set up the tables:

  1. Launch GNA.
  2. Select Table Maintenance > Building Structural Elements.
  3. Click New to create a new table.
  4. Select any element type, other than Header, from the Element Category field.
  5. Enter the Table Name and Column Name.
  6. Complete the other parameters as required.
  7. Select one or more models under Apply to Models.
  8. Click Save.
  9. Repeat steps 3 to 8 as many times as required to create additional tables.
    Enter the same table name and the same column name for each table.

Ensure that all models in all tables are different.
If any are repeated, a validation error appears.

Land Adjustments

To set up the tables:

  1. Launch GNA.
  2. Select Table Maintenance > Land Adjustments.
  3. Click New to create a new table.
  4. Select any element type., other than Header, from the Element Category field.
  5. Enter the Table Name and Column Name.
  6. Complete the other parameters as required.
  7. Do one of the following:
    Select one or more land uses under Land Uses.
    Select one or more land schedules under Land Schedules.
  8. Click Save.
  9. Repeat steps 3 to 8 as many times as required to create additional tables. Enter the same table name and the same column name for each table.

Ensure that all land uses or land schedules in all tables are different.
If any are repeated, a validation error appears.

 

 

103-ma-parm-shared-columns

 

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

103-ma-parm-General-5

MA General Parameters Page 5 tab

Version 6.1

Overview

In Development.

 

 

103-ma-parm-General-5

 

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

MA General Parameters Page 6 tab

MA General Parameters Page 6 tab

Version 6.1

Overview

In Development.

 

 

103-ma-parm-General-6

 

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

MA – Land Use Parameters

Mass Appraisal Land Use Parameters

Overview

The Mass Appraisal Validation Table for Land Use Codes is used for setting up categories based on how the land is used. These can be applied by Property Type and can be defined as Agricultural. Examples include Leased Land, Undeveloped, Wetland, and Vineyard. There is no rate or value included in the setup for these codes. Both a land rate schedule, which determines the value, and a land use code are applied to each land record.

Accessing the Land Use Validation Table

To access the MA Land Use Validation Table:

  1. Launch GNA.
  2. Select Application Configurations > Mass Appraisal > Table Maintenance > Single Entry Tables.
  3. Select land-landuse from the drop-down list.

The Land Adjustments validation tables can be associated with the land use validation codes. In this case, only the adjustments that apply to the Land Use that is selected on the Land Information General form are displayed in the Adjustments tab.

The following are added to the database for the Mass Appraisal validation table for Land Use:

  • An entry in MA_TABLES, listing the year and landuse
  • A table named VT_USR_LANDUSE
  • An entry for each validation code in the table MA_PARM_LANDUSE
  • An entry in VT_USER_MA_TABLE, listing the year, the long and short description and the column name.

Land Use Validation Table Icons

The New and Delete icons are disabled for the Mass Appraisal Land Use Validation Table. This is a unique table. You cannot create a new table or delete the existing table.
Save
Click Save to save modifications to the short and long descriptions and the lookup group type.
Codes
Click the Codes icon to view or modify the validation codes.
Exit
Click Exit to close the form.

Mass Appraisal Land Use Codes Validation Table Parameters

Year
The year for the Land Use Validation Table is displayed on the tab at the top of the form.

You can view the land rate schedule validation table for multiple years at the same time. To do this, select the Year menu and enter the year that you want to access in the Current Year field. Then, open a new version of the form.

Code
The Land Use Validation Table is saved as land – land Use Codes.
Short Description
Enter a short description.
Long Description
Enter a long description. This is used for lookups and is displayed on forms and reports.
Table Type
For the Land Use Codes, this field display landuse – Land Use Codes.
Table Category
This field displays the table category. The category for the Land validation tables is land – Land.

Land Use Validation Codes

The Mass Appraisal Validation Codes for Land Use are used for defining the details for each land use category.

Mass Appraisal Land Use Codes Validation Codes IconsNew
Click New to clear the form and create a new record.
Saving a Code
Click Save to save a new record or modifications to an existing one.
Deleting a Code
Click Delete to remove the current record.
Exit
Click Exit to close the form.

Mass Appraisal Land Use Codes Validation Codes Parameters

Year
The year is displayed for the MA Land Use Validation Table at the top of the form. In order to view codes in a different year, you need to open the table in a different year.
Code
Enter a unique combination of alphanumeric characters to identify the Land Use validation code. The codes are listed in ascending order in the Land Use drop-down list on the Land Appraisal Information form.
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.
Property Type
Select a Property Type from the drop-down list if you are defining the code for a specific property type (Table: VT_USR_ PROPTYPE).
Agricultural
Select this option, if the code is applicable to agricultural land.

If the Agricultural field is selected, the Land Use code is included in a separate agricultural calculation and is not part of the regular Land Information computation.

 

 

103-ma-parm-LandUse

 

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

MA – Building Use Table

Mass Appraisal Building Use Table

(In Development)

Overview

Also referred to as Building Style, the Building Use Code Table (MA_PARM_BLDGUSE) defines the starting building area rates and default depreciation tables to use.
These rates can be applied by number of units or as a flat rate. The system creates a table called VT_USR_BLDGUSE.

The table can be setup by group, property type — now setup as a MA Link Group, building model and sub model with a flat rate or rate per unit (up to units).
The rate per unit is calculated differently, according to how the Skip Rates Interpolation option that is set on the Mass Appraisal General Parameters form.
See Skip Rates Interpolation.

Building Use Table Parameters

Year

  • This field displays the year selected for the current validation table and cannot be changed.

Group

Code

  • Enter the Code. The user selects the code when entering data on the xxx

Short Description

  • Enter a short description.

Long Description

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

Bldg Model Code

  • This option is displayed only if the Model Table Lookup field is selected for the current validation table. Select the model code to apply to the code from the drop-down list (Table: VT_USR_MODEL). This field is useful for associating different costs with the same structural element, for different models; for example for different types of buildings.

Sub-Model Code

  • This option is displayed only if the Sub Model Lookup field is selected for the current validation table. Select the submodel code to apply to the current validation code from the drop-down list (Table: VT_USR_SUBMODEL). This field is used for associating a secondary model with the code, typically an occupancy type set up through the Mass Appraisal Occupancy validation table.

Property Type

  • Select the property type from the drop-down list. If none is selected, the code is applied to all property types (Table: VT_USR_PROPTYPE)

Depreciation Table

  • Select the Mass Appraisal Depreciation Table for the building type (Table: VT_USR_<table_ name>, where table name is the name assigned to the selected Depreciation table). The depreciation is calculated by subtracting the Effective Year Built, or Year Built, from the Depreciation Year and applying the value from the depreciation table to the number of years.

Max Depreciation Percentage

  • Enter the maximum depreciation percentage to be used if the calculated depreciation is too high.

Up to Units

  • This option appears only if the Units Table Lookup option is selected on the Validation Table form. It is used for setting varying rates according to the number of units.

Rate Expression

  • Enter the rate for the specific building use. The rate entered in this field is applied to the effective area. This total is divided by the Effective Area.

 

 

103-ma-parm-BldgUse

 

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