Smart 3D Interface - Intergraph Smart Reference Data Standard Database - Version 12.4 - Help - Hexagon

Standard Database for Intergraph Smart Reference Data Help

Language
English
Product
Intergraph Smart Reference Data Standard Database
Search by Category
Help
Standard Database for Smart Reference Data Version
12.4

SDB Worksheets for Consistency with Smart3D

Project Defaults

A new project default, ZI_SP3D_VR, was introduced in SDB, with possible values 2009.1, 2011.1, 2011.R1, 2014, 2014.R1, 2016, 2018, 2019, 13 and 13.1. The default value for this project default is 13.1. To support the latest version of Smart 3D v13.1, a new value 13.1 was added in SDB.

To generate the exported Excel (that is, exported Excel for Smart 3D from the SP3D 20.01 Export Jobs screen) with Smart 3D 2019, the project default value for ZI_SP3D_VR should be changed to 2018-2019. For generating exported Excel for Smart 3D 13.1, the value for this project default should be set to 13.1.

Smart 3D Sheet Procedure

A new Smart 3D procedure SET_SHT_ATTRS_FOR_S3D_VERSIONS has been created on Smart 3D Procedures. This procedure should be added to the sheets with attributes for Smart 3D versions 2009.1, 2011, 2011 R1, 2014, 2014 R1, 2016, 2018, 2019, 13 and 13.1 on Data Table Configurations on the Attached Procedures tab.

S3D Hierarchy Structure in Smart Reference Data-SDB

SDB catalog structure is included with all the applicable class nodes and the Part Class sheets that are delivered with S3D. SDB Catalog Structure is modified to match the S3D Catalog Structure to the possible extent.

Configuration Update for Smart 3D Version 2011 R1 in SDB

List of New Attributes

The following table shows the new attributes that were added to the SDB sheet templates (SP3D 10.07 screen).

Sheet

Attribute

Added/Deleted

PipeBranch

MinimumHeaderWallThickness

Added

WeakerRPadCommodityOption

Added

NutPartData, WasherPartData, PipeStock

MaterialsMgmtIDENT

Added

ValveOperatorPartData

MaterialsMgmtIDENT

Added

DimensionalBasis

Added

GasketPartData

MaterialsMgmtIDENT

Added

InnerRingMaterialsGrade

Added

OuterRingMaterialsGrade

Added

LinerMaterialsGrade

Added

MaximumTorque

Added

PreferredTorque

Added

MinimumTorque

Added

BoltPartData

BoltRequisitionClassification

Added

BoltThreadDesignation

Added

PipingCommodityPartData

ValveFlowPattern

Added

ValvePortOption

Added

MaterialsMgmtIDENT

Added

TechDeliveryConditions

Added

PipingSpecialtyStockPartData, InstrumentStockPartData

FirstSizeSchedule

Added

SecondSizeSchedule

Added

ValveFlowPattern

Added

ValvePortOption

Added

MaterialsMgmtIDENT

Added

TechDeliveryConditions

Added

MultiportValveOperatorData

XOffset

Added

YOffset

Added

RotationAngle

Added

InsulationSpec

InsulationClassDescription

Added

HeatTracingMedium

Added

ThicknessRule

Not Deleted

TemperatureRule

Not Deleted

InsulationThicknessTable

InsulOutsideDia

Added

The attributes that have been deleted in Smart 3D 2011 R1, will not be exported in the exported template when the export is performed for Smart 3D 2011 R1.

The below attached procedure must be "active" for this functionality to work properly.

New Rules in SDB for Consistency with Smart 3D 2014

The following are the new piping rules that are added in Smart 3D 2014. SDB has provided sample data for these rules.

  • BoltLengthLookupRule

  • PipeBranchFabricationRule

  • EndPrepCompatibleExceptionsRule

  • NPDCompatibilityExceptionsRule

The following are the new HVAC rules which are added in Smart 3D 2014.

  • MinimumDuctThickness

  • PermissibleDuctThicknessPerSpec

Updated the properties in SDB to be compliant with Smart 3D version 2016

"MaterialsManagementIdent" attribute has been deleted from the connection parts and added to CommoditycodeSubstRule sheets to support S3D 2016. Also, updated the Smart 3D procedure SET_SHT_ATTRS_FOR_S3D_VERSIONS.

"MaterialsMgmtIDENT" attribute is removed from the following sheets in S3D 2016 Version:

  • GasketPartData

  • NutPartData

  • WasherPartData

"MaterialsMgmtIDENT" attribute is added to the following sheets in S3D 2016 Version:

  • BoltCommodityCodeSubstRule

  • GasketCommodityCodeSubstRule

  • NutCommodityCodeSubstRule

  • WasherCommodityCodeSubstRule

Updated the properties in SDB to be compliant with the Smart 3D version 2018

  • New attribute "PurchaseLengthBasisOption" has been added to "PipingMaterialsClassData" sheet to be compatible with S3D 2018.

  • "CalculationProgIDs" sheet is updated with Dot Net progIDs.

Enabled the PreserveRows option in Data Table configuration for all the hierarchical codelist sheets in SDB

  • The PreserveRows option is enabled in the data table configurations (SDB_SHT_CONFIG) for all the hierarchical codelist sheets in SDB.

  • User can easily export the codelist sheets in the correct format for delta export and new entries with the required parent entries.

Configuration Update for Smart 3D Version 13 in SDB

Updated the properties in SDB to be compliant with the Smart 3D version 13.

  • New attribute " FlangeSetBackDistanceProgID" has been added to "CalculationProgIDs" sheet to be compatible with Smart 3D 13.

  • Updated SDB Custom Packages, General Configuration, Project Defaults and SDB delivered data to be inline and compatible with the latest Smart 3D version.

Configuration Update to export selection basis ’15’ and ’20’ for RPAD component in SDB

  • SDB has updated retrieval source for the RPAD attribute in PCF sheet which now helps the user export RPAD with multiple selection basis as 15 and 20. Configure the above workflow for SDB Delivered spec 1CS1S0A.

Smart 3D Interface Configurations in SDB

The Smart 3D interface is designed in a flexible and powerful way. Customers can maintain multiple sets of configurations and choose any one when creating an export job. Customers should create and work on customized versions of the SDB configurations.

Transfer Types

SDB has provided the data transfer types as listed below. These transfer types must be used to export SDB delivered data. All the SDB delivered transfer types are marked as Standard to prevent customers from modifying the delivered transfer types.

For Piping

  • SDB_CODE_LISTS: Contains a list of data tables required to export SDB codelists data.

  • SDB_GENERIC_DATA: Contains a list of data tables required to export SDB Generic data.

  • SDB_PIPING_EN_SPEC: Contains a list of specification data tables required to export European Norm specifications.

  • SDB_PIPING_JS_SPEC: Contains a list of specification data tables required to export Japanese Industry specifications.

  • SDB_PIPING_SPEC_WBK: Contains a list of specification data tables required to export PIP, Power and BioPharma specifications.

  • SDB_CATALOG: This is a sample transfer type delivered with SDB.

For Enterprise Content

  • SDB_PLC_HVAC: Contains a list of data tables required to export HVAC data.

  • SDB_PLC_CARNES_HVAC: Contains a list of data tables required to export Carnes HVAC data.

  • SDB_PLC_LINDAB_HVAC: Contains a list of data tables required to export Lindab HVAC data.

  • SDB_PLC_CONDUIT: Contains a list of data tables required to export Conduit data.

  • SDB_PLC_CABLING: Contains a list of data tables required to export S3D cabling data.

  • SDB_PLC_CABLETRAY: Contains a list of data tables required to export Cable Tray data.

  • SDB_PLC_CABLEWAY: Contains a list of data tables required to export Cable Way data.

  • SDB_PLC_DUCTBANK: Contains a list of data tables required to export Ductbank data.

  • SDB_PLC_EQUIP: Contains a list of data tables required to export equipment data.

  • SDB_PLC_MHE: Contains a list of data tables required to export MHE (Material Handling Equipment) data.

  • SDB_PLC_MHEC: Contains a list of data tables required to export MHEC (Material Handling Equipment Component) data.

  • SDB_HS_ASSEMBLY_CDL: Contains a list of data tables required to export Hangers and Supports - Assemblies codelist data.

  • SDB_HS_S3DASSY_CDL: Contains a list of data tables required to export Hangers and Supports - S3D Assembly codelist data.

  • SDB_HS_S3DPARTS_CDL: Contains a list of data tables required to export Hangers and Supports - S3D Parts codelist data.

  • SDB_HS_SYSTEM_CDL: Contains a list of data tables required to export Hangers and Supports - S3D System codelist data.

  • SDB_PLC_HS_AISC: Contains a list of data tables required to export Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

  • SDB_PLC_HS_AN10: Contains a list of data tables required to export Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

  • SDB_PLC_HS_ASSY: Contains a list of data tables required to export Hangers and Supports - S3D Assy data.

  • SDB_PLC_HS_ASV2: Contains a list of data tables required to export Hangers and Supports - S3D AssembliesV2 data.

  • SDB_PLC_HS_BP: Contains a list of data tables required to export Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

  • SDB_PLC_HS_BP_A: Contains a list of data tables required to export Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

  • SDB_PLC_HS_PART: Contains a list of data tables required to export Hangers and Supports - S3D Parts data.

  • SDB_PLC_HS_SYS: Contains a list of data tables required to export Hangers and Supports - S3D System data.

  • SDB_HS_DDAASSY_CDL: Contains a list of data tables required to export Hangers and Supports - DDS Assy codelist data.

  • SDB_HS_DDS_PRT: Contains a list of data tables required to export Hangers and Supports - DDS Parts data.

  • SDB_HS_DDSASSY: Contains a list of data tables required to export Hangers and Supports - DDS Assemblies data.

  • SDB_SPEL_SPI_PLC_CBL: Contains a list of data tables required to export Smart Electrical and Smart Instrumentation cabling data.

For Structural

  • SDB_STR_CROSSSECTION: Contains a list of data tables required to export Structure data.

  • SDB_STIFFENER: Contains a list of data tables required to export structure data in stiffener format.

For Marine Content

  • SDB_PLC_MC_GCMD: Contains a list of data tables required to export GC Macro Defnitions data.

  • SDB_PLC_MC_GCSO: Contains a list of data tables required to export GC Standard Openings data.

  • SDB_PLC_MC_GCTD: Contains a list of data tables required to export GC Template Definitions data.

  • SDB_PLC_MC_SMBX: Contains a list of data tables required to export SM-BuiltUpCrossSections-Metric-1.0 data.

  • SDB_PLC_MC_SMSC: Contains a list of data tables required to export SM_Struct Common data.

  • SDB_PLC_MC_SMSX: Contains a list of data tables required to export SM_Struct Cross sections data.

