MA Income Model Application Tables

Mass Appraisal Income Model Application Tables

Overview

The CAMA Income Models tables are used to predefine the economic models to use with each property, according to the following properties:

  • Quality
  • Effective year built range,
  • Unit range will drive a desired value for the Economic model and Model name (Used As).

Prerequisites

The following are required:

  • Economic Models
  • Income Category Codes
  • Jurisdictions
  • Neighborhoods
  • Property Types

Accessing the CAMA Income Model Table

To access the CAMA Income Model table:

  1. Launch GNA.
  2. From the GNA ribbon, select Application Configurations (tab) > Mass Appraisal > Table Maintenance > Single Entry Tables.
  3. Select one of the existing Income Models. The Income Model table is a Single Entry Table.
    Note that you cannot create a new one, or delete an existing one. Therefore, the New and Delete buttons are not enabled. Available parameters are:

    Table Type – Displays incmodel – Income Model Application. This parameter cannot be modified from the form.
    Table Category which Displays inc – Income. This parameter cannot be modified from the form.

  4. Update the short and long descriptions in the English and French Short and Long Description fields.
  5. Select a lookup group type from the Lookup Group Type drop-down list.
  6. Click Save.
  7. Click Codes to open the Income Model Application Codes form.

Setting Up the Income Model Application Codes

All existing Income Model Application Codes are listed in the pane on the left hand side of the interface.

Create Income Model Application codes

To create a new Income Model Application code:

  1. Enter a unique code to identify the Model Application code. This can be any combination of alphanumeric and underscore characters. However, it must start with an alphabetic character.
  2. Enter short and long descriptions in the Short and Long Description fields.
  3. Create the lookup types, as described in the CAMA General Information documentation, if applicable.
  4. Select a quality from the Quality Code parameter.
  5. Enter a range of years in the Year Built From and Year Built To parameters.
  6. Enter a range of units in the Units From and Units To parameters.
  7. Select an economic model from the Use Economic Model parameter.
  8. Select a model name from the Model Name field.
  9. Click the Add Model icon to add a new Income Model Application Code.
  10. Repeat steps 4 to 9 to create another code.
  11. Click Save.

Verifying the CAMA Income Model Application Codes

To view the Income Model Application:

  1. Launch Govern.
  2. Open a Profile that contains CAMA Income.
  3. Open the CAMA Income form.
  4. Perform a search and load the required records to the form.
  5. Enter the year built in the Year Built field.
  6. Enter the number of units in the Units field.
  7. Enter the model name in the Category Code field.
  8. Click the Apply Detail Economic Model action button.

The fields for the economic model are displayed on the Income form.

 

 

 

103-ma-parm-incmodel

 

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

Mass Appraisal (MA) Compute Entity Configuration

Version 6.1 [under construction]

Overview

Expressions are used throughout the Mass Appraisal system in order to compute appraised values.The administrator must setup the different business entities used for computations.

  • Income Economic Compute Entity
  • Income Actual Compute Entity
  • Income Detail Compute Entity
  • Land Compute Entity
  • Master Compute Entity
  • Miscellaneous Structures Compute Entity
  • MRA Compute Entity
  • Site Compute Entity
  • Building Structural Elements Compute Entity
  • Building Areas Compute Entity

 

 

103-ma-parm-ComputeEntity

 

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 1 tab

General Parameters Page 1 tab

Version 6.1

Overview

The Mass Appraisal General Parameters form contains parameters and options for configuring the Govern OpenForms Mass Appraisal system. These are divided across the following tabs:

  • Page 1: Yearly Data, General Options, Increase / Decrease, and Transfer to Tax
  • Page 2: Building, Income, and Land
  • Page 3: Comparable Sales
  • Pages 4 and 5: Buildings
  • Page 6: Marshall & Swift

To access the Mass Appraisal General Parameters form:

  1. Launch GNA.
  2. Select Application Configurations > Mass Appraisal > General Parameters.

Documentation

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

Page 1 Parameters

Yearly Data

Year

CAMA parameters are saved by year. Select the year that you want to view or modify from the Year drop-down list.
When you open the MA General Parameters form, the year is automatically set to the current year for GNA. You can select a different year in order to view or modify parameters for that year. This is a requirement for appraisers who are working in multiple years at the same time.
Because the MA General Parameters form is opened in a separate window, you cannot view multiple versions of this form in multiple years at the same time. This is different from other forms that contain data saved by year. For these forms, you can open multiple versions at the same time. For example, the following screen shot shows multiple version of the A/R Class Codes form.

