MA – Land Dimension (Units) Computation

CAMA Land Dimension (Units) Computation

Overview

The purpose of the Land dimension compute is to update the table PC_LEGAL_INFO with the total land dimension information (from all land records) whenever a MA_LAND record is created or modified.
This compute is always the FIRST one called after a save and is always executed immediately from the client PC even if the daemon option is turned on.

Parameters

Registry and Constant

  • USE_METRIC = system_registry (“General”, “use metric”) = (‘yes’ or ‘no’)
  • FULL_SCALE_FORMAT = “Mass Appraisal”, “Land SF to Acres Full Precision” = (‘yes’ or ‘no’)
  • SF_IN_ACRE = 43560 ‘ number of square feet in 1 acre
  • SM_IN_ACRE = 4046. 85642 ‘ number of square meter in 1 acre
  • FEET_IN_METER = 3.2808399 ‘ number of feet in 1 meter

 

Table Used

MA_LAND

  • MA_LAND. LUSE_CODE -> MA_PARM_LANDUSE.LUSE_CODE
  • MA_LAND.P_ID -> PC_LEGAL_INFO.P_ID
  • MA_LAND.P_ID -> PC_PARCEL.P_ID (Only if the jurisdiction is part of the MA_PARM index)
  • MA_LAND.P_ID -> PC_AREA.P_ID (Only if the neighborhood or commercial neighborhood is part of the MA_PARM index)

 

Compute Logic

Updates only occur when the columns use to compute the land dimensions have been modified by a user.
When this occurs the following logic is applied for ALL land records associated with a given P_ID in order to replace the existing information in PC_LEGAL_INFO.
Because land calculations can be based on the total dimension information, we need to make sure the MA_LAND.MODIF_STAMP is reset to NULL for all records associated with a given P_ID when update to PC_LEGAL_INFO are made.

The update logic is applied if one of the following situations is TRUE:
1) MA_PARM_LANDUSE.Agricultural = 0 (or NULL) AND MA_LAND.exclude_lot_size = 0 (or NULL) AND ( MA_LAND. lot_size or MA_LAND. lot_units_type ) has changed.
2) MA_PARM_LANDUSE.Agricultural = 0 (or NULL) AND MA_LAND. exclude_frontage = 0 (or NULL) AND (MA_LAND. Frontage or MA_LAND. lot_units_type ) has changed.
3) MA_PARM_LANDUSE.Agricultural = 0 (or NULL) AND MA_LAND. exclude_depth= 0 (or NULL) AND (MA_LAND. Depth or MA_LAND. lot_units_type) has changed.

If one of the above case is true, we perform this for each MA_LAND record.
We are updating up to 9 columns in PC_LEGAL_INFO. If no PC_LEGAL_INFO record exists for the combination P_ID, YEAR_ID and FROZEN_ID then a new record is created.

  • PC_LEGAL_INFO.front_size
  • PC_LEGAL_INFO.depth_size
  • PC_LEGAL_INFO.front_size_unit
  • PC_LEGAL_INFO.size_1
  • PC_LEGAL_INFO.size_1_unit
  • PC_LEGAL_INFO.size_2
  • PC_LEGAL_INFO.size_2_unit
  • PC_LEGAL_INFO.size_t
  • PC_LEGAL_INFO.size_t_unit

 

USE_METRIC = “yes”

PC_LEGAL_INFO.front_size (2 decimals) =
sum of MA_LAND.frontage where MA_LAND. exclude_frontage = 0 (or NULL) and ( MA_LAND.lot_units_type = ‘sm’ or MA_LAND.lot_units_type = ‘h’)
+
sum of ( MA_LAND.frontage / FEET_IN_METER) where MA_LAND. exclude_frontage = 0 (or NULL) and ( MA_LAND.lot_units_type = ‘a’ or MA_LAND.lot_units_type = ‘sf’)