For Plant Content

  • S3D_INSULATIONDATA: Data tables required to export Insulation Data.xls.

  • S3D_PLC_LZONEUP: Data tables required to export LightingZoneLookUp.xls.

  • S3D_PLC_SGENSER: Data tables required to export SpaceGenericServices.xls.

  • S3D_E205COMP: Data tables required to export E205 Equipment Sample Data.xls.

  • S3D_E210SIM: Data tables required to export E210 Equipment Sample Data.xls.

  • S3D_PLC_E215SLEG: Data tables required to export E215 Equipment Sample Data.xls.

  • S3D_E230SPH: Data tables required to export E230 Equipment Sample Data.xls.

  • S3D_E240COMP: Data tables required to export E240 Equipment Sample Data.xls.

  • S3D_E245S: Data tables required to export E245 Equipment Sample Data.xls.

  • S3D_PLC_E305HSTX: Data tables required to export E305 Equipment Sample Data.xls.

  • S3D_PLC_E307KHX: Data tables required to export E307 Equipment Sample Data.xls.

  • S3D_PLC_E310VSTX: Data tables required to export E310 Equipment Sample Data.xls.

  • S3D_PLC_E320DPEX: Data tables required to export E320 Equipment Sample Data.xls.

  • S3D_PLC_E325PLEX: Data tables required to export E325 Equipment Sample Data.xls.

  • S3D_PLC_E332IDAC: Data tables required to export E332 Equipment Sample Data.xls.

  • S3D_PLC_E334FDAC: Data tables required to export E334 Equipment Sample Data.xls.

  • S3D_PLC_E405HORT: Data tables required to export E405 Equipment Sample Data.xls.

  • S3D_PLC_E410VERT: Data tables required to export E410 Equipment Sample Data.xls.

  • S3D_PLC_HOPUBB1: Data tables required to export Horizontal Pump Type BB1 Sample Data.xls.

  • S3D_PLC_HOPUBB2: Data tables required to export Horizontal Pump Type BB2 Sample Data.xls.

  • S3D_PLC_HOPUBB3: Data tables required to export Horizontal Pump Type BB3 Sample Data.xls.

  • S3D_PLC_HOPUBB5: Data tables required to export Horizontal Pump Type BB5 Sample Data.xls.

  • S3D_PLC_PUMPOH2: Data tables required to export Horizontal Pump Symbol OH2 Sample Data

  • S3D_PLC_PUMPOH3: Data tables required to export Vertical Pump Symbol OH3 Sample Data.xls.

  • S3D_PLC_VPMPVS1: Data tables required to export Vertical Pump Type VS1 Sample Data.xls.

  • S3D_PLC_VPMPVS6A: Data tables required to export Vertical Pump Type VS6 Sample Data.xls.

  • S3D_PLC_EQCOMP: Data tables required to export EquipmentComponent.xls.

  • S3D_STDNOZDATA: Data tables required to export Standard Nozzle Data.xls.

  • S3D_PLC_EQENDCP: Data tables required to export Equipment Ends Component Sample Data.xls.

  • S3D_DOORSEQUIP: Data tables required to export DoorsEquipment.xls.

  • S3D_SIMPLEDOOR: Data tables required to export SimpleDoor.xls.

  • S3D_SPACEMGMT: Data tables required to export SpaceMgmt.xls.

  • S3D_ALLCOMMON: Data tables required to export AllCommon.xls.

  • S3D_BULKLOADISOKEYS: Data tables required to export BulkLoadIsoKeys.xls.

  • S3D_DRAWINGS: Data tables required to export Drawings.xls.

  • S3D_GEN_NMG_RULES: Data tables required to export GenericNamingRules.xls.

  • S3D_IFCRULE: Data tables required to export IFCRule.xls.

  • S3D_MODULETYPES: Data tables required to export ModuleTypes.xls.

  • S3D_REPORTS: Data tables required to export Reports.xls.

  • S3D_GDSI: Data tables required to export GridsDrawingStyleIntf.xls.

  • S3D_STR_STRSASC: Data tables required to export StructSlabAssemblyConnections.xls.

  • S3D_STR_STRSLBG: Data tables required to export StructSlabGeneral.xls.

  • S3D_STR_STRSLBL: Data tables required to export StructSlabLayer.xls.

  • S3D_STR_STRSPLC: Data tables required to export StructSplitConnections.xls.

  • S3D_STR_STRSTIR: Data tables required to export StructStairs.xls.

  • S3D_STR_STRWASC: Data tables required to export StructWallAssemblyConnections.xls.

  • S3D_SHAPES: Data tables required to export Shapes.xls.

  • S3D_STR_STRWLLG: Data tables required to export StructWallGeneral.xls.

  • S3D_STR_STRWLLL: Data tables required to export StructWallLayer.xls.

  • S3D_STR_STRWLLO: Data tables required to export StructWallOperators.xls.

  • S3D_PLC_EQUIP: Data tables required to export Equipment.xls.

  • S3D_STR_STRINSU: Data tables required to export StructInsulationSpec.xls.

  • S3D_STR_STRSMFP: Data tables required to export StructMemberFireProofing.xls.

  • S3D_STR_STRWLCS: Data tables required to export StructWallCrossSection.xls.

  • S3D_STR_TRECRSS: Data tables required to export TrenchCrosssection.xls.

  • S3D_STR_STREQPF: Data tables required to export StructEquipFoundations.xls.

  • S3D_STR_STRFOOT: Data tables required to export StructFootings.xls.

  • S3D_STR_STRFRMC: Data tables required to export StructFrameConnections.xls.

  • S3D_STR_STRHNDR: Data tables required to export StructHandrails.xls.

  • S3D_STR_STRLADR: Data tables required to export StructLadders.xls.

  • S3D_STR_STRSPLD: Data tables required to export StructPlateDimensions.xls.

  • S3D_PLC_HS_AN10: Data tables required to export HS_S3DParts_Anvil PH-2010.xls.

  • S3D_PLC_HS_BP: Data tables required to export HS_S3DParts_BergenPowerNF09.3.xls.

  • S3D_PLC_HS_CTPARTS: Data tables required to export S3D_HS_CTPARTS.

  • S3D_PLC_HS_LR: Data tables required to export HS_LRPARTS.xlsx.

  • S3D_PLC_HS_PART: Data tables required to export HS_S3DPARTS.xlsx.

  • S3D_PLC_HS_ASSY_V2: Data tables required to export HS_Assembly_V2.xls.

  • S3D_STR_TREGENC: Data tables required to export Trench_General_Composition.xls.

  • S3D_DUCTBANK: Data tables required to export Ductbank.xls.

  • S3D_PLC_CONDUIT: Data tables required to export Conduit.xls.

  • S3D_PLC_CABLEWAY: Data tables required to export CableWay.xls.

  • S3D_STR_STRCOMN: Data tables required to export AllStructCommon.xls.

  • S3D_STR_XSEC_AISC: Data tables required to export StructCrossSections-AISC-LRFD-3.1.xls.

  • S3D_STR_XSEC_MISC: Data tables required to export StructCrossSections-MISC-SHAPES-1.0.xls.

  • S3D_STR_STROPEM: Data tables required to export StructOpeningsMetric.xls.

  • S3D_STR_STRASMC: Data tables required to export StructAssemblyConnections.xls.

  • S3D_PLC_CABLING: Data tables required to export Cabling.xls.

  • S3D_PLC_CABLETRAY: Data tables required to export CableTray.xls.

  • S3D_PLC_HVAC: Data tables required to export Hvac.xls.

  • S3D_PLC_LNDHVAC: Data tables required to export Lindab HVAC Catalog.xls.

  • S3D_SPHVAC: Data tables required to export Spiral HVAC Catalog.xls.

  • S3D_PLC_CARNES_HVAC: Data tables required to export Carnes HVAC Catalog.xls.

  • S3D_PLC_ONFLYINST: Data tables required to export On-the-fly Instruments.xls.

  • S3D_INSTDATA: Data tables required to export Instrument Data.xls.

  • S3D_OTFPIPINGSPL.XLS: Data tables required to export Sample Job for On The Fly Piping Speciality.xls.

  • S3D_PIPING_SPECIAL: Data tables required to export Piping Speciality data.xls.

  • S3D_PLC_HS_SYS: Data tables required to export HS_System.xls.

  • S3D_PLC_HS_BP_A: Data tables required to export HS_S3DAssy_BergenPowerNF09.3.xls.

  • S3D_PLC_HS_AISC: Data tables required to export HS_Str-AISC-LRFD-3.1.xls.

  • S3D_PLC_HS_ASSY: Data tables required to export S3D_HS_S3DASSY.xls.

Data Table Mappings

SDB has provided below list of Data Table mappings. These configurations must be used to export SDB delivered data from SDB.

For Piping

  • SDB_ITEM_MAPPING: Contains Data table & Attribute mappings required to export PIP specifications, Power specifications, BioPharma specifications and component data defined in imperial units.

  • SDB_METRIC_MAPPING: Contains Data table & Attribute mappings required to export European Norm specifications and component data defined in metric units.

  • SDB_ITEM_MAPPING_JS: Contains Data table & Attribute mappings required to export Japanese Industry specifications.

For Enterprise Content

  • SDB_ITEM_MAP_HVAC: Contains Data table mappings required to export HVAC data.

  • SDB_ITM_CARNES_HVAC: Contains Data table mappings required to export Carnes HVAC data.

  • SDB_ITM_LINDAB_HVAC: Contains Data table mappings required to export Lindab HVAC data.

  • SDB_ITEM_MAP_CONDUIT: Contains Data table mappings required to export Conduit data.

  • SDB_ITEM_MAP_CABL: Contains Data table mappings required to export Cabling data.

  • SDB_ITEM_MAP_CTRY: Contains Data table mappings required to export CableTray and CableWay data.

  • SDB_ITEM_MAP_EQUIP: Contains Data table mappings required to export Equipment data.

  • SDB_ITEM_MAP_MHE: Contains Data table mappings required to export MHE (Material Handling Equipment) data.

  • SDB_ITEM_MAP_MHEC: Contains Data table mappings required to export MHEC (Material Handling Equipment Component) data.

  • SDB_ITEM_MAP_HS_AISC: Contains Data table mappings required to export Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

  • SDB_ITEM_MAP_HS_AN10: Contains Data table mappings required to export Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

  • SDB_ITEM_MAP_HS_ASSY: Contains Data table mappings required to export Hangers and Supports - S3D Assy data.

  • SDB_ITEM_MAP_HS_ASV2: Contains Data table mappings required to export Hangers and Supports - S3D AssembliesV2 data.

  • SDB_ITEM_MAP_HS_BP: Contains Data table mappings required to export Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

  • SDB_ITEM_MAP_HS_BP_A: Contains Data table mappings required to export Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

  • SDB_ITEM_MAP_HS_PART: Contains Data table mappings required to export Hangers and Supports - S3D Parts data.

  • SDB_ITEM_MAP_HS_SYS: Contains Data table mappings required to export Hangers and Supports - S3D System data.

  • SDB_ITEM_MAP_DDS_PRT: Contains Data table mappings required to export Hangers and Supports - DDS Parts data.

  • SDB_ITEM_MAP_DDSASSY: Contains Data table mappings required to export Hangers and Supports - DDS Assemblies data.

  • SDB_SPEL_SPI_MAP_CBL: Contains Data table mappings required to export Smart Electrical and Smart Instrumentation cabling data.

