103-ma-parm-General

103-ma-parm-General #103ma

Mass Appraisal General Parameters
Mass Appraisal Module Overview, What’s New, wiki Module Map Govern Administrator wiki GNA System Map
Version 6.1
Overview | Documentation | Page 1 Parameters | Roll Forward Data | See Also

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:
WorkflowGeneralController.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 on page 103.

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

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 screen shot, the current year is 2013. The user returns to 2010 and changes a record. A confirmation message, similar to the following, 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.

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

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.

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 page 111 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

See Also

Mass Appraisal Module Overview

*

GNA Field Exclusions

Fields Exclusion

Overview

Use the Field Exclusion form to define the list of fields to exclude from the Roll Forward and Copy to Year processes. Fields that are not listed are copied to the destination year when you run a Roll Forward or Initialize Year batch process on a Mass Appraisal or Tax module.

Documentation

To view the pdf version of this page, click on the following link.
FieldsExclusion.pdf

Accessing the Form

To access the Field Exclusion form:

  1. Launch GNA.
  2. Select Application Configurations > Fields 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 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.

Tables

Fields from the following tables can be excluded from the Roll Forward or Initialize Year process.

Aircraft Excise Tax Tables

  • AC_ASSESSMENT
  • AC_ASSESSMENT_DET
  • AC_EXEMPTIONS
  • AC_LEVY_MASTER
  • AC_LK_LEVY_EXEMPT

Boat Excise Tax Tables

  • BT_ASSESSMENT
  • BT_EXEMPTIONS
  • BT_LEVY_MASTER
  • BT_LK_LEVY_EXEMPT

Mass Appraisal Tables

  • MA_BLDG_AREA_YEAR
  • MA_BLDG_DRAWING
  • MA_BUILDINGS
  • MA_BUILDINGS_2
  • MA_INCOME
  • MA_INCOME_DETAIL
  • MA_LAND
  • MA_LINKS_PERCENT
  • MA_LK_INC_FIELD
  • MA_MASTER
  • MA_MISC_STRUCTURES
  • MA_MRA
  • MA_OVERRIDE
  • MA_SITE
  • MA_VALUES_TABLES

Motor Vehicle Excise Tax Tables

  • MV_ASSESSMENT
  • MV_EXEMPTIONS
  • MV_LEVY_MASTER
  • MV_LK_LEVY_EXEMPT

Property Control Tables

  • PC_AREA
  • PC_LEGAL_INFO

Real Property Tax Tables

  • TX_EXEMPTIONS
  • TX_LEVY_MASTER
  • TX_LK_LEVY_EXEMPT
  • TX_RE_ASSESSMENT

 

Related Information

See the Mass Appraisal Initialize Year Batch Process.

 

 

103-GN-001

 

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

 

 

AR Lockbox Configuration

Accounts Receivable (A/R) Lockbox Configuration

Configuring the A/R Lockbox

The configuration of the A/R Lockbox comprises the following steps:

  • Verifying the Configuration in the Business Entity Designer (BED)
  • Setting the Default Parameters in GNA
  • Defining the A/R Subsystem Priorities
  • Setting Up Deposit Management
  • Setting Up A/R General Parameters for the Subsystems
  • Defining the Lockbox Batch Process
  • Setting Security for the Lockbox
  • Customizing the Layout

For more information about lockbox user data entry, see the A/R Lockbox user form.

For more information processing an A/R Lockbox file, see A/R Lockbox batch processes.

Verifying the Configuration in the Business Entity Designer (BED)

Read More...

The A/R Lockbox contains one business model with two business entities:

  • Business Model: AR_Lockbox
  • Business Entities. AR_Lockbox_Header and AR_Lockbox_Detail

You can configure the following:

  • On the Model: Allow use in the Govern Query Tool.
  • On the Entities: Set rules for Auditing and Central Notes

Setting the Default User Registry Parameters in GNA

The following defaults are defined in the User Registry Manager in GNA for the Lockbox user form in Govern. They can be configured for the Lockbox user form in Govern. These are defined in the User Registry Manager.

  • Effective Date
  • Entry Date
  • Installment
  • Payment Type
  • Transaction Type

To configure the default settings:

  1. Launch GNA.
  2. Select Parameters > User Registry Editor.
  3. Select Lockbox from the Registry Filter.
  4. Enter a date in the Default Effective Date parameter. This appears on the Lockbox Details tab of the Lockbox form in Govern.
    The Effective Date is the date that the payment becomes effective.
  5. Enter a date in the Default Entry Date parameter. This date appears in the Entry Date field on the Lockbox Details tab of the Lockbox form in Govern, when you click New.
    The Entry Date is the date that the payment is entered.
  6. Select an installment number from the Installment drop-down list. The installment appears on the user form. Installments are used with Real Property Tax. They are defined in the VT_SYSTEM INSTALL table. Setting the installment type for the period in which the payments are entered, speeds up the data entry process.
  7. Select a payment type from the Payment Type drop-down list. Payment types include: ACH, American Express, Collection Agency, Debit, Discover, eCheck Personal, Lockbox, MasterCard, Pinless Debit, and Visa.
  8. Select a transaction type from the Transaction Type drop-down list. Typically, this is Payment.
  9. Click Save.

Users have access to these settings from the Lockbox user form in Govern, if they have the required security permissions. See Setting Security for the Lockbox.

