Govern Standard Batch Programs

Govern Standard Module – Batch Processes

Overview

Batch processes are used to calculate and update multiple records at the same time, to post records to the General Ledger accounts, to delete records that are not posted, to apply pending amounts and penalties, to extract or compute amounts for a specific date, and to close a fiscal period or year. This page provides general information on batch processes that applies to all modules.

Prerequisites

  • Each batch process must be defined in GNA, Batch Process Editor.
  • It must be linked to a Profile and accessed through a Profile.
  • Access permissions must be provided by role and user.

Accessing the Batch Processes

To access a batch process:

  1. Launch Govern.
  2. Select Batch Process in the View menu if the Batch Processes explorer is not displayed.
  3. Open the Batch Processes explorer.
  4. Select the process that you want to view.
  5. Running Batch Processes
  6. Open the batch process and enter the optional and required information, such as selecting a deposit number or numbers, entering a range of dates or tax map numbers, selecting a department, subsystem, and cycle code. You can do any of the following:
  • Execute or run the process immediately.
  • Schedule the process to run at a later date or on a recurring basis, at regular intervals, such as daily, weekly, hourly, etc.
  • Create and save a schedule for a batch process. Then, deselect the Activate button until you are ready to put the schedule into place. Select Activate when you are ready to run the process at regular intervals.

For further details about running and scheduling batch processes, refer to the Govern Scheduler documentation.

General Guidelines

This section provides a few rules and tips about batch processes.

Optional Fields

If a field is optional, you can enter the required criteria or leave it blank to process all records that meet the other criteria on the form. For example, if a date field if optional, leave it blank to process records from all dates.

Fiscal Year

The Fiscal Year displayed in the Home menu in Govern Ribbon is not applicable to the batch processes. When the fiscal year is required for the batch process, you need to enter it on the batch process form. On some batch processes, you may need to enter an effective year or entry year as well as the fiscal year.

Posted Records

When you run the Account Receivable batch processes, records are saved to the following tables: AR_MASTER, A/R_SUMMARY, and AR_DETAIL.

Once A/R records are posted, they cannot be modified or deleted. Therefore, it is important to verify all records before posting them.

Deposit Management

Deposit Management is integrated with Accounts Receivable in Govern OpenForms. All Payment Data Entry transactions require a deposit number. Depending on the setup in GNA, the deposit numbers can be automatically-generated or you can create them manually in the Deposit Management form.

Viewing Reports and Verifying the Status of Batch Processes

When you run a batch processes in Govern, the status of the process is indicated by the progress bar. Green indicates success, yellow a warning, and red an error. Information, warning, and error messages are displayed below the bar.

If you click on a message, you can view it in a message box.

You can also click on the Copy button and copy all messages to a separate file.

Viewing Reports and Attachments

Reports and attachments can be linked to a batch process in GNA. For example, a csv file, containing information about accounts with an overdue balance, could be generated at the end of a batch process. A report could be generated as a pdf.

If a report or attachment has been generated by the batch process, you can view it by clicking the icon that appears beside the progress bar when the process is successfully completed.

NOTE: You can also view reports generated from scheduled batch processes in the Govern Scheduler. Refer to the Govern Scheduler documentation for details.

 

To view a report or attachment:

  1. Launch Govern and run the batch process.
  2. When the process is complete, a message is displayed on the progress bar in the Batch Processes Explorer.
  3. An attachment icon is displayed in the list box under the Progress Bar.
  4. Click on the Attachment icon .
  5. The report or attachment opens in the application in which it was created.

See Also

Govern Batch Scheduler and Installing the Batch Scheduler Service
General Batch Process OpenForms Standards (100-batchprocess)

 

 

101-std-fea-014

 

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-std-fea-015

Govern Hibernate

Overview

An area that is critical to productivity in Govern is the user interface and workspace. The Govern Hibernate standard feature is designed to enhance the user experience. Benefits of using the feature are the following:

  • Personalization of user interface and workspace.
  • Reduced time required to recommence work after restarting the application.
  • Increased productivity by not having to re-establish interface setting and searches.

When enabled, the Hibernate feature will create a snapshot of the user work area, save the snapshot, and restore the workspace when the user restarts the application. Interface settings, i.e. Window location and pane settings are stored in (Table: USR_HIBERNATE).