For Structural

  • SDB_ITEM_MAP_STR: Contains Data table mappings required to export Structure data.

  • SDB_ITEM_MAP_STIFF: Contains Data table mappings required to export Structure data in stiffener format.

For Marine Content

  • SDB_ITEM_MAP_MC_GCMD: Contains Data table mappings required to export GC Macro Definitions data.

  • SDB_ITEM_MAP_MC_GCSO: Contains Data table mappings required to export GC Standard Openings data.

  • SDB_ITEM_MAP_MC_GCTD: Contains Data table mappings required to export GC Template Definitions data.

  • SDB_ITEM_MAP_MC_SMBX: Contains Data table mappings required to export SM-BuiltUpCrossSections-Metric-1.0 data.

  • SDB_ITEM_MAP_MC_SMSC: Contains Data table mappings required to export SM_Struct Common data.

  • SDB_ITEM_MAP_MC_SMSX: Contains Data table mappings required to export SM_Struct Cross sections data.

For Plant Content

  • S3D_ITEM_MAP_INSULDA: Data table mappings required to export Insulation Data.xls.

  • S3D_ITEM_MAP_LZONEUP: Data table mappings required to export LightingZoneLookUp.xls.

  • S3D_ITEM_MAP_SGENSER: Data table mappings required to export SpaceGenericServices.xls.

  • S3D_ITEM_MAP_E205COM: Data table mappings required to export E205 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E210SIM: Data table mappings required to export E210 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E215SLG: Data table mappings required to export E215 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E230SPH: Data table mappings required to export E230 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E240COM: Data table mappings required to export E240 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E245S: Data table mappings required to export E245 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E305HST: Data table mappings required to export E305 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E307KHX: Data table mappings required to export E307 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E310VST: Data table mappings required to export E310 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E320DPE: Data table mappings required to export E320 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E325PLE: Data table mappings required to export E325 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E332IDA: Data table mappings required to export E332 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E334FDA: Data table mappings required to export E334 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E405HOR: Data table mappings required to export E405 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_E410VER: Data table mappings required to export E410 Equipment Sample Data.xls.

  • S3D_ITEM_MAP_HOPUBB1: Data table mappings required to export Horizontal Pump Type BB1 Sample Data.xls.

  • S3D_ITEM_MAP_HOPUBB2: Data table mappings required to export Horizontal Pump Type BB2 Sample Data.xls.

  • S3D_ITEM_MAP_HOPUBB3: Data table mappings required to export Horizontal Pump Type BB3 Sample Data.xls.

  • S3D_ITEM_MAP_HOPUBB5: Data table mappings required to export Horizontal Pump Type BB5 Sample Data.xls.

  • S3D_ITEM_MAP_PUMPOH2: Data table mappings required to export Horizontal Pump Symbol OH2 Sample Data

  • S3D_ITEM_MAP_PUMPOH3: Data table mappings required to export Vertical Pump Symbol OH3 Sample Data.xls.

  • S3D_ITEM_MAP_PMPVS1: Data table mappings required to export Vertical Pump Type VS1 Sample Data.xls.

  • S3D_ITEM_MAP_VPMPVS6: Data table mappings required to export Vertical Pump Type VS6 Sample Data.xls.

  • S3D_ITEM_MAP_EQCOMP: Data table mappings required to export EquipmentComponent.xls.

  • S3D_ITEM_MAP_SDNOZDA: Data table mappings required to export Standard Nozzle Data.xls.

  • S3D_ITEM_MAP_EQENDCP: Data table mappings required to export Equipment Ends Component Sample Data.xls.

  • S3D_ITEM_MAP_DOOREQP: Data table mappings required to export DoorsEquipment.xls.

  • S3D_ITEM_MAP_SDOOR: Data table mappings required to export SimpleDoor.xls.

  • S3D_ITEM_MAP_SPCMGMT: Data table mappings required to export SpaceMgmt.xls.

  • S3D_ITEM_MAP: Data table mappings required for exporting AllCommon.xls.

  • S3D_ITEM_MAP_BLIK: Data table mappings required to export BulkLoadIsoKeys.xls.

  • S3D_ITEM_MAP_DRAWING: Data table mappings required to export Drawings.xls.

  • S3D_ITEM_MAP: Data table mappings required to export GenericNamingRules.xls.

  • S3D_ITEM_MAP_IFCRULE: Data table mappings required to export IFCRule.xls.

  • S3D_ITEM_MAP_MDLETYP: Data table mappings required to export ModuleTypes.xls.

  • S3D_ITEM_MAP_REPORT: Data table mappings required to export Reports.xls.

  • S3D_ITEM_MAP_GDSI: Data table mappings required to export GridsDrawingStyleIntf.xls.

  • S3D_ITEM_MAP_STRSASC: Data table mappings required to export StructSlabAssemblyConnections.xls.

  • S3D_ITEM_MAP_STRSLBG: Data table mappings required to export StructSlabGeneral.xls.

  • S3D_ITEM_MAP_STRSLBL: Data table mappings required to export StructSlabLayer.xls.

  • S3D_ITEM_MAP_STRSPLC: Data table mappings required to export StructSplitConnections.xls.

  • S3D_ITEM_MAP_STRSTIR: Data table mappings required to export StructStairs.xls.

  • S3D_ITEM_MAP_STRWASC: Data table mappings required to export StructWallAssemblyConnections.xls.

  • S3D_ITEM_MAP_SHAPES: Data table mappings required to export Shapes.xls.

  • S3D_ITEM_MAP_STRWLLG: Data table mappings required to export StructWallGeneral.xls.

  • S3D_ITEM_MAP_STRWLLL: Data table mappings required to export StructWallLayer.xls.

  • S3D_ITEM_MAP_STRWLLO: Data table mappings required to export StructWallOperators.xls.

  • S3D_ITEM_MAP_EQUIP: Data table mappings required to export Equipment.xls.

  • S3D_ITEM_MAP_STRINSU: Data table mappings required to export StructInsulationSpec.xls.

  • S3D_ITEM_MAP_STRSMFP: Data table mappings required to export StructMemberFireProofing.xls.

  • S3D_ITEM_MAP_STRWLCS: Data table mappings required to export StructWallCrossSection.xls.

  • S3D_ITEM_MAP_TRECRSS: Data table mappings required to export TrenchCrosssection.xls.

  • S3D_ITEM_MAP_STREQPF: Data table mappings required to export StructEquipFoundations.xls.

  • S3D_ITEM_MAP_STRFOOT: Data table mappings required to export StructFootings.xls.

  • S3D_ITEM_MAP_STRFRMC: Data table mappings required to export StructFrameConnections.xls.

  • S3D_ITEM_MAP_STRHNDR: Data table mappings required to export StructHandrails.xls.

  • S3D_ITEM_MAP_STRLADR: Data table mappings required to export StructLadders.xls.

  • S3D_ITEM_MAP_STRSPLD: Data table mappings required to export StructPlateDimensions.xls.

  • S3D_ITEM_MAP_HS_AN10: Data table mappings required to export HS_S3DParts_Anvil PH-2010.xls.

  • S3D_ITEM_MAP_HS_BP: Data table mappings required to export HS_S3DParts_BergenPowerNF09.3.xls.

  • S3D_ITEM_MAP_HS_CT: Data table mappings required to export S3D_HS_CTPARTS.

  • S3D_ITEM_MAP_HS_LR: Data table mappings required to export HS_LRPARTS.xlsx.

  • S3D_ITEM_MAP_HS_PART: Data table mappings required to export HS_S3DPARTS.xlsx.

  • S3D_ITEM_MAP_HS_ASV2: Data table mappings required to export HS_Assembly_V2.xls.

  • S3D_ITEM_MAP_TREGENC: Data table mappings required to export Trench_General_Composition.xls.

  • S3D_ITEM_MAP_DCTBNK: Data table mappings required to export Ductbank.xls.

  • S3D_ITEM_MAP_CONDUIT: Data table mappings required to export Conduit.xls.

  • S3D_ITEM_MAP_CABLWAY: Data table mappings required to export CableWay.xls.

  • S3D_ITEM_MAP_STRCOMN: Data table mappings required to export AllStructCommon.xls.

  • S3D_ITEM_MAP_STR_AIS: Data table mappings required to export StructCrossSections-AISC-LRFD-3.1.xls.

  • S3D_ITEM_MAP_STR_MIS: Data table mappings required to export StructCrossSections-MISC-SHAPES-1.0.xls.

  • S3D_ITEM_MAP_STROPEM: Data table mappings required to export StructOpeningsMetric.xls.

  • S3D_ITEM_MAP_STRASMC: Data table mappings required to export StructAssemblyConnections.xls.

  • S3D_ITEM_MAP_CABL: Data table mappings required to export Cabling.xls.

  • S3D_ITEM_MAP_CTRY: Data table mappings required to export CableTray.xls.

  • S3D_ITEM_MAP_HVAC: Data table mappings required to export Hvac.xls.

  • S3D_ITEM_MAP_LNDHVAC: Data table mappings required to export Lindab HVAC Catalog.xls.

  • S3D_ITEM_MAP_SPHVAC: Data table mappings required to export Spiral HVAC Catalog.xls.

  • S3D_ITEM_MAP_CARNES: Data table mappings required to export Carnes HVAC Catalog.xls.

  • S3D_ITEM_MAP_ONFLYIN: Data table mappings required to export On-the-fly Instruments.xls.

  • S3D_ITEM_MAP_INSTDAT: Data table mappings required to export Instrument Data.xls.

  • S3D_ITEM_MAP_OTFPSPL: Data table mappings required to export Sample Job for On The Fly Piping Speciality.xls.

  • S3D_ITEM_MAP_PSDATA: Data table mappings required to export Piping Speciality data.xls.

  • S3D_ITEM_MAP_HS_SYS: Data table mappings required to export HS_System.xls.

  • S3D_ITEM_MAP_HS_BP_A: Data table mappings required to export HS_S3DAssy_BergenPowerNF09.3.xls.

  • S3D_ITEM_MAP_HS_AISC: Data table mappings required to export HS_Str-AISC-LRFD-3.1.xls.

  • S3D_ITEM_MAP_HS_ASSY: Data table mappings required to export S3D_HS_S3DASSY.xls.