Depreciation Year

The Depreciation Year is used in calculating the depreciation of building structural elements and miscellaneous structures. The calculation is based on a table of percentages defined by the number of years that have lapsed. This is calculated by subtracting the actual or effective year the structure or element was built from the Depreciation Year. Refer to the Mass Appraisal Buildings and Miscellaneous Structures guides for further details.
The Depreciation Year can be the calendar year or any year from which you want to set up depreciation percentages.

Minimum Appraised Value

Enter a minimum appraised value for a property. The definition of Appraised Value depends on the Method in Use. This is selected on the Mass Appraisal Property Information form in Govern. See Mass Appraisal Property Information.

Options

Use Legal Description Property Type for Neighborhood Adjustments

Define this parameter according to how you want to set up neighborhood adjustments. The Neighborhood Adjustment applies to the building, miscellaneous structure, and land values. It is displayed on the following forms:

  • CAMA Building Structural Elements and Features (BSE)
  • Miscellaneous Structures
  • Land Information

It can be based on a Property Type, such as residential, commercial, or industrial. The Property Types are defined in the user validation table VT_USR_PROPTYPE. They are associated with neighborhoods through the Mass Appraisal Neighborhood Validation Table. They are associated with appraisal values through the following Mass Appraisal Validation Tables:

  • Building Use Code
  • Miscellaneous Structure Code (MUSE)
  • Land Use Codes

A Property Type is selected for the parcel on the Legal Information form in Govern.

  • The Neighborhood Adjustment is applied to a Property Type if all the following conditions are met:
  • The Neighborhood Validation Codes are set up by Property Type
  • The Mass Appraisal Land Use, Building Use, or Miscellaneous Structures Use Code is set up by Property Type
  • Use Legal Description Property Type for Neighborhood Adjustments is selected on the Mass Appraisal General Parameters form.

Otherwise, the Neighborhood Adjustment is not applied by Property Type.

Frozen Records

When you create an MA – Sales Information or MA – Audit Information record, a frozen record is automatically created. When a record is frozen, a copy of all the active CAMA records for the property are saved and assigned a Frozen ID. You can view the land, sales, income, building, and miscellaneous structures records, for the property at the moment the record was frozen. This is similar to having a series of snapshots of the property record.
You can continue to make changes to the property record after it is frozen. You can even have multiple frozen records for a property. Each time a record is frozen, a new frozen ID is assigned.
The current record is assigned the Frozen ID 0. Frozen IDs are updated differently according to whether the record is frozen from the Sales or from the Audit form. Sales information records have positive frozen IDs. The records frozen from the Audit form have negative frozen IDs in past years. A new Frozen ID is automatically assigned each time a record is frozen.
Records Frozen From MA_Audit
When you select the Value Finalized option on the MA – Audit form, a frozen record is automatically created. The first time the record is frozen, it is assigned Frozen ID -2. The next time, it is assigned Frozen ID -3, and so on.
Users can view frozen records by selecting the applicable year and Frozen ID in the History Panel, provided they have the required access permissions. Records from all Mass Appraisal forms can be viewed.
Access rights are required for viewing and modifying frozen records. These are defined in the OFD by selecting the Alternate type and then setting rights for the required Profile, Roles and Users. Refer to the Govern OpenForms Designer Guide (OFD) for details.
any of these forms, you can open all the forms listed under Forms with Frozen IDs on page 15 and view the data as they were at the time the record was frozen. For example, you could be updating a property and have open Fiscal Year 2015 with Frozen ID 0, but need to see the land record for 2013, Frozen ID -2.
To view records in past or future years:

  1. Launch Govern.
  2. Open a Profile that contains CAMA.
  3. Open the required form.
  4. Perform a search and load the required record to the form.
  5. Select the History panel.
  6. Double-click on the entry for the year and the Frozen ID you want to view.
  7. Open the Forms Explorer and open forms that you want to view.
  8. Open the History Panel again if you want to return to the year and Frozen ID that you had originally opened.

Closed Year / Certified Records

The Frozen ID -1 is a copy of the current or Frozen ID 0 record. It is created at the following times in order to preserve a copy of the original data:

  • When you run the CAMA Close Year batch process
  • When you create a Value Finalized MA – Audit record

This record is identified as Certified in the database and on the History Panel:

If the History for Current Year option is selected in Govern Admin, When you set an MA – Audit Information record to Value Finalized, Frozen IDs -1 and -2 are created at the same time.
If the History for Current Year option is deselected, Frozen IDs are not created in the current year.