PC_LEGAL_INFO.depth_size (2 decimals) =
sum of MA_LAND.depth where MA_LAND. exclude_depth= 0 (or NULL) and ( MA_LAND.lot_units_type = ‘sm’ or MA_LAND.lot_units_type = ‘h’)
+
sum of ( MA_LAND. depth / FEET_IN_METER) where MA_LAND exclude_depth = 0 (or NULL) and ( MA_LAND.lot_units_type = ‘a’ or MA_LAND.lot_units_type = ‘sf’)

If at least one value is calculated for front_size or depth_size then PC_LEGAL_INFO.front_size_unit = ‘m’

PC_LEGAL_INFO.size_1 (2 decimals) =
sum of MA_LAND.lot_size where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘sm’
+
sum of ( MA_LAND.lot_size X 10000 ) where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘h’
+
sum of ( MA_LAND.lot_size X SM_IN_ACRE ) where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘a’
+
sum of ( MA_LAND.lot_size / (FEET_IN_METER * FEET_IN_METER) ) where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘sf’

PC_LEGAL_INFO.size_2 = NULL
PC_LEGAL_INFO.size_t = PC_LEGAL_INFO.size_1
If at least one value is calculated for size_1 then PC_LEGAL_INFO.size_1_unit = ‘sm’ and PC_LEGAL_INFO.size_t_unit = ‘sm’

USE_METRIC = “no”

PC_LEGAL_INFO.front_size (2 decimals) =
sum of MA_LAND.frontage where MA_LAND. exclude_frontage = 0 (or NULL) and ( MA_LAND.lot_units_type = ‘a’ or MA_LAND.lot_units_type = ‘sf’)
+
sum of ( MA_LAND.frontage X FEET_IN_METER) where MA_LAND. exclude_frontage = 0 (or NULL) and ( MA_LAND.lot_units_type = ‘sm’ or MA_LAND.lot_units_type = ‘h’)

PC_LEGAL_INFO.depth_size (2 decimals) =
sum of MA_LAND.depth where MA_LAND. exclude_depth= 0 (or NULL) and ( MA_LAND.lot_units_type = ‘a’ or MA_LAND.lot_units_type = ‘sf’)
+
sum of ( MA_LAND. depth X FEET_IN_METER) where MA_LAND exclude_depth = 0 (or NULL) and ( MA_LAND.lot_units_type = ‘sm’ or MA_LAND.lot_units_type = ‘h’)
If at least one value is calculated for front_size or depth_size then PC_LEGAL_INFO.front_size_unit = ‘sf’

PC_LEGAL_INFO.size_1 (2 decimals)
sum of MA_LAND.lot_size where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘sf’
+
sum of ( MA_LAND.lot_size X FEET_IN_METER * FEET_IN_METER ) where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘sm’

PC_LEGAL_INFO.size_2 (2 decimals)
sum of MA_LAND.lot_size where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘a’
+
sum of ( MA_LAND.lot_size * 10000 / SM_IN_ACRES) where MA_LAND. exclude_lot_size = 0 (or NULL) and MA_LAND.lot_units_type = ‘h’

PC_LEGAL_INFO.size_t (2 decimals if FULL_SCALE_FORMAT = ‘no’ or 15 decimals if FULL_SCALE_FORMAT = ‘yes’) = ( PC_LEGAL_INFO.size_1 / SF_IN_ACRES ) + PC_LEGAL_INFO.size_2
If at least one value is calculated for size_1 then PC_LEGAL_INFO.size_1_unit = ‘sf’ and PC_LEGAL_INFO.size_t_unit = ‘a’

If at least one value is calculated for size_2 then PC_LEGAL_INFO.size_2_unit = ‘a’ and PC_LEGAL_INFO.size_t_unit = ‘a’

 

 

101-ma-compute-LandUnits

 

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 – Appraisal Linking

CAMA Appraisal Linking

Overview

Parcel Linking