Data Table Configurations

SDB has provided the below list of data table configs. These configurations must be used to export SDB delivered data from SDB. All the SDB delivered data table configurations are marked as Standard to prevent customers from modifying the delivered data table configs.

For Piping

  • SDB_SHT_CONFIG: Contains data table configurations required to export PIP specifications, Power specifications, BioPharma specifications, codelists and component data defined in imperial units.

  • SDB_METRI_SHT_CONFIG: Contains data table configurations required to export European Norm specifications and component data defined in metric units.

  • SDB_SHT_CONFIG_JS: Contains data table configurations required to export Japanese Industry specifications and component data.

  • SDB_SAMPLE_CONFIG: Sample Data Table configurations have been provided under this configuration.

For Enterprise Content

  • SDB_SHT_CONFIG_HVAC: Contains data table configurations required to export HVAC data.

  • SDB_CONF_CARNES_HVAC: Contains data table configurations required to export Carnes HVAC data.

  • SDB_CONF_LINDAB_HVAC: Contains data table configurations required to export Lindab HVAC data.

  • SDB_SHT_CNFG_CONDUIT: Contains data table configurations required to export Conduit data.

  • SDB_SHT_CONFIG_CABL: Contains data table configurations required to export S3D Cabling, Smart Electrical and Smart Instrumentation Cabling data.

  • SDB_SHT_CONFIG_CTRY: Contains data table configurations required to export CableTray & CableWay data.

  • SDB_SHT_CONFIG_EQUIP: Contains data table configurations required to export Equipment data.

  • SDB_SHT_CONFIG_MHE: Contains data table configurations required to export MHE (Material Handling Equipment) data.

  • SDB_SHT_CONFIG_MHEC: Contains data table configurations required to export MHEC (Material Handling Equipment Component) data.

  • SDB_SHT_CNFG_HS_AISC: Contains data table configurations required to export Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

  • SDB_SHT_CNFG_HS_AN10: Contains data table configurations required to export Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

  • SDB_SHT_CNFG_HS_ASSY: Contains data table configurations required to export Hangers and Supports - S3D Assy data.

  • SDB_SHT_CNFG_HS_ASV2: Contains data table configurations required to export Hangers and Supports - S3D AssembliesV2 data.

  • SDB_SHT_CNFG_HS_BP: Contains data table configurations required to export Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

  • SDB_SHT_CNFG_HS_BP_A: Contains data table configurations required to export Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

  • SDB_SHT_CNFG_HS_PART: Contains data table configurations required to export Hangers and Supports - S3D Parts data.

  • SDB_SHT_CNFG_HS_SYS: Contains data table configurations required to export Hangers and Supports - S3D System data.

  • SDB_SHT_CNFG_DDS_PRT: Contains data table configurations required to export Hangers and Supports - DDS Parts data.

  • SDB_SHT_CNFG_DDSASSY: Contains data table configurations required to export Hangers and Supports - DDS Assemblies data.

  • SDB_SPEL_SPI_SFG_CBL: Contains data table configurations required to export Smart Electrical and Smart Instrumentation Cables data.

For Structural

  • SDB_SHT_CONFIG_STR: Contains data table configurations required to export Structure data.

  • SDB_SHT_CONFIG_STIFF: Contains data table configurations required to export Structure data in Stiffener format.

For Marine Content

  • SDB_SHT_CNFG_MC_GCMD: Contains data table configurations required to export GC Macro Definitions data.

  • SDB_SHT_CNFG_MC_GCSO: Contains data table configurations required to export GC Standard Openings data.

  • SDB_SHT_CNFG_MC_GCTD: Contains data table configurations required to export GC Template Definitions data.

  • SDB_SHT_CNFG_MC_SMBX: Contains data table configurations required to export SM-BuiltUpCrossSections-Metric-1.0 data.

  • SDB_SHT_CNFG_MC_SMSC: Contains data table configurations required to export SM_Struct Common data.

  • SDB_SHT_CNFG_MC_SMSX: Contains data table configurations required to export SM_Struct Cross sections data.

For Plant Content

  • S3D_SHT_CONF_INSULDA: Data table configurations required to export Insulation Data.xls.

  • S3D_SHT_CONF_LZONEUP: Data table configurations required to export LightingZoneLookUp.xls.

  • S3D_SHT_CONF_SGENSER: Data table configurations required to export SpaceGenericServices.xls.

  • S3D_SHT_CONF_E205COM: Data table configurations required to export E205 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E210SIM: Data table configurations required to export E210 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E215SLG: Data table configurations required to export E215 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E230SPH: Data table configurations required to export E230 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E240COM: Data table configurations required to export E240 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E245S: Data table configurations required to export E245 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E305HST: Data table configurations required to export E305 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E307KHX: Data table configurations required to export E307 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E310VST: Data table configurations required to export E310 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E320DPE: Data table configurations required to export E320 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E325PLE: Data table configurations required to export E325 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E332IDA: Data table configurations required to export E332 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E334FDA: Data table configurations required to export E334 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E405HOR: Data table configurations required to export E405 Equipment Sample Data.xls.

  • S3D_SHT_CONF_E410VER: Data table configurations required to export E410 Equipment Sample Data.xls.

  • S3D_SHT_CONF_HOPUBB1: Data table configurations required to export Horizontal Pump Type BB1 Sample Data.xls.

  • S3D_SHT_CONF_HOPUBB2: Data table configurations required to export Horizontal Pump Type BB2 Sample Data.xls.

  • S3D_SHT_CONF_HOPUBB3: Data table configurations required to export Horizontal Pump Type BB3 Sample Data.xls.

  • S3D_SHT_CONF_HOPUBB5: Data table configurations required to export Horizontal Pump Type BB5 Sample Data.xls.

  • S3D_SHT_CONF_PUMPOH2: Data table configurations required to export Horizontal Pump Symbol OH2 Sample Data

  • S3D_SHT_CONF_PUMPOH3: Data table configurations required to export Vertical Pump Symbol OH3 Sample Data.xls.

  • S3D_SHT_CONF_VPMPVS1: Data table configurations required to export Vertical Pump Type VS1 Sample Data.xls.

  • S3D_SHT_CONF_VPMPV6A: Data table configurations required to export Vertical Pump Type VS6 Sample Data.xls.

  • S3D_SHT_CONF_EQCOMP: Data table configurations required to export EquipmentComponent.xls.

  • S3D_SHT_CONF_SDNZDAT: Data table configurations required to export Standard Nozzle Data.xls.

  • S3D_SHT_CONF_EQENDCP: Data table configurations required to export Equipment Ends Component Sample Data.xls.

  • S3D_SHT_CONF_DOOREQP: Data table configurations required to export DoorsEquipment.xls.

  • S3D_SHT_CONF_SDOOR: Data table configurations required to export SimpleDoor.xls.

  • S3D_SHT_CONF_SPCMGMT: Data table configurations required to export SpaceMgmt.xls.

  • S3D_SHT_CONF_ALCOMON: Data table configurations required to export AllCommon.xls.

  • S3D_SHT_CONF_BLIK: Data table configurations required to export BulkLoadIsoKeys.xls.

  • S3D_SHT_CONF_DRAWING: Data table configurations required to export Drawings.xls.

  • S3D_SHT_CONF_GENMGRL: Data table configurations required to export GenericNamingRules.xls.

  • S3D_SHT_CONF_IFCRULE: Data table configurations required to export IFCRule.xls.

  • S3D_SHT_CONF_MODLTYP: Data table configurations required to export ModuleTypes.xls.

  • S3D_SHT_CONF_REPORTS: Data table configurations required to export Reports.xls.

  • S3D_SHT_CONF_GDSI: Data table configurations required to export GridsDrawingStyleIntf.xls.

  • S3D_SHT_CONF_STRSASC: Data table configurations required to export StructSlabAssemblyConnections.xls.

  • S3D_SHT_CONF_STRSLBG: Data table configurations required to export StructSlabGeneral.xls.

  • S3D_SHT_CONF_STRSLBL: Data table configurations required to export StructSlabLayer.xls.

  • S3D_SHT_CONF_STRSPLC: Data table configurations required to export StructSplitConnections.xls.

  • S3D_SHT_CONF_STRSTIR: Data table configurations required to export StructStairs.xls.

  • S3D_SHT_CONF_STRWASC: Data table configurations required to export StructWallAssemblyConnections.xls.

  • S3D_SHT_CONF_SHAPES: Data table configurations required to export Shapes.xls.

  • S3D_SHT_CONF_STRWLLG: Data table configurations required to export StructWallGeneral.xls.

  • S3D_SHT_CONF_STRWLLL: Data table configurations required to export StructWallLayer.xls.

  • S3D_SHT_CONF_STRWLLO: Data table configurations required to export StructWallOperators.xls.

  • S3D_SHT_CONF_EQUIP: Data table configurations required to export Equipment.xls.

  • S3D_SHT_CONF_STRINSU: Data table configurations required to export StructInsulationSpec.xls.

  • S3D_SHT_CONF_STRSMFP: Data table configurations required to export StructMemberFireProofing.xls.

  • S3D_SHT_CONF_STRWLCS: Data table configurations required to export StructWallCrossSection.xls.

  • S3D_SHT_CONF_TRECRSS: Data table configurations required to export TrenchCrosssection.xls.

  • S3D_SHT_CONF_STREQPF: Data table configurations required to export StructEquipFoundations.xls.

  • S3D_SHT_CONF_STRFOOT: Data table configurations required to export StructFootings.xls.

  • S3D_SHT_CONF_STRFRMC: Data table configurations required to export StructFrameConnections.xls.

  • S3D_SHT_CONF_STRHNDR: Data table configurations required to export StructHandrails.xls.

  • S3D_SHT_CONF_STRLADR: Data table configurations required to export StructLadders.xls.

  • S3D_SHT_CONF_STRSPLD: Data table configurations required to export StructPlateDimensions.xls.

  • S3D_SHT_CNFG_HS_AN10: Data table configurations required to export HS_S3DParts_Anvil PH-2010.xls.

  • S3D_SHT_CNFG_HS_BP: Data table configurations required to export HS_S3DParts_BergenPowerNF09.3.xls.

  • S3D_SHT_CNFG_HS_CT: Data table configurations required to export S3D_HS_CTPARTS.

  • S3D_SHT_CNFG_HS_LR: Data table configurations required to export HS_LRPARTS.xlsx.

  • S3D_SHT_CNFG_HS_PART: Data table configurations required to export HS_S3DPARTS.xlsx.

  • S3D_SHT_CNFG_HS_ASV2: Data table configurations required to export HS_Assembly_V2.xls.

  • S3D_SHT_CONF_TREGENC: Data table configurations required to export Trench_General_Composition.xls.

  • S3D_SHT_CONF_DUCTBNK: Data table configurations required to export Ductbank.xls.

  • S3D_SHT_CONF_CONDUIT: Data table configurations required to export Conduit.xls.

  • S3D_SHT_CONF_CABLWAY: Data table configurations required to export CableWay.xls.

  • S3D_SHT_CONF_STRCOMN: Data table configurations required to export AllStructCommon.xls.

  • S3D_SHT_CONF_STRAISC: Data table configurations required to export StructCrossSections-AISC-LRFD-3.1.xls.

  • S3D_SHT_CONF_STRMISC: Data table configurations required to export StructCrossSections-MISC-SHAPES-1.0.xls.

  • S3D_SHT_CONF_STROPEM: Data table configurations required to export StructOpeningsMetric.xls.

  • S3D_SHT_CONF_STRASMC: Data table configurations required to export StructAssemblyConnections.xls.

  • S3D_SHT_CONF_CABL: Data table configurations required to export Cabling.xls.

  • S3D_SHT_CONFG_CTRY: Data table configurations required to export CableTray.xls.

  • S3D_SHT_CONF_HVAC: Data table configurations required to export Hvac.xls.

  • S3D_SHT_CONF_LNDHVAC: Data table configurations required to export Lindab HVAC Catalog.xls.

  • S3D_SHT_CONF_SPHVAC: Data table configurations required to export Spiral HVAC Catalog.xls.

  • S3D_SHT_CONF_CARNES: Data table configurations required to export Carnes HVAC Catalog.xls.

  • S3D_SHT_CONF_ONFLYIN: Data table configurations required to export On-the-fly Instruments.xls.

  • S3D_SHT_CONF_INSTDAT: Data table configurations required to export Instrument Data.xls.

  • S3D_SHT_CONF_OTFPSPL: Data table configurations required to export Sample Job for On The Fly Piping Speciality.xls.

  • S3D_SHT_CONF_PSDATA: Data table configurations required to export Piping Speciality data.xls.

  • S3D_SHT_CNFG_HS_SYS: Data table configurations required to export HS_System.xls.

  • S3D_SHT_CNFG_HS_BP_A: Data table configurations required to export HS_S3DAssy_BergenPowerNF09.3.xls.

  • SDB_SHT_CNFG_HS_AISC: Data table configurations required to export HS_Str-AISC-LRFD-3.1.xls.

  • S3D_SHT_CNFG_HS_ASSY: Data table configurations required to export S3D_HS_S3DASSY.xls.