Location

The Hibernate feature is located under the Options tab > Hibernate Mode group in the Govern Ribbon.

NOTEHibernate Mode is securable in the Govern Security Manager (GSM) if it is not available in the Govern ribbon, users should verify with an administrator as to whether they have sufficient access rights.

Settings

WARNINGEffective from versions: 6.0.1409.0113 and 6.0.1410.0017, a new table (Table: USR_HIBERNATE) containing 2 fields. These fields contain the User_ID and details of the Hibernate Environment in XML format. As a result of this new table, before running Govern users must first run the Database Verification process in GNA.

There are three (3) user setting options/states for the Hibernate feature. Hibernate states/options are available as a drop down menu that is displayed with a click on Hibernate Mode in the ribbon.
Options are as follows:

Auto (Default)

Auto is the default state of the application. When Govern is installed, the Hibernate Mode will be enabled. Exiting from the application will result in the current workspace being saved.

NOTE: When Auto is selected, the Save User Interface option cannot be selected.

 

NOTEWhen there are multiple OpenForm Profiles opened prior to the hibernate process, i.e. save and exit, upon restarting, the last active profile will be opened in the forefront.

On Demand

Select On Demand to give the option to:

  • Save the current workspace; saves the current workspace; the current appearance will be restored when the application is reopened.
  • Keep previously saved workspace. When you click OK, the previously saved workspace will be saved, i.e. the setting that was displayed when the application was opened.
  • Clear Previously saved workspace.

The above three (3) options are user selectable through a dialog box that appears when exiting the application.

NOTE: If the dialog box is closed, or the user clicks Cancel, the user will be returned to the application.

Off

When Off is selected, the interface will not be saved. Upon restarting the interface will be reset, i.e. no user panes will be opened, neither will any query results be restored.

NOTEWhen Off is selected, the Save User Interface option cannot be selected.

Business Rules

When the Hibernate feature is enabled, and a user workspace is saved, the following business rules will apply
1. All open profiles will be recorded, and restored when the Govern application is restarted.
2. When there are multiple OpenForms profiles open, when Govern is restarted, the focus will be on the active profile.

  • Each profile will be defined in the user interface settings file by its unique code and instance number to establish layout hierarchy.
  • If previously opened, all profile items, i.e. forms, reports, view queries, etc. will be reopened.
  • All dataset record keys will be loaded.
  • Active record will be selected.
  • The toolboxes layout will be saved using the ActiPro (Save/Load layout) feature.

3. A click on Save User Interface in the ribbon will save a snapshot of the user interface/workspace following the above rules 1 and 2.
4. In the event of an unrecoverable system failure, i.e. application “crash” the stored user workspace file is reset; all settings will be erased. The “Hibernate” Mode is set to “Clear”.

What’s New

[6.0] Previously the XmlHibernateByUser.xml file was used. Now the information is recorded in (Table: USR_HIBERNATE).

 

 

101-std-fea-015

 

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-std-fea-016

101-std-fea-016 #fea #stdfea #std

Jurisdictions & Clusters
Overview | What’s New

Overview

[Discontinued 6.1]
This feature is no longer needed having been replaced by the MASS APPRAISAL LINK GROUP feature.

Jurisdictions and Clusters is a standard feature option in version 6.1. It combines in a cluster or group, property physical characteristics (jurisdiction, neighborhood) with a mass appraisal group for valuation methods and rates (income neighborhood).
Functionality is currently in development.

For more information, see the technical design page.

What’s New

this section will contain any new information that is relevant to Jurisdictions.

Audit Trail (Entity Audit) Feature

Audit Trail (Entity Audit)

Overview

The Audit Trail feature is available as of Release 6.0.1410. This feature is standard in Govern OpenForms. When enabled, changes to entities are audited and user changes (Add-Delete-Modify) are recorded.
Details such as When the change was made, Who made the change, What the previous setting was, and so on are recorded and displayed in the Entity Audit form. It is recommended that this feature be enabled for sensitive data. (Table: USR_AUDIT_OPENFORMS).