The Parcel Linking function is used for linking a group of parcels. These parcels can be assessed and assigned values based on total area rather than
on a per parcel basis, with the Mass Appraisal module. This function can be used, for example, to maintain data on a condominium complex.
Define the complex as the master parcel and link each unit to it. Enter a percentage for each unit; then, use the Appraisal Linking option to calculate
the values. Alternately, you can enter a value and a percentage for each unit and use this option to calculate the value of the master parcel. For additional details, see Parcel Linking

 

 

101-ma-frm-003

 

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 – CAMA Drawing (non-Apex)

CAMA Drawing (non-apex)

[ Deprecated]

Overview

The function has been replace with the APEX building drawing feature.

 

 

101-ma-frm-004

 

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 – CAMA Building Drawing Apex

CAMA Building Drawing Apex

Overview

The Building Drawing Apex form is used for creating and displaying drawings of the areas within the selected building. It calculates and displays the area and perimeter of the structural elements, by element type. It provides totals for the building,

Prerequisite Forms

Before creating a Building Drawing, you need a Buildings record.

Accessing the Building Drawing Form

To access the Drawing form:

  1. Open a Profile with Mass Appraisal Drawings.
  2. Select the Mass Appraisal Drawing form in the Forms Explorer.
  3. Perform a search and load the property to the form.

The Building Drawing form has two dividers: Drawing displaying the drawing created in the Apex application and the Building Area showing the calculated areas and other building drawing dimensions in grid format.

Building Drawing Icons

Browsing Building Drawing Records

If multiple building drawing records exist for the property, use the right and left navigational arrows to scroll to a specific record.

Saving the Building Drawing Record

Click the Save icon to save a new record or any modifications to an existing one.

Open Apex

Click the Open Apex icon to open the Apex application and create or update a building drawing.
Double-clicking in any white area within the building drawing opens the Apex application as well.

Refresh

Click the Refresh icon to refresh the drawing in the Building Drawing form.
The new and delete icons do not exist on the Building Drawing form. Drawings are created and deleted from the Buildings form.

The Drawing function allow the user to view the building drawing of the selected building. The user can launch Apex to edit the drawing. If the user wants to keep the changes, he must save in govern after the changes in Apex. The areas will be recalculated and updated in the two area tables.
Roll forward will be made, but the drawing and the areas we always replaced.

See Also

Product Knowledge 3rd party APEX (303)

R&D Employees

 

 

101-ma-frm-005

 

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 – CAMA Building Area

CAMA Building Area

Overview

The Building Area divider lists the building areas added to the building drawing in either Govern Sketch and Apex, depending on the application you are using. It totals the areas for each code and lists them under the following headings: Area Code, Base Area, Actual Area, Heated Area, Percent Heated, Perimeter, Living Area, and Effective Area. It lists the following details for each code. This information is saved to MA_BLDG_AREA:

Documentation

To view this information in pdf format, click on the following link:
UsrBuildingsArea.pdf

Overriding the Building Area State

The Building Area divider has two states:

Override State
In this state, you can add, update, and delete building area codes in the Building Area grid. When you are in this state, the Block Area Override icon is visible. Click this icon to do the following:

  • Prevent users from making any modifications to the data on the grid.
  • Reset the Building Area grid
NOTE: When you click the Block Area Override icon, the application resets the Building Area grid. All the existing overrides are removed. The grid is populated from the building areas drawn on the Drawing Editor.

Normal State
In this state, you cannot add, update, or delete the building areas codes in the Building Area grid. This is the default state before any modifications are made to the Building Area grid. The Allow Area Override icon is visible. Click the Allow Area Override icon to permit users to add, modify, and delete building area codes in the grid.

Building Area Icons

New: Click the New icon to add a new area code for the building. For the Drawing Area calculation, this is the same as adding a new area in the Govern Sketch or Apex drawing editor. The added area is used in the calculation; however, it is not added to the drawing or sketch on the editor. See Area. To add a new row, select the last row in the list. click the Allow Building Area Modifications icon and click the New icon.