Templates

SDB has provided the below list of Templates. These templates must be used to export SDB delivered data from SDB. All the SDB delivered templates are marked as Standard to prevent customers from modifying the delivered data table configs.

For Piping

  • SDB_CODELISTS: Contains template data sheets required to export codelists data.

  • SDB_TEMPLATE: Contains template data sheets required to export Generic Data, PIP Specifications, Power Piping Specifications and BioPharma Specifications.

  • SDB_METRIC_TEMPLATE: Contains template data sheets required to export European Norm (EN) Specifications.

  • SDB_TEMPLATE_JS: Contains template data sheets required to export Japanese Industry Specifications.

  • SDB_TEMPLATE_SAMPLE: Contains sample template data sheets.

For Enterprise Content

  • SDB_TEMPLATE_HVAC: Contains template data sheets required to export HVAC data.

  • SDB_TPL_CARNES_HVAC: Contains template data sheets required to export Carnes HVAC data.

  • SDB_TPL_LINDAB_HVAC: Contains template data sheets required to export Lindab HVAC data.

  • SDB_TEMPLATE_CONDUIT: Contains template data sheets required to export Conduit data.

  • SDB_TEMPLATE_CABL: Contains template data sheets required to export Cabling data.

  • SDB_TEMPLATE_CTRY: Contains template data sheets required to export Cable Tray & Cable Way data.

  • SDB_TEMPLATE_EQUIP: Contains template data sheets required to export Equipment data.

  • SDB_TEMPLATE_MHE: Contains template data sheets required to export MHE (Material Handling Equipment) data.

  • SDB_TEMPLATE_MHEC: Contains template data sheets required to export MHEC (Material Handling Equipment Component) data.

  • SDB_TEMPLATE_HS_AISC: Contains template data sheets required to export Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

  • SDB_TEMPLATE_HS_AN10: Contains template data sheets required to export Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

  • SDB_TEMPLATE_HS_ASSY: Contains template data sheets required to export Hangers and Supports - S3D Assy data.

  • SDB_TEMPLATE_HS_ASV2: Contains template data sheets required to export Hangers and Supports - S3D AssembliesV2 data.

  • SDB_TEMPLATE_HS_BP: Contains template data sheets required to export Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

  • SDB_TEMPLATE_HS_BP_A: Contains template data sheets required to export Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

  • SDB_TEMPLATE_HS_PART: Contains template data sheets required to export Hangers and Supports - S3D Parts data.

  • SDB_TEMPLATE_HS_SYS: Contains template data sheets required to export Hangers and Supports - S3D System data.

  • SDB_TEMPLATE_DDS_PRT: Contains template data sheets required to export Hangers and Supports - DDS Parts data.

  • SDB_TEMPLATE_DDSASSY: Contains template data sheets required to export Hangers and Supports - DDS Assemblies data.

  • SDB_SPEL_SPI_TPL_CBL: Contains template data sheets required to export Smart Electrical and Smart Instrumentation cables data.

For Structural

  • SDB_TEMPLATE_STR: Contains template data sheets required to export Structure data.

  • SDB_TEMPLATE_STIFF: Contains template data sheets required to export Structure data in Stiffener format.

For Marine Content

  • SDB_TEMPLATE_MC_GCMD: Contains template data sheets required to export GC Macro Definitions data.

  • SDB_TEMPLATE_MC_GCSO: Contains template data sheets required to export GC Standard Openings data.

  • SDB_TEMPLATE_MC_GCTD: Contains template data sheets required to export GC Template Definitions data.

  • SDB_TEMPLATE_MC_SMBX: Contains template data sheets required to export SM-BuiltUpCrossSections-Metric-1.0 data.

  • SDB_TEMPLATE_MC_SMSC: Contains template data sheets required to export SM_Struct Common data.

  • SDB_TEMPLATE_MC_SMSX: Contains template data sheets required to export SM_Struct Cross sections data.