WARNINGAs this feature is enabled on a “per attribute” basis, excessive use, i.e. enabling the AUDIT flag in multiple attributes can impact system performance. It is therefore recommended that the feature be used sparingly, and only when required. After the required Audit has been performed, AUDIT flags should be reset to the default values (i.e. FALSE).

 

Specifications

Read More...

The audit feature of the Audit Trail is performed on the following:

  • At the Business Entity level
  • For any Govern key, e.g. (p_id, na_id, pp_id, etc.)
  • Business Entity properties that are to be audited may be enabled/disabled to audit:
    • User View (when data is sensitive)
    • User Updates (A)dd, (D)elete, (M)odify)
    • Menu item

Configuring

Any Govern Business Entity can be flagged for auditing. When enabled the entity will be added to the Audit Trail. To add an entity to the Entity Audit Trail:

  1. In the BED, open the entity that you want to add to the Audit Trail.
  2. Under the Properties pane select To be Audited or To be Audited in View Mode under 1 – Basic Data Settings.
  3. Click Save.
NOTE: When you return to Govern, to view the results of the changes, ensure that you either close and re-open the application, or click Refresh under the options tab.

 

NOTE: An audit trail CANNOT be setup for Custom Controls.

Viewing

When enabled, the Entity Audit screen can be displayed by selecting View (tab) > Entity Audit. Alternatively, the Ctrl-H key combination may also be used.

Security

Users and Roles

Restricting the viewing of the Entity Audit screen is securable by Users and Roles.

mGovern

Audit trail works with the mGovern – Mobile application; changes made on the road will be loaded back to the master table for review.
NOTE: An audit trail CANNOT be setup for Custom Controls.

What’s New

Audit Trail Reports

Audit Trail (Entity Audit) Reports for Govern and GNA – See the Documentation section below

Implementation of Audit Trail

6.0.1410 Audit Trail has been implemented as Standard Feature 017 – Entity Audit.
Hot Key and Menu Item to VIEW Audit trail on demand with VIEW security. New tables (reminder for Upgrades changes to reports)

Best Practices

  • CTRL-H (Hot Key) to show AUDIT trail information on demand. Useful for testing, designing (form/report/….)
  • Provides the administrator and integrator with the DATA SOURCE.
  • There is always a temptation to want to control what is audited and what is not.
    CAUTION: Query and Search implementations can return a lot of records, to the extent that there may be system performance issues.

Technical Information

The Audit Trail feature is configured in the BED at the Entity Level. The Audit number is AUTO-GENERATED.
In release 6.0 of Govern, the following tables are used for Govern and GNA respectively:

Govern Audit Trail

The following tables are queried for Govern:

  • (Table: USR_AUDIT_OPENFORMS)
    • AUDIT_ID
    • AUDIT_ACTION
    • ENTITY_ID
    • FORM_CODE
    • USER_ID
    • AUDIT_DATE
    • IP_ADDRESS
    • SOURCE_COMPUTER_NAME
    • REMOTE_COMPUTER_NAME
  • (Table: USR_AUDIT_OPENFORMS_CHANGE)
    • AUDIT_ID
    • ATTRIBUTE_ID
    • TABLE_NAME
    • COLUMN_NAME
    • OLD_VALUE
    • NEW_VALUE
  • (Table: USR_AUDIT_OPENFORMS_KEY)
    • AUDIT_ID
    • ATTRIBUTE_ID
    • KEY_NAME
    • KEY_VALUE
    • IS_PRIMARY_KEY

GNA Audit Trail

The following tables are queried for the Govern New Administration (GNA)

  • (Table: USR_ADM_AUDIT_TRANS) – One record for each save
    • AUDIT_TRANS_ID
    • LAST_MODIF_UID
    • LAST_MODIF_DATE
    • IP_ADDRESS
    • SOURCE_COMPUTER_NAME
    • REMOTE_COMPUTER_NAME
  • (Table: USR_ADM_AUDIT_RECORD) – One record for each table included in a save
    • AUDIT_RECORD_ID
    • AUDIT_TRANS_ID
    • TABLE_NAME
    • RECORD_ID
    • MODIF_TYPE
    • RECORD_DESCRIPTION
  • (Table: USR_ADM_AUDIT_FIELD) – One record for each field, only when a modification
    • AUDIT_FIELD_ID
    • AUDIT_RECORD_ID
    • FIELD_NAME
    • OLD_VALUE
    • NEW_VALUE