Records Frozen From MA – Sales Information

When you create a sales record, from MA – Sales Information, a Frozen ID is automatically assigned. For sales records, Frozen IDs start at 1. They increase by 1 each time a sales record is created within the year. For example, if a property sells four times in a year, you would have four Frozen ID records, 1, 2, 3, and 4.
Frozen records are not created for the Sales Information or Audit Information forms. You cannot open the MA- Audit form as it existed in 2011 when the Sales Information was created and Frozen ID 1 was assigned.

Forms with Frozen IDs

When you create an MA – Sales Information record or set an MA – Audit Information record to Value Finalized, frozen records are automatically created for the following forms:

  • CAMA – Property Information
  • CAMA – Building Information
  • CAMA – Building Structural Elements
  • CAMA – Building Drawing or Drawing APEX
  • CAMA – Building Area
  • CAMA – Land Information
  • CAMA – Income
  • CAMA – Miscellaneous Structures
  • CAMA – MRA
  • CAMA – Sites
  • CAMA – Values Override
  • Property Control Property Area
  • Property Control Legal Information

Summary

The following table lists the assigned IDs that appear in the Frozen ID field on the History Panel and on the Govern Ribbon. Note that this text box is used for Split Merge data as well as Frozen IDs:
Record Status Frozen and Other Assigned IDs
Current Record 0
Frozen from MA – Sales Information 1, 2, 3, 4…
Closed Year / Certified Record -1
Frozen from MA – Audit -2, -3, -4, -5…
Split Merged Data -32,766

Notes on Frozen Records

You cannot view the Sales Information record at the time a frozen record was created from the Audit form and vice versa, you cannot view the Audit Information record at the time the Sales Information record was created. Frozen records are not created for these forms when a Sales Information or Audit Information record is created or finalized.
A Frozen ID -1 record is not created if there is an open Split Merge record for the property for the year. No message is displayed.

Security for Frozen Records

The Alternate Security applies to Frozen Records. Users have access to view, update and delete frozen records according to the alternate security rights assigned for the form. For details about alternate security, refer to the Govern Security Manager guide.
You cannot change values saved under a Frozen ID, unless you have Super User rights or full access rights to the historical records. A new Frozen ID is automatically assigned each time a record is frozen.

Roll Forward Data

Select the Roll Forward Data option if you make modifications to records in earlier years that you want to carry forward to records in the future years that are open.
When making property appraisals you may need to have open the current fiscal year and several years in the future. For example, if the current fiscal year is 2015, you may have open 2016, 2017, and 2018. The configuration parameters and property records from 2015 are copied to the future years, 2016, 2017, and 2018.
If there is a change made in 2015, such as an extension to a porch, you can update the record for the year in which the change occurred and then roll the change forward to the future years, without having to open and modify each record. The changed field is copied from the current year to the future years. Structures that have not changed are not rolled forward.
In the following examplet, the current year is 2013. The user returns to 2010 and changes a record. A confirmation message appears each time you save a new record or modify an existing one when there are records for future or more recent years.

The message displays the records that are updated. This includes the current record.
When the confirmation record appears, do one of the following:

  • Select Update Sales Data and click Yes to update the sales records along with the current modification.
    This updates the sales records for all Frozen IDs for the property in the same year, regardless of whether the change was made before or after the property was sold.
  • Click Yes to roll the current modification forward.
    Newly created records, deleted records, and modified records are rolled forward.
  • Click No if you do not want to roll the current modification forward.

The data are rolled forward if the CAMA Property Information record exists for the current parcel.

Typically, this record would be created when you open the new year. However, if it were deleted, the Roll Forward would not occur.

Data in the following Govern tables are rolled forward:

Govern Forms Govern Tables
Property Area PC_AREA
Legal Information PC_LEGAL_INFO
Tax Real Estate Assessment TX_RE_ASSESSMENT
Tax Assessment AC_, BT_, PP_, MV_, RE_ASSESSMENT
Tax Exemptions TX_EXEMPTIONS
Tax Levy Master TX_LEVY_MASTER
Appraisal Property Information
Appraisal data MA_MASTER
Building Drawing MA_DRAWING
Building Area MA_BLDG_AREA
Building Structural Elements MA_BUILDINGS, MA_BUILDINGS_2, MA_BUILDINGS_3, etc.
Income MA_INCOME
Land MA_LAND
MRA MA_MRA
Site Information MA_SITE
Miscellaneous Structures MA_MISC_STRUCTURES

 

Use Exemptions

