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

 

MA Single Entry Tables Income Added Items by Category

MA Single Entry Tables – Income Added Items by Category

Release 6.1

Overview

The Mass Appraisal Income Added Field has been changed. It has been removed and replaced with a generic editor. Currently it has been labeled as Income Added Fields, and is, for now, only for MA Income.

Scripts

Below are scripts that correspond with any changes to MA Income Added Fields.

Modifications on MA Parm Income Added Fields Editor (as of 2015.11.25 Wed.)

The Mass Appraisal (MA) Income Added Field has been changed. It has been removed and replaced by a generic editor (currently, it is labeled as Income Added Fields, and is, for now, only for MA Income.

As an alternative to adding a script to the MiscCorrectionScripts, premature at this stage of development, execute the following script on relevant Release 6.1 databases:

DELETE FROM vt_user WHERE code = ‘incadd0’ AND table_name = ‘MA_TABLE’
DELETE FROM ma_tables WHERE table_name = ‘incadd’

In addition, execute the following missing script (if (Table: MA_TABLES_BACKUP) exists.

DELETE FROM ma_tables_backup WHERE table_name = ‘incadd’

The above removes the incadd table type in Mass Appraisal’s Single Entry Tables.
DEVNOTE: Location of MiscCorrectionScripts (LOCATION: ServerNamedeploymentsBinariesSYSTEMrelNum)

the Mass Appraisal Income Added Field has been changed. It has been removed and replaced by a more generic editor(for now, it is labeled as “Income Added Fields”), and is, for now, only for MA Income.
Instead of adding a script in MiscCorrectionScripts which isn’t relevant for this stage of development, I ask you to execute this script on your DBs 6.1:

 

 

103-ma-parm-add

 

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

 

 

 

GNA Conversion MA Tables

(GNA) Conversion – Mass Appraisal Tables

Overview

A conversion is required for clients upgrading to Govern OpenForms, version 6.1 from an earlier release version of Govern for OpenForms, or from Govern for Windows. This upgrade is due to changes that have been made to the structure of the Govern Database. See Govern Database Diagrams – Refer to the List of Changed Tables section

 

 

103-ma-cvt-002

 

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

Govern Installation

Govern Installation

This page contains links to installation and setup resources, and documentation.

Setup

Database and Connections

  • Install MS SQL SERVER (399-Installation)
  • Create Databases and Connections (ODBC)
  • Execute Admin One-Time Script Execution
    • As of 6.0, a one-time script needs to be executed by a DB SYS ADMIN to setup a Table Change Event required by the application. The first time a Verify Database is run, the script will be executed.
      • If the Govern user does not have the required access, an error will be displayed and it will be MANDATORY to have the Database Administrator (DBA) executed it manually.
      • Click here to access the CreateCleanupJobForRecentTableChanges script commands that can be copy and pasted in a MS SQL SERVER Query windows

Deployment Server

Deployment Client

Configuration

API/Services

  • Batch Scheduler Service (106-installation) see also (106-all-sc)
  • AR / CC Web Service
  • PC / GIS Web Service
  • eGov Web Service

System Options

  • Mobile Installation
  • e-Government Installation
  • GIS

3rd Party Tools

  • For testing email notifications SMTP4Dev

Other Systems

Upgrades

From Govern for Windows 10.8

From a Previous Version of OpenForms

 

Troubleshooting

Cannot Start Application Error

Application cannot be started. Contact the application vendor.
If you are having problems to open the shortcuts directly from the server you need to delete the folder [2.0] under the path below.
C:Usersuser_idAppDataLocalApps.
100-Installation-ShortcutError.pdf

Users do not have access to Govern Security Manager
Only users setup as Administrator or Super User in the User definition table can access GSM. (USR_USERFILE)

 

100-Installation

Accounts Receivable (A/R) Module

Accounts Receivable (A/R) Module

Overview

The Accounts / Receivable and Cash Collection module is used for collecting and recording payments. It is designed for use by cashiers and accounting departments working directly with the public and processing the payments required for a local government. Inquiry on customer accounts and open invoices are provided for by the Govern applications. Reports can be requested at any time and can provide balancing, accounting and management information.

Documentation

To see this information in .PDF format, click on the following link:
101-ar-AccountsReceivable

For the A/R Transaction Rules, see 101-ar-001-AR-TransRulesGL.

 

Read More...

 

A/R Administrative Forms

A/R General Parameters The General Parameters form is used for defining the A/R settings that are used throughout Govern. These include deposit management, subsystem priorities for A/R data, ACH parameters, and billing options. 103-ar-parm-General
A/R Class Codes A/R Class Codes are used for classifying Accounts Receivable information. They are set up by subsystem. 103-ar-parm-Class

Overview

This section provides an overview of the A/R data entry forms available for Accounts Receivable in Govern OpenForms. For details, see Govern Accounts Receivable.

Accounts Receivable Inquiry

The Accounts Receivable Inquiry form displays transaction details on the selected account, including historical data, where applicable. This form is linked to the master file of each subsystem so that you can access all the accounts receivable information available on a given property or taxpayer name and address record. See AR Inquiry

A/R User Forms Accessible From A/R Inquiry

Payment Data Entry The Payment Data Entry form is used for accepting and processing payments at the counter, by cash, check, credit card, debit card, or by any other user-defined method. The current owner of the account is automatically defined as the payer. AR Payment Data Entry
A/R Transaction The A/R Transaction form is used for a number of Accounts/Receivable transaction types, including abatements, charges, fees, and duplicate payments. It is used for viewing existing transactions, creating new ones, and for applying modifications to an account or bill. AR Data Entry – AR Transactions
Abatements and Exemption Abatements are applied to reduce the amount owed on an account or to exempt an amount from payment. Typically, they are used to decrease property taxes and are applied after the real property tax assessment and levies are calculated. AR Data Entry – Abatements and Exemptions
Adjustments The A/R Adjustment form is used to apply modifications to an account or bill and can be used to either increase or decrease the balance due on an account. AR Data Entry – Adjustments
Charge, Demand, Fee, Interest, and Penalty Transactions The transaction types in this section follow the same form as the A/R Adjustments. Select the applicable form for the transaction type. Then follow the procedures described under A/R Adjustments. AR Data Entry – Interest, Penalties, Fees and Charges
Refunds The section describes the Refund transaction data entry form. Typically, refunds are used for overpayments and duplicate payments. AR Data Entry – Refunds
Refund Reversal The Refund Reversal transaction process is available for posted refunds only. It can be run if a refund or payment reversal was created in error. https://kb.harrisgovern.com/101-ar-frm-028
Payment Reversal: The section describes the Payment Reversal transaction data entry form. Typically, payment reversals are used for Non-Sufficient Funds (NSF) checks. R Data Entry – Payment Reversals
Payment Transfer The section describes the Payment Transfer transaction data entry form. Payment transfers are used to transfer posted payments from one account to another. They can be used to correct payments that were posted to the wrong account. They can be made on posted payments only. AR Data Entry – Payment Transfer

Deposit Management

NOTE: Deposit Managment is required in Govern OpenForms version 6.0 and above.

 

Deposit Management Deposit Management is required for all A/R transactions including delinquency collection and bankruptcy in Govern OpenForms. A deposit number is assigned to all transactions and this is used for posting payments through batch processes. Deposit numbers can be automatically-assigned or created manually. In both cases, they are managed through the Deposit Management user form in Govern. Automatically-assigned deposit numbers are made up of the current date, the initials of the currently logged-in user, and a sequence number. They cannot be overwritten. Manually created deposit numbers are system generated, based on a combination of user-defined criteria. These can be overwritten. AR Deposit Management

A/R Batch Processes

Overview

For general information on batch processes, see Standard Batch Processing Feature in Govern, Setting up Batch Process in Govern Administrator or OpenForms Batch Processing

The Accounts Receivable batch processes are grouped under the following headings on this page:

  • Daily Batch Processes
  • Periodically
  • Yearly
  • Batch Deletion

All batch processes are displayed in the Batch Process Explorer by short description.

Daily Batch Processes

The batch processes in the Daily section are run regularly or on a daily basis. They include:

Cash Collection Posting Transfers payment records to the payment summary in A/R. See Cash Collection (Payments) Posting. https://product.govern.harrisgovern.com/101-ar-bp-020
Payment Reversal Posting Transfers payment reversal entries to the A/R payment summary records. Payment reversals are used for Not Sufficient Funds (NSF) checks or for incorrect payment posting. https://product.govern.harrisgovern.com/101-ar-bp-041
Payment Transfer Posting Transfers payment transfer records to the A/R payment summary records. Payment transfers are created to transfer amounts from one account to another. They can be used to correct payments that were posted to the wrong account. Payments can be transferred only after a payment is posted. AR Posting – Payment Transfers
A/R Adjustments Posting Transfers A/R Adjustment entries to A/R payment summary.
Generate Refund Check Numbers Generates check numbers for refund transactions. This batch process can be used instead of the default setup. By default, a check number is automatically generated when you create a refund transaction. A setup is required in GNA before running this batch process in order to change the default Generate Refund Check Numbers
Refunds Posting Transfers the refund entries to the A/R payment summary records and finalizes the records.. https://kb.harrisgovern.com/101-ar-bp-025
Postdated Payments Posting Transfers postdated payments to A/R payment summary records. https://kb.harrisgovern.com/101-ar-bp-027
Deposit Posting Deposit Posting is used for transferring the deposit transaction to Accounts / Receivable summary and finalizing the transactions. https://kb.harrisgovern.com/101-ar-bp-031

Periodically

The batch processes in the Periodically section are run frequently, but only when required. These batch processes perform calculations and apply outstanding amounts as required.

Apply Pending Credits Reapplies credits generated from transactions posted after a balance record was processed. AR Apply Pending Credits
Set Warning Flag on Delinquent A/R Run this process to add a warning message to an account or to a group of accounts with outstanding charges. The message appears whenever the account is accessed. You need to enter the subsystem, and Minimum Balance Due. AR Set Warning Flag on Delinquent
Apply Penalty on Delinquent Accounts Calculates penalties based on amounts owed as of a specific date. AR Apply Penalty on Delinquent
Generate Delinquent Charges Posts the late charges on accounts with outstanding balances. AR Generate Delinquent Charges
Compute Balance Due As Of Date Calculates the interest due for a specific date. AR Compute Balance As Of a Date
Extract an As Of Date A/R Detail Table Creates a temporary table listing A/R information for a specified date. This process allows the User to view the information and to create reports. AR Extract As Of Date A/R Detail Table
Automatic Generation of Refunds Generates a refund or a group of refunds based on selection criteria. AR Generate Refunds
Automatic Generation of Over and Short Generates all over and under payments currently in the system. AR Generate Over and Short

 

Yearly

The batch processes in this section are run once a year or when a period closes.

Transfer A/R to History Transfers A/R records to the A/R_MASTER database table. Billing entries are summarized by date while cash flow entries are transferred as is. AR Transfer to History
Reinitialize A/R Tables Deletes all records from the Accounts Receivable database tables: AR_MASTER, AR_DETAIL, and AR_SUMMARY. This process is used by organizations that forward their records at year end and do not keep historical copies. AR Re-Initialize A/R Tables
Period Closing Sets a closing date for an accounting period. After the closing date, A/R data cannot be recorded or modified for the period. AR Period Closing
Transfer Credits from One Year to Another: Adjusts your accounts by removing credits from accounts in one year and applying them to another. AR Transfer Credits from One Year to Another

Batch Deletion

The batch processes in this section delete non-posted transactions. They are used for maintaining A/R transaction records and files. Once transactions are posted, they cannot be modified or deleted.

Batch Deletion of Payments Deletes non-posted payments. https://kb.harrisgovern.com/101-ar-bp-080
Batch Deletion of Refunds Deletes non-posted refunds. https://kb.harrisgovern.com/101-ar-bp-081
Batch Deletion of A/R Transactions: Deletes non-posted transactions. https://kb.harrisgovern.com/101-ar-bp-082

Configuration

System Parameters & Validation Tables

Application Parameters

Configuration Utilities

  • Enterprise Migration Tool (under review)
    • Export: Select Govern Tax, then A/R parameters
    • Import: After import, added fields will need to be setup in the business entity designer (BED) and then added to the form (OFD)?

 

System Options

System Series (200-299)

Third Party

System Series (300-399)

  • Contact R&D for details

API & Services

System Series (400-499)

  • Contact R&D for details

Web Service

For information on the Accounts Receivable Web Service, see AR/CC Web service

Legend

Pink – Available not tested … | Red – Under review, Malfunctioning or Known Issue(s) … #e000000 | Gray – Not Available – Roadmap …

 

 

 

101-ar

 

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