Mass Appraisal Computation Batch Process
Release 6.1
Overview
The Mass Appraisal computation batch program calculates the values for all the mass appraisal modules, Property, Site, Land, Buildings, MRA or FMV, Income, and Global. A separate batch process is available for the Mass Appraisal Sales module.
For details on Mass Appraisal Computation and Value Business Rules, see Valuation, MA Tables, Modification Stamps.
Computation by Neighborhood
Neighborhoods are filtered by jurisdiction. In order to run the batch process by neighborhood, you need to set up the Mass Appraisal User Validation Table by Jurisdiction.
To set up the Neighborhood table by jurisdiction.
- Launch GNA.
- Select Editors > User Validation Table Editor > Mass Appraisal.
- Select NBHD – Neighborhood.
- Select By Jurisdiction.
Running a Batch Process on a Saved Dataset
If you want to run a batch process on a group of parcels, such as parcels within a certain area or tax jurisdiction, you need to create and save a dataset. You can also use an existing dataset. In Govern, a dataset is a saved group of property records:
To create a new dataset:
- Launch Govern.
- Perform a search and load the parcel records that you want to include in the dataset to the treeview.
- Select the View menu.
- Enter a name for the dataset in the text box in the Data Sources section of the View menu.
- Click Save Dataset.
For further details on creating Datasets, refer to the Govern General Information documentation.
Accessing the Mass Appraisal Computation Batch Process
To access the Mass Appraisal Computation Batch Process in Govern:
- Launch Govern.
- Select a Profile that contains the Mass Appraisal Computation batch process.
- Select the Mass Appraisal Computation batch process.
Year: Enter the year for the computation. This is a required field.
By default, this field displays the year entered the last time that the process ran.
Parcels to Compute
Select one of following:
- All
Select this option to run the process on all parcels that meet the other criteria.
- Saved Dataset
Select this option to run the batch process on the selected dataset.
- Jurisdiction / Neighorhood
The Neighborhood is optional. However, if you want to run the batch process on a specific neighborhood, you must select the Jurisdiction first.
Jurisdiction
Select a Jurisdiction to run the sales data computation on a specific jurisdiction.
Neighborhood
In order to select a neighborhood, you must select a Jurisdiction first. Select the Jurisdiction. Then, select the neighborhood from the Neighborhood drop-down list.
- Tax Map Number
Enter a range of tax map numbers in the From and To parameters under Tax Map Number.
Computation Options
Select one of the following options.
- All parcels that require a data update: Select this option to run the batch process on all records that are not up-to-date because they were modified before the parameters changed in GNA. These parcels have a modification date that is earlier than the parameter change.
- All parcels that require a data update and a force compute: Select this option to run the batch process on all parcels that are not up-to-date and on all records for the selected modules. Then select the Mass Appraisal modules on which you want to run the computation:
- All, Site, Miscellaneous Structures, MRA, Land, Building, Income, and Global.
Records to be processed:
- Year selected: or all if none selected
- Records (parcels) selected: all, saved named dataset (includes autosave dataset), jurisdiction, neighborhood
- Record Frozen-id = zero (current)
Records to be calculated:
- When the modification stamp of the record requires it (see Batch Processing below)
- A change was made to Mass Appraisal Tables (different impact) after the component record was last computed
- A component modification stamp is null (never computed or changes to characteristics or dependencies that require a compute)
- A component modification stamp is less than the Component or Site parameters modification stamp
- The force computation can be applied to all modules or to a specific one.
Batch Processing:
- The batch program can be scheduled to run periodically. For instance, a process can be run every 3 minutes.
- The transaction Mode “Roll Back If One Transaction Failed” is not supported. It will be “Continue If One Transaction Failed” by default
- Refer to the Standard Batch Process details Batch Program Setup or Govern Scheduler for more details
Batch Execution
The batch program can be executed on demand or scheduled with Govern Scheduler.
During the execution, warning and error messages will be presented in the batch result grid.
- On error, the parcel id will be displayed in the message
- Double-click on the message to access the full text
Once completed, information will be displayed, that includes:
- Parameters and Options used
- Total number of records read
- Total number of records processed
Batch Processing (technical)
Before Executing Subprocesses:
- Select all parcel ID and frozen ID related to the year (or all year if none selected) the jurisdiction, or the neighborhood or the saved dataset if chosen.
- When the Computation Options “All parcels that require a Data Update” is selected and the “Only Parcels with an empty modif stamp” is checked
- The batch process will only return parcels without a modif stamp in MA_MASTER.
- MA_MASTER.MODIF_STAMP = NULL
- The batch process will only return parcels without a modif stamp in MA_MASTER.
Execute Subprocess
- For each computation, select all parcels with records for that component to compute
- MA_MASTER.MODIF_STAMP = NULL
- MA_“component”.MODIF_STAMP = NULL
- MA_“component”.MODIF_STAMP less than MA_“component”.SITE_MODIF_STAMP
- MA_“component”.MODIF_STAMP less than MA_MODIF_STAMP.”component”_STAMP
- If the component does have a force compute option setup, select all component items to compute
- Computation order:
- Compute site
- Compute miscellaneous
- Compute MRA
- Compute land
- Compute building
- Compute income
- Compute global
What’s New
- 6.1 Final Compute and Transfer Records to tax is now a distinct batch program called Transfer to Tax (see road map).
- 6.1 Final Compute Set History to Yes is now a distinct batch program called Close Year
- 6.1 The batch computation will now process records set to History Only (prior to 6.1, they were not processed)
Troubleshooting
- After changes, it is always best to compute for a single year and small dataset
- The parcel ID is listed in the error message
- Turning on the Govern Diagnostic Tool
- Turning on the SQL Profiler Tool (system administrator)
See Also
- Mass Appraisal Batch Sales Computation
- Standard Batch Process
- Govern Batch Program Setup
- Govern Scheduler
- R&D Development Notes (internal only)
101-ma-bp-002