Defining the A/R Subsystem Priorities

Define the order in which payments received through the Lockbox, and by other means, are distributed. This is set on the A/R Subsystem Priorities.
Payments are distributed according to the following rules:

  • Payments are made first to the subsystems with the Ignore Year option selected, according to Priority Number. The subsystem with the highest priority number is paid first.
  • Payments are then made to subsystems with the Ignore Year option deselected, according to Priority Number. The subsystem with the highest priority number is paid first.
  • If two subsystems have the same priority number, and the Ignore Year is the same, payments are made in alphabetical order.

To access the A/R Subsystem Priorities form:

  1. Launch GNA.
  2. Select Application Configurations > Accounts Receivable > A/R Subsystem Priorities.
  3. Enter a number in the Priority field beside each subsystem for which payments are received through the lockbox. This number corresponds to the order in which payments are made on billed items. The highest number represents the highest priority (AR_Master.PRIORITY).
  4. Select Ignore Year to give the subsystem priority. Otherwise, payments are made on all outstanding bills according to year; i.e., all bills from 2015 are paid before the bills from 2016 if this option is deselected.
  5. Click Save.

Click Exit to close the form. A confirmation message appears if there are any unsaved modifications. Click Yes to save your new data or No to close the form without saving.

Setting Up Deposit Management

Deposit Management is required for all A/R transactions including those received through the Lockbox. Deposit numbers can be created manually or automatically. In both cases, they are managed through the Deposit Management entity, which is part of the Lockbox form in Govern.

Full details of setting up Deposit Management are provided in the Accounts Receivable documentation.

Setting Up A/R General Parameters for the Subsystems

Review the Accounts Receivable General Parameters to ensure that the rules for minimum payments are correctly setup.
To review the A/R General Parameters:

  1. Launch GNA.
  2. Select Application Configurations > Accounts Receivable > General Parameters.
  3. Verify the Minimum Balance to Compute Charges parameter.
  4. Scroll through the settings for each subsystem under Related Subsystem Parameters.
  5. Verify the setting for Allow Payments < Late Charges Due for each subsystem.By default, payments that are less than the late charges due cannot be entered on the user forms. A message appears and the payment cannot be saved.
  6. Verify the Minimum Collection Amount for each subsystem for which it appears.

Defining the Lockbox Batch Process

To define the A/R Lockbox batch process:

  1. Launch GNA.
  2. Select Editors > Batch Process Definition Editor.
  3. Click New.
  4. Select A/R Lockbox from the Process drop-down list.
  5. Set up the parameters as defined in the Batch Processing documentation.

Setting Security for the Lockbox

In the Govern Security Manager (GSM), you can define security permissions for the GNA administrative forms used for the Lockbox. However, this security applies to the entire form. For example, the security definitions for the User Registry Manager apply to the entire form, not just the Lockbox options.

The User Registry Lockbox parameters are also available in Govern via an action button. You can provide security for this action button through the OpenForms Designer.

To define this security:

  1. Launch the Govern Security Manager (GSM).
  2. Select Applications > Govern > Profiles.
  3. Select the Profile containing the A/R Lockbox form and Batch Process.
  4. Select Batch Processes > A/R Lockbox.
  5. Right-click on the A/R Lockbox batch process.
  6. Click Edit to set up permissions.
  7. Click Exclusions to define exceptions to the permissions.
  8. Click OpenForms.
  9. Select the A/R Lockbox form.
  10. Repeat steps 5 through 7.
  11. Click Save.

Customizing the Layout

You can make the following changes to the Lockbox user form through the OpenForms Designer (OFD):

  • Customize the form by renaming and repositioning the fields as required by your organization.
  • Customize the Browse screen and the Record Description, if required.
  • Set the security for the Lockbox user form in Govern.

To set up the security:

  1. Launch the Govern OpenForms Designer (OFD).
  2. Open the A/R Lockbox form.
  3. Select the Security icon to shift to Security Mode.
  4. Select a Security Type, Profile, and Role or user.
  5. Select the User Registry action button.
  6. Define the security permissions.
  7. Click Save.
  8. Repeat steps 4 to 7 for all required combinations of Security Type, Profile, and Role or user.
  9. Repeat steps 4 to 7 for all required combinations of Security Type, Profile, and Role or user, but select the Quick Save and Insert action button.

 

 

101-frm-036-config

 

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

 

 

 

 

UB Module OpenForms Reference

Utility Billing (UB) Module OpenForms Reference

Version 6.0 and Version 6.1 – (In Development)

Overview

This module is currently in development. This page will be updated as information becomes available. Please refer to the module Product Map or contact Govern R&D.

 

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

What’s New in Utility Billing

Utility Billing What’s New

Version 6.0 and Version 6.1 – (Under Development)

Overview

This module is currently in development. This page will be updated as it becomes available. For more information, refer to the module Product Map or contact R&D.

 

 

101-ub-wnew

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

101-ub-compute

Utility Billing Compute

Version 6.0 and Version 6.1 – (In Development)

Overview

The Utility Billing Computation process has two stages: the Tentative Computation and the Posting to A/R. Perform the Tentative Computation to calculate readings and services and view the results before posting them to A/R. You can then make any required modifications before finalizing the process.
For more information, see the module Product Map or contact R&D.

 

 

101-ub-compute

 

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