Lookup Tables - WebTMA 5

WebTMA Capital Planning makes extensive use of Lookup tables to keep your data entry consistent. Funding is outlined in Accounting > Funding Source Types and Accounting > Funding Sources.

The value of Lookups is that, rather than trying to remember which values to enter for a given field, you simply select an item from a list box that contains the needed values. The following topics explain the purpose of each Lookup table used by WebTMA Capital Planning.


Path: Transactions >CPPM Lookups > Appropriations

This Lookup is used by government organization to identify appropriation committees that authorize or approve discretionary funds. If your organization does not use appropriation committees, the labels for this Lookup window can be changed via Text Management to something more appropriate.

The Appropriations Lookup is applied on the Transactions > Capital Planning > Work Elements / Identity Tab–Additional Info Subtab.

Audit Types

Path: Transactions > CPPM Lookups > Audit Types

Use the Audit Types window to categorize Capital Planning Audits.

Building Types

Path: Organization > Lookups > Building Types / Identity Tab

The standard Lookup in WebTMA, Lookups > Building Types, has a Cost per Square Foot field that was added to support the Capital Planning module.

If you are an existing WebTMA client, we recommend that you edit each building type and add the Cost per Square Foot value that indicates replacement cost per Sq. Ft. for the building. When you enter new building records, the cost per square foot will be entered automatically from this list when you select the Building Type. You can also enter or change this amount directly in the Cost per Sq. Ft. field on the Building / Identity Tab.

Construction Types

Path: Transactions > CPPM Lookups > Construction Types

This Lookup is used to clarify the construction type of the building. In contracts, Building type often is used to signify the usage category or purposing of a building. This Lookup is applied on the Building / Identity Tab to support the Capital Planning module.

Estimate Markups

Path: Transactions > CPPM Lookups > Estimate Markups

Capital Planning estimate lines can have one or more markups applied to them. This Lookup is used to define these markups. An Estimate Markup is applied to any Estimate line on the Work Element / Estimate Tab.

Default Estimate Markups can be established on a Capital Setups record. If you have done this when adding a new Estimate line, these default markups are added automatically to the estimate line. They can still be removed individually or modified at that point.

The Rate % entered is expected to be a percentage, and when the value is used internally in calculations, the value is divided by 100. Thus, if you have a markup of 10%, enter 10, not .1.

Estimate Models

Path: Transactions > CPPM Lookups > Estimate Models

Capital Planning estimates can be derived from various cost estimating models. This Lookup is where these cost estimating models are defined. An estimate model is applied to a Work Element on the Transactions > Capital Planning > Work Elements / Estimate Tab.

Cost estimation models are mathematical algorithms or parametric equations used to estimate the costs of a product or project. The results of the models are typically necessary to obtain approval to proceed and are factored into business plans, budgets, and other financial planning and tracking mechanisms. WebTMA Capital Planning currently supports mathematical algorithms but does not yet support parametric cost estimating models.

These algorithms were originally performed manually but now are almost universally computerized. They may be standardized (available in published texts or purchased commercially) or proprietary, depending on the type of business, product, or project in question. Simple models may use standard spreadsheet products.

Models typically function through the input of parameters that describe the attributes of the product or project in question, and possibly physical resource requirements. The model then provides as output various resources requirements in cost and time. Some models concentrate only on estimating project costs (often a single monetary value).

Sample Data:

  • Design Model
  • In-house model
  • RS Means Construction Cost Database
  • MARS Facility Maintenance & Repair Cost Forecast


Path: Transactions > CPPM Lookups > Justifications

It is important to justify the work or projects being funded. The Justifications Lookup is provided to formalize the various common Justifications you may use.

These Justifications are applied to the Transactions > Capital Planning > Work Elements / Identity Tab.

Because the Capital Planning module uses a number of worksheets for what-if-scenarios, and because the lookup cells in these spreadsheets are not dynamic at this time, we must map all Justifications to four different Levels. Those four Levels are Health and Safety, Damage Prevention, Scheduled Maintenance, and Needed Repairs. You can have an unlimited number of Justifications, but they all map to these four Justification Levels.

Sample Data:

A fifth option, 'Undefined,' is available if you have enhancements or new construction; however, 'Undefined' is not included in the lookup cells and does not display on the spreadsheets.

