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 replacement costs, depreciated values, and insurable values of buildings and other improvements.

The Marshal & Swift Copy to Year batch process is the same as the Govern Copy to Year batch process that will copy the parameter tables from one year to another.

 

NOTE: The parameter table for Marshall & Swift is called msvpo.ValuationSettings.

Govern users can run the Marshall & Swift Copy to Year batch process in to order to copy Mass Appraisal administrative parameter definitions, and appraisal tables from one year to any other year.

Documentation

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

Configuration

Configuring the Marshall & Swift Copy to Year Batch Process

The procedure of Configuring the Marshall and Swift Batch process is similar to other Govern standard batch processes. Please refer to the Govern New Administration (GNA) 6.x User Guide for details.

  1. Launch the Govern New Administration (GNA)
  2. Select Editor (tab) > Profile Editor.
  3. Follow the steps to add the batch process to the required profile.
  4. From the GNA ribbon, click Editors (tab) > Batch Process Definition Editor.
  5. In the Profile Editor, click the profile that you would like to modify.
  6. Click the Links tab.
  7. Select your form and click Add to add the batch process to the form.

The Copy to Year for Marshall & Swift Parameter Tables is a System batch process. The Marshall & Swift parameter table (msvpo.ValuationSettings) is also included in the Mass Appraisal Copy To Year batch process.

See Also

Copy Mass Appraisal Parameter Tables to Year

Mass Appraisal Initialize Year

 

MA – Product Map

 

 

103-ma-bp-010

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 – 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 a snapshot (freeze/audit) of the CAMA & Tax data.

Documentation

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

101-ma-bp-012_MATaxrollSnapshot.pdf

User Interface (UI)

The UI for the Taxroll Snapshot batch process is  similar to standard Govern batch processes.

Taxroll Snapshot batch process Parameters

Year: The Year that the snapshot will be made from.

Snapshot: The snapshot number that will be used as the FROZEN_ID. Values are taken from (Table: SNAPSHOT) System Validation table.

  • Selected from a snapshot value between -32500 and -32759

Parcels to snapshot (group)

All: When this option is selected, data is selected from all Parcels in (Table: PC_PARCEL).

Tax Map Number – Selecting this option will:

  • Only select data for Parcels included in the Tax Map Range
  • If selected, you must provide at least a From or a To tax map number
    • A partial Tax Map number can be used; the search will perform a LIKE ‘taxMapNumber%’

Saved Dataset – This option will select data only for Parcels included in the selected Dataset name

Delete destination data before snapshot – Select this option to delete the destination data for the selected Parcels before making the Snapshot.

Records by batch: Specify the number of parcels to include in each batch; system default is 50.

Business Rules for Obtaining Records

Getting Records

This process will select all distinct parcels from (Table: PC_PARCEL)

Running the Taxroll Snapshot Batch Process

This batch process can be run Synchronously or Asynchronously. Note that Asynchronous transactions are recommended for improved performance. The Transaction Mode is forced to CONTINUOUS.

Related Information

Refer to the Govern OpenForms Designer (OFD) documentation for details.
Refer to the Mass Appraisal General Information documentation for further details on frozen records.

 

 

101-ma-bp-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 – Summary Record Card

Mass Appraisal (MA) – Summary Record Card

Version 6.0.1903 / 6.1.1911 (In Development)

Overview

NOTE: This page is under development.

The Mass Appraisal (MA) Summary Record Card is a form that presents as a Header and a list of summary information, called “cards” in the MA module. This form displays components of a property where each component is grouped. For example, the MA Summary Record Card would display, amongst other things,  information Buildings Structural Elements (BSE), Land, Site, etc.

The Summary Record Card form is currently available for the following:

  • Mass Appraisal (MA)
  • Property Control (PC)

 

Related Topics

 

 

101-ma-frm-075

 

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 – Module OpenForms Reference

Mass Appraisal Module OpenForms Reference

Release 6.1 [To be reviewed]

Overview

OpenForms Reference information. Intended for Business Analysts and System Administrators.
The page contains general information on the system standards queries and distributed forms.

Distributed Forms

The following forms are distributed via the Enterprise Migration Tool EMT Import/Export in the Utility menu in the OpenForms Govern’ Administrator (GNA) system.
The forms can be copied and modified in the OpenForms Designer (OFD).

 