You can apply real property tax exemptions directly to the land, building, miscellaneous structures, and income data records. This is useful when an exemption is applicable to a specific mass appraisal value rather than to the entire property.
Select the Use Exemptions option to add the Exemptions divider to the MA Land Information, MA Building Structural Elements, MA Miscellaneous Structures, and Income Data forms. You can then apply a full or partial exemption to any of these records. Refer to the specific Mass Appraisal guides for details.

Do Not Copy Expired Overrides to Next Year

Select this option if you do not want to copy the expired override values over to the next year, when you copy the default parameters.

Include Personal Property Assessment

Select this option to include personal property assessment data in the Mass Appraisal calculation. If this option is selected the values from the Personal Property adjustment tables are transferred to the MA_MASTER table.
To calculate the Personal Property Assessment, run the Appraised Value Computation process in Govern Batch Processing. Select Fast Compute Mass Appraisal Values. Then select Personal Property and click Process. See Appraised Value Computation on page 134 for details.

Increase / Decrease Option

Show Increase / Decrease Values
Select this option to display the Equalization Increase / Decrease, and when available, Physical Increase / Decrease values. See Increase / Decrease on page 109 for details.
Increase / Decrease Value Computation
If this option is selected, the Increase/Decrease value is calculated during the final year computation, and displays the information on the Values tab of the Property Information (Mass Appraisal) function form in Govern for Windows. The information is displayed in the Equalization Increase, Equalization Decrease, Physical Increase and Physical Decrease parameters. See Increase / Decrease on page 109 for details.

Transfer to Tax

Use the following options to set up the automatic transfer of Mass Appraisal values to the Real Property Tax Assessment subsystem.
Automatically Transfer to Tax
Select this option to transfer CAMA values to the tax module, automatically, when the MA – Audit Information record is saved finalized. Otherwise, if this option is deselected, values are transferred during the Mass Appraisal Values Computation batch process.
Assessment Value Based on Property Type Rates
Select this option to transfer appraised values at different rates, according to property type. Then, set the amounts to transfer using the Multiple Assessment Rates form. See Multiple Assessment Rates on for details.
Assessment Equalization %
Enter the percentage of the total appraisal value to transfer to the Real Property Tax sub-system.
This option is available if the Assessment Value Based on Property Type option is deselected

Do Not Transfer AG Credit to Tax
Select this option if you are not transferring the agricultural value to the tax sub-system with the other Mass Appraisal values. Refer to the user section of the Mass Appraisal Land guide for further details on the agricultural value.

Page 2 to 5 Parameters

Parameters found on the Mass Appraisal General Parameters Pages 2 through 5 are used for Building, Land, Income, and Comparable Sales data. Refer to the specific guides for details about completing these parameters.

Page 6 Parameters

The Page 6 parameters are required for Marshall & Swift data. Refer to the Marshall & Swift documentation for guidelines on completing these parameters.
Complete these parameters before running the Govern Batch Processes to export and import Marshall and Swift data.

 

 

103-ma-parm-general-1

 

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 2 tab

General Parameters Page 2 tab

Overview

Mass Appraisal General parameters page 2 tab is used to configure:

  • Building Value Options
  • Land Options
  • Income Options

To access, Govern Administrator, Application Parameters, Mass Appraisal, General Parameters, Divider Page 2

Building Value Computation Options

(In Development)
Quality Point Rounding

Units Look-Up Using Base Area Size

Round up by Area Type

Round up by Drawing Code

Force Compute for all Building Seq?

Effective Area = Living Area

Optimize Computation Speed (deprecated)

Skip Rates Interpolation

Automatically Filling (deprecated)

Size Adjustment Method

  • Look-up table

Cama and Overall Adjustments No. Decimal Positions

Quality Points No. Decimal Positions

Size Adjustment No. of Decimal Positions

Buildings Drawing

Use Apex Application for Drawing (to be removed)
Drawing Auto-Save Image (twice)
Drawing Auto-Save Image (twice)
Use Apex Medina
Drawing Decimal Position
New Drawing Height and Width
Drawing AutoScale

Buildings Associate

Associate SE Models (Year Effective)
Select to associate to Structural Elements to Models, unselect to associate to PROPERTY TYPE

Land Options

Associate

You can associate the land adjustments with either the Land Use Codes or the Land Rate Schedules. When used, only the adjustments that are associated with the specified code or schedule are displayed on the Land Adjustment form in Govern. Otherwise, all adjustments are displayed. Note: You can select only one of these options. You can associate the land adjustment to either the land use or the land schedule. You cannot select both options but you can leave both blank.

