Working with standard databases > Planning a new standard database > Developing a standard database coding scheme
Learn more

Standard database setup forms

Structure of the standard database

How Sage Estimating sorts and aligns

Deciding how to code phases

Defining abbreviations for units of measure

Developing naming guidelines for formulas and variables

Deciding how to code assemblies

Develop naming guidelines for item tables

Developing naming guidelines for crews, crew resources, and rate tables

Developing a standard database coding scheme

The key to a good standard database is a coding scheme that helps you find things quickly and easily. The most important aspects of an efficient scheme are:

If your company already has a coding scheme, this may be a good time to make some improvements. As you are devising a new scheme, be sure everyone agrees on the plan before you start creating phases and items.