NOTE: The legacy table USR_AUDIT_TRAIL will be kept for modules running in prior releases, but administrators should note the new modifications and table structures for any impact to their processes.

 

Documentation

Click to view or download the documentation for this feature.

Audit Trail Reports

Click below to view or download documentation for the Audit Trail Report
101-st-fea-017_Audit_Trail_Report.pdf

 

 

101-std-fea-017

 

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

Profile Visual Queries

Profile Visual Queries

Overview

The Govern Visual Query is a visualization of query results. This visual representation can be in the form of Pie Charts, Graphs of Data, or Data grids. When a dataset is retrieved, the impact upon the end user is increased significantly when the data is presented in a format that is easy for the viewer to visualize. The visual query is presented as icons that are displayed on the Govern Release 6.0 ribbon. When the user clicks the icon that is used to represent the Visual Query, the query result is displayed. Optionally after the data is displayed, the resulting chart may also be configured to display a report when the user clicks on the image of the chart.

Display of Data Query Controls

Query data, when compatible, can be presented in any of the following supported controls:

Control Name Description
Label Displays a user-defined text label in
the Govern ribbon.
Large Label Unlike the text label, a large text label
icon is displayed in the Govern ribbon.
Picture This is a picture icon that will display
a thumbnail representation of the
selected image.
Pie Chart Displays a Pie Chart graphical
representation of the data.
Column Chart Data will be displayed as a column chart.
Line Chart A Line Chart representation of the data
is displayed.

 

What’s New!

Export to Excel Option

NEW! The functionality that has been added to this feature is the ability to conveniently export the View Query result as a Microsoft Excel file. This is export is carried out from the result grid. See below to review the details of this feature.
View_Query_Export_to_Excel_Option.pdf

Configuring the Visual Query

Prior to configuring the control in the OpenForms Designer (OFD), it will be necessary to design queries to retrieve the data that will then be presented. In addition users must approach this process with the understanding that units that are being retrieved must also be formatted for use in the control.

Queries Tab

The parameters under the Queries tab are used to configure the profiles with queries.

Profile Editor – Queries tab command buttons

  • Add a New Query: Click this button to add a new Query to the current profile.
  • Remove Selected Query: To remove the currently selected query from the profile, click Remove Selected Query.
NOTE: You are able to make multiple or extended selections using the Ctrl or Shift keys in this list.

Profile Editor – Queries tab parameters

Control Type

Select one of the control types for your query from the drop down menu.

Query

This list will display the English Long Name of the available queries. When the Open icon is clicked , the SQL Query editor is launched to create a new query; when a query is already configured in the parameter, it will be displayed. Refer to SQL Query Editor on page 245 for information about creating queries with the Govern SQL Query Editor.

Tool Tip

Enter the text for a Tool Tip that is displayed when the user pointer is hovered over the ribbon icon. This parameter has 3 possible states that can be selected.

  • Fix – Select this option to display the current text string as a fixed text description, i.e. tool tip.
  • Query – When selected, the parameter will change to a drop down list of queries. The result of the queries can then be used to determine whether the tool tip is displayed.
  • Logical Expression – Select this option to display a list of Logical Expressions that can be used to determine whether the tool tip is displayed.

Visibility

This is a flag that is set to indicate that the icon will be displayed in the Govern Ribbon.

  • Fix – Select this option to display the icon as a fixed image.
  • Query – When selected, the parameter will change to a drop down list of queries. The result of the queries can then be used to determine whether the icon is displayed. Refer to SQL Query Editor on page 245 for information about creating queries with the Govern SQL Query Editor.
  • Logical Expression – Select this option to display a list of Logical Expressions; the visibility of the controls icon will be based upon the result of the expression. Refer to Logical Expression Editor on page 186 for information about creating Logical Expressions with the Govern Logical Expression Editor.

On Click group

The options in the On Click group when selected will determine what action occurs when the selected query item is clicked in the ribbon. The options are as follows:

None

Selecting None is an indication that no action will be performed when the query item is clicked

Open Form

When selected, you will have the option to indicate which is to be opened when the user clicks on the query.

Open Report

Click to select the option to choose a report that will be displayed.

Open View Query