Cancel: The Cancel icon is displayed when you click New. Click Cancel icon to remove a new unsaved row.

Overriding the Building Area Tab

The Building Area tab has two states, an override state in which you can add, modify, and delete areas to the building and a blocked state.
Save
Click the Save icon to save a new entry or modifications to an existing one.
Delete
Click the Delete icon to remove a saved row.

Viewing Building Area Records

The Building Area divider displays values for each area code by Base Area, Actual Area, Heated Area, Percent Heated, Heated, Perimeter, Living Area, Effective Area, Building ID, and Building Sequence:

Totals are provided for each column. These totals are also displayed on the Building Structural Elements and Features Values tab of the form.
Base Area
This column provides the area defined for the area code by a drawing tool.
Actual Area
This column displays the Base Area multiplied by the Actual Rate as defined in the Actual Area % field on the Drawing Area Codes form

Actual Area = Base * Actual Area %

Heated Area
This column displays one of the following options: Heated, Not Heated, or Partially Heated to indicate the area of the building that is heated.
Heated %
This column displays the percentage of the area that is heated as defined in the Heated field on the Drawing Area Codes form, as follows:

  • If Not Heated is selected in the Heated field, no value is displayed in the Heated % field.
  • If Heated is selected in the Heated field, 100% is displayed in the Heated % field.
  • If Partially Heated is selected in the Heated field, -1 is displayed in the Heated % field and a double asterisk is displayed beside the area code.

For Partially Heated:

  1. Double-click anywhere in the row beside the area code.
  2. Enter a percentage in the Heated Structure text box.
  3. Click OK.

This text box appears when Partially Heated is selected under Heated

Perimeter
This column displays the perimeter of the area if Perimeters is selected on the Drawing Area Codes form. This is also displayed in the Structural Element grid on the Building Drawing Edit form.

If a row for a structural element is grayed out, the values are not included when the total amounts are calculated. See Exclude From Computation on page 110 in the Administrator section.

Living
This column displays the value in the Actual column if Living Area is selected on the Drawing Area Codes form (Base * Actual %). Otherwise, no value is displayed. In the final calculation for the building this value determines the percentage of the actual area that can be calculated as living space.
Building ID
This field displays the Building ID defined for the property on the Buildings record.
Building Sequence Number
This field displays the Building Sequence Number defined for the property on the Buildings record.
Negative Area
Negative areas are displayed on the Building Area tab if codes with negative area are drawn. Typically, negative areas are used to represent areas, such as a stairwell or courtyard that do not need to be included in the overall area of the building. The following screen shot includes codes with negative areas.

 

 

101-ma-frm-012

 

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 – Site Information

CAMA Site Information

Overview

The CAMA Sites form is used for calculating the site adjustments for a parcel based on location and other geographical information. For example, the proximity to heavy traffic, green spaces, or schools can have an influence on the appraised value of a parcel. The Site Adjustments are defined in GNA and associated with the mass appraisal land, building, miscellaneous structure, personal property, or income data record for the parcel. An adjustment can also be associated with all these appraisal records as a group.

See also Site Description setup.

There are two main tabs: CAMA Sites Information (General, Adjustments and Values) and CAMA Sites History. The CAMA Site History divider displays all the CAMA Sites records for the property including the current year record and all records from past and future years, if they exist. Records are displayed by Site Number, Year ID, and Frozen ID. All the appraisal values and adjustments are displayed.
Multiple Site Information records can exist for a parcel.

What’s New

Refer to the Mass Appraisal What’s New Page

[6.1] Site Adjustments can be included in a Mass Appraisal Link Group
[6.1] Site Group Description query in use in other mass appraisal value components (land, building, income, etc.) — see also Site Setup Technical Information
[6.1] Site Value for Personal Property and MRA [10.8] [6.1] Overrides Values: New checkboxes and fields are added to the form for override values. If you enter an override value, it is displayed on the form beside the original calculated value.

