Structure of the standard database
How Sage Estimating (SQL) sorts and aligns
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
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:
- Meaningful codes
- Consistency, especially in spelling and capitalization
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.