For Plant Content

  • S3D_TEMP_INSULDA: Template data sheets required to export Insulation Data.xls.

  • S3D_TEMP_LZONEUP: Template data sheets required to export LightingZoneLookUp.xls.

  • S3D_TEMP_SGENSER: Template data sheets required to export SpaceGenericServices.xls.

  • S3D_TEMP_E205COM: Template data sheets required to export E205 Equipment Sample Data.xls.

  • S3D_TEMP_E210SIM: Template data sheets required to export E210 Equipment Sample Data.xls.

  • S3D_TEMP_E215SLG: Template data sheets required to export E215 Equipment Sample Data.xls.

  • S3D_TEMP_E230SPH: Template data sheets required to export E230 Equipment Sample Data.xls.

  • S3D_TEMP_E240COM: Template data sheets required to export E240 Equipment Sample Data.xls.

  • S3D_TEMP_E245S: Template data sheets required to export E245 Equipment Sample Data.xls.

  • S3D_TEMP_E305HST: Template data sheets required to export E305 Equipment Sample Data.xls.

  • S3D_TEMP_E307KHX: Template data sheets required to export E307 Equipment Sample Data.xls.

  • S3D_TEMP_E310VST: Template data sheets required to export E310 Equipment Sample Data.xls.

  • S3D_TEMP_E320DPE: Template data sheets required to export E320 Equipment Sample Data.xls.

  • S3D_TEMP_E325PLE: Template data sheets required to export E325 Equipment Sample Data.xls.

  • S3D_TEMP_E332IDA: Template data sheets required to export E332 Equipment Sample Data.xls.

  • S3D_TEMP_E334FDA: Template data sheets required to export E334 Equipment Sample Data.xls.

  • S3D_TEMP_E405HOR: Template data sheets required to export E405 Equipment Sample Data.xls.

  • S3D_TEMP_E410VER: Template data sheets required to export E410 Equipment Sample Data.xls.

  • S3D_TEMP_HOPUBB1: Template data sheets required to export Horizontal Pump Type BB1 Sample Data.xls.

  • S3D_TEMP_HOPUBB2: Template data sheets required to export Horizontal Pump Type BB2 Sample Data.xls.

  • S3D_TEMP_HOPUBB3: Template data sheets required to export Horizontal Pump Type BB3 Sample Data.xls.

  • S3D_TEMP_HOPUBB5: Template data sheets required to export Horizontal Pump Type BB5 Sample Data.xls.

  • S3D_TEMP_PUMPOH2: Template data sheets required to export Horizontal Pump Symbol OH2 Sample Data

  • S3D_TEMP_PUMPOH3: Template data sheets required to export Vertical Pump Symbol OH3 Sample Data.xls.

  • S3D_TEMP_VPMPVS1: Template data sheets required to export Vertical Pump Type VS1 Sample Data.xls.

  • S3D_TEMP_VPMPVS6A: Template data sheets required to export Vertical Pump Type VS6 Sample Data.xls.

  • S3D_TEMP_EQCOMP: Template data sheets required to export EquipmentComponent.xls.

  • S3D_TEMP_SDNZDAT: Template data sheets required to export Standard Nozzle Data.xls.

  • S3D_TEMP_EQENDCP: Template data sheets required to export Equipment Ends Component Sample Data.xls.

  • S3D_TEMP_DOOREQP: Template data sheets required to export DoorsEquipment.xls.

  • S3D_TEMP_SDOOR: Template data sheets required to export SimpleDoor.xls.

  • S3D_TEMP_SPCEMGMT: Template data sheets required to export SpaceMgmt.xls.

  • S3D_TEMP_ALCOMON: Template data sheets required to export AllCommon.xls.

  • S3D_TEMP_BLIK: Template data sheets required to export BulkLoadIsoKeys.xls.

  • S3D_TEMP_DRAWING: Template data sheets required to export Drawings.xls.

  • S3D_TEMP_GENMGRL: Template data sheets required to export GenericNamingRules.xls.

  • S3D_TEMP_IFCRULE: Template data sheets required to export IFCRule.xls.

  • S3D_TEMP_MODLTYP: Template data sheets required to export ModuleTypes.xls.

  • S3D_TEMP_REPORTS: Template data sheets required to export Reports.xls.

  • S3D_TEMP_GDSI: Template data sheets required to export GridsDrawingStyleIntf.xls.

  • S3D_TEMP_STRSASC: Template data sheets required to export StructSlabAssemblyConnections.xls.

  • S3D_TEMP_STRSLBG: Template data sheets required to export StructSlabGeneral.xls.

  • S3D_TEMP_STR_STRSLBL: Template data sheets required to export StructSlabLayer.xls.

  • S3D_TEMP_STRSPLC: Template data sheets required to export StructSplitConnections.xls.

  • S3D_TEMP_STRSTIR: Template data sheets required to export StructStairs.xls.

  • S3D_TEMP_STRWASC: Template data sheets required to export StructWallAssemblyConnections.xls.

  • S3D_TEMP_SHAPES: Template data sheets required to export Shapes.xls.

  • S3D_TEMP_STRWLLG: Template data sheets required to export StructWallGeneral.xls.

  • S3D_TEMP_STRWLLL: Template data sheets required to export StructWallLayer.xls.

  • S3D_TEMP_STRWLLO: Template data sheets required to export StructWallOperators.xls.

  • S3D_TEMP_EQUIP: Template data sheets required to export Equipment.xls.

  • S3D_TEMP_STRINSU: Template data sheets required to export StructInsulationSpec.xls.

  • S3D_TEMP_STRSMFP: Template data sheets required to export StructMemberFireProofing.xls.

  • S3D_TEMP_STRWLCS: Template data sheets required to export StructWallCrossSection.xls.

  • S3D_TEMP_TRECRSS: Template data sheets required to export TrenchCrosssection.xls.

  • S3D_TEMP_STREQPF: Template data sheets required to export StructEquipFoundations.xls.

  • S3D_TEMP_STRFOOT: Template data sheets required to export StructFootings.xls.

  • S3D_TEMP_STRFRMC: Template data sheets required to export StructFrameConnections.xls.

  • S3D_TEMP_STRHNDR: Template data sheets required to export StructHandrails.xls.

  • S3D_TEMP_STRLADR: Template data sheets required to export StructLadders.xls.

  • S3D_TEMP_STRSPLD: Template data sheets required to export StructPlateDimensions.xls.

  • S3D_TEMPLATE_HS_AN10: Template data sheets required to export HS_S3DParts_Anvil PH-2010.xls.

  • S3D_TEMPLATE_HS_BP: Template data sheets required to export HS_S3DParts_BergenPowerNF09.3.xls.

  • S3D_TEMP_HS_CTPARTS: Template data sheets required to export S3D_HS_CTPARTS.

  • S3D_TEMP_HS_LRPARTS: Template data sheets required to export HS_LRPARTS.xlsx.

  • S3D_TEMPLATE_HS_PART: Template data sheets required to export HS_S3DPARTS.xlsx.

  • S3D_TEMP_HS_ASSY_V2: Template data sheets required to export HS_Assembly_V2.xls.

  • S3D_TEMP_TREGENC: Template data sheets required to export Trench_General_Composition.xls.

  • S3D_TEMP_DUCTBANK: Template data sheets required to export Ductbank.xls.

  • S3D_TEMP_CONDUIT: Template data sheets required to export Conduit.xls.

  • S3D_TEMP_CABLWAY: Template data sheets required to export CableWay.xls.

  • S3D_TEMP_STRCOMN: Template data sheets required to export AllStructCommon.xls.

  • S3D_TEMP_STRAISC: Template data sheets required to export StructCrossSections-AISC-LRFD-3.1.xls.

  • S3D_TEMP_STRMISC: Template data sheets required to export StructCrossSections-MISC-SHAPES-1.0.xls.

  • S3D_TEMP_STROPEM: Template data sheets required to export StructOpeningsMetric.xls.

  • S3D_TEMP_STRASMC: Template data sheets required to export StructAssemblyConnections.xls.

  • S3D_TEMP_CABL: Template data sheets required to export Cabling.xls.

  • S3D_TEMPLATE_CTRY: Template data sheets required to export CableTray.xls.

  • S3D_TEMP_HVAC: Template data sheets required to export Hvac.xls.

  • S3D_TEMP_LNDHVAC: Template data sheets required to export Lindab HVAC Catalog.xls.

  • S3D_TEMP_SPHVAC: Template data sheets required to export Spiral HVAC Catalog.xls.

  • S3D_TEMP_CARNES_HVAC: Template data sheets required to export Carnes HVAC Catalog.xls.

  • S3D_TEMP_ONFLYIN: Template data sheets required to export On-the-fly Instruments.xls.

  • S3D_TEMP_INSTDAT: Template data sheets required to export Instrument Data.xls.

  • S3D_TEMP_OTFPSPL: Template data sheets required to export Sample Job for On The Fly Piping Speciality.xls.

  • S3D_TEMP_PSDATA: Template data sheets required to export Piping Speciality data.xls.

  • S3D_TEMPLATE_HS_SYS: Template data sheets required to export HS_System.xls.

  • S3D_TEMPLATE_HS_BP_A: Template data sheets required to export HS_S3DAssy_BergenPowerNF09.3.xls.

  • SDB_TEMPLATE_HS_AISC: Template data sheets required to export HS_Str-AISC-LRFD-3.1.xls.

  • S3D_TEMPLATE_HS_ASSY: Template data sheets required to export S3D_HS_S3DASSY.xls.

Sample Export Jobs

The following sample jobs are provided to export the delivered data from SDB:

For Piping

  • SDB_EXP_CODELIST: Sample job to export all the SDB codelists.

  • SDB_EXP_GENERIC_DATA: Sample job to export SDB Generic Data.

  • SDB_EXP_ALL_PIPSPEC: Sample job to export all the PIP specifications in SDB.

  • SDB_EXP_POWER_SPEC: Sample job to export all the Power piping specifications in SDB.

  • SDB_EXP_ENSPEC: Sample job to export all the European Norm (EN) specifications in SDB.

  • SDB_EXP_JSSPEC: Sample job to export all Japanese Industry specifications in SDB.

  • SDB_EXP_GB: Sample job to export component data referring to Guobiao (GB) Standards.

  • SDB_EXP_BPH_SPEC: Sample job to export Bio Pharma Specifications in SDB.

  • SDB_EXP_SCSPEC : Sample job to export Semiconductor Industry Specifications in SDB.

For Enterprise Content

  • SDB_EXP_HVAC: Sample job to export HVAC specifications & Data in SDB.

  • SDB_EXP_CARNES_HVAC: Sample job to export Carnes HVAC specifications & Data in SDB.

  • SDB_EXP_LINDAB_HVAC: Sample job to export Lindab HVAC specifications & Data in SDB.

  • SDB_EXP_CONDUIT: Sample job to export Conduit Data in SDB.

  • SDB_EXP_CABLING: Sample job to export Cabling Data in SDB.

  • SDB_EXP_CABLETRAY: Sample job to export CableTray specifications & Data in SDB.

  • SDB_EXP_CABLEWAY: Sample job to export CableWay specifications & Data in SDB.

  • SDB_EXP_DUCTBANK: Sample job to export Ductbank specifications & Data in SDB.

  • SDB_EXP_EQUIPMENT: Sample job to export Equipment Data in SDB.

  • SDB_EXP_MHE: Sample job to export MHE (Material Handling Equipment) Data in SDB.

  • SDB_EXP_MHEC: Sample job to export MHEC (Material Handling Equipment Component) Data in SDB.

  • SDB_HS_ASSEMBLY_CDL: Sample job to export Hangers and Supports - Assemblies codelist data.

  • SDB_HS_S3DASSY_CDL: Sample job to export Hangers and Supports - S3D Assembly codelist data.

  • SDB_HS_S3DPARTS_CDL: Sample job to export Hangers and Supports - S3D Parts codelist data.

  • SDB_HS_SYSTEM_CDL: Sample job to export Hangers and Supports - S3D System codelist data.

  • SDB_EXP_HS_AISC: Sample job to export Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

  • SDB_EXP_HS_AN10: Sample job to export Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

  • SDB_EXP_HS_S3DASSY: Sample job to export Hangers and Supports - S3D Assy data.

  • SDB_HS_S3DASSYV2: Sample job to export Hangers and Supports - S3D AssembliesV2 data.

  • SDB_EXP_HS_BP: Sample job to export Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

  • SDB_EXP_HS_BP_A: Sample job to export Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

  • SDB_EXP_HS_S3DPARTS: Sample job to export Hangers and Supports - S3D Parts data.

  • SDB_EXP_HS_SYSTEM: Sample job to export Hangers and Supports - S3D System data.

  • SDB_EXP_HS_DDS_CDL: Sample job to export Hangers and Supports - DDS Assy codelist data.

  • SDB_EXP_HS_DDSPARTS: Sample job to export Hangers and Supports - DDS Parts data.

  • SDB_EXP_HS_DDSASSY: Sample job to export Hangers and Supports - DDS Assemblies data.

  • SDB_EXP_SPEL_SPI: Sample job to export Smart Electrical and Smart Instrumentation cabling data.

For Structural

  • SDB_EXP_STRUCTURE: Sample job to export Structure data.

  • SDB_EXP_STIFFENER: Sample job to export structure data in stiffener format.

For Marine Content

  • SDB_EXP_MC_GCMACDEF: Sample job to export GC Macro Definitions data.

  • SDB_EXP_MC_GCSTDOPN: Sample job to export GC Standard Openings data.

  • SDB_EXP_MC_GCTEMDEF: Sample job to export GC Template Definitions data.

  • SDB_EXP_MC_STRBXSECT: Sample job to export SM-BuiltUpCrossSections-Metric-1.0 data.

  • SDB_EXP_MC_STRUCTCOM: Sample job to export SM_Struct Common data.

  • SDB_EXP_MC_STRXSECT: Sample job to export SM_Struct Cross sections data.