Form No. Page Link/Product Code Description
MA017 101-ma-ofr-017 CAMA – Land
MA021 101-ma-ofr-021 CAMA – Value Override
MA015 101-ma-ofr-015 CAMA – Sale info
MA014 101-ma-ofr-014 CAMA – Property Info
MA 101-ma-ofr- Buildings (contains BSE and )
MA 101-ma-ofr- CAMA – Building Drawing
MA016 101-ma-ofr-016 CAMA – Site

 

Site

[in development]

Business Entity Designer

Model & Entities

  • The Model is CAMA Sites.
  • Business entities include MA_Sites_Values and MA_Sites_History. These entities are linked by P_ID.

Attributes

Three attributes are added to the form in the BED.
These are calculated values that use the following expressions.

  • BUILDING_DIR IsNull(@attrINCOME_DIR_VALUE,0)-IsNull(@attrLAND_VALUE,0)
  • BUILDING_GRM IsNull(@attrINCOME_GRM_VALUE,0)-IsNull(@attrLAND_VALUE,0)
  • BUILDING_MRA IsNull(@attrMRA_VALUE,0)-IsNull(@attrLAND_VALUE,0)
NOTE: The same attributes and entities are added to the CAMA Property Information form.

OpenForms Designer

Controller for Site Information

  • Assembly: MsGovern.OpenForms.CustomControls.dll
  • Class MA_Site_Controller

Site Information > General tab

  • The General tab is configured by a custom control:
  • MASiteAdjustments_Control
  • The control displays a grid used for entering the site adjustments for the site.

Controller for Site History

  • Assembly: MsGovern.OpenForms.CustomControls.dll
  • Class MA_SiteHistory_Controller

Site Information ID Setters

  • P Id Parcel ID
  • Frozen Id Frozen ID
  • Year Id Year ID

Site History ID Setters (to be verified)

  • P Id Parcel ID

Order by

  • Site No Ascending
  • Year Id Ascending
  • Frozen Id Ascending

Land

Model
The Land Information Model Land Information form has two entities:

  • MA_LAND
  • MA_EXEMPTIONS

The exemptions entity is useful if you have real property tax exemptions that can be applied directly to a land record.
Data associated with MA_EXEMPTIONS are saved to MA_LK_EXEMPTIONS

Controllers
MA LAND

  • Assembly: MsGovern.OpenForms.CustomControl.dl
  • Class: MA_Land_Control
  • The Controller has a custom save and delete.
  • The custom save is used for creating the original record (Frozen ID -1)

MA LAND Form Action Buttons

  • Copy Land to copy the land data info from current land record
  • Paste Land to paste the land data info to current land record
  • Refresh to compute data and reload the form

MA_LAND ADJUSTMENT
Custom Entity

  • Assembly: MsGovern.OpenForms.CustomControl.dl
  • Class: MA_LandAdjustments_Control

Buildings

under construction

Reference Database tables
PC_PARCEL_LK_BLDG
MA_BUILDINBG
MA_BUILDING_INFO (merged with MA_BUILDING)
MA_BUILDING_DRAWING
MA_BUILDING_AREA by year
MA_BUILDING_1, _2, _etc.

Data Model

General Information on the models used for the forms

Property Control

Parcel [pc_parcel] is active [effective year, inactive year] Parcel linked to buildings [pc_pid_lk_bid] active [effective and inactive date] Building can be linked to property location (ex: corner address)
Building can be linked to building (ex: unit to condo complex building, premise renting in…)
Building can be master in building link (ex: condo complex building, rental building…)
Occupant records can be linked to building

Mass Appraisal (by year)

Building can be linked to a parcel that is linked to condo appraisal
Building can be linked to a parcel that is linked to premise rental appraisal
Building can be linked to a parcel site record by year
Building can be linked to a parcel income record by year
Building can be linked to a parcel MRA record by year

Miscellaneous Structure records can be linked to building
Occupant records can be linked to building

What’s New

The following are additions and changes related to the CAMA OpenForms Reference:

Release 6.1.1605.245 / 6.1.1603.316

A new field called VALUE_OVERRIDE has been added to the following forms:

  • Buildings
  • Income
  • Misc Structures
  • Site
  • Land
  • MRA

Deployments and Versions affected:

  • GOVERN_REFERENCE_V61_DEV_MTL-SQL2012_SQL 6.1.1605.245
  • GOVERN_REFERENCE_V61_REL_MTL-SQL2012_SQL 6.1.1603.316

Location of the changes are indicated below.

CAMA Buildings

CAMA_Buildings.png
Click to view full size image.

CAMA Land Information

CAMA_LandInformation.png
Click to view full size image.

CAMA Misc. Structure Information