Features

Standard

  • Site Adjustments
  • Frozen Records
  • Roll Forward: A message appears when you click Save, prompting you to roll the record forward to future years, if records exist.

Action Buttons
In addition to the standard action buttons, the CAMA Sites form has action buttons for copying the record and refreshing the calculated data,

  • Copy:You can copy a site information record to another property or to multiple properties. There are two ways to do this:Copy with Search: Click the Copy with Search icon to open the Search screen. Then, perform a search and select the property records to which you want to copy the Site Information record.
    Copy to Recordset: Click the Copy to Recordset icon to copy the Site Information record to all the property records in the current record set. A confirmation message appears. Click Yes to continue.

Fields

Site Number
Enter a unique number for the site. This provides a reference for linking the Site Information record to other Mass Appraisal records. The Site Adjustments can then be applied to the land, building, miscellaneous structures, and income data records.

Site Information Grid

All Mass Appraisal Site Adjustment validation tables are listed by Sequence Number, Adjustment Type, Adjustment Code, and Value.
Sequence Number
The sequence numbers are displayed in the left column of the grid. These are assigned in Govern Admin according to the order that the adjustments need to be calculated. If one adjustment is dependent on the result of another, it is assigned a higher number. Adjustments are calculated in order of sequence number; i.e., the adjustment with sequence number two is calculated before number three.
Adjustment Type
The short description from the Site Adjustment Validation Table is listed under the Adjustment Type column
Adjustment Code
Select an adjustment code for each adjustment type that you want to include in the site adjustment. These are the codes created for the Site Adjustment validation table in Govern Admin. Values are defined for these codes.
If you are not selecting a code for an adjustment type, you can enter a description in the Adjustment Code field. No value is attached to this type of entry.
Value
When you click Save, the value corresponding to the selected code is displayed in the Value column.
Overide
Click the override checkbox to enter an override value.
Override Value
Enter an value if you want to override the calculated value.

Adjustments Summary
The CAMA Sites Adjustments divider displays the Site adjustment amounts and percentages for all the CAMA modules: Building, MRA, Income Data, Land, and Miscellaneous Structures.

When you create the Site adjustments in Govern Admin, you can define them for a specific CAMA module or for all CAMA modules. The total amount or percentage for each module is displayed on the Adjustments Summary tab.
These values are listed as amounts or percentages according to how they are defined in Govern Admin. For example, the total of all site adjustments defined as amounts specific to buildings or to all modules is displayed in the Adjusted Bldg. Amount field.
The total of all site adjustments configured as percentages, specific to buildings or to all modules, is displayed in the Adjusted Bldg. Percentage field.
Notes
Add any relevant notes or comments in the Notes field.
CAMA Sites Values
The appraised value for each CAMA module for the site is displayed on the Appraisal Values tab.

The forms on which the values are calculated is listed in this section:
Building Value
This Building Value is calculated on the Building Structural Elements form. Refer to the Govern CAMA: Buildings guide for details.
Miscellaneous Structure Value
This value is calculated on the Building Miscellaneous Structures form. Refer to the Govern CAMA: Miscellaneous Structures guide for details.
Land Value
This Land Value is calculated on the Land Appraisal Information function. Refer to the Govern CAMA: Land guide for details.
Land AG Value
This Land Agricultural Value is calculated on the Land Appraisal Information function. Refer to the Govern CAMA: Land guide for details.
Income DIR Value
This value is calculated on the Income Data form. Refer to the Govern CAMA: Income guide for details.
Building Residual DIR
The Building Residual DIR value is used to determine the building value based on the Income DIR and Land values.
(Building Residual DIR) = (Income DIR Value) – (LAND Value)

where Income DIR = MA_SITE.INCOME_DIR_VALUE and LAND = MA_SITE.LAND_VALUE
The Building Residual DIR calculated for the Site is different from the Building Residual DIR calculated for the Property. Adjustments are applied on the Site Value.