Associate Land Adjustment to Land Use

Select this option to associate or apply the Land Adjustments to the Land Use Codes.
If this option is selected:
• The Apply Adjustment to Land Use list box appears on the Mass Appraisal Land Adjustment validation table form.
• You can apply the adjustment to one or more land use codes.
The land use code is applied to the Land Adjustment Tables. These are displayed under Adjustment Type on the Adjustments tab of the Land Information form.
Only the adjustment types that are applied to the selected Land Use Code are displayed on this tab.

Example: Applying Adjustments to Land Use
In the following scenario, there are two land adjustments that can be applied to the Waterfront land use. If you follow the setup described in this section, only these adjustments appear in the Land Information > Adjustments tab.

  • 1. Open the Mass Appraisal General Parameters form.
  • 2. Select Page 2.
  • 3. Select the Associate Land Adj. to Land Uses option.
  • 4. Click Save.
    • The Apply to Land Uses list box appears on the Land Adjustment Mass Appraisal Validation Table form.
  • 5. Open the Mass Appraisal Validation Tables form.
  • 6. Open the Topography Land Adjustment table.
  • 7. Select Waterfront in the Apply to Land Uses list boxes.
  • 8. Click Save.
  • 9. Open the Shape / Size Land Adjustment table.
  • 10. Select Waterfront in the Apply to Land Uses list boxes.
  • 11. Click Save.

Result

  • The Topography and Shape/Size adjustments are listed on the Adjustments tab. The Validation Codes are listed under Adjustment Code.
  • The user can select the code that applies and can also override the value, provided security permissions are granted.

Associate Land Adjustment to Land Schedules

Select this option if you want to apply the Land Adjustments to one or more land rate schedule codes.
If this option is selected:

  • The Apply Adjustment to Land Schedule list box appears on the Mass Appraisal Land Adjustment validation table.
  • You can apply the adjustment to one or more land rate schedules.

Only the land adjustment tables that are associated with the land rate schedule that is selected on the Land Information General tab are displayed in the Land Information Adjustments tab.
Note: You can select only one of these options. You can associate the land adjustment to either the land use or the land schedule. You cannot select both options but you can leave both blank.

Year Effective for Land Adjustments Association

(To be verified) Year Effective: Enter the year that the association with the land adjustment comes into effect. This option is used with either the Associate Adjustment to Land Use or the Associate Adjustment to Land Schedules option.

Compute

Compute by Sequence:

Select this option to calculate the land adjustments in order of sequence number. Otherwise, the land adjustments are calculated according to the mathematical order of operation rules.
The sequence number for each land adjustment is entered on the Mass Appraisal Validation Tables for Land Adjustments.
If this option is selected, the computation is made in ascending order of sequence number; i.e., the land adjustment tables with sequence numbers 1 and 2 are calculated before 3.

Year Effective for the Compute by Sequence Number:

Enter the fiscal year for beginning the Compute by Sequence Number computation, if applicable.

Other

Cumulative Land Rate

Cumulative Land Rate: Select this option if you are using a cumulative method for applying the land rate. With this method the rates per square unit are added together in order to determine a final rate.
For example
Acre – Price
0 -1 3500
1-2 3000
2-3 2700
3-4 2500
Total $11,700.00

Allow Negative Value:

Select this option to enable the data entry fields for negative area values.

Skip Rates Interpolation:

Select this option to prevent the automatic calculation of rates, set by unit, on values that fall between set amounts.
For example:
Rates are set for building structures measuring up to 1,000 units, up to 1,500 units and up to 2,000 units, through the Rates Adjustment tables.
If the structure measures 1,200 units, the Rates Interpolation calculates a value between 1,000 and 1,500 units, according to the formula provided in Appendix A Rates Interpolation on page 164, and uses this amount.
If the Skip Rates Interpolation option is selected, the rate for 1,500 units is used.

Conversion Full Precision:

Full Precision on Total Land Area sq. ft. to Acres Conversion: This parameter is applied to the Total Size of the lot, as shown on the Legal Information form, when the value is converted from square feet to acres.
Select this option to round the Total Size to fifteen decimal places.
Otherwise, the result of the conversion is rounded to two decimal places.

Income Options

(In Development)
 

103-ma-parm-General-2

 

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 3 tab

MA General Parameters Page 3 tab

Version 6.1

Overview

In Development.

 

 

103-ma-parm-General-3

 

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 4 tab

MA General Parameters Page 4 tab

Version 6.1

Overview

In Development.

 

 

103-ma-parm-General-4

 

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