4.13.13 Master Code Types and Master Codes

<< Click to Display Table of Contents >>

Navigation:  4. Additional Features > 4.13 The Code Definition Window >

4.13.13 Master Code Types and Master Codes

4.13 The Code Definition Window

Master Code Types and Master Codes let you inspect custom-code definitions stored in the selected historical database. These definitions can serve as a reference for consistent code structures across projects. A code type defines a custom-code field, such as Discipline or Material. A code is an entry belonging to that type, such as a particular discipline or material category.

The master tables are separate from the custom codes stored in the current project. Opening these views does not import definitions, assign codes to items or synchronise projects.

Open the master tables

Command

Displayed information

Database > Master > Code Types

Open the CODETYPE table in the selected historical database. Use it to inspect the available custom-code field definitions.

Database > Master > Codes

Open the CODE table in the same database. Use it to inspect code identifiers, descriptions, hierarchy and associated values.

Both commands use the database-table viewer, so the window title may be Historical Database Tables. The displayed table is restricted to CODETYPE or CODE respectively. Scroll horizontally to inspect additional columns and check the active filter if expected records are missing.

Identify the correct definition set

Check ProjectID before comparing definitions. The table can contain records labelled MASTER as well as records associated with other project identifiers. The menu commands do not automatically restrict the view to MASTER.

Use ProjectID + CodeType to identify a code-type definition. Use ProjectID + CodeType + CodeID to identify a code entry. Identical CodeID values in different code types or definition sets do not necessarily mean the same thing.

Master Code Types

Field or field group

Meaning

ProjectID

The definition set or source-project identifier under which the record is stored.

CodeType

The custom-code field identifier, for example C05. Check its title and definition; the same field identifier can have different meanings in different projects.

Title / Description

The field title and explanation of its intended use.

FieldSize / FieldType

The field length and presentation or input type.

Calculate / Format

The calculation expression and display format, where defined.

Mandatory / DefaultCodeID

Whether a value is required and which code value is used as the default.

The available columns depend on the database schema. For detailed explanations of custom-code properties, calculations, formatting, defaults and totals, see the other sections of 4.13 The Code Definition Window.

Master Codes

Field or field group

Meaning

ProjectID / CodeType

The definition set and custom-code field to which the code belongs. Match these to the corresponding CODETYPE record.

CodeID / Description

The code value and its explanation.

CodeOver

The parent-code identifier when the codes form a hierarchy. Interpret it within the same ProjectID and CodeType.

Factor / UnitWeight

Associated numerical values that can be used by the project's code calculations or item setup. Their practical meaning depends on the code definition.

VCG_min/max, LCG_min/max, TCG_min/max

Coordinate limits associated with the code. Check their intended use and coordinate convention before reusing them in another project.

Example: inspect discipline codes

Suppose a company's master set uses C05 for Discipline. This is an example convention, not a fixed meaning assigned to C05 by the program.

Table

Example identifiers

Information to check

CODETYPE

ProjectID = MASTER; CodeType = C05

The title is Discipline, with the required field type, field length and default settings.

CODE

ProjectID = MASTER; CodeType = C05; CodeID = S

The description identifies the intended discipline, for example Steel.

CODE

ProjectID = MASTER; CodeType = C05; CodeID = U

The description identifies another permitted discipline, for example Outfitting.

When comparing this set with a project, check both the C05 field definition and its code entries. A matching field identifier alone does not establish that the two projects use the same discipline convention.

Work with codes in the current project

Use View > Code Definition to create or maintain the current project's custom-code structure. For the documented process of copying codes from another project or importing them from text files, see 4.13.9 Import Codes.

Changes in one project's codes are not automatically propagated to other projects or to the master definitions. Likewise, changing a master definition does not automatically update projects that already have their own copies. Review field meanings, code identifiers, hierarchy, calculation references and coordinate conventions before reusing a definition set.

See also: 4.13 The Code Definition Window

See also: 4.13.9 Import Codes

See also: 4.13.1 Create a New Code Type