Income GRM Value
This value is calculated on the Income Data form. Refer to the Govern CAMA: Income guide for details.
Building Residual GRM
The Building Residual GRM value is used to determine the building value based on the Income GRM and Land values.
(Building Residual GRM) = (Income GRM Value) – (LAND Value)

where Income GRM = MA_MASTER.INCOME_GRM_VALUE and LAND = MA_MASTER.LAND_VALUE.
The Building Residual GRM calculated for the Site is different from the Building Residual GRM calculated for the Property. Adjustments are applied on the Site Value.

MRA Value
The MRA Value is calculated by the logical expression or formula defined for the market model in Govern Admin.
The MRA Value field is calculated when Market Approach is selected as the Method in Use.
Building Residual MRA
The Building Residual MRA value is used for determining the building value based on the MRA and Land values. It is calculated as
(Building Residual MRA) = (MRA Value) – (LAND Value)

where MRA = MA_MASTER.MRA_VALUE and LAND = MA_MASTER.LAND _VALUE
The Building Residual MRA value is calculated when Market Approach is selected as the Method in Use.
Total Value
This is the sum of all values on this tab.

CAMA Site History

The CAMA Site History tab displays all the CAMA Sites records for the property including the current year record and all records from past and future years, if they exist. Records are displayed by Site Number, Year ID, and Frozen ID. All the appraisal values and adjustments are displayed.

 

 

101-ma-frm-016

 

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 – What’s New

CAMA Mass Appraisal – What’s New

Version 6.0 | 6.1

Overview

The following is a non-exhaustive compilation that lists recently updated topics related to the Govern for OpenFormsTM Mass Appraisal module.

 

What’s New

MA – M&S Valuation Setting Editor (103-ed-025)

Valuation Setting Editor (Marshall & Swift MVP Interface) Available in release 6.1.2211 – (In Development) Overview Marshall & Swift (M&S)

Posted in Developers, Editors, Feature, GNA, Mass Appraisal, Whats New | Tagged , , , , , , , | Leave a comment

TX – BP Load LockBox Entries (101-tx-bp-005)

Load LockBox Entries Batch Process Release 6.1.1912 | 6.0.1904 | 6.0.1903 Overview This batch process will load a payment lockbox

Posted in Batch Process, Configuration, Mass Appraisal, Personal Property Tax | Tagged , , , , , , , , | Leave a comment

MA – Marshall & Swift Copy to Year Batch Process (103-ma-bp-010)

Mass Appraisal (MA) Marshall & Swift Copy to Year Batch Process Overview Marshall & Swift™ offers appraisal guidelines for developing

Posted in Batch Process, Mass Appraisal | Tagged , , , , , , , , , | Leave a comment

MA – BP Taxroll Snapshot (101-ma-bp-012)

Mass Appraisal Taxroll Snapshot Batch Process Release 6.1 Overview The Mass Appraisal Taxroll Snapshot batch process is designed to make

Posted in Batch Process, Configuration, Mass Appraisal | Tagged , , , , | Leave a comment

 

Old News

Read More...

Release 6.1

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

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

Display a Description with the Building Drawing Code

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

Batch Computation

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

Default Alignment on Text and Numeric Attributes

Number Formatting for Appraisal Table Elements

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

Lookup Group Types in Neighborhood

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

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

Mass Appraisal Lookup Groups

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

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

Site is Mandatory for all Appraisal Components

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

Site is a Multi-Field Combination

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

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

Long versus Short Description

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

Do not display Option

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

Forced Unique Default Code Option

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

Is Required

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

Features Table Category

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

Apply To Units/Units Look-Up

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

Simulation (deprecated)

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

Daemon Hybrid Mode for Appraisal Computation (deprecated)

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

Database (see impact list)

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

Exclude from Roll text box

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

Parameters no longer used

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

New Conversion Menu

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

 

See Also

 

 

101-ma-wnew

 

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...