Overview

In Govern OpenForms, you can create two or more Mass Appraisal Building Structural Elements or Land Adjustments that have the same table name, but different column names. This can be useful for creating a breakdown by percentage for elements or adjustments.

It is possible to create two or more tables that have both the same table name and the same column name. However, this is not a recommended setup. The following conditions apply:
Building Structural Elements are applied to different models.

• All Models must be different, not just the combination.
• Land Adjustments are applied to different land uses or land schedules.
• All land uses or schedules must be different, not just the combination.

The tables have different sequence numbers.
This is not a recommended configuration. If two or more elements share the same table and column name, they can be overriden with the worng element if a user makes a change in Govern.

For a pdf version of this page, open the following document.
SameColumnDifferentModel.pdf

Configuration for Building Structural Elements

To use this feature, ensure that the Apply Structural Elements to Models option is selected in GNA.
To enable this option.

1. Launch GNA.
2. Select Application Configurations > Mass Appraisal > MA General Parameters.
3. Select Page 2.
4. Select the Associate SE to Models option.
5. Click Save.

Configuration for Land Adjustments

Land Adjustments can be associated with either Land Uses or Land Schedules.
To enable one of these options:

1. Launch GNA.
2. Select Application Configurations > Mass Appraisal > MA General Parameters.
3. Select Page 2.
4. Select one of the following:
   Associate Land Adj. to Land Uses.
   Associate Land Adj. to Land Schedules
5. Click Save.

Creating Mass Appraisal Tables with the Same Table and Column Name

Building Structural Elements

To set up the tables:

1. Launch GNA.
2. Select Table Maintenance > Building Structural Elements.
3. Click New to create a new table.
4. Select any element type, other than Header, from the Element Category field.
5. Enter the Table Name and Column Name.
6. Complete the other parameters as required.
7. Select one or more models under Apply to Models.
8. Click Save.
9. Repeat steps 3 to 8 as many times as required to create additional tables.
   Enter the same table name and the same column name for each table.

Ensure that all models in all tables are different.
If any are repeated, a validation error appears.

Land Adjustments

To set up the tables:

1. Launch GNA.
2. Select Table Maintenance > Land Adjustments.
3. Click New to create a new table.
4. Select any element type., other than Header, from the Element Category field.
5. Enter the Table Name and Column Name.
6. Complete the other parameters as required.
7. Do one of the following:
   Select one or more land uses under Land Uses.
   Select one or more land schedules under Land Schedules.
8. Click Save.
9. Repeat steps 3 to 8 as many times as required to create additional tables. Enter the same table name and the same column name for each table.

Ensure that all land uses or land schedules in all tables are different.
If any are repeated, a validation error appears.