CAMA_MiscStructInformation.png
Click to view full size image.

CAMA Site Information

CAMA_SiteInformation.png
Click to view full size image.

CAMA Income Information

CAMA_IncomeInformation.png
Click to view full size image.

CAMA Fair Market Value

CAMA_FairMarketValue_MRA.png
Click to view full size image.

 

 

101-ma-ofr

 

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 – Valuation Business Rules

Mass Appraisal Valuation Business Rules

Release 6.1 [In Development]

Overview

The following information provides the computation business rules.

Computation Trigger Business Rules

Computation occurs:

  • On Save in Govern
  • On Condition in the Batch Compute:
    • If modif stamp of detailed record different than detail record modif stamp
    • If force compute of components selected in the batch process
    • If roll forward to other years
  • if MA Audit record is Finalized

Computation does not occur:

  • If Parcel Inactive – MA Records are deleted when inactivated
  • if Building inactive
  • if Parcel Linking inactive
  • if Building Linking inactive for the other linked buildings

History Only

  • If the history only is set to true (-1 or 1), it will be skipped when the computation is done using the Batch Computation program.
  • It will be ignored when a record is saved and computation will occur.

Parcel Linking

A parcel can receive values from other parcels or provide a portion of its value to others. Contrary to the VB6 version, we will only load the values provided by other parcels and it is assumed the parcels that are providing the values have been previously computed.
If possible, if the parcels to be loaded have a MA_MASTER.MODIF_STAMP set to NULL, we should be calling this compute (recursive call) for these parcels prior to complete this step. (to be verified)

IMPORTANT: A parcel cannot receive and provide a value at the same time. Parcels having the MA_MASTER.exclude_from_roll = <> 0 are providing values to other parcels and therefore they are not computed. However the modif stamps to all linked parcels are reset.
  • MA_MASTER.exclude_from_roll = -1 – The parcel provides all types of values to other parcels
  • MA_MASTER.exclude_from_roll = 1 – The parcel provides only a land value to other parcels (to be validated)
  • MA_MASTER.exclude_from_roll = 2 – The parcel provides only a misc. and a building value to other parcels.

Troubleshooting of Computation Errors

In case of errors during the computation process (for example, parameters not configured), all the system columns will be set to 0 and no timestamp will be attached to the appraisal records. (verify if at detail level only?)

TIP: Setup the console

Rounding Business Rules

101-ma-brules-maround-visual.pngGeneral Rounding Method

OpenForms uses the standard Microsoft XXX rounding methodology.
Full column precision for type and sized is used at the database level

Appraisal Rounding Parameters

The following parameters impact rounding at different levels:
Final Appraisal Values
MA Round Table [ma_round]

  • Building, Land, Misc, Income, MRA [code = bldg., inc, land, misc, mra, sale]
  • Total Property Value [code = appval]

General Tax Parameters

  • Personal Property Round Total or Detail value

Linked Records

  • MA_SITE.LK_LAND_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘land’) – (to be validated)
  • MA_SITE.LK_LAND_AG_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘land’).
  • MA_SITE.LK_MISC_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘misc’).
  • MA_SITE.LK_BLDG_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘bldg’).
  • MA_SITE. LK_INC_GRM_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘inc’).
  • MA_SITE. LK_INC_DIR_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘inc’).
  • MA_SITE. LK_MRA_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘mra’).
  • MA_SITE.PP_LK_VALUE is rounded to 0 decimal.
  • MA_SITE. LK_COMP_VALUE is rounded based on the MA_PARM_MAROUND information (code = ‘compval’).

Detail Component Values

MA Round Table [ma_round]

  • Building Area
  • Building Look-up Area
  • Market Living Area [code = lareamk]

General Appraisal Parameters

  • Quality Points number of digits
  • Building Size
  • Land? (verify)
  • Drawing Area Code Rounding (deprecated in 6.1)

Field Level

  • Column precision and size

 

See Also

 

 

101-ma-values

 

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 – Specifications

Mass Appraisal (MA) SPECIFICATIONS

General Information

The following documentation is for version 6.1 only and is intended for information only.

Appraisal Totals

The Property Total value depends on:

  • The valuation method in used for the property.
  • An Override Value – if Effective Override Record
  • Linked Parcels Value Distribution (condos..)

The Site Total value depends on:

  • The sum of characteristics linked to a site

The Detail Record Total value depends on:

  • The cost calculation configuration that can vary by property types, models, etc.
  • Override value in effect

 

 

101-ma-Specification

 

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

CAMA Audit Information

