Specon or SPCom file - Intergraph Smart Reference Data - Version 10.2 - Training - Hexagon

Intergraph Smart Reference Data Training (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Training
Smart Materials/Smart Reference Data Version
10.2

Using the Specon file, you can transfer the specifications from Smart Reference Data to PDMS/ E3D. The Specon file contains information about specifications, ident details for various components, identity of new or old specification, list of specification headers, and so on. The information which is extracted into the Specon file will be in the format that PDMS/ E3D interface can interpret.

Prerequisite: Before you transfer the Specon file to PDMS/ E3D, you must first transfer the relevant ident files. For example, if you are transferring the Piping specification which contains information about the bolt and flange components, then you must first transfer the Flange-Bolt-Point and Single-Bolt-Ident files, so that PDMS/ E3D can refer to the ident information from these files during the transfer process.

The following image is a glimpse of the attributes and other details available in the Data Table Configuration section for PDMS/ E3D, which are extracted into the Specon file.

Specon_Main_Page

Smart Reference Data supports the following 3 types of Specon files:

  • Insert: When you extract the data for a specification for the first time, all the extracted data is sent to the Insert Specon file.

    SPecon_Insert

  • Modify: When you modify the data available in a specification that is already exported, that data is sent to the Modify Specon file. For this, you must set the Export settings as Add, Modify, and Delete.

    When you modify the existing data, the Name and Type columns change the positions in the output file of Modify.

    Specon_Modify

  • Delete: When you delete or replace the data available in a specification that is already exported, that data is sent to the Delete Specon file and the newly added data goes to the Insert Specon file. For this, you must set the Export settings as Delete or Replace.

    Delete_SPCOM

After you extract data from Smart Reference Data in to PDMS/ E3D Specon file, you can view the generated output in the Notepad as follows.

Specon_Complete

If you are extracting data from multiple specifications into PDMS/ E3D Specon file, you can view the generated output in the Notepad as follows.

Specon_Complete_Two_Specs

The sections are as follows:

  • General Information: General details about the specification such as Smart Reference Data version number, Job ID, Job Code, number of times the job was run, Units for Bore and Distance, and so on.

  • Specification Headers: The header information which is common for all the components that are available in the Specon file.

  • Body: The data in this section is generated based on the attributes defined for the components/Gtypes Data table in the data table configuration. The values of these attributes are fetched based on the retrieval method and source defined for the attributes inside the same Data Table. The Attributes, Retrieval Method, and Source are configured in the Data Table Configuration.

  • Attribute Names: These attribute names are extracted from the Alternate Names column. PDMS/ E3D cannot interpret the Attribute Names that are defined in Smart Reference Data. To address this, you can customize the attribute names in the Data Table Configuration page under the Alternate Name column so that PDMS/ E3D can interpret them when you export the file.

    If no alternate name is defined for an attribute, the attribute name which is delivered as part of the standard is considered.

  • Default Values: For any attribute, if the retrieval source is mentioned as PDMS Default, then the system will extract the values that are defined in the Default column of the Specon file under the data table configuration. No data is extracted if the Default column is empty.

The following table has list of attributes and other related details about the Specon file.

SPCOM

  • Definition: Spec Code

  • Retrieval Source: sh.spec_code

  • Retrieval Method: BASE_COLUMN

PDMS_VERSION

  • Definition: Version

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

FLUREF

  • Definition: Fluid Reference

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

LINETYPE

  • Definition: LINETYPE

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

BLTM

  • Definition: Bolting Method. The possible values are New or Old.

  • Retrieval Source: PDMS Default

  • Retrieval Method: ATTR_STND_METHOD

BSPEC

  • Definition: Name of the Bolt Specification

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

RATI

  • Definition: Pressure Rating

  • Retrieval Source: m_pck_pdms_lookup.get_spec_rating(sh.spec_header_id)

  • Retrieval Method: BASE_COLUMN

PDMS_DESCRIPTION

  • Definition: Spec Description

  • Retrieval Source: m_pck_pdms_lookup.get_pdms_spcom_desc(sh.spec_header_id)

  • Retrieval Method: BASE_COLUMN

NOMREF

  • Definition: Nominal Size Table Reference

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

BRREF

  • Definition: Branch Reference

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

REDREF

  • Definition: Reducing Reference

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

FINPUT

  • Definition: FINPUT

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

DISC_TEXT

  • Definition: Spec Discipline

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

PDMS_TYPE

  • Definition: The reference to the GTYPE for the component in the specification like TUBE, VALV, etc

  • Retrieval Source: Get_GTYPE

  • Retrieval Method: ATTR_STND_METHOD

PDMS_NAME

  • Definition: The name of the component, usually the ident code or as defined by the users in data table configurations.

  • Retrieval Source: i.ident_code

  • Retrieval Method: BASE_COLUMN

PBOR0

  • Definition: Specifies the bore of p-point integer. For multiway components (such as a Tee), more than one PBORE SELEC may be specified (PBORE1, PBORE2 etc.)

  • Retrieval Source: Get_PBORE0

  • Retrieval Method: ATTR_STND_METHOD

PBOR1

  • Definition: Specifies the bore of p-point integer. For multiway components (such as a Tee), more than one PBORE SELEC may be specified (PBORE1, PBORE2 etc.)

  • Retrieval Source: Get_PBORE1

  • Retrieval Method: ATTR_STND_METHOD

PBOR2

  • Definition: Specifies the bore of p-point integer. For multiway components (such as a Tee), more than one PBORE SELEC may be specified (PBORE1, PBORE2 etc.)

  • Retrieval Source: Get_PBORE2

  • Retrieval Method: ATTR_STND_METHOD

PBOR3

  • Definition: Specifies the bore of p-point integer. For multiway components (such as a Tee), more than one PBORE SELEC may be specified (PBORE1, PBORE2 etc.)

  • Retrieval Source: Get_PBORE3

  • Retrieval Method: ATTR_STND_METHOD

PBOR4

  • Definition: Specifies the bore of p-point integer. For multiway components (such as a Tee), more than one PBORE SELEC may be specified (PBORE1, PBORE2 etc.)

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

STYP

  • Definition: Defines the Specific Type of the component; it is effectively a subdivision of a GTYPE. For example, a component of GTYPE VALV may have an STYPE GATE, GLOB, CHEC etc

  • Retrieval Source: Get_STYP

  • Retrieval Method: ATTR_STND_METHOD

PDMS_ANGLE

  • Definition: Defines the required angle of an ELBO or BEND, when DDANGL has been used in the component pointset (PTSET). The answer to this SELEC question in an SPCOM may be a single value (e.g. 90.0) or a range of values (e.g. 45.0,90.0)

  • Retrieval Source: PDMS Default

  • Retrieval Method: ATTR_STND_METHOD

SHOP

  • Definition: SHOP, should have values between TRUE and FALS

  • Retrieval Source: PDMS Default

  • Retrieval Method: ATTR_STND_METHOD

CATREF

  • Definition: Catalog Reference, usually interface Commodity code or Ident for interface as PDMS/ E3D

  • Retrieval Source: Get_CATREF

  • Retrieval Method: ATTR_STND_METHOD

DETAIL

  • Definition: Reference to the Details Text in PDMS_D file.

  • Retrieval Source: '/'||m_pck_pdms_lookup.Get_PDMS_SDTE(i.ident)

  • Retrieval Method: BASE_COLUMN

MATXT

  • Definition: Reference to the Material Text in PDMS_M file.

  • Retrieval Source: '/'||m_pck_pdms_lookup.Get_PDMS_MATTXT_XTEXT(i.ident,cc.commodity_id,'CODE')||'-M'

  • Retrieval Method: BASE_COLUMN

CMPREF

  • Definition: Reference to the Component Reference in PDMS_C file.

  • Retrieval Source: m_pck_pdms_lookup.get_pdms_cmpref(i.ident,cc.commodity_id)

  • Retrieval Method: BASE_COLUMN

BLTREF

  • Definition: Reference to the Bolt Reference in PDMS_D file.

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

TMPREF

  • Definition: Link to template

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

PDAREF

  • Definition: Link to Pipe Data Table

  • Retrieval Source: m_pck_pdms_lookup.get_pdms_schedules(i.ident,sh.spec_header_id)

  • Retrieval Method: BASE_COLUMN

PRTREF

  • Definition: Link to Part Reference Table

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

SUFF

  • Definition: SUFF

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

CONX

  • Definition: CONX

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

BDIAMETER

  • Definition: Diameter of the Bolt Geometry

  • Retrieval Source: Get_PBORE0

  • Retrieval Method: ATTR_STND_METHOD

BTYP

  • Definition: Bolt Reference

  • Retrieval Source: PDMS Default

  • Retrieval Method: ATTR_STND_METHOD

BSEL

  • Definition: Bolt Select

  • Retrieval Source: Get_PDMS_Zero_Val

  • Retrieval Method: ATTR_STND_METHOD

In the SPCOM file, the retrieval source for PBOR0, PBOR1, PBOR2, PBOR3, PBOR4 values are set in such a way that the values are fetched from Input1, Input2, Input3, Input4, Input5 of the ident respectively. If users want to customize the values fetched in the PBOR attribute for any G-Type, attached procedure must be created for the SPCOM Data table such that the values are fetched from the desired Input attributes from the ident.

Below is a case shown for fetching the PBOR0 and PBOR3 values for TEE components. The latter can either be a Normal TEE or a reducing TEE. For a normal TEE, PBOR0 and PBOR3 values must be same. As seen in the below snapshots, the standard retrieval source for PBOR0 and PBOR3 fetches the values from Input1 and Input4 from the ident. This cannot be achieved by the standard retrieval sources present in the SPCOM Data table. Hence, an attached procedure must be created, which fetches PBOR0 and PBOR3 values from the first size of the ident for a Normal TEE component and first and second size respectively for a Reducing TEE component.

Sample attached procedure:

DMS-3