For Plant Content

  • S3D_INSULATION_DATA: Sample job to export Insulation Data.xls.

  • S3D_LZONEUP: Sample job to export LightingZoneLookUp.xls.

  • S3D_SPACEGENSER: Sample job to export SpaceGenericServices.xls.

  • S3D_E205_SAMPLE: Sample job to export E205 Equipment Sample Data.xls.

  • S3D_E210_SAMPLE: Sample job to export E210 Equipment Sample Data.xls.

  • S3D_E215_SAMPLE: Sample job to export E215 Equipment Sample Data.xls.

  • S3D_E230_SAMPLE: Sample job to export E230 Equipment Sample Data.xls.

  • S3D_E240_SAMPLE: Sample job to export E240 Equipment Sample Data.xls.

  • S3D_E245_SAMPLE: Sample job to export E245 Equipment Sample Data.xls.

  • S3D_E305_SAMPLE: Sample job to export E305 Equipment Sample Data.xls.

  • S3D_E307_SAMPLE: Sample job to export E307 Equipment Sample Data.xls.

  • S3D_E310_SAMPLE: Sample job to export E310 Equipment Sample Data.xls.

  • S3D_E320_SAMPLE: Sample job to export E320 Equipment Sample Data.xls.

  • S3D_E325_SAMPLE: Sample job to export E325 Equipment Sample Data.xls.

  • S3D_E332_SAMPLE: Sample job to export E332 Equipment Sample Data.xls.

  • S3D_E334_SAMPLE: Sample job to export E334 Equipment Sample Data.xls.

  • S3D_E405_SAMPLE: Sample job to export E405 Equipment Sample Data.xls.

  • S3D_E410_SAMPLE: Sample job to export E410 Equipment Sample Data.xls.

  • S3D_PUMP_BB1: Sample job to export Horizontal Pump Type BB1 Sample Data.xls.

  • S3D_PUMP_BB2: Sample job to export Horizontal Pump Type BB2 Sample Data.xls.

  • S3D_PUMP_BB3: Sample job to export Horizontal Pump Type BB3 Sample Data.xls.

  • S3D_PUMP_BB5: Sample job to export Horizontal Pump Type BB5 Sample Data.xls.

  • S3D_PUMP_OH2: Sample job to export Horizontal Pump Symbol OH2 Sample Data.

  • S3D_PUMP_OH3: Sample job to export Vertical Pump Symbol OH3 Sample Data.xls.

  • S3D_PUMP_VS1: Sample job to export Vertical Pump Type VS1 Sample Data.xls.

  • S3D_PUMP_VS6: Sample job to export Vertical Pump Type VS6 Sample Data.xls.

  • S3D_EQUIP_COMPONENT: Sample job to export EquipmentComponent.xls.

  • S3D_STD_NOZZLE: Sample job to export Standard Nozzle Data.xls.

  • S3D_EQUIP_ENDCOMP: Sample job to export Equipment Ends Component Sample Data.xls.

  • S3D_DOORS_EQUIP: Sample job to export DoorsEquipment.xls.

  • S3D_SIMPLEDOOR: Sample job to export SimpleDoor.xls.

  • S3D_SPACEMGMT: Sample job to export SpaceMgmt.xls.

  • S3D_ALLCOMMON: Sample job to export AllCommon.xls.

  • S3D_BULKLOADISOKEYS: Sample job to export BulkLoadIsoKeys.xls.

  • S3D_DRAWINGS: Sample job to export Drawings.xls.

  • S3D_GENNAMRULES: Sample job to export GenericNamingRules.xls.

  • S3D_IFCRULE: Sample job to export IFCRule.xls.

  • S3D_MODULETYPES: Sample job to export ModuleTypes.xls.

  • S3D_REPORTS: Sample job to export Reports.xls.

  • S3D_GRIDSDRAWINGSTIN: Sample job to export GridsDrawingStyleIntf.xls.

  • S3D_STR_SLB_ASMBCNS: Sample job to export StructSlabAssemblyConnections.xls.

  • S3D_STR_SLB_GEN: Sample job to export StructSlabGeneral.xls.

  • S3D_STR_SLAB_LAYER: Sample job to export StructSlabLayer.xls.

  • S3D_STR_SPLIT_CNS: Sample job to export StructSplitConnections.xls.

  • S3D_STR_STAIRS: Sample job to export StructStairs.xls.

  • S3D_STR_WALL_ASMBCNS: Sample job to export StructWallAssemblyConnections.xls.

  • S3D_EQPT_SHAPES: Sample job to export Shapes.xls.

  • S3D_STR_WALL_GEN: Sample job to export StructWallGeneral.xls.

  • S3D_STR_WALL_LAYER: Sample job to export StructWallLayer.xls.

  • S3D_STR_WALL_OP: Sample job to export StructWallOperators.xls.

  • S3D_EQUIPMENT: Sample job to export Equipment.xls.

  • S3D_STR_INSULSPEC: Sample job to export StructInsulationSpec.xls.

  • S3D_STR_MEMBR_FP: Sample job to export StructMemberFireProofing.xls.

  • S3D_STR_WALL_CRS: Sample job to export StructWallCrossSection.xls.

  • S3D_TRENCH_CRSSEC: Sample job to export TrenchCrosssection.xls.

  • S3D_STR_EQP_FNDNS: Sample job to export StructEquipFoundations.xls.

  • S3D_STR_FOOTINGS: Sample job to export StructFootings.xls.

  • S3D_STR_FRAME_CNS: Sample job to export StructFrameConnections.xls.

  • S3D_STR_HANDRAILS: Sample job to export StructHandrails.xls.

  • S3D_STR_LADDERS: Sample job to export StructLadders.xls.

  • S3D_STR_PLATE_DIM: Sample job to export StructPlateDimensions.xls.

  • S3D_HS_AN10: Sample job to export HS_S3DParts_Anvil PH-2010.xls.

  • S3D_HS_BP: Sample job to export HS_S3DParts_BergenPowerNF09.3.xls.

  • S3D_HS_CTPARTS: Sample job to export S3D_HS_CTPARTS.

  • S3D_HS_LRPARTS: Sample job to export HS_LRPARTS.xlsx.

  • S3D_HS_S3DPARTS: Sample job to export HS_S3DPARTS.xlsx.

  • S3D_HS_ASSEMBLY_V2: Sample job to export HS_Assembly_V2.xls.

  • S3D_TRENCH_GEN_COMP: Sample job to export Trench_General_Composition.xls.

  • S3D_DUCTBANK: Sample job to export Ductbank.xls.

  • S3D_CONDUIT: Sample job to export Conduit.xls.

  • S3D_CABLEWAY: Sample job to export CableWay.xls.

  • S3D_STR_ALLCOMMON: Sample job to export AllStructCommon.xls.

  • S3D_STRUCT_AISC_3.1: Sample job to export StructCrossSections-AISC-LRFD-3.1.xls.

  • S3D_STRUCT_MISC_1.0: Sample job to export StructCrossSections-MISC-SHAPES-1.0.xls.

  • S3D_STR_OPEN_METRIC: Sample job to export StructOpeningsMetric.xls.

  • S3D_STR_ASMBLY_CONN: Sample job to export StructAssemblyConnections.xls.

  • S3D_CABLING: Sample job to export Cabling.xls.

  • S3D_CABLETRAY: Sample job to export CableTray.xls.

  • S3D_HVAC: Sample job to export Hvac.xls.

  • S3D_LINDAB_HVAC: Sample job to export Lindab HVAC Catalog.xls.

  • S3D_SPIRAL_HVAC: Sample job to export Spiral HVAC Catalog.xls.

  • S3D_CARNES_HVAC: Sample job to export Carnes HVAC Catalog.xls.

  • S3D_ONFLY_INST: Sample job to export On-the-fly Instruments.xls.

  • S3D_INST_DATA: Sample job to export Instrument Data.xls.

  • S3D_OTFPSPL: Sample job to export Sample Job for On The Fly Piping Speciality.xls.

  • S3D_PSDATA: Sample job to export Piping Speciality data.xls.

  • S3D_EXP_HS_SYSTEM: Sample job to export HS_System.xls.

  • S3D_HS_BP_A: Sample job to export HS_S3DAssy_BergenPowerNF09.3.xls.

  • S3D_HS_AISC_LRFD3.1: Sample job to export HS_Str-AISC-LRFD-3.1.xls.

  • S3D_HS_S3DASSY: Sample job to export S3D_HS_S3DASSY.xls.

SRD SDB - S3D Interface work process

The overriding objective of this integrated work process is to benefit from the key strengths and unique advantages of both tools – each being "best in class" – in the most efficient and highest value adding manner.

While there will always be company and project-specific requirements that may deviate from the process outlined below, this section describes how Hexagon clients would typically use these two systems in an integrated environment.

The role of Smart Reference Data in the integrated process is to enrich the Smart 3D "best in class" design and modeling capabilities, with its world market-leading capabilities in piping standards management:

  • Creation and maintenance of material component libraries that consist of groups, parts, commodity codes, and idents.

  • Creation and maintenance of material specifications combined with revision management.

  • Creation and maintenance of miscellaneous information, and rules.

The integrated process itself is easy and characterized by limited dynamics:

  • At the beginning of each project based on a new Smart 3D catalog, a one-time upload of the Smart Reference Data specifications and/or Smart Reference Data component library into Smart 3D takes place. A feedback loop with Smart Reference Data helps to ensure quality and change control.

  • Revisions and ad-hoc updates are transferred from Smart Reference Data to Smart 3D whenever required during the project execution.

Export Components and Specifications to Smart 3D

After all the specifications have been successfully created, they can be transferred into Smart 3D. The following procedures are applicable to both product group and project group environments.

The workflow shown below explains how the export functionality behind the export screen of Smart 3D Transfer Jobs collects all required data. This includes component data, specification data, general Smart 3D interface data, template data (for example, the code lists and rules for Smart 3D), sheet configurations, and item mappings from the various areas in Smart Reference Data and the Smart 3D interface. Once all the required data is collected via the export function, the software writes the data into an Excel workbook, which can then be loaded into Smart 3D.

Export Jobs

  1. Click Integration > Smart 3D > Smart 3D Transfer Jobs to run the export job for accessing the Smart 3D Bulk load sheets.

  2. On the screen, enter the following details:

    • Job - Enter any job name to identify it. For example, enter 1CA1S01 as the job name based on the specification name to be exported to Smart 3D.

    • Comment - Enter comments for the job. For example, Export 1CA1S01. This is simply a description for the job name.

Destinations

Destination - Smart Reference Data can be delivered to different Smart 3D catalogs. Smart Reference Data keeps track of what was transferred to which Smart 3D instance, to enable incremental (delta) transfers. Each export destination has a name and is characterized by the catalog server, catalog schema server, catalog database, and catalog schema database.

  1. Users can select the Destination from LOV.

  2. If Smart Reference Data is used to feed multiple instances of Smart 3D, all the instances should be configured on this screen with a different destination name. This helps Smart Reference Data to understand what information is already transferred to Smart 3D for each instance/destination combination.

  3. The user needs to update the Destination with Interface Version and Symbol Path to extract associated symbol DLLs and symbol Icons from Smart Reference Data as a ZIP file.

Transfer Types

Transfer Type is a logical grouping of Excel spread sheets to be populated. Currently, there are a few logical groups available in OOTB SDB.

Bulkload Utility

Bulk load Mode - The Bulk load utility is used to load the Excel spreadsheets into the Smart 3D catalog. While working with Smart Reference Data, it is recommended that the ADD_ MODIFY_DELETE option of the bulk loader is used. This option requires the bulk loader commands A, M, or D in the first column of each row of the Excel spreadsheet. These bulk loader commands are placed automatically by Smart Reference Data during the generation of the Excel spreadsheets.