Select the Open View Query option to open a selected View Query.

Execute Command

To execute a command, click this option; available commands can be selected from the list.

Open GIS

When selected, this option will open a window with an embedded GIS output screen.

Open Query Tool

Selecting this option will open the Govern Query Tool (QT).

Open Batch Process

To configure the query to load a batch process, select this option.

NOTE: Multiple or extended selections using the Ctrl or Shift keys are not allowed in this list.

Security

For more information, see 102-Govern Security Manager (GSM) OpenForms System Suite.

Best Practices

As a Best Practice, users should ensure that their queries have been optimized, as they will be executed at the time Govern is loaded.

How to Set up a Visual Query

Click for detailed steps to setup Profile Queries.

 

 

101-std-fea-003

 

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-std-fea-004-ofr

101-std-fea-004-ofr #stdfea #std

Dynamic Searches – STANDARD OpenForms Reference
Govern Standard Module Overview, Configuration, OpenForms Reference, What’s New, wiki Module Map …. Last Modified Feb. 14th 2016

Table of Contents

Overview
Module Specific Dynamic Search Details
General A/R
Aircraft
Boat
Motor Vehicle
Real Property
Personal Property
Miscellaneous Billing
Utility Billing
Special Assessment
Complaints, Grievances, Request for Services …
Permit
AutoSave Treeview

VERSION 6.0 | VERSION 6.1

Overview

(Under construction)
The following dynamic searches are distributed.

  • Module Specific
  • Bar Code
  • Synchronized Treeview

Module Specific Dynamic Search Details

The following search fields are available – See what is available and what is roadmap

General A/R

  • Bar code or A/R ID
  • Bill Number
  • Invoice Number
  • Mortgage Company or Tax Service Orgaization (TSO)
  • Receipt No. (payment)

Aircraft

  • Aircraft Serial Number
  • Last or Company / First / Initial
  • Type of Name (Individual, Company or No Format)

Boat

  • Plate Number
  • Boat Serial Number
  • Last or Company / First / Initial
  • Type of Name (Individual, Company or No Format)

Motor Vehicle

  • Plate Number
  • Motor Vehicle Serial Number
  • Motor Vehicle ID (MV_ID)
  • Last or Company / First / Initial
  • Type of Name (Individual, Company or No Format)

Real Property

  • Tax Map Number
  • Tax Bill

Personal Property

  • Tax Map Number
  • Account Number
  • Personal Property ID (PP_ID)
  • Last or Company / First / Initial
  • Type of Name (Individual, Company or No Format)

Miscellaneous Billing

  • Account Number
  • Last or Company / First / Initial
  • Type of Name (Individual, Company or No Format)

Utility Billing

  • Tax Map Number
  • Account Number
  • Utility Billing ID (UB_ID)
  • Meter Serial Number
  • Route Number and Sequence
  • Name Status (Owner…)
  • Last or Company / First / Initial
  • Type of Name (Individual, Company or No Format)

Special Assessment

  • Project Name
  • Project Code

Complaints, Grievances, Request for Services …

  • Enter the reference number
  • Search in application number, permit number, certificate number, alternate permit id and any of the above

Permit

  • Reference number
  • Department
  • Permit Kind
  • Permit Type
  • From and to Date
  • Tax Map number
  • Last or Company / First / Initial
  • Type of Name (Individual, Company or No Format)
  • Include Void Permit
  • Include Historical Permit
  • Include License to Name
  • Search in application number, permit number, certificate number, alternate permit id and any of the above

Note: Backward searches are deprecated

AutoSave Treeview

Synchronized Treeview search

  • Select NAME SEARCH Autosave to access by the content of the Treeview
  • Note: Synchronize must be set to on
  • See Roadmap

Overview | Module Specific Dynamic Search Details | AutoSave Treeview

BP – Evaluate Expressions (Recompute and Set)

Batch Process – Evaluate Expressions (Recompute and Set)

Overview

This batch process replaces the Recompute Formulas and Logical Expressions. This batch process is setup by Business Entity (Single Selection Combo)
Filters include:

  • Saved Datasets
  • Govern ID
  • Year ID
  • Frozen Id
  • other Business Entity ID [Filter Detail List to be verified ]

 

 

101-std-bp-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...