MA – Land Rate Schedule

Mass Appraisal Land Rate Schedule

Overview

The Land Rate Schedule validation table is used to for setting up the rates for land records. One rate schedule can applied to each record. There can be multiple land records for a property. You can apply a flat rate or set up a rate schedule in order to apply different rates according to the number of units. This is described under Linear Square Foot Calculation. You can also create a separate rate, formula, or logical expression for the rate schedule.

Accessing the Land Rate Schedule Validation Table

To access the MA Land Rate Schedule Validation Table:

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

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

The Mass Appraisal Land Rate Schedule validation table is saved in the database as follows:

  • In MA_TABLES by year and the table name, landschd
  • In VT_USER_MA_TABLE by year, the long and short description, and the column name as the code.
  • A new table called VT_USR_LANDSCHD
  • In MA_PARM_LANDRATE, with the UP to Units value
  • In MA_PARM_LANDSCHD, with the codes and values for flat rates

Land Rate Schedule Validation Table Icons

The New and Delete icons are disabled for the Mass Appraisal Land Rate Schedule 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.CodesClick the Codes icon to view or modify the validation codes.

Mass Appraisal Land Rate Schedule Validation Table Parameters

Year – The year for the Land Rate Schedule 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.

CodeThe Land Schedule Validation Table is saved as land – landschd.
Short DescriptionEnter a short description.Long DescriptionEnter a long description. This is used for lookups and is displayed on forms and reports.Table TypeThis field displays lnadschd – Land Rate Schedule.Table CategoryThis field displays the table category. The category for the Land validation tables is land – LandLookup Group TypeUse the Lookup Group Type to create rate schedules by a combination of jurisidiction, neighborhood or income neighborhood, and property 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.

Land Rate Schedule Validation Codes

The Mass Appraisal Land Rate Schedule Validation Codes are used for creating various codes for the selected land rate.
Mass Appraisal Land Rate Schedule Validation Codes Action Icons

New – Click New to create a new validation code.When you click New, the Exit button changes to Cancel so that you can clear unsaved data.Saving a CodeClick Save to save a new code or modifications to an existing one.Deleting a CodeClick Delete to remove the current record.ExitClick Exit to close the form.

Mass Appraisal Land Rate Schedule Validation Codes Parameters

YearThe year is displayed for the Land Rate Schedule 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.CodeEnter a unique combination of alphanumeric characters to identify the Land Rate Schedule validation code. The codes are listed in ascending order in the Rate Schedule drop-down list on the Land Appraisal Information form.Short DescriptionEnter a short description.Long DescriptionEnter a long description. This is used for lookups and is displayed on forms and reports.
DetailsYou can set up land rate schedules by a fixed rate or by up to units values.Unit TypeSelect the type of units from the drop-down list (Table: VTSYSTEM_LUNIT).Market Land RateEnter a value in the Market Land Rate if you are using Comparable Sales and the Market Adjustment Option. This rate is multiplied by the number of units and used in the comparable sales computation. It is not used in the land value computation. For further details, refer to the Sales and Comparable Sales documentation.

Lookup by Unit

Up to UnitsThis option is used for creating a land rate scheduled based on number of units. The field appears only if the Fixed Rate option is deselected.Enter the maximum number of units that apply to the Rate Expression. The type of units used in the calculation is displayed in the Unit Type parameter.Rate ExpressionClick the ellipsis button and enter an expression for the rate corresponding to the number of units entered in the Up to Units field. This field appears only if the Fixed Rate option is not selected. You can calculate the rate from either the Fixed Rate or Up to Units values, not both.Add New RangeClick Add after entering your values in the Up to Units and the Rate fields. The record will be listed in ascending order in the grid to the right.Remove RangeTo remove a record, select it in the grid and click Remove.Import UnitsSelect the Import Units to use the same Up to Units table create for another Land Rate Schedule Validation Code.

NOTE: If the code name is ALL or anything else but ALLx, then the rate is equal to the Up to Units range of this unit value. Otherwise, if the table name is ALLx (where x is a number), then the rate is equal to a linear calculation. See Appendix A Linear Square Foot Calculation.