Master Items

Path: Transactions > CPPM Lookups > Master Items

Capital Planning incorporates a complete Life Cycle Renewal Program.

To help you establish your Cyclic Renewal Program, we provide a Lookup that holds many common items that are cyclic in nature. Master Cyclic Renewal Items are non-tagged maintenance items such as tile, curtains, flooring, tuck pointing, etc. TMA initializes your database with this ‘starter library’ of cyclic renewal items. You can choose to add to this, modify it, or not use it at all. The Master Items Lookup record can be applied to the Renewal Programs / Identity Tab.

You can enter UniFormat element fields in a valid level 2, 3, or 4 without providing the parent level. Once a UniFormat level is selected, the parent record automatically populates. If you select a Level 1 (or 2, or 3), the subsequent fields are filtered by the parent selection.

How to Add a Capital Planning Master Item

When adding new master cyclic renewal items, it is mandatory to provide a Code, Description, Frequency, and at least one UniFormat Element, so items and their replacement costs can be rolled up into building components or systems.

This data is extremely critical and should be given considerable thought before proceeding. The Master Items represent the specific cyclic renewals items for all facilities, utilities, and grounds including Code, Description, UniFormat classification, and Frequency in years (life expectancy).

Think carefully about your choices, this data impacts your long-term time commitments to edit and maintain your Cyclic Renewal database. It is a question of the specificity you need on future cyclic renewals versus the time needed to create and maintain the data. More specificity translates to much more time to maintain the data. Master Renewal data can be simple at the start and increase in complexity later as needed.

WebTMA Capital Planning comes with a number of Cyclic Maintenance Items already loaded. You can review this list and delete any you do not wish to use.


Path: Transactions > CPPM Lookups > Regulations

Various rules that are issued by Regulatory Agencies might impact or drive a Work Element. This Lookup allows you to define those regulations and the regulatory agency that issued them. Regulations are applied to each Work Element record on the Capital Planning > Work Elements / Regulation X-Ref Tab.


Path: Transactions > CPPM Lookups > Sources

Work Elements have various sources. These sources can include Facility Condition Audits, Contracted Engineering Studies, Internal Inspections, or a walk-through inspection of a building. Use this Lookup to formalize the possible sources of a Work Element. The Sources Lookup is applied to a Work Element on the Capital Planning > Work Elements / Identity–Additional Info Subtab.


Path: Organization > Lookups > Status

This is an existing Lookup in WebTMA. A Capital Planning check box was added to support the Capital Planning Module.

If you are an existing WebTMA client, we recommend that you visit the Status Lookup window and add as many Capital Planning Statuses as required for designating the status of Work Elements.


Path: Transactions > CPPM Lookups > UniFormat

UniFormat™ is a nationally recognized classification for building components and is licensed by CSI (Construction Standards Institute). It is also used to classify building components in building systems. The UniFormat™ library has been licensed by TMA. By coding Work Elements and Cyclic Renewal items by UniFormat, the Capital Planning module is able to roll up cost estimates and work projects into various levels. Many different Estimate Models such as RS Means map their estimates to the UniFormat codes.

Note: The basic twelve categories should not be changed to allow comparisons with other institutions. This is critical data that applies to all Work Elements and cyclic Renewal tables. Care must be taken to create a usable list prior to the start of loading data. Changing the breakdown after data is loaded is extremely time consuming and requires editing most entries and may require splitting up many records previously loaded.

UniFormat Tree View Tab

This Tab allows you to review the various UniFormat™ levels and sub-levels.

Work Element Types

Path: Transactions > CPPM Lookups > Work Element Types

The Work Element Type is used to classify Work Elements. Both Type and Subtype are supported. Work Element Type is a mandatory field on the Transactions > Capital Planning > Work Elements / Identity Tab.

Designation Field: The Excel Worksheets used for 'what-if-scenarios' require a fixed set of Work Element Types. Because of this, all Work Element Types must map to the hard wired set of values. These selections are made in the Designation field. The following list shows the hard-wired values available:

  • Undefined
  • Deferred Maintenance
  • Facility Improvement
  • Capital Construction
  • Cyclic Renewal
  • Plant Adaption
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

2024 Client Training Schedule
See the full list of web training events.