On the Specification Management page, you can display specifications with header information (geometrics, groups and details, notes, limits, symbols) and their items.
Select a display option at the top of the screen. The available options are:
-
All - All specifications appear regardless of their revision and issue status.
-
Not issued and highest revision - Only the specifications that are not issued and that have the highest revision number appear.
All specification items appear grouped by project, specification type, and specification code.
Click a specification in the Spec Code field to open the Spec Header Geometrics page where the specification header information appears.
Click a commodity code to open the Commodity Codes report. For more information, see Commodity Codes (Catalog Search).
Specification Header Geometrics
The geometrics assigned to the selected specification header appear on the Spec Header Geometrics page.
Click a table name to open a window where the details of the selected geometric appear.
If you click a branch table name, the branch table matrix appears.
If you have selected a rating table name, the rating curve appears under the geometric table details.
Specification Groups
The table groups assigned to the selected specification appear on the Specification Groups screen.
Specification Details
The table details assigned to the selected specification appear on the Specification Details screen.
Specification Notes
The notes defined for the selected specification appear on the Specification Notes screen.
Specification Limits
The limits defined for the selected specification appear on the Specification Limits screen.
Specification Symbols
The symbols attached to the selected specification appear on the Specification Symbols screen.
The table below shows the Smart Reference Data screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.
Screen |
S.50.06 Specification Management Geometrics: S.40.10-13, S.50.20-22, S.40.01/.02/.03/.05/.07 Spec Groups and Details: S.20.01, S.20.02 Spec Notes: S.50.09 |
Table |
n/a (no synchronization, direct query) |
CIP |
n/a (no CIP) |
Log File |
n/a |
The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.
Value |
Screen |
Field |
Database Column |
Other Source/Comment |
---|---|---|---|---|
Project |
S.50.06 |
m_spec_headers.proj_id |
||
Spec Type |
S.50.06 |
Spec Type |
m_spec_headers.spec_type |
|
Spec Code |
S.50.06 |
Spec Code |
m_spec_headers.spec_code |
|
Rev |
S.50.06 |
Rev |
m_spec_headers.spr_id (m_spec_revisions.revision_number) |
|
Issued |
S.50.06 |
Issued |
m_spec_headers.issue_ind |
|
Published |
S.50.06 |
Published |
m_spec_headers.published |
|
Active |
S.50.06 |
Active |
m_spec_revisions.active_ind (where spr_id=m_spec_headers.spr_id) |
|
Publish Date |
S.50.06 |
Date |
m_spec_headers.date_published |
|
Seq |
S.50.06 |
Seq |
m_spec_items.oder_seq |
|
Short Code |
S.50.06 |
Short Code |
m_spec_items.short_code |
|
Group |
S.50.06 |
Group |
m_spec_items.p_group_id (m_commodity_groups.cg_group_code) |
|
Part |
S.50.06 |
Part |
m_spec_items.p_part_id (m_parts.part_code) |
|
Option |
S.50.06 |
Option |
m_spec_items.option_code |
|
Commodity Code |
S.50.06 |
Commodity Code |
m_spec_items.commodity_id (m_commodity_codes.commodity_code) |
|
Commodity Code Layout |
S.50.06 |
Commodity Code Layout |
m_commodity_code_layouts.layout_short |
|
Commodity Project |
S.50.06 |
Commodity Project |
m_commodity_codes.proj_id |
|
Unit1 |
S.50.06 |
Unit1 |
m_spec_items.size1_unit_id |
|
From 1 |
S.50.06 |
From 1 |
m_spec_items.from_size1 |
|
To 1 |
S.50.06 |
To 1 |
m_spec_items.to_size1 |
|
Unit2 |
S.50.06 |
Unit2 |
m_spec_items.size2_unit_id |
|
From 2 |
S.50.06 |
From 2 |
m_spec_items.from_size2 |
|
To 2 |
S.50.06 |
To 2 |
m_spec_items.to_size2 |
|
Design Only |
S.50.06 |
Design Only |
m_spec_items.design_only |