Defining a Fixed RateComplete the fields in this section if you are applying a land rate schedule.Use Fixed RateSelect this option to define a fixed rate for the land. When you select this option, the Value, Formula, and Logical Expression fields appear.
Defining the Agricultural RateApply Rate Adjustment to Agricultural RateSelect this option to apply the value from the Land Adjustment Table, Rate Element Category to the Agricultural Rate.Agricultural RateClick the ellipsis button and enter an expression to calculate the Agricultural Rate for the selected code, if applicable.
This value is displayed in the Unit Price Agricultural field on the Land Appraisal Information function in Govern.Apply Land Adjustment to Agricultural ValueSelect this option to add the Land Adjustment to the Total Agricultural Value, as displayed on the Land Appraisal Information function, in Govern.
If this option is selected:

Total Agricultural Value = Units * Unit Price AG + Land Adjustment

Otherwise, if this option is deselected:

Total Agricultural Value = Units * Unit Price AG

 

 

103-ma-parm-LandSchedule

 

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

 

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 Copy to Year System Batch Process

Mass Appraisal Copy to Year System Batch Process

Overview

Run the Mass Appraisal Copy to Year process in to order to copy the Mass Appraisal tables and administrative parameter definitions from one year to any other year.

A typical use is to run this process once a year to copy the administrative information from the current fiscal year to the next. However, it could be run to copy the definitions from any year in which data exist to any other year. If parameters already exist, they are not overwritten.

Documentation

To view this information in pdf format, open the following document:
103-ma-bp-005.pdf

Configuring the Copy to Year Batch Process

The Copy to Year is a System batch process. It is accessible in the Mass Appraisal menu in GNA. Like any other batch process, additional Copy to Year batch processes can be defined. These can be added to one or more Profiles and run from Govern.
To configure the batch process:

  1. Launch GNA.
  2. Select Editors > Batch Process Definition Editor.
  3. Select 103-ma-bp-005 > Copy to Year.
  4. Select the Transaction tab.

If you are using the System Copy to Year batch process, the Transaction Type and Transaction Mode cannot be modified.
These are set to the following:

  • Sync: In synchronous batch processing, transactions are processed one after another in a sequence. If there are multiple steps in the process, one step is completed before the next begins.
  • Break If One Transaction Failed: The process terminates when a transaction fails. All the transactions that were completed are cancelled. All the computations are returned to the starting point.
NOTE: If you are creating one or more additional Copy to Year batch processes to run in Govern, these fields are enabled. However, because the batch process is designed to run in this Transaction Type and Mode, the settings are switched to Synchronous mode and Break If One Transaction Failed when you run the process, regardless of the user input.

You can add an e-mail and set up scheduling for this batch process.

Running the Copy to Year Batch Process

To run the System Copy to Year batch process:

  1. Launch GNA.
  2. Select Application Configurations > Mass Appraisal > Copy to Year.
  3. Select the year in the From drop-down list, for which the tables, constants, queries and shared expressions that you want to copy exist.
    Only the years from which data exist appear in the list.
  4. Enter the year to which you want to copy the data in the To parameter.If data already exist for that year, they will not be overwritten.
  5. Click the Run button to run the batch process.If you are using the batch process in Govern, you can set up a schedule on the form.

If you are running the batch process in Govern, you can set up a schedule to run it on a regular basis or at a future time.

Data Copied

The following data are copied from the selected year to the destination year during the batch process:

Mass Appraisal Tables

Lookup Groups
All tables with Lookup Group data including:

  • MA_LOOKUP_GROUP
  • MA_SHARED_LOOKUP_GROUP
  • MA_SHARED_LOOKUP_GROUP_INDEX
  • MA_SHARED_LOOKUP_GROUP_SET

MODIF_STAMP

  • MA_MODIF_STAMP

MA Parameter Tables

  • All tables beginning with MA_PARM

MA Tables

  • All tables listed in MA_TABLES

These tables contain parameters and definitions the Mass Appraisal modules.

User Validation Tables

All User Validation Tables that are:

  • Year based
  • One of the following table types.
    Regular
    Mass Appraisal
    Tax Billing

Queries, Constants, Shared Expressions

  • All Queries, Constants, and Shared Expressions that are year based.

See Also

Mass Appraisal Initialize Year

 

 

103-ma-bp-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 – Initialize Year Batch Process

Mass Appraisal Initialize Year Batch Process

Overview

Run the Mass Initialize Year batch process in to order to copy Mass Appraisal data from one year to another year.
A typical use is to run this process once a year in order to copy data from the current fiscal year to the next. However, it could be run to copy data from any year in which data exist to any other year. If data already exist, they are not overwritten. For a list of the data that are copied, see Data Copied.

Documentation

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

Prerequisites