Overview

The CAMA Audit Information form is used for maintaining information about the mass appraisal audits associated with each property. This information includes the status of the audit, which can be either Pending or Finalized. A reason code can be associated with the audit. Details about the site visit, such as the appraiser’s name, dates, source codes and activity codes, as well as notes and comments can be tracked from this form. The Audit Information record can be transferred directly to the Govern Tax module.

When you save a CAMA Audit Record with the Value Finalized option selected, the historical data for the record are frozen.

Audit Information records can be created manually or generated automatically by the following batch processes:

  • MA Audit Pending: Run the MA Audit Pending batch process to generate a new Mass Appraisal Audit Information records with the Status set to Pending and the Frozen ID to 0. For details, see MA Audit Pending batch process.
  • MA Audit Finalized: Run the MA Audit Finalized batch process to generate Finalized Mass Appraisal Audit Information records from records with the Status set to Finalized. This batch process generates a Frozen ID for each audit, starting at -2 for the first. If a second audit is finalized, it is assigned Frozen ID -3, the third is assigned Frozen ID -4, and so on. Finalized records cannot be modified, except by authorized users. For details, see MA Audit Finalized batch process.

The Audit Information form contains new fields: Status and Reason Code.

Documentation

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

Accessing the Audit Information Form

To access the CAMA Audit Information form:

  1. Launch Govern.
  2. Open a Profile that contains the CAMA Audit Information form.
  3. Select Audit Information in the Forms Explorer.
  4. Perform a search to retrieve the required property record.
  5. Load the record to the form.

Audit Information Icons

New
Click the New icon to create a new Audit Information record for the property.
Save
Click the Save icon to save a new record or any modifications to an existing one. Data are saved to MA_AUDIT_INFO.
Delete
Click the Delete icon to remove the Property Information record from the database. A confirmation message appears. Click Yes to continue.
Browse
If multiple Frozen IDs exist for the record, click the Browse icon. You can then view and or select a copy of the record saved under a Frozen ID from the Browser Audit Information screen.
Transfer to Tax
Select the Transfer to Tax icon to transfer the active record directly to the TX_RE_ ASSESSMENT table in the Govern Real Property Tax module.
When you transfer the audit information to tax, the following fields are populated on the Tax Assessment Maintenance form and in the Govern database.

Govern OpenForms User Form and Fields Govern Database Table and Column
Form Real Estate Tax Assessment Maintenance form Table TX_RE_ ASSESSMENT table
Field Land Value Column VA_LAND_ VALUE
Field Improvement Value Column VA_IMPROVEMENT
Field Total Assessment Column VA_TOTAL_ASSMT

A confirmation message is displayed when you click the icon. Click OK to continue.

Audit Information Data Entry Fields

Value Finalized
Select the Value Finalized option and click Save when the audit is complete. Once a Value Finalized record is saved, all fields are read-only and cannot be modified, except by authorized users.A new Frozen ID is generated and applied to all the CAMA records for the property. These records can be viewed, at any time, by selecting the applicable Frozen ID in the History panel.
The MA Audit Finalized batch process automatically generates MA Audit Information records. On these records, the Value Finalized option is selected. Records are generated from MA Audit Information records with the Status set to Finalized.
Status
The Status combo box contains two items Pending and Finalized.
The MA Audit Pending batch process creates new MA Audit Information records with the Status set to Pending. An appraiser can set the Status to Finalized when the audit is complete. The MA Audit Finalized batch process generates finalized audit records and automatically selects the Value Finalized option.
Fiscal Year
By default, this field displays the fiscal year of the department. This year is also displayed on the Govern Toolbar.
Frozen ID
This field displays the frozen ID of the selected record. When the record is current, the Frozen ID is set to zero (0). When a finalized audit record is created for the property, the Frozen ID is set to -2 for the first, -3 for the second, -4 for the third, and so on.
Site Number
Select a Site Number from the drop-down list.
Audit Reason
Select a reason code to explain the reason for the audit (Table: VT_USER.MA_AUDIT_REASON).
Entry Date
Enter the date the information was recorded.
Appraiser
Select an appraiser’s name from the drop-down list.
Entry Code
Select the entry code from the drop-down list (Table: VT_USR_ MAENTRY).
Activity Code
Select the activity code from the drop-down list (Table: VT_ USR_MAACTV).
Source Code
Select the source code from the drop-down list (Table: VT_ USR_MAINFSRC).
Notes & Comments
This field provides space for notes and comments.

 

 

101-ma-frm-019

 

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