Job Goal - The post data transfer scenario in Smart Reference Data depends on the selection in the Job Goal combo box. The available options are:

  • PRE_IF_TABS

  • FILL_IF_TABS

  • VERIFY_CSTCY

  • WRITE_TO_FILE

  • BULKLOAD

  • ANALYZE_LOG

  • VERIFY_SP3D

  • IMP_GUIDS

  • COMPLETE_JOB

Following are some tips on the combo box selection in Smart Reference Data:

  • It might be necessary to change and modify the codelist data during the project. If the changes have been performed in Smart Reference Data, the codelist workbook should be generated for loading into Smart 3D using Smart 3D Bulk load utility.

  • It might also be necessary to update Smart 3D part class data, if existing Smart Reference Data components are modified, existing Smart Reference Data components are deleted, or new Smart Reference Data components are created. In such cases, Smart Reference Data takes care of the required change management in the Smart 3D part sheets. This means that the revised Smart 3D catalog data sheets being created by Smart Reference Data can be loaded with the Smart 3D Bulk load utility in the ADD_MODIFY_DELETE mode. With each export, Smart Reference Data creates the spreadsheets from the database and a user can decide whether they want to create a difference sheet. This will only show the modified, new, or deleted items, or if an entire sheet should be created. (See inventory description below)

  • Another common exercise is the modification of Smart 3D specification sheets (all specification related sheets) by Smart Reference Data. Smart Reference Data stores all successfully transferred Smart 3D information in an inventory. After an update of specification-related attributes in Smart Reference Data, a new export job compares the current data against the inventory data. Smart Reference Data creates the A, M, D entries in the first column based on this comparison, where data changed is compared to the last transfer. An initial transfer always generates all records with the A (append) command. In a subsequent transfer, Smart Reference Data only creates new, deleted, or modified records.

Unchanged records compared to the previous transfer are not exported again.

A: Add the record

M: Modify the record

D: Delete the record for codelists. The Delete operation does not physically delete the record in the database.

  • In some cases, the modification of a record happens inside the attributes building the unique key of the record. In this case, simple M information is not sufficient, because Smart 3D is not able to find the correct record. In such cases, the previous version of the record must be marked by a D. Then the new version of the record must be marked with an A. If such an update is carried out within a catalog that was already used in plants, the plants need to be synchronized with the catalog in the Smart 3D project management tool.

  • Occasionally, the use of inventory logic in the interface is not required. In such cases, the job goal should be set to Write to File. After an export job has been executed, the job can be cancelled by clicking Cancel Job to not use the inventory. After the job is cancelled, the same sheets can be created once again, even though the containing data has not been changed. This method is especially helpful for training, testing, and during implementation phases. It is also useful in cases where reference data is delivered to different targets.

  • All "generation" mechanisms in Smart Reference Data perform data validations (Smart Reference Data internal) and create detailed log files. When a log file reports a warning (for example, missing data or mapping), the problem should be resolved in the Smart Reference Data library or specification. A user should NOT attempt to manually modify data in the spreadsheets under any circumstances, to avoid information inconsistency.

Data Table Mappings/Attribute Mappings

  • Data Table Mappings - The Data table mapping is a named set of relations between Sheets and assigned groups/parts/commodity codes/idents.

  • Attribute Mappings - The Attribute mapping is a named set of relations between Sheet attributes and those values that should appear on distinct parts/commodity codes/idents or Specifications/spec items.

The search process proceeds in the following level order:

Ident> Commodity Codes > Commodity Parts > Spec Items > Spec Headers

If no mapping is found on one level, the search continues the next level.

On Data Table Configurations, there is a config setting on the attribute level that can restrict the levels scanned.

If the value is defined as read from geometric and the value is not found in the assigned geometric on Attribute Mappings, the higher mapping levels are automatically ignored, in the same way as if a value is not found in the geometric.

General Configurations

Config - Smart Reference Data can store different sets of settings. These settings are project independent. Copying a configuration, copies all the details such as configuration items and their values.

The general config items define different aspects of the Smart 3D interface. User may not be required to create new config items. However, if a config item is missing, it can be added on General Configurations.

The config items SI_SCHEDULE1_ATTRIBUTE and SI_SCHEDULE2_ATTRIBUTE should be set to ATTR_CHAR1 and ATTR_CHAR2 respectively to export Piping Specifications.

The config item SI_TRANSLATION_LEVEL should be set to IDENT to export Piping Specifications.

The config item SI_ASSOCIATED_CC_GRP_PART should be updated if associated commodity codes are required for new group part combinations as shown below:

The config item SDB_DEF_PROG_IDS should be updated with DOTNET_PROG_IDS and EXPORT_DLL_FILE with "Y" values, if the commodity codes are required to exported with Dot Net ProgIDs along with DLLs.

The config item SDB_DEF_PROG_IDS should be updated with VB6_PROG_IDS and EXPORT_DLL_FILE with "N" values, if the commodity codes are required to export with Legacy COM ProgIDs and Non-piping content from SDB.

The user needs to select the appropriate SDB_CONFIG from the LOV.

Templates

Template - There are many sheets required by the Smart 3D database to enable the placement of components or the intended automation.

The data for these sheets may not be extracted dynamically from the Smart Reference Data commodity code or geometric tables during Smart 3D export jobs. However, data not conventionally maintained or standardized using Smart Reference Data commodity code, geometric, ident, or specification management screens can be maintained in Smart Reference Data as TEMPLATES. These sheets can be extracted during Smart 3D export jobs and loaded in Smart 3D.

Some examples of TEMPLATE sheets are:

  • ValveOperatorMatlControlData

  • Operator’s Dimensional Data

Selection of Data to be exported in Transfer Job

The second block of the Transfer Jobs screen contains seven tabs as shown in the figure below:

Data Tables - This tab displays the sheets selected to export data to Smart 3D. The sheets are automatically added here, based upon the transfer type selected on the previous screen. Sheets can also be added or deleted manually on this screen before submitting the export job.

SHARED Tip By keeping the selection switch Y for the General Configuration Item AUTO_SELECT_SHTS_FOR_PARTS on General Configurations, all the sheets applicable for the spec items in the selected spec codes automatically get "copied to" after submitting the job.

Specification Items - The specification code to be submitted for the Smart 3D export job is selected on this screen. Multiple specification codes can be submitted. By clicking LOV (F9), the selection list pops up, enabling the user to select the specification code to fill in the data.

After making all the relevant selections, click Save.

Idents - In a spec code, if the user wants to extract the part class sheet for an item such as an elbow, pipe, flange, and so on, the commodity code can be selected from the LOV. Users must select the group, part, and commodity code and then click Save.

Start Online

The previous screens show how to select relevant data for a Smart 3D export job. When a user clicks Start Online, the job is submitted for extraction.

After the job is started, the following steps are automatically executed by the export job.

This step performs the collection of ALL required data for later export. The data is stored in interface tables. After a job collects data for a component such as a specification, or a template (that is, a code list), no other job can access this data for the same destination unless the first job is not completed or cancelled.

After all the required data for the current export job is collected within the interface tables, the export job exports the data from the interface tables into Excel spreadsheets and stores them in one or several workbooks. Each of the steps explained above may fail due to many reasons.

To avoid the failure of steps,

  • Check the settings in a job environment

  • Check log files

  • Verify that the settings given in the job environment (especially Data Table Configurations) are correct against assigned specification data, components, and all other sheets.

Once a job is successfully completed, the exported workbook is displayed on the Transfer Files Tab. Double-click the workbook name to download it to the user’s workstation.

Logfiles

  1. Click the Log Files tab, to view the log files created during the Smart 3D export job.

  2. Double-click the log file name to open the log file or to read the Consistency Check Report, Verification Report, Write_xlsx, and so on.

Transfer Files

  1. Click the Transfer Files tab, to view the bulk load sheets workbook extracted by the Smart 3D export job.

  2. Double-click the workbook. The workbook opens in a separate window. This file can be either saved in a different folder in Smart 3D or in the download folder of Smart Reference Data itself.

Once the export job has created the Excel workbook files, they are stored in a previously defined folder on the Smart Reference Data application server. These workbook files can be downloaded to any Smart Reference Data client by double-clicking the file name on the Transfer Files tab of Transfer Jobs.

It is necessary to transfer the workbook files into a folder from where the Smart 3D Bulk load utility can access them. The Bulk load utility is then started.

For more information on how the Bulk load utility is used, refer to the corresponding Smart 3D documentation.

The specifications, which must be verified, must be added to the right window. It is recommended that the Verify Symbol Placement checkbox is checked. This will virtually verify and place all specification components and report errors.

This tool produces an Excel workbook that reports issues and inconsistencies under several categories for the selected specifications and their components.

Verification has errors

The verification has errors:

By answering this question with NO, the user has found a problem in the Smart 3D catalog definition. If this error is due to the Smart Reference Data exported, the export environment inside the Smart Reference Data must be corrected until it fulfills the requirements of Smart 3D.

If the user cancels the job, it deletes the data of this job from the interface tables and allows a new job, or a new run of the same job to collect the data again from the scratch.

Once the reasons for errors within Smart 3D are identified, the appropriate settings in Smart Reference Data must be checked.

The settings in the Smart Reference Data can be checked using the methods below:

  • Correcting the SP3D 10.07 Sheet Configs settings for a sheet and its attributes, by inserting new data on SP3D 10.04 Item Mappings

  • Correcting the Smart Reference Data specifications or component base tables

  • Adding additional data or modifying existing data on SP3D 10.08 Templates. Sometimes several of the above corrections must be performed to resolve an error.

Once the above corrections are finalized, a new job run can be created and started again.

Verification has no errors

The verification has no errors:

Once the verification of the data inside Smart 3D is verified as correct, the job can be completed.

During the execution of a job, Smart Reference Data requests the upload of the GUID sheet into Smart Reference Data. The GUID sheet is created by Smart 3D during bulkloading and stored in the workbook, which was loaded into Smart 3D.

Once the job goal is reached, the job is complete, and the current export workflow is finished.

If the same job (or a different job with the same destination, same sheets, and same specifications/components) is started again without a change in any data, most of the sheets (except special sheets such as custom interfaces) remain empty. This is because Smart Reference Data recognizes that the data has been successfully exported previously. In other words, as long as Smart Reference Data does not find new, deleted, or modified records in the current job interface table data compared with the inventory, no data is exported.

If the data must be exported entirely once again for any reason, the job must be started with a new destination.

Loading Exported Data to the Smart 3D Catalog

Existing Smart 3D Catalog

User can load the data exported from Smart Reference Data-SDB into an existing catalog or a new Smart 3D catalog.

  1. Make sure that user has not added codelists from the Hexagon specific codelist range, otherwise there will be issues with codelists.

  2. Bulk load the data exported from SDB in Append mode into an existing catalog in Smart 3D. Check that this operation does not result in any errors except for a few warnings.