It is recommended to run the Copy to Year batch process before running the Initialize Year process. The Copy to Year process copies administrative parameters and tables to the year. The Initialize Year process copies the data.

Configuring the Initialize Year Batch Process

The Initialize Year is a System batch process. It is accessible in the Mass Appraisal menu in GNA. This batch process can be configured, like any other batch process. Additional Initialize Year batch processes can be defined. These can be added to one or more Profiles and run from Govern.
To configure the batch process:

  1. Launch GNA.
  2. Select Editors > Batch Process Definition Editor.
  3. Select 103-ma-bp-006 > Initialize Year.
  4. Select the Transaction tab.

Note: If you are using the System Initialize Year batch process, the Transaction Type and Transaction Mode cannot be modified.
These are set to the following:
Sync: In synchronous batch processing, transactions are processed one after another in a sequence. If there are multiple steps in the process, one step is completed before the next begins.
Break If One Transaction Failed: The process terminates when a transaction fails. All the transactions that were completed are cancelled. All the computations are returned to the starting point.

If you are creating one or more additional Initialize Year batch processes to run in Govern, these fields are enabled. However, because the batch process is designed to run in this Transaction Type and Mode, the settings are switched to Synchronous Mode and Break If One Transaction Failed when you run the process, regardless of the user input.

Regardless of whether you are running the System batch process or a user-defined process, you can add an e-mail and set up scheduling as for any other batch process. Refer to the Govern Scheduler documentation for details.

Running the Initialize Year Batch Process

To run the System Copy to Year batch process:

  1. Launch GNA.
  2. Select Application Configurations > Mass Appraisal > Initialize Year.
  3. Select the year in the From drop-down list, in which the data that you want to copy exist.
    Only the years from which data exist appear in the list.
  4. Enter the year to which you want to copy the data in the To parameter.
  5. Select the Delete destination data before the copy to overwrite the data that already exist in the destination year.
    Otherwise, if you do not select this option and data already exist for the destination year, they are not overwritten.
  6. Click the Run button to run the batch process.

If you are running the batch process in Govern, you can set up a schedule to run it on a regular basis or at a future time.
When you run the batch process, messages appear to indicate the number of records copied to the destination year and the number of records skipped.

Data Copied

Data from the following tables are copied from the selected year to the destination year during the batch process with the following exceptions:

Exceptions

The following exceptions apply:

Data Already Exist

If data already exist in the destination year for selected records, the records are skipped, unless the Delete data in destination year option is selected.

Field Exclusion

Fields specified in the Field Exclusion List are not copied.
To add fields to the Field Exclusion list:

  1. Launch GNA.
  2. Select Application Configurations > Field Exclusion.
  3. Click the Add button.
    A list of tables appears in the Table Name column.
  4. Select the applicable table.
    A list of columns appears in the Column Name column.
  5. Select the applicable column.
  6. Select Copy to Next Year to exclude the field from the Initialize Year process.
  7. Select Roll Forward to exclude the field from the Roll Forward process.
  8. Click Save.

Property Control Tables

  • PC_LEGAL_INFO
  • PC_AREA

Mass Appraisal Tables

  • MA_BLDG_AREA_YEAR
  • MA_BLDG_DRAWING
  • MA_BUILDINGS
  • MA_BUILDINGS_2 to 9
  • MA_CA_VAL_TRACKING
  • MA_INCOME
  • MA_INCOME_2 to 9
  • MA_INCOME_DETAIL
  • MA_LAND
  • MA_LAND_2 to 9
  • MA_LINKS_PERCENT
  • MA_LK_EXEMPTIONS
  • MA_LK_INC_FIELD
  • MA_MASTER
  • MA_MISC_STRUCTURES
  • MA_MRA
  • MA_MRA_2 to 9
  • MA_NY_AG MA_NY_CODE
  • MA_OVERRIDE *
  • MA_PA_LAND
  • MA_PA_LAND_DETAIL
  • MA_PA_SOIL_DETAIL
  • MA_SITE
  • MA_URAR_COMMENTS
  • MA_URAR_COST
  • MA_URAR_IMPROV
  • MA_URAR_NBHD
  • MA_URAR_PRIORSALES
  • MA_URAR_PUB
  • MA_URAR_RECONCIL
  • MA_URAR_SALECOMP
  • MA_URAR_SITE
  • MA_URAR_SUBJECT
  • MA_VALUES_TABLE
NOTE: *Overrides are not copied from MA_OVERRIDE if the Ending Year is earlier than the destination year.

 

 

103-ma-bp-006

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