100-USR-Registry

User and Machine Registry (USR_REGISTRY) Parameters

Version 6.0 – Version 6.1 (In Development)

User and Machine Registry

The KEY TYPE is used to identify USER and MACHINE registry parameters.
Key Type 1 = User ID registry, – IDENTIFICATION Code = User Id
Key Type 2= Machine registry – IDENTIFICATION Code = Machine Name
Payment Processors not updated

Cash Collection Parameters

Read More...

By User ID

Registry Type Section Name Key Name Key Type Identification CD Key Value Encrypted Action Notes
Cash Collection Cashier Cash Collection Cashier auto collapse MCR Group and AR Class Distribution 1 user id 0 or 1 0
Cash Collection Cashier Cash Collection Cashier search style 1 userid Style lookup 0 Default lookup group in Cash Collection Form VERIFY conditions
Cash Collection Cashier Cash Collection Cashier real estate up to installment 1 userid 1,2,3,4,t 0
Cash Collection Cashier Cash Collection Cashier self reported tax breakdown by periods 1 userid 0 or 1 0
Cash Collection Cashier Cash Collection Cashier show only accounts by balance 1 userid 0 or 1 0 A/R with a zero balance will not be displayed in the grid
Cash Collection Cashier Cash Collection Cashier year to collect 1 userid YEAR, 0 or null 0 If a year is entered, only A/R for this year will be displayed
default collection type Missing (credit card, cash, etc.)
Cash Collection Parameters Cash Collection credit card type 1 userid Table Lookup will need to use the new table CC TYPE
Cash Collection Parameters Govern allow Misc. Cash Receipts 1
Govern allow xxx Data Entry (Fee, Demand, Discount…) 1 Deprecrated
Govern bill validation verify
Govern cashier Id Text verify
Govern check validation
Govern credit card data entry Automatic/Manual Deprecated?
Govern default access type Table Lookup Property Control, Real Property, SRT, Name … Still in use?
Govern default cycle
Govern default payment data entry year
Govern display cycle code Deprecrated
Govern display fiscal year field Deprecrated
Govern display installment field Deprecrated
Govern print credit card receipt to verify
Govern print receipt log see roadmap
Govern receipt group 3 letter
Govern use cash drawer
Govern slip driver, font, etc. To be reviewed
Cash Collection Parameters Payment Data Entry deposit to be reviewed

By Machine

Registry Type Section Name Key Name Key Type Identification CD Key Value Encrypted Action Notes
Cash Collection Cashier Cash Collection Cashier cash drawer name 2 machine name EPSON TM-H6000IV Receipt 0 As shown in Windows Printer names
Cash Collection Cashier open cash drawer sequence 2 machine name 27;105 0
Cash Collection Parameters All the same section names and parameters as by User ID

 

 

100-USR-Registry

 

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

Upgrade Information

Upgrade Information

Overview

If you want to upgrade Govern for Windows to OpenForms 6.0

100-upgrade-ux-diagram.png
Govern for Windows Upgrade Path – Click to Enlarge

Read More...

100-upgrade-ux-table.png

If you are upgrading Govern OpenForms 4.7.4, 5.1 or 5.2 to OpenForms 6.0

If you are upgrading to 6.1

General Upgrade Path

100-upgrade-ux-table.png

See Also

 

100-upgrade

 

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

What’s New in v1511

What’s New in Release 1511

OpenForms Technology

Technology and Architecture

  • [6.1] Manage TableChangedEvent (15297)
  • [6.1] New Expression Functions IsNullOrEmpty() | IsNullOrWhiteSpace() | HasValue()
  • [6.0] Shared Expressions / Expressions Query Parameters (15132)

General

  • [6.0] Move Previous Next record of a parent entity from a Child Entity (ex Buildings)
  • [6.1] Maximize Form (Govern) – on F11 & Button
  • [6.1] Maximize Form (OFD) – on F11 & Button (14402)
  • [6.0] Entity Search Feature (Govern) in browse and other – on CTRL+ F

Systems and Application Modules

