Govern DeployEZ

Overview

Govern DeployEZ is used for installing the applications, resource files, custom controls, and Help files required for the Govern OpenForms Product Suite, in other words for installing everything that you need for your deployment.

With Govern DeployEZ, you can:

Maintain all the deployments required by your organization from one central location on a Web server.
Install all administrative and user applications, in the Govern OpenForms Product Suite from this location.
Create customized deployment packages to meet the requirements of all your end-users and system administrators.
Maintain multiple versions of the same applications to meet the different needs of your organization, such as testing and production.
Roll back to an earlier version easily and seamlessly.
Ensure that only one version of a deployment is created at a time with the automatic lock.
For the overview document see 111-Install-DeployEZ

Read More...Read Less...

Documentation

Documents related to the Govern DeployEZ application include the following:

Govern DeployEZ
This document describes how to install, uninstall, and configure Deploy EZ. It provides the step-by-step procedures for Creating a new deployment and updating an existing one.
See 111-all-deployez -GovernDeployEZ-(man)-[v6.0].

Steps to Follow When the Update is Complete

Perform the following steps when the new deployment is complete, but before making the applications available to the users.

Run a Database Verification.
This step verifies that the stored procedures are valid, it verifies the database tables and ensures that there are no errors in the database structure. It rebuilds the user and system validation table and verifies the table indexes. Refer to the Govern New Administrator (GNA) documentation for further details.
Launch the Govern Scheduler and restart the Scheduler Service. Ensure that no one is running a scheduled batch process when you perform this step. The Scheduler Service automatically checks for new batch process and updates the existing ones at startup. It automatically updates the Govern Scheduler application. Refer to the Govern Scheduler guide for further details.
Define the Report Configuration parameters in GNA. See the following section.

Downloading Reports

To download the Govern standard reports for your deployment:

Launch DeployEZ.
Create a new deployment or update an existing one.
For this deployment ensure that the Govern Standard Reports option is selected.
When the deployment is complete you can verify the following folders in the Deployments folder:
Reports: The latest reports are extracted from a zip file and loaded to this folder.
Binaries > REPORT: This folder contains a sub-folder for each release and version that you have downloaded. The reports that downloaded with each version are found in the sub-folder
Launch GNA.
Select Parameters > General Settings Editor.
Select Report from the Registry Filter drop-down list.
Ensure that the patch is correctly set in the Standard Report Path for Crystal Reports or SRSS accordingly.

Videos (Restricted – Internal Access Only)

This video provides an overview of Govern DeployEZ.– Short tutorial for first time users.
The video will open in a separate tab.

Getting Started with DeployEZ – For first time users.
Installing DeployEZ – Learn how to install the Govern Deploy EZ application.
Configuring DeployEZ – Learn how to configure Govern Deploy EZ for your deployments.
Creating a Deployment – Learn how to create a Govern OpenForms deployment with DeployEZ
Updating Deployments – Learn how to update an existing deployment
Uninstalling – Learn how to uninstall, reinstall, or roll back a Govern OpenForms deployment.

NOTE: If you are changing your deployment server or uninstalling your current deployment, ensure that you remove the configuration file. Verify the configuration path in the Govern DeployEZ 6.0 guide.

Installation Notes

System Requirements Release 6.0
Installing DeployEZ
Uninstalling DeployEZ

Troubleshooting

Reinstalling DeployEZ

You may want to reinstall Deploy EZ if you are changing the Deployment Server or the deployment path. In order to do this, you must completely uninstall Deploy EZ.

Uninstalling DeployEZ

Instructions for completely uninstalling Deploy EZ are provided in the following link.
Uninstalling Deploy EZ

NOTE: The paths for uninstalling certain files are different depending on whether you installed Deploy EZ release 6 or release 5.1 or 4.7.I

What’s New

Download Govern Pre-release Versions

Pre-release versions of the Govern application can contain features that are in the current branch for early testing in our clients’ production environments. Although still in active development, they are supported. These versions can be downloaded for creating deployments. Click here for details.

Govern Release Notes

Govern Release Notes can now be found through the DeployEZ application. As an administrator, when you are downloading Govern binaries, links to view associated release notes will be displayed. It will be necessary to ensure that you are updated to the latest version of DeployEZ. Click here for details.

Govern DeployEZ has a whole new look and feel compared to version 5.1 and prior. It is now a ClickOnce application. It is maintained on a Web server and installed from a Web link. Whenever you launch the application from your computer, a verification is made, and if a more recent version exists, it is used. This ensures that all users have the latest version and all the latest features of DeployEZ.

DeployEZ is not tied to any one Govern OpenForms release. You can use it to install any version of any application. When creating a deployment directory for Govern DeployEZ, you are required to use the UNC format. If you try to enter a drive name in a mapped drive, an error occurs and you are unable to continue:
[Version 6.0.0.58] Prior to this version a folder called MS Govern was created in the deployment server root directory. This folder is no longer needed and can be deleted.

111-all-deployez

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

Expressions

Overview

Expressions are used in Govern OpenForms, version 6.0 and above to perform a wide variety of tasks within a Govern entity, such as:

Performing a validation
Performing a mathematical operation
Performing a computation
Executing a selection query
Displaying the value of an unselected attribute on a form
Attaching a condition to an entity or control; i.e., enabling it or making it visible only if a certain condition is met

Where to Add Expressions

Read More...Read Less...

Expressions can be added at the entity level and on most controls in the OFD.

They can also be associated with a calculated value for an attribute or a validation rule in the Business Entity Designer. Expressions that are added to the OFD are not saved in the database.

The correct syntax must be applied as described in the following table as well as the document available from the following link. The following topics are described in the document:

General Procedures for Adding Expressions
Deleting an Expression
Types of Expressions
Adding an Expression to a Govern Form
Adding an Expression at the Entity Level
Adding an Expression to a Control
Applying Formatting to Expressions
Adding Text in an Expression
Displaying the Field Description
For Further Reference

Documentation

To view or download this information as a pdf, click on the following links:

About Expressions

Expressions.pdf

Expression Reference

ExpressionReference.pdf

Notes

Expression evaluation. We can test the expressions in the Expression Selector editor, before adding it to user or administrative form. When you enter your expression, the required parameters, including those inside queries, appear in a list. Enter applicable values to test the validity of the expression.
Convert null parameters to default values. By default, all parameters that have a null value will now be converted to a default value (0 for numeric, empty string for strings, 01/01/0001 for dates). This means that you no longer need to use IsNull( ) around all your parameters. However, if you need the old behavior (to use different default values, for example) you just have to uncheck the “Convert null parameters to default values” option.

What’s New

Variable: You can use a variable in an expression.

Expressions

Expressions are used throughout Govern OpenForms. They are created in the Expression Selector, available in various administrative forms in GNA, in the Business Entity Designer (BED) and in the OpenForms Designer (OFD). For detailed information, see OpenForms Designer and the Business Entity Designer (BED).

Expression	Description	Example / Syntax	Result
Expression	Description		Result
Abs	Returns the absolute value of a specified number.
Acos	Returns the angle whose cosine is the specified number.	Acos(1)	0
Asin	Returns the angle whose sine is the specified number.	Asin(0)	0
Atan	Returns the angle whose tangent is the specified number.	Atan(0)	0
Case	Evaluates the first parameter in the function and returns the first value that matches in the following list of options.	Case(@attrID,	when @attrID = 2 this returns ‘two’
		1, ‘One’,
		2, ‘two’,
		3, ‘three’)
Ceiling	Returns the smallest integer greater than or equal to the specified number.	Ceiling(1.5)	2
Cos	Returns the cosine of the specified angle.	Cos(0)	1
Date	Returns the current date or the date part of a given date and time.	Date()	Returns the current date.
		Date(@attrDATE)	Returns the date part of an associated attribute.
		Date(#‎11/‎26/‎2014 3:34:05 PM#)	Returns 11/26/2014
DateAdd	Adds to the current date and time the given number of years, quarters, months, weeks, etc. (either positive or negative).	DateAdd(‘year’, 2)	Returns the current date and time + 2 years.
	The list of available date parts is {Day, DayOfYear, Hour, Minute, Month, Quarter, Second, Weekday, WeekOfYear, Year}. The case is insensitive.	DateAdd(‘year’, 2, @attrDATE) =>.	Returns the date and time of the attribute + 2 years
		DateAdd(‘month’, -2) => Returns the current date and time – 2 months.
		DateAdd(‘year’, 2, @attrDATE) => Returns the given date and time + 2 years.
		DateAdd(‘month’, -2) => Returns the current date and time – 2 months.
DateDiff	Calculates the difference between two given dates and times (either positive or negative).	DateDiff(‘year’, @attrDATE1, @attrDATE2)	Returns the number of years between the dates and times of two associated attributes.
	The list of available date parts is {Day, DayOfYear, Hour, Minute, Month, Quarter, Second, Weekday, WeekOfYear, Year}. These are case-insensitive.	DateDiff(‘week’, @attrDATE1, @attrDATE2)	Returns the number of weeks between the dates and times of two associated attributes.
	See https://msdn.microsoft.com/en-us/library/microsoft.visualbasic.dateinterval(v=vs.110).aspx for more details about this list.	DateDiff(‘minute’, @attrDATE1, @attrDATE2)	Returns the number of minutes between the dates and times of two associated attributes.
Day	Returns the current day or the day part of a given date.	Day()	Returns the current day
		Day(@attrDATE)	Returns the day part associated with an associated attribute.
		Day(#11/‎26/‎2014 3:34:05 PM#)	26
		Day(#11/‎26/‎2014#)	26
Display	Returns a string representation of the attribute value.	‘Land Use Code: ‘ + @attrLUSE_CODE.Display	Returns the item selected from the Land Use Code drop-down list.
Double	Returns the double representation, or a copy, of the value.	Double(“7”)	7
Exp	Returns e raised to the specified power.	Exp(0)	1
Floor	Returns the largest integer less than or equal to the specified number.	Floor(1.5)	1

		Floor(3.5)	3

		Floor(-3.5)	-4
Format	Formats the first parameter using the style defined in the second parameter.	Format(@attrAMOUNT, ‘c’)	Returns the value in the attribute AMOUNT formatted as currency.
		Format(123.45, ‘0000.0’)	Returns 0123.5

HasValue	If the field contains a value, the expression returns True. Returns False if the parameter is Null or empty.	HasValue(@attrBLDG_VALUE)	Returns True if a value is entered in the Building Value field. If the field is empty or Null, returns False.
IEEERemainder	Returns the remainder resulting from the division of a specified number by another specified number.	IEEERemainder(3, 2)	-1
If	Returns a value based on a condition.	If(4/2 = 2, ‘abc’, ‘def’)	‘abc’
In	Returns true if an element is in a set of values.	In(@attrId, 4, 5, 6)	true when @attrId is 4, 5 or 6
IsNull	If the parameter is Null, the expression returns the second parameter. Otherwise the first parameter is returned.	IsNull(@attrID, 0)	If @attrID is Null, a 0 is returned.
IsNullOrEmpty ( )	If the parameter is Null or Empty, the expression returns the second parameter. Otherwise the first parameter is returned.	IfNullOrEmpty(@attrID, 0)	If @attrID is null or Empty a 0 is returned
IsNullOrWhiteSpace ( )	If the parameter is null Or Empty Or White Spaces, it returns the second parameter. Otherwise the first parameter is returned.	IfNullOrWhiteSpace(@attrID, 0)	If @attrID is NULL or Empty or White Spaces, a 0 is returned
Len	Returns the length of the specified string.	Len(‘Main Street’)	Returns 11
Len	Note that characters in the length are counted from one, starting index one. Use the Evaluate feature of the Expression Editor to test this.	Len(‘Main Street’)	Returns 11
		Ln(e)	Ln(e) returns 1.
Log	Returns the logarithm of a specified number.	Log(1, 10)	0
Log10	Returns the base 10 logarithm of a specified number.	Log10(1)	0
Lower	Converts all letters in the specified string to lowercase.	Lower(‘Main Street’)	Returns main street.
Max	Returns the larger of two specified numbers.	Max(1, 2)	2
Min	Returns the smaller of two numbers.	Min(1, 2)	1
Month	Returns the current month or the month part of a given date.	Month()	Returns the current month.
		Month(@attrDATE)	Returns the month part of an associated attribute.
		Month(#11/‎26/‎2014 3:34:05 PM#)	11
		Month(#11/‎26/‎2014#)	11
Now	Returns the current date and time.	Now()	11/‎26/‎2014 3:34:05 p.m.
Pow	Returns a specified number raised to the specified power.	Pow(3, 2)	9
Query	Executes a query and returns the first value in the first row.	Syntax:	Returns the result from GetParcelName.
	Note: As a best practice, write queries that return only one row and one column.	Query(‘QueryName’)
		Example 1: Query(‘GetParcelName’)
		Syntax:	Returns the result from GetQuantity with a maximum cache of 2 minutes.
		Query(‘QueryName’, n)
		Example 2: Query(‘GetQuantity’, 2)
		Syntax:	Returns the tax map number from the first row of the results.
		Query(‘QueryName’, ‘ColumnName’)
		Example 3:
		Query(‘GET_P_ID’, ‘Tax_Map’)
		Syntax:	Returns the tax map number from the first row of the results, with a maximum cache of two minutes.
		Query(‘QueryName’, ‘ColumnName’, n)
		Example 4:
		Query(‘GET_PARCEL_ID’, ‘Tax_Map’, 2)
Round	Rounds a value to the nearest integer or specified number of decimal places. The mid number behavior can be changed by using EvaluateOption.RoundAwayFromZero during construction of the Expression object.	Round(15.5,0) Round(3.2222, 2)	3.22
Round 0	Use the zero (0) to rounds to 0 decimal places using banker’s rounding: The value is rounded to the nearest even number.	Round(16.5,0)	16
Sign	Returns a value indicating the sign of a number.	Sign(-12)	-1
Sin	Returns the sine of the specified angle.	Sin(0)	0
Sqrt	Returns the square root of a specified number.	Sqrt(4)	2
Str	Returns the string representation of a value.	Str(5)	‘5’
Substr	Returns a substring of the first parameter from the x-th character defined by the second parameter on a length defined by the third parameter.	Substr(‘abcdef’, 2, 3)	‘cde’

	Note that characters in the substring are counted from zero, starting index zero. You can use the Evaluate feature on the Expression Editor to see how the characters are counted.
Tan	Returns the tangent of the specified angle.	Tan(0)	0
Truncate	Calculates the integral part of a number. No rounding is applied.	Truncate(1.7)	1
Upper	Converts all letters in the specified string to uppercase.	Upper(‘Main Street’)	Returns MAIN STREET
Variable	Creates a variable that can be added to an e-mail, for example.	{ Name = ‘Govern’; Amount = Query(‘getAmount’) + 500; Tax = Amount * .15; }	Establishes variables for e-mails, etc.
Year	Returns the year part of a date.	Year()	Returns the current year.
		Year(@attrDATE)	Returns the year part of an associated attribute.
		Year(#‎11/‎26/‎2014 3:34:05 PM#)	2014
		Year(#‎11/‎26/‎2014#)	2014

Allowed Expressions

This section lists the expressions that are allowed in Govern OpenForms. The same interface is used for adding expressions throughout the Govern OpenForms Product Suite.
The list of expressions is available if you open the Expression Selector and hit [Ctrl] + the space bar. When you begin typing the first couple of letters of a syntax, a tooltip appears. The tooltip provides the same information as the following list.

For Further Reference

For further reference, refer to the following:
Numeric Formats
For numeric formats, see https://msdn.microsoft.com/en-us/library/y006s0cz(v=vs.90).aspx or https://msdn.microsoft.com/en-us/library/4fb56f4y(v=vs.90).aspx
Date Formats
For date formats, see https://msdn.microsoft.com/en-us/library/362btx8f(v=vs.90).aspx or https://msdn.microsoft.com/en-us/library/73ctwf33(v=vs.90).aspx
Dates and Date Parts
For dates and date parts, see https://msdn.microsoft.com/en-us/library/microsoft.visualbasic.dateinterval(v=vs.110).aspx for more details about this list.

Where to Add an Expression

The table on the following page lists the levels (form, entity, and attribute), and the controls (label, link, action button, groupbox, tab, etc.) and shows where you can add an expression for the user forms. Detailed information and examples are provided in the Govern OpenForms Designer and Business Entity Designer guides. This section provides a brief overview:

Form / Business Model: Govern user forms are based on the business models created in the Business Entity Designer (BED). Expressions cannot be added to a business model or a user form (OFD form). They can be added to a business entity – a divider within a form – and to most controls.
Business Entity: Business Entities are created in the Business Entity Designer (BED). They must be added to business models. You can add an expression as a validation rule in the BED, or the Record Description or the enabling or visibility properties in the OpenForms Designer (OFD).
Custom Entity: Custom Entities are created in the OpenForms Designer (OFD) in order to add specialized controls or code to the form. You cannot add an expression to a Custom Entity. However, the custom entities must be added to a form with a root entity. You can add expressions to the root entity of the form.
Attribute: Attributes are the data entry fields on a user form. They are created in the BED and added to business entities. They are mapped to database columns or can be stand alone. You can add an expression to an attribute as a default value, a calculated value, or as a validation rule in the BED, or the enabling or visibility properties in the OFD. If you want to perform a calculation that is not saved to the database, but is displayed on a form, you can create a stand-alone attribute or add a label to the form and add an expression to the label.
Controls: Expressions can be added to the enabling or visibility properties of labels, links, action buttons, custom controls, groupboxes or tabs. They cannot be added to grids, rows, columns, or to custom entities. For further information, see the Govern OpenForms Designer and Business Entity Designer guides.

Level	Application	Type
Form	OFD	N/A
	BED	N/A
Entity	OFD	Allow Save, Allow Delete	Allow Update	Record Description
	BED	Validation Rule
Attribute	OFD	IsEnabled	IsVisible
	BED	Validation Rule	Default Value	Calculated Value
Label	OFD	IsEnabled	IsVisible	Expression (Any)
	BED	N/A
Link	OFD	IsEnabled	IsVisible
	BED	N/A
Action Button	OFD	IsEnabled
	BED	N/A
Custom Control	OFD	IsEnabled	IsVisible
	BED	N/A
Row or Column	OFD	N/A
	BED	N/A
Grid	OFD	N/A
	BED	N/A
Groupbox	OFD	IsEnabled	IsVisible
	BED	N/A
Tab	OFD	IsEnabled	IsVisible
	BED	N/A
Custom Entity	OFD	N/A
	BED	N/A

Examples

Expressions are used throughout Govern for different. Click on the Examples list to see different examples on how they can be used.

System	Type	Applicable to	Description	Examples
BED	Validation Rule	Entities and Attributes	Business Rules on Save	bed01
	Calculation & Formatting	Numeric and Text Attributes	Saved Attributes and Calculated Fields definition	bed02
	Properties (True/False)	Business Entities and Attributes	Sets properties (Is required / is audit / is central notes allowed … )	bed03

OFD	On/Off (True/False)	Visibility	Set properties (Is enabled / Is visible for labels, fields, action buttons…)	ofd01
	On/Off (True/False)	Security	Set properties for (Allow delete / insert / save action buttons ….)	ofd02
	Entity	Record Selector	Defines Record selector (mini browse) info to display	ofd03

GNA	Profile Query (Coolbar)	Coolbar Info	Used to set conditional labels, action items, icons, links, etc.	gna01

Videos

Click to link to a video preview of Using Expressions in Govern.
Click to see the “Become an Expressions Ninja” Video

Govern for OpenForms Release 6.x

The following are the current database diagrams for Govern OpenForms modules. These files are presented in .PDF format for easy viewing.

Available Modules:

Read More...Read Less...

Personal Property / Motor Vehicle / Business Tax

(Updated 2017.06.12)

101-tx-PP MV BT and AR 61.pdf

Accounts Receivable (PP / MV / BT / AR) 6.1

PP MV BT and AR 61.pdf

Property Control (PP) 6.1

(Updated 2016.12.06)

101-pc-Property Control 61.pdf

Security 6.1

Security61.pdf

Self Reported Tax and Accounts Receivable (ST & AR) 6.1

(Updated 2017.06.12)

101-st-Self Reported Tax 61.pdf

Tax and Accounts Receivable (Tax & AR) 6.1

(Updated 2017.06.12)

101-tx-Tax and AR 61.pdf

Utility Billing and Accounts Receivable (UB & AR) 6.1

(Updated 2017.06.12)

101-ub-UtilityBilling and AR 61.pdf

Workflow 6.1

(Updated 2017.08.01)

101-wm-Workflow Management 61.pdf

Audit

Audit.pdf

Delinquency (DC) 6.1

(Updated 2017.06.12)

101-DC-Delinquency and AR 61.pdf

NEW! OpenForms Designer (OFD) and Business Entity Designer (BED)

101-std-OFD and BED61.pdf

Govern for Windows (VB6)

The following are the current database diagrams for Govern for Windows (VB6) modules. These files are presented in .PDF format for easy viewing.

NOTE: For information only. Source 10.5 Govern for Windows.

Available Modules

Read More...Read Less...

Land Management (LM)

101-wm-LandManagementVB6.pdf

Mass Appraisal (MA)

101-ma-MassAppraisal VB6.pdf

Property Control (PC)

101-pc-Property Control VB6.pdf

Self Reported Tax / Accounts Receivable (SRT & AR)

101-st-SRT and AR VB6.pdf

Personal Property / Motor Vehicle / Business Tax /
Accounts Receivable (PP / MV / BT / AR)

101-tx-PP MV BT and AR VB6.pdf

Tax and Accounts Receivable (Tax & AR)

101-tx-Tax and AR VB6.pdf

Utility Billing and Accounts Receivable (UB & AR)

101-UtilityBilling and AR VB6.pdf

Security

101-std-Security VB6.pdf

List of Changed Tables

UPDATED! The following is a list of tables that are present in each of the major releases of Govern, i.e. Govern for Windows (VB6), Govern for OpenForms Release 6.0 and 6.1. This .PDF file lists which tables have changed between the three (3) aforementioned releases.

Click to view the “GovernTableChanges_2020.08.27.pdf” document or download the document

NOTE: The above list is not exhaustive; it does not provide a complete breakdown of changed columns or their functionalities. Table details may be found through the GovernDB page in Confluence.

Videos

Webinar – Govern for Windows Dataflow (Internal Access)

Govern for Windows Dataflow Webinar Click to view the recording

(Recorded – Dec. 16, 2016)

Mass Appraisal Land Information

[In Development]

Specification Overview

All the CAMA Land information is presented on a single form in Govern OpenForms called Land Information.

You can create multiple Land Information records for a parcel in order to cover all the different land uses and types.
Data about the parcel size are maintained on the CAMA Land Information forms and with the Govern Property Control Legal Information form.
- The update on the Legal Information form is automatic.
- There are options for excluding the lot size, depth, and frontage for a specific parcel.
- For more information about the Legal Information form, click on the following link: PC Legal Information
The Land Value is determined by a number of factors that include the parcel size, the land use, the rate schedule, adjustments, and tax exemptions applied specifically to the land. It can be applied to a MRA record or to a Income record, according to the appraisal method selected as well as to the land record’s option INCLUDE IN Income or MRA.
Assessment Exemptions can be applied on Appraisal Land Records
Audit, Copy to, Roll forward, Audit trails and other standard features

What’s New

[5.1] (to be verified in 6.0) You can now copy and paste a land record. This can save time if you are creating multiple land records that are similar. The land records can be on separate parcels. All data from the General tab can be copied with the exception of the LOT_SIZE, LOT_UNITS_TYPE, UNITS, and UNITS_TYPE. Data are copied one record at a time.
[6.1] Refresh Icon no longer available
[6.1] Mass Appraisal Link Group table lookup …
[6.1] Cluster configuration for table lookup …
[6.1] Site is required for all components
[6.1] Land Info merged into Land
[6.1] Simulation and template fields removed
[6.1] New Override Fields (to show calculated and overrided value)

Land Information

General

All land records are maintained on a single data entry form called Land Information. The appraised land value is determined from the values enteredon this form that include area, use, and applicable adjustments. This Land Information form has a General and an Adjustments tab. If the Govern Real Property TAX module is integrated to the Mass Appraisal through Govern Admin, an Exemptions tab is included and you can apply tax exemptions directly to the land record (verify if available in 6.1) . Similar functionality is added to the Building Structural Elements and Features and Miscellaneous Structures forms. Before recording the land appraisal information record for a property, update the following:

Mass Appraisal Site Information
Mass Appraisal Property Information
Legal Description

If multiple Land Information records are available for the property, the navigation arrows are displayed. If it is configured, the Record Description is displayed.

Land Schedules without a Predefined Price per Unit

If a price per unit is included in the rate schedule, the land value is calculated automatically. Otherwise, if a price per unit is not included, then you must enter a value in the Units Price field under section. The Land Value is calculated based on the unit price and other fields.

Calculating the Agricultural Value

The Agricultural Unit Price is separate from the Land Unit Price. It is determined by multiplying the Units * Unit Price AG. The Land Adjustment is calculated according to the configuration. Amounts are displayed in the Unit Price AG and Total AG Before Adj. fields if the selected rate schedule code applies to the agricultural value.

The Units Price and Total Value Before Adjustments are calculated based on the Rate Schedule Code. The Total Value field at the bottom of the interface is calculated based on the total with the adjustments.

Excluding Land Area from the Legal Description

To exclude the land size from the Legal Description record for the property click on the exclude option according to how you set up the record:

Exclude Lot Size
Exclude Depth
Exclude Frontage

Copy and Paste to Create New Land Records

Copy: Use the copy and paste icons to copy data from one land record to another. The records can be on the same parcel or on multiple parcels. This can be useful if you are creating multiple land records with similar data. Records are copied one by one. To copy a record, open it in the Land Information form and click the Copy icon.
Paste: Use the Paste icon to paste land information data from the source parcel where it was copied with the Copy icon to the destination parcel. All data from the General tab are copied with the exception of the following: Lot Size, Lot Units Type, Units, and Unit Type (validate).

Overriding the Land Value

Total Value = Units * Unit Price + Land Adjustment + Site Adjustment + Neighborhood Adjustment + Final Adjustment.

To override the Total Value:
1. Select the General tab on the Land Information form.
2. Select the Override option to enable the Final Adjustment field.
Enter a new value in the Final Adjustment field. This is added to the Total Value. (New change in 6,.1)

Land Form – General

–General Section
Site No.

Select the Site from the Site No dropdown list. Several sites can be created for a property on the MA – Sites form. Typically, they are based on location and other geographic information.
Multiple adjustments can be applied to each Site using the MA – Sites form.

Rate Schedule

Select a land rate schedule from the Rate Schedule dropdown list. Rate Schedules are defined in Govern Admin. They determine the land value based on a number of factors, such as the number of units, the Link Group type (neighborhood, jurisdiction, income neighborhood). The rate can be applied as a flat rate or according to a schedule. A separate rate expression can be applied on the agricultural land on the parcel. The Land Adjustments can be associated with Rate Schedules in Govern Admin.

Land Use Code

Select a code for the land use from the Land Use Code dropdown list. The Land Use Codes are defined in Govern Admin. They are used for classifying properties according to how the land is used. Land Use Codes can be associated with a Property Type (VT_USR PROPTYPE) and classified as Agricultural. The Land Adjustments can be associated with land use codes in Govern Admin.

Land Unit type

Select the unit type corresponding to the area you entered from the Lot Units Type dropdown list. Examples are acres, hectares, square feet, and square meters.

–Dimensions Section
Enter the area of one of the following:

Depth / Exclude
Frontage / Excluded
Lot Size / Exclude

Exclude is used for calculating the land value. If Exclude is checked, the area will not be used in the Legal Total Size calculation.

–Units Section
During the computation, the units and unit type are automatically converted and the results are displayed in the Units and Unit Type fields. The Units Price and Total Value Before Adjustments are calculated based on the Rate Schedule Code during the save. The Total Value field at the bottom of the interface is calculated based on the total with the adjustments.

Total Units

Calculated amount

Unit Type

Calculated field (converted)

Unit Price

Calculated amount if entered in Land Schedule Land Rate

Unit Price AG

Calculated amount if entered in Land Schedule AG Rate

Total Value Before Adj.

Sum of land value before adjustments. Calculated amount.

Total AG Value Before Adj.

Sum if land Agricultural values before adjustments. Calculated amount.

–Adjustments Section

Land

The Land Adjustment is the total of the adjustments selected on the Adjustments tab. Calculated amount

Land AG

Calculated amount

Site

The Site Adjustment is calculated according to the selections made on the Site Information form. Calculated amount

Neighborhood

The Neighborhood Code is selected for the property on the Property Area record. Refer to the Property Control guide for details on this form. The adjustment applied to the land for the Neighborhood is defined in Govern Admin per Neighborhood on the Mass Appraisal Neighborhood Validation Table. .Calculated amount

Land Form – Adjustments

Viewing / Applying an Adjustment

The Land Information Adjustments tab lists the available adjustments.

To apply an adjustment, select the Adjustments tab on the Land Appraisal Information function. The available adjustments are listed. According to the setup, the adjustments can be associated with the Land Use Code or Rate Schedule selected on the General tab. Otherwise, they are not associated with any data entry field.

By default the land adjustments are listed by sequence number. You can sort them in ascending or descending order by any of the available columns. To do this, click on the column heading. You can also remove any columns that you do not want to view. Right-click on the title bar of the columns to display a context-sensitive menu. Deselect the columns that you do not want to view. You can also change the position of a column by dragging and dropping it to the left or right.

Select a specific code for the adjustment type, by clicking inside the Adjustment Code text field, if applicable. Click Save.

Overriding an Adjustment

To override a land adjustment, select the Adjustments tab on the Land Information form. Select (check) the Override checkbox beside the value you want to modify.

Enter a new value in the Value field and click Save. Note: The value is recalculated and displayed under Value.

Land Form – CAMA Exemptions

Validate if available in 6.1

Configuration

For a step by step administrative setup see Module Specification (above) Configuration or Product Map under the Land Form Function for all related product detail wiki URL pages.

There are three (3) Mass Appraisal Validation Tables that are specific to land information. All are set up and maintained in Govern Admin in Govern for Windows.

Land Adjustments (Table: MA_PARM_LANDADJT)
Land Rate Schedule (Table: MA_PARM_LANDSCHD)
Land Use Codes (Table: MA_PARM_LANDUSE)

Land Adjustments

You can create as many Mass Appraisal Land Adjustment tables as required.
Multiple adjustments can be applied to a land record.
Land adjustments tables are defined in Mass Appraisal tables and are often associated with topographic or other geographic features of the land or proximity to roads or schools.
They can be applied as flat rates, formulas, or logical expressions and associated with the land use or rate schedule codes.
Adjustments are displayed on both the Land Information > Adjustments tab.

Land Rate Schedule

The Mass Appraisal Land Rate Schedule Validation Table is unique.
Rate Schedules are defined in Govern Admin.
They determine the land value based on a number of factors, such as the number of units, the neighborhood, and the jurisdiction.
The rate can be applied as a flat rate or according to a schedule.
A separate rate, formula, or logical expression can be applied on the agricultural land on the parcel.
The Land Adjustments can be associated with Rate Schedules in Govern Admin.

Land Use Codes

The Mass Appraisal Land Use table is unique.
The Land Use Codes are used for classifying properties according to how the land is used.
Land Use Codes can be associated with a Property Type (Table: VT_USR_PROPTYPE) and classified as Agricultural.
The Land Adjustments can be associated with land use codes in Govern Admin.

NOTE: Before performing the specific setup for the CAMA Land Information form, it is important to complete the general CAMA configuration.

Documentation

This section provides links to the administrative and user documents for land information.

Administrator
Govern Land Administration : Mass Appraisal General Parameters and Validation Tables (specific to land) 6.0
Linear Square Foot Calculation: [To be revised] This document describes the linear square foot calculation used in the cumulative land calculation method.

User Manual
This document describes the Govern CAMA Land Information form for data entry of land
Govern Land Information user data entry

Technical Specification

See Module Section OpenForms Reference (OFR), Installation and Design info from R&D Developers

Video

8-101-100 – Land Appraisal from the Appraiser’s side Course 1 of 5 Govern APPRAISER
[PDF] [video]

101-ma-frm-017

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

Workflow Setup

NOTE: This page contains information that is intended for advanced Govern users that are familiar with the steps that are required to configure a form.

Overview

The following are the sections that require configuration by an Administrator prior to setting up a Workflow.

Admin Setup

Read More...Read Less...

(GNA) System Registry

In the Govern New Administrator (GNA)…

From the GNA ribbon, select Parameters tab > System Parameters group > General Settings Editor.
Set the Registry Filter parameter to General.
Configure the following parameters:

Section Name: SMTP (If email option is used)
Section Name: Imaging > Imaging Path

(OFD) Configuration

Workflow (Root Entity)

Controller

Workflow_Controller

Misc

Allow delete save insert expressions can be entered

Configuration

Filters by System ID

Reference ID = parcel id
Primary Department = department

Filters by Constants (Attribute, Operator, Constant)

Reference Type (equal to) = P_ID
Key Type co (equal to) = co

Name

Business Entity Model

Text

OFD name for Business Entity Model

Tab Sequence

Divider Tab sequence ?

Record Description

(would be nice to have workflow type)

Workflow – General

Controller

WorkflowType_Control (For Combo box)

+ Attributes

Workflow – Form

Controller

WorkflowAddedFields_Control

Activities

Controller

Activity_Control

Multimedia

Controller

MultimediaDocuments_Control

Parent Entity

Workflow

Steps to Set Up a Workflow

NOTE: The following steps must be completed by users with Administration access to Govern.

The following are the steps required to create a Violation Workflow.

Configure SMTP
Create Kind: Complaint
Create Category: Violation
Apply Template Form: Workflow Name Template – This will create a basic complaint form in OFD
Create Fees: e.g. Liquor Fee 1, Liquor Fee 2+, Cannabis Fee
Create Activities with actions
Create Types: e.g. Liquor Violation, Marijuana Violation
Create Steps with actions
Add the form to a profile
Review the form in the OFD
View the result in Govern

Videos

Workshop – R&D Workflow Workshop (Internal Access)

Video only available for internal use.

Presentation

Click to view the presentation as a .PDF file.

101-std-frm-002-setup

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

Application Browser Form – Matix Integration

Overview

Matix leverages the power and flexibility of ESRI’s ArcGIS Server, and web-based mapping services, to provide an everyday tool for performing statistical analysis and visualizations. Matix integration allows the Govern application to leverage the functionality of the Matix plugin in Govern V6 through a custom control. When configured the integration is presented as another “child” of the integration controls, similar to the Govern Web Browser Integration (WBI). Matix Integration has been implemented in GA release 1511 for version 6.0 and 6.1.

For the Matix integration, there are three (3) principal areas of the user interface that are used.

Dataset TreeView – This is used for displaying search results, and expanding the results to access related OpenForms.
Matix Ribbon – This area contains the principal controls that allow users to query and interact with configured base maps.
Matix Map pane – This displays the GIS map as well as the controls to modify the display of the map, layers, and selected parcels. The Dataset TreeView and the Matix Map pane can be configured to update and display information automatically or with manual synchronization.

Configuring the UI for Auto-Synch or Manual Synch operation is achieved through selections made in the Govern User Registry Manager form. See Auto-Synch and Manual Synch Configuration in the Matix documentation for more information.

Features

Matix Integration features include:

Display GIS Map In Govern
Support Multiple Matix Configuration, Different Map / Data per role/user
Ability to Show Selected Parcel (in Govern) on the Map
Support Multiple Selection Mode (Rectangle, Free Hand, point,…)
Ability to add/replace GIS selection to Govern Treeview
Ability to Create PNG / Multimedia Document
Search Govern Parcel and display the result on the map
Search GIS for GIS Data and Intersection
Support Multiple Base Image
Support Theme Map
- Label
- Color Ramp
- Points

User Registry Filter Matix

See Other
AutoZoom to Highlighted (Selected)
AutoZoom to Selected (Loaded)

OFD Setup Controller Setup

Search Group

Documentation

Click to link to the Current Matix documentation.

Videos

Click on this video link to learn more about Govern Matix Integration.

Govern GIS Integration (Prior to Version 6.0)

Version 6.0 | Prior Versions

Overview

From the original concept of Govern, the integration of GIS has played a key role in developing Govern’s centralized, land-based, property control data model. Over time, driven by the evolution of the industry as well as client needs, Govern has integrated different GIS engines [systems], developed applications, functions and a web PC/GIS service API. see technical sheet

Govern Applications

Harris Govern offers two products for integrating Govern with the Esri ArcGIS suite of applications;

Govern GIS Explorer
Govern GIS Parcel Editor
Govern Web Browser Integration

Govern GISExplorer

Govern GISExplorer is fully integrated with Govern OpenForms, version 5.1, 5.2, and 6. Once it is configured, it can be accessed directly from the view menu in Govern. It can also be used through a Web browser. It presents geographic information from the Govern database on a local map that is installed on ArcGIS for Server. It presents this information in a collection of map layers that users can navigate and query for parcel information, historical information, creating an abutter’s list, creating an inspection route, and multiple other users.

Installing and Configuring Govern GISExplorer

Govern GISExplorer requires ESRI ArcGIS for Server and ArcMap. Versions 10.1 and later are strongly recommended. You need to install a base map and a client map on ArcGIS for Server.

In order to integrate the ESRI geodatabase with the Govern database, you need to perform the following configuration in GNA.

Complete the GNA GIS parameters.
Provide the base map and the client map URLs
Create a GIS tooltip for identifying parcels.
Run the GIS Synchro Tool to synchronize the geodatabase with the Govern database.
Once the configuration is complete, Govern GISExplorer can be accessed directly from the Govern View menu.

Documentation

This section provides links to the documentation on the Govern GISExplorer. There are separate documents for version 6.0 and 5.1. The difference is in how the application is integrated with Govern. Otherwise, the features and functions of the application are the same.

Govern GISExplorer 6.0

For details on installing, configuring, and using the Govern GISExplorer 6.0, see:
Govern GISExplorer 6.0

Govern GISExplorer 5.1

For details on installing, configuring, and using Govern GISExplorer 5.1, see:
Govern GISExplorer 5.1

Govern GISExplorer Video Presentation

This video series presents Govern GIS View in three parts. Click on the following links to view the videos in a secondary window or Screencast.com.

Part I: Overview of Govern GISExplorer UI and General Features
GIS Explorer Part I I

Part II: Inspection Routing and Zoning Layers
GIS Explorer Part II

Part III: Attribute Query, Abutter’s List, and Google Maps Integration
GIS Explorer Part III

Govern GIS ParcelEditor

The Govern GIS Parcel Editor is designed for use with Govern OpenForms [v5.1+] and Govern for Windows [10.7+].

You can initiate a property split / merge or rename a division directly on your client map in Esri ArcMap. Then, maintain and update the transaction record in Govern.

The Govern GIS Parcel Editor is an Add-In created for ESRI ArcMap™ 10.1. Users who are not familiar with ArcMap can consult the ESRI website. All the information required for running ArcMap, as well as a number of training videos, is available on this site http://training.esri.com/gateway/index.cfm

Installing and Configuring the Govern GIS Parcel Editor

The Govern GIS Parcel Editor requires an IIS Server, Govern Property Control (PC) Web service, Esri ArcGIS for Server, and ArcMap, v 10.1 or higher.

The Govern GIS Parcel Map Editor installation file MSGovernGISAddin.esriAddIn This file is installed using the ARCMap Add In configuration tool. When installation is complete, the Govern toolbox is added to ArcMap.

You need to complete the following configuration in order to integrate the GIS Parcel Editor with Govern:

Complete the GNA GIS parameters.
Run the GIS Synchro tool to synchronize the geodatabase with the Govern database.
Perform a configuration using the Govern toolbox in ArcMap.
Define general settings on the System Registry in GNA.
Map GIS data to Govern using the Data Mapping Editor.

Documentation

For complete details about installing, configuring, and using the Govern GIS Parcel Editor, click on the following link:

Govern GIS Parcel Editor 5.1

Presentations

Govern GIS Parcel Editor [v5.1] PowerPoint

This slide presentation introduces the Govern GIS Parcel Editor and
describes its key features. It was presented at the Harris User Conference in 2013.

Presentation Link

Previous Offerings

GovView for Govern for Windows

GovView was fully integrated with Govern for Windows and was offered with previous releases.
It was used, not only for visualizing parcels on a map, but obtaining data on selected parcels directly from the Govern database..

Support for this product is discontinued.

JMAP Integration

Cadastral, Permits & Inspections

JMAP 3.0 was integrated with previous versions of Govern for Windows.
Support for this product is discontinued.

Third Party Systems

350 Esri General Information

Environmental Systems Research Institute (Esri®) is an international supplier of GIS software web GIS and geodabase management applications. The company, with headquarters in Redlands, California, was founded in 1969. Today it has 30% of the GIS market – more than any other vendor – with one million users worldwide.

Harris Govern has integrated Esri’s Geographic Information Systems (GIS) software with Govern in order to provide governments with local maps for presenting parcel information. These can be used interactively in myriad ways, such as for demographic analysis of neighborhoods and jurisdictions, preparing an abutter’s list, improving workflow, and creating inspection routes.

Environmental Systems Research Institute (ESRI®) is an international supplier of GIS software web GIS and geodabase management applications. The company, with headquarters in Redlands, California, was founded in 1969. Today it has 30% of the GIS market – more than any other vendor – with one million users worldwide.

For more information about Esri, click on the following link:
http://www.esri.com/about-esri

351 ESRI ArcGIS for Server

Esri ArcGIS for Server is required for all Govern GIS integrations. It manages the GIS information, making it available through a GIS web service via an Internet connection.
The base map and client map are installed on the ArcGIS server for interactive use with Govern.

For more information about ESRI ArcGIS for Server, click on the following link:
http://www.esri.com/software/arcgis/features

352 Esri ArcMap

ArcMap is the central application in the ArcGIS suite. It is the end-user application, used to navigate local maps, interactively, explore geospatial data, and query for geographic information.

For more information about ESRI ArcMap, click on the following link:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006600000001000000

398 Microsoft Silverlight

For Govern OpenForms v6, Silverlight 5 is required.
Click on the following link for information about Silverlight and to download version 5

http://www.microsoft.com/silverlight/

361 K2 JMAP

Harris Govern integrated a JMAP extension with Govern for Windows
for Permits & Inspection Integration

JMap

Support for this product is discontinued.

203-all-gis-v50

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

Govern DeployEZ

Overview

Documentation

Steps to Follow When the Update is Complete

Downloading Reports

Videos (Restricted – Internal Access Only)

Installation Notes

Troubleshooting

Reinstalling DeployEZ

Uninstalling DeployEZ

See Also

What’s New

Download Govern Pre-release Versions

Govern Release Notes

Expressions

Overview

Where to Add Expressions

Documentation

About Expressions

Expression Reference

Notes

What’s New

Expressions

Allowed Expressions

For Further Reference

Where to Add an Expression

Examples

Videos

See Also

Govern Database Diagrams and Tables

Govern for OpenForms Release 6.x

Available Modules:

Land Management 6.1

UPDATED! Land Management 6.0

UPDATED! Workflow Management 6.1

Mass Appraisal (MA)

Miscellaneous Billing (MB) 6.1

Name & Address (NA) 6.1

Personal Property (PP) 6.1

Personal Property / Motor Vehicle / Business Tax

Accounts Receivable (PP / MV / BT / AR) 6.1

Property Control (PP) 6.1

Security 6.1

Self Reported Tax and Accounts Receivable (ST & AR) 6.1

Tax and Accounts Receivable (Tax & AR) 6.1

Utility Billing and Accounts Receivable (UB & AR) 6.1

Workflow 6.1

Audit

Delinquency (DC) 6.1

NEW! OpenForms Designer (OFD) and Business Entity Designer (BED)

Govern for Windows (VB6)

Available Modules

Land Management (LM)

Mass Appraisal (MA)

Property Control (PC)

Self Reported Tax / Accounts Receivable (SRT & AR)

Personal Property / Motor Vehicle / Business Tax / Accounts Receivable (PP / MV / BT / AR)

Tax and Accounts Receivable (Tax & AR)

Utility Billing and Accounts Receivable (UB & AR)

Security

List of Changed Tables

Videos

Webinar – Govern for Windows Dataflow (Internal Access)

Related Topics

Mass Appraisal Land Information

Specification Overview

What’s New

Land Information

General

Land Schedules without a Predefined Price per Unit

Calculating the Agricultural Value

Excluding Land Area from the Legal Description

Copy and Paste to Create New Land Records

Overriding the Land Value

Land Form – General

Land Form – Adjustments

Viewing / Applying an Adjustment

Overriding an Adjustment

Land Form – CAMA Exemptions

Configuration

Personal Property / Motor Vehicle / Business Tax /
Accounts Receivable (PP / MV / BT / AR)