As a result of the added functionality and enhancements to the Govern Mobile application, changes have been made to the Govern New Administration (GNA) user interface.

Initialize Mobile Database

• New feature to Add and Update User Tables, during the GNA Initialize Mobile Database process, and the Mobile Deployment Get Latest process.
• Feature to allow users to Exclude database objects, i.e. tables, functions, or views. Excluded objects are populated in an exclusion table.

Verify Database Process

• NEW! RE / PP Tax Conversion Scripts have been included to add required “RE” Cycle Codes. See RE/PP Tax Conversion Scripts in the What’s New! section.

Email Template Editor

• 6.1 (1706) New Email Template Editor.

Database Utilities

• [6.0 / 6.1] Support for the extraction of Personal Property (PP) tables in the Mobile Database Initialization process.
• [6.1] Database Extraction Utility to extract a snapshot of the data along with all parameters for a selected data set.
• [6.0] Database Verification behavior changes on opening Govern Administrator (GNA)
  • If the connection key is set to an empty database, the Initialize Database process will be launched automatically (see below) and once completed, GNA will be closed and restarted as it is mandatory to run the Verify Database process
  • If their is a major release difference (first 2 digits) between the the program and the database version, it will be mandatory to run the database verification or exit the application. This situation will occur for example, when upgrading from 5.1 to 6.0. A change from 6.1.1503 to 6.1.1511 will not trigger it .
• [6.0] Database Verification new INITIALIZE Database process to create a Govern Ready Standard System Database.
  • It is no longer necessary to use UPDATA. Tables, fields and views will be created automatically
  • Process is triggered automatically when the table USER_KEY_MASTER does not exist
• [6.0] Database Verification INITIALIZE Database process – NEW Govern USER and ROLE
  • A new role called “Govern SuperUsers” is created in the GSM. This role will grant access (E)xecute to all GSM and GNA functions.In addition, a User called Govern User belonging to this role will be created.
  • The Govern user password can be changed, the user and role can be deleted after a new Administrator user and role with full access has been successfully created and validated for the organization.
• [6.0] Database Verification INDEXES
  • All indexes created and used by the Govern applications will be identified as such and will start with the letters GV or PK when the index is a primary key. This will enable the application to manipulate these indexes when needed.
  • An option to delete and recreate indexes was added
  • NOTE: Indexes created by users will not be modified or manipulated in any way. However, it is strongly recommended to delete and recreate them. First they should be reviewed to see if they are still needed (some indexes can impact performance negatively) and for the ones to keep, documented, as they will need to be recreated manually. They can be deleted using the Database Verification Delete Indexes of Type option ALL.

Connection Keys

• [6.0] A trailer connection key called NOLIMIT will be automatically created and used for lengthy processes that may time out with the preset time limit. For instance, one cause of a time out can be during the rebuilding of an index for an extremely large table. If the time required to rebuild the index exceeds the timeout limit, the system will error out. By default its timeout is set to UNLIMITED. This key can be selected through the Connection Key Manager.

Editors

• [6.1] External Command Editor has changed
  • It is now expression driven, and all external commands are now written as expressions. The seven combo boxes in the 6.0 version, for adding logical expressions, constants, formulas, etc., have been replaced by one, the Expression Selector.
  • You can now view all the Profiles and user forms to which a selected command is added directly on the External Commands Editor in the Used In list box.
• [6.1] Constants & Expressions can be overridden by group (year and jurisdiction)
• [6.1] Queries can be overridden by group (year and jurisdiction)
• [6.1] Execution Context
• [6.0] Batch Process are no longer setup by categories and are linked to the Profile
• [6.0] Reports are no longer setup by categories and are linked to the Profile

User and System Validation Tables

• [6.1] Generate Data Base View (If checked, will create a view
• [6.1] Tables can be setup by Jurisdiction
• [6.1] New flag when tables are Maintained by System
• [6.1] Added fields can now be created in this function

Application Parameters General

• [6.1] Roll Forward Exclusion (new functionality to exclude fields from being rolled forward)
• [6.0] “Owner as of Month” and “+/- Years” in the GNA Department Maintenance form NEW!

Application Parameters

• [6.1] Mass Appraisal parameters are available on OpenForms
• [6.0] Accounts Receivable parameters are available
• [6.0] Cash Collection parameters are available
• [6.0] Business Tax (SRT) parameters are available
• [6.0] Personal Property parameters are available
• [6.0] Real Property parameters are available

User Interface

• [6.0] The interface for the Govern New Administration has been updated to have a similar look and feel and navigation as other applications in the Govern Release 6.0 suite. Refer to GNA User Interface for interface details.

Troubleshooting

Table Change Event Script

• The first time a verify database is run, a script needs to be executed by a user with System ADMIN rights.

• IMPORTANT: If your user does not have the required rights, the System DBA will need to execute the following script in each Data Base Server used for Govern deployments.

   

• Click here for the script CreateCleanupJobForRecentTableChanges commands that can be copied and pasted directly in a query window in MS SQL Server