Mass Appraisal General

  • [6.1] Manage TableChangedEvent (15297)
  • [6.1] IsRequired Attribute Expression in Mass Appraisal Tables
  • [6.1] MA Parameters Value Formatting (15120)
  • [6.1] MA Compute – Remove the (Daemon) Refresh button
  • [6.1] MA Compute – Batch Process (15172)
  • [6.1] MA Compute – Update PC Legal Info From MA_LAND
  • [6.1] MA Compute – PC Data changes forces a MA compute

Income

  • [6.1] Mass Appraisal Income is now available
  • [6.1] New Mass Appraisal Income Model Table
  • [6.1] New Mass Appraisal OpenForms – one for “a”, one for “e”

Building Structural Elements

  • [6.1] MA Compute BSE

Options and Third Parties

Matix GIS Integration

  • [6.0] New Matix Integration
  • [6.0] Matix Configuration Screen in GNA (15318)

 

 

100-wnew-v1511

 

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

What’s New in v1606

What’s New in Release 1606

OpenForms Technology

General

  • [6.0] Database Extraction Tool Functionality for Personal Property
  • [6.0] System Batch process that can be executed in GNA and Govern. Batch Process Definition will be created automatically by the Database Verification Utility.
    • MSGDatabaseStructure_SystemData.xml was added for Batch Process
  • [6.0] System Batch Process Audit Information
    • Default Parameter Audit Record entries for system collections were removed
    • Audit records labels can be added in a batch process : Can replace Step 1 and Step 2 information (needs to be specified when designing)

Technology and Architecture

  • [6.0] OpenForms Technology: New Margins Property
  • [6.1] OpenForms View Query: Ability to click on a link and load a different Govern ID. (developed to support Corporate Account)
  • [6.1] Create new reserve names parameter for standard organization Address and Logo
  • [6.1] History Toolbox
    • Ability to change the year regardless if there are records for the years
    • Tool Box displays information for name base profiles
  • [6.0] System Dictionary updated during the Verify Database for missing Business Entity Attributes.

 

Standard OpenForms Controllers

Read More...

  • [6.0] CO Generic Link Controller (Link to Names, Link to Parcels, etc.) without delete capabilities. The standard controller was changed to remove delete capabilities of the linked item for system integrity and a new controller was added with the Delete Capabilities. This was necessary since it some context, you do not want users to delete an existing link. Although security was applicable to the delete feature, it was changed to support system integrity business rules.
  • [6.0] Standard Create A/R Controller

 

Systems and Application Modules

Property Control / Name and Address

[6.0] Centralized ACH Information

  • Name and Address (101-na-frm-001)
  • ACH Information (101-na-frm-016)
  • Mailing Index (101-na-frm-002)

[6.0] Name Linking (101-na-frm-035)

  • New Link Type for ST Corporate Account

 

Miscellaneous Billing

The module is now available on OpenForms, GA Release 6.1.1606

  • [6.1] Mailing Index is now used for Misc. Billing Accounts to support the centralized ACH processing.
    • Created automatically (included in Control) – Miscellaneous Correction Script will create in the Verify Database Process.
  • [6.1] Account Maintenance
  • [6.1] Invoice Maintenance
  • [6.1] Recurring Invoice Maintenance
    • Command button to Open the list of available Invoices for the Account to create a new Recurring Invoice
  • [6.1] Batch Processing
    • Process Recurring Invoices
    • Post Miscellaneous Billing to A/R
    • Recompute Sales Tax
    • Copy to Year (Administrative Batch Process available to run in GNA and Govern)
    • Initialize Next Year Recurring Invoices (same)

 

  • [6.1] Administrative Functions (Parameters)
    • Account and Invoice Structure (SY REGISTRY)
    • General Parameters
    • Categories
    • Items
    • Recurring Batch Codes
    • Copy to Next Year
    • Initialize Next Year
    • Templates for Land Management Automation (Land Management Road Map)
  • [6.1] Reports
    • New standard Invoice Report

Mass Appraisal

  • [6.1] MA Tables Auto Select code when we only have 1 value available
  • [6.1] New Action Button to call the MA Compute for current parcel
  • [6.1] MA Table Feature – Ability to use a mask
  • [6.1] MRA OpenForm Reference modified to include the Overrides
  • [6.1] MA Compute: Add a parcel Range User Criteria in the Compute Batch Process
  • [6.1] MA Tables Select/Deselect All option to exclude value

 

Accounts Receivable and Cash Collection

  • [6.0] ACH Processing Implementation – Mailing Index start of implementation – to be continued in 1609
  • [6.0] Lock Box Processing

 

Self-Reported Tax & e-Gov

  • [6.0] New Corporate Account
  • [6.0] Filings Transfer Enhancement
  • [6.0] Create and manage digital (electronic) signatures
    • Add in setup in GNA to activate feature in eRemittance
    • eRemittance Preview WebControl to ask for password of eProfile
    • Account Selection modified to show Accounts by Mailing Index and allow to inactive access
  • [6.0] ACH Debit feature (turned on in GNA)

 

System Options and Third Party

The following changes have been made to optional systems and third party integration.

Matix GIS Integration

  • [6.1] Change Base Map On the Fly: It is now possible to change the base map to display directly in the viewer. (validate if 6.0)
  • [6.1] MATIX – Print Capabilities – Consume Image
    • Multimedia button in menu bar
  • [6.1] Free Hand Selection Mode is now functional
  • [6.1] New Selection Mode (Circle, Ellipse, Triangle)

e-Government

  • [6.0] Ability to capture and store bank information (including routing and account numbers) when checks are processed via lockbox and e-Checks. (validate if standard)

 

Payment Processor Forte

  • [6.0] New payment processor Forte introduced for Govern OpenForms 6.0.1606. Forte for eGoverment processes coming in 1609.

 

 

100-wnew-v1606

 

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

What’s New in OpenForms

What’s New in OpenForms

Overview

The goal of the Knowledge Base is to document, on a higher level, changes that have an impact on the structure, on the organization, or on the process. For a summary list previous to 6.1, see Change Impact Assessment and for changes made to the database structure fields or tables, see Database Model Changes.

Detailed reports are generated automatically and are available as html pages on a govern server (http://deployez.msgovern.com/releaseNotes/xxx)
Each time a programmer makes a change in Govern to a RELEASE branch, these changes are documented and recorded in a change set that is “checked-into” the next release iteration that will be built. A report is produced automatically every hour for each supported version.

Release Information

Expand to display a non-exhaustive listing of changes to the Govern suite of applications on a per release basis.

Read More...

AR – Search to Load Data (101-ar-fea-026)

Accounts Receivable (A/R) Search to Load Feature Available in Govern Rel. 6.0/6.1 Overview Selecting a Record Key from the DataSet

Posted in Accounts Receivable, Feature, Whats New | Tagged , , , , , , , , , | Leave a comment

MA – M&S Valuation Setting Editor (103-ed-025)

Valuation Setting Editor (Marshall & Swift MVP Interface) Available in release 6.1.2211 – (In Development) Overview Marshall & Swift (M&S)

Posted in Developers, Editors, Feature, GNA, Mass Appraisal, Whats New | Tagged , , , , , , , | Leave a comment

Generic Import Editor (103-ed-024)

Generic Import Editor Available in release 6.1.xxxx – (In Development) Overview The Generic Import Editor is a GNA Editor that

Posted in Developers, Editors, Feature, GNA, Whats New | Tagged , , , , , , | Leave a comment

SSRS – SQL Server Reporting Services Report Conversion Tool

SQL Server Reporting Services Report Conversion Tool Version 6.1 Overview The SSRS Report Conversion tool is a Windows application developed

Posted in Developers, GNA, Reports, Whats New | Tagged , , , , , , , , , | Leave a comment

Bill Messages Editor

Bill Messages Editor Available in release 6.1.1911 Overview The Bill Messages Editor allows you to edit and manage Bill Messages.

Posted in Editors, Feature, GNA, Whats New | Tagged , , , , , | Leave a comment

What’s New in OpenForms Applications

The following are links to the What’s New pages of Govern OpenForms Applications

What’s New in Govern System Options

What’s New in Govern Application Modules

Tips & Troubleshooting

Tips for implementation

  • During an implementation, the link to this page can be added as an External Command to a Form or to the Coolbar Query.
  • Harris Govern employees can setup a subscription to have these reports sent automatically by email.

Release Notes/ Firewalls

  • Firewalls can prevent access to the release notes. Please verify with the system administrator if you are experiencing problems.

Product Structure

System Name Knowledge Base Page What’s New Page Link
101 Govern 101-all-govern 101-all-govern-wnew
102 Security Manager 102-all-gsm 102-all-gsm-wnew
103 Govern Administrator (GNA) 103-all-gna 103-all-gna-wnew
104 Business Entity Designer (BED) 104-all-bed 104-all-bed-wnew
105 OpenForms Designer (OFD) 105-all-ofd 105-all-ofd-wnew
108 Batch Scheduler 106-all-sc 106-all-sc-wnew
107 Query Tool 107-all-qt 107-all-qt-wnew
111 Deploy EZ 111-all-deployez 111-all-deployez-wnew
201 e-Gov 201-all-eGov 201-all-eGov-wnew
202 Mobile 202-all-mobile 202-all-mobile-wnew
101-std Govern Standard Features 101-std 101-std-wnew
101-ar Govern A/R Module 101-ar 101-ar-wnew
101-cc Govern Cash Collection Module 101-cc 101-cc-wnew
etc.

Release Notes Report

This link if only accessible to Harris Govern Employees (only). Click here to view the release note report.

 

 

100-wnew

 

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

Reporting Govern Actions

Reporting Govern Actions

Version 6.0 and Version 6.1

Overview

A GovernAction is a link between a method (InsertData) and a report. GovernActions take the form of a report object with a name that has a ‘GovernAction’ prefix, and value format. The process is similar to an Insert or Update action in the database. GovernActions are executed just prior to Displaying, Exporting, or Printing a report. Users should note that there is no Log, or indication of the running of the GovernAction. If the Govern Action triggers an exception, execution of the report stops, and the error is displayed but it is not handled. The GovernAction is designed to be triggered from any Govern report, but currently the action is only configured through Crystal Reports.
Govern Actions are an efficient way to…

  1. Perform an audit on parcels that have been accessed using Crystal Report.
  2. Provides a secure, and controlled method of inserting data in tables.

Have a report display information on multiple accounts, the report can then generate history information in the table and show new data that has been inserted; this new data is inserted in the (Table: ST_EVENT_HIST)

Read More...

Documentation

User

Click below to display or download the user documentation
100-reporting-GovernActions.pdf

Technical

Click below to display or download the technical documentation.
100-reporting-GovernActions-TECH.pdf

Related Topics

OpenForms Reporting Features

What’s New!

Changes Due to Refactoring

NEW! As a result of recent refactoring, the following two (2) changes have been made to the Govern Actions.

Placement of Govern Actions in Crystal Reports

Govern Actions no longer need to be placed exclusively in the Details section in a Crystal Report; Actions may now be placed in any of the main sections available to Crystal, i.e. Report Header, Page Header, Details, Report Footer, and Page Footer.

Grouping Allowed

A Crystal Report report can now have grouping and Govern Actions at the same time. For example there could grouping under an ST_ID. The methodology employed involves parsing the exported XML file and identifying required keywords.

NOTE: There is a limitation to the size of the XML file that is parsed; file size should not exceed 2 GB.

 

 

100-reporting-GovernActions

 

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

Std. Integrity Business Rules

Govern Standard Integrity Business Rules (To be or not to be!)

Overview

The following integrity rules ensure that record dependencies are maintained when inactivating or deleting a record to ensure no orphan records are created.
These rules are referred to as Govern’s “To be, or not to be” business rules.

  • Inactive parcels are grayed out in the tree view and the records are read-only.
  • A effective and Inactive year is used in Govern to determine if a property or building is active.
  • In some modules (Self Reported business tax and Personal Property tax…) it is possible to temporarily deactivate an account

Property Control

Parcels (Property Info)

The property master information record PC_PARCEL is not year based.

  • It is considered ACTIVE when the EFFECTIVE YEAR is equal to or less than the current year.
  • It is considered INACTIVE when the INACTIVE YEAR is equal to or less than the current year.

If a parcel was created or inactivated in the middle of a role year (splits merges, new subdivision), then the dates are used and verified.

  • It is considered ACTIVE when the EFFECTIVE YEAR = or < than the current year AND the current date is equal or greater than the EFFECTIVE DATE.
  • It is considered INACTIVE when the INACTIVE YEAR = or < than the current year AND the current date is equal or greater than the INACTIVE DATE. (validate if inactive year must be year + 1 of the inactive date)
  • When a parcel is inactive all the records in the different tables must be inactivated for the current AND the future years.
  • All tables with frozen_id and year_id are set to inactive by setting their frozen id to -32766.
  • All link tables with EFFECTIVE_YEAR, INACTIVE_YEAR, FROM_YEAR, END_YEAR, EFFECTIVE_DATE, INACTIVE_DATE, FROM_DATE or END_DATE must also be inactivated

Parcel Linking

Parcels can be linked together using the parcel linking function PC_PARCEL_LINKS, generally used for condos.

  • A property is considered part of the link if its parcel linking effective date is less than or equal to the current date and the effective date is greater than the current date
  • If a property that is the MASTER record of a link is inactivated, than all the records in the link are inactivated

Buildings

The physical buildings are linked to the property using PC_LK_PARCEL_BLDG records that are not year based.

  • It is considered ACTIVE if the property is ACTIVE
  • It is considered ACTIVE when the EFFECTIVE YEAR is equal to or less than the current year.
  • It is considered INACTIVE if the property is INACTIVE
  • It is considered INACTIVE when when the INACTIVE YEAR = or < than the current year AND the current date is equal or greater than the INACTIVE DATE (same validation)

If a building is inactivated, then

  • Mass Appraisal Building Information MA_BUILDINGS is inactivated (-32766)
  • Mass Appraisal Miscellaneous Structures linked to a MA_BUILDINGS (to be verified)

Building Linking

Buildings can be linked together PC_LK_BLDG_TO_BLDG using the Building Linking function

  • The same rules apply as Parcel Linking

Names

Name records NA_NAMES cannot be deleted if in used:

  • Owner
  • Occupant
  • Releated Name
  • Grantor and Grantee

Property Locations

  • Property Location records PC_LOCATION cannot be deleted if a building is linked to it.

Mass Appraisal

Appraisal records are year and frozen id based.

MA Property Information

The Mass Appraisal Property Information MA_MASTER must exist for any computation to take place.

  • The record cannot be deleted if any appraisal components are linked to it
  • If an appraisal record is created in land, building, site, MRA, income, personal property, miscellaneous structure, the MA MASTER will be created for the specific year and frozen id if it does not exists. Note: The Valuation Method will be set to Cost (1).

MA Sites

All Mass Appraisal components are linked to a site record MA_SITE

  • Still Active Site Record Cannot be Deleted! if a site record is used by another mass appraisal component, it cannot be deleted.

 

Linked to INCOME or MRA

  • Land records linked to an active Income or MRA record cannot be deleted
  • Building records linked to an active Income or MRA record cannot be deleted

Tables Considered

The following tables are considered when applying these rules: (to be reviewed)
Refer to each module section for the list of tables applicable.

Property Control (PC)

  • PC_PARCEL
  • PC_LEGAL_INFO
  • PC_AREA
  • PC_PARCEL_LINKS
  • PC_LK_PARCEL_BLDG
  • PC_LK_BLDG_TO_BLDG

 

Real Property Tax (TX)

  • TX_EXEMPTIONS
  • TX_LEVY_MASTER
  • TX_LK_LEVY_EXEMPT
  • TX_QC_REP_FISCALE
  • TX_RE_ASSESSMENT

 

Mass Appraisal (MA)

  • MA_CA_VAL_TRACKING
  • MA_INCOME
  • MA_INC_INFO
  • MA_INC_SIMULATION
  • MA_LAND
  • MA_LD_INFO
  • MA_LK_EXEMPTIONS
  • MA_LK_INC_FIELD
  • MA_MASTER
  • MA_MISC_STRUCTURES
  • MA_MRA
  • MA_OVERRIDE
  • MA_SALE_SAVED_P
  • MA_SITE
  • MA_VALUES_TABLE

 

Personal Property (PP)

An account can be temporarily inactivated (to be validated)

  • PP_ASSESSMENT
  • PP_ASSESSMENT_DET
  • PP_AUDIT_INFO
  • PP_EXEMPTIONS
  • PP_LEVY_MASTER
  • PP_LK_LEVY_EXEMPT
  • PP_TEMPLATE_AS

 

100-std-brules

 

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