When you want to modify or delete existing objects in the catalog using the Add/Modify/Delete mode, you must first identify the properties that define the uniqueness of the object.
The reason is that when you modify or delete an object in the catalog, the Bulkload utility needs to identify a row on the Excel sheet with an existing object in the database. For this purpose, Bulkload uses certain properties of the object that play a role in naming the object.
For example, in the piping material class table, the piping specification object in the database is identified by its specification name (SpecName). You can change all the properties on a piping specification except its SpecName. If you change the SpecName, then the identity of that object is lost, and hence Bulkload reports an error that it cannot find the object.
The following table lists all objects in alphabetical order and the corresponding unique properties.
Names such as UserClassName, OccClassName, ObjectName, SpecName, and PartNumber must be unique when compared to each other within a class and across the entire catalog.
Object |
Unique Properties |
---|---|
Allowable Piping Materials Class |
SpecName, FluidCode |
Auto Bolt Selection at Spec Brk Rule |
PipingMaterialsClassEndA, PipingMaterialsClassEndB, EndPreparationEndA, PressureRatingEndA, EndStandardEndA, MaterialGradeEndA, EndPreparationEndB, PressureRatingEndB, EndStandardEndB, MaterialGradeEndB, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, MaximumTemperature, MaximumPressure |
Auto Clamp Selection at Spec Brk Rule |
PipingMaterialsClassEndA, RevisionNumberEndA, PipingMaterialsClassEndB, RevisionNumberEndB, EndPreparationEndA, EndStandardEndA, MaterialGradeEndA, EndPreparationEndB, EndStandardEndB, MaterialGradeEndB, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits |
Auto Gasket Selection at Spec Brk Rule |
PipingMaterialsClassEndA, RevisionNumberEndA, PipingMaterialsClassEndB, RevisionNumberEndB, EndPreparationEndA, PressureRatingEndA, EndStandardEndA, MaterialGradeEndA, EndPreparationEndB, PressureRatingEndB, EndStandardEndB, MaterialGradeEndB, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, FluidCode, MaximumTemperature, MaximumPressure |
Auto WBS Creation Rule |
RuleName |
Bend Angles |
SpecName, Npd, NpdUnitType, BendAngle |
Bend Radius Multiplier Rule |
NominalPipingDiameter, NominalPipingDiameterUnits, PipeBendRadiusMultiplier |
Bolt Commodity Code Subst Rule |
ContractorCommodityCode, BoltDiameter, BoltLength |
Bolt Diameter Equivalence Rule |
BoltDiameterInPrimaryUnits, PrimaryUnitsOfMeasure |
Bolt Extension |
NominalPipingDiameter, NominalPipingDiameterUnits, PressureRating, EndPreparation, EndStandard |
Bolt Part Data |
IndustryCommodityCode |
Bolt Selection Filter |
SpecName, NominalDiameterFrom, NominalDiameterTo, BoltOption, MaximumTemperature, EndPreparation, PressureRating, EndStandard, AlternateEndPreparation, AlternatePressureRating, AlternateEndStandard |
Bolt Selection Filter For Nozzles |
EquipmentTagNumber, NozzleTagnumber, ContractorCommodityCode, BoltingRequirements, QuantityOfCapScrews, CapScrewContractorCmdtyCode, CapScrewDiameter, TappedHoleDepth, BoltExtensionOption |
Cable Nozzle |
PortType, SubType, Diameter, Area, Tightness |
Cabletray Ports |
NominalWidth, NominalDepth, ActualWidth, ActualDepth |
Cable Tray Spec |
SpecName |
Cable Way Bend Radius |
SpecName, BendRadius |
CableWay Nominal Sizes |
SpecName, SectionName |
Cableway Spec |
SpecName |
Calculation ProgIDs |
DesignStandard |
Cap Screw LenCalTolerance |
BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
Cap Screw LenCal Tolerance Per Spec |
SpecName, BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
Clamp Selection Filter |
SpecName, NominalDiameterFrom, NominalDiameterTo, ClampOption, EndPreparation, EndStandard, AlternateEndPreparation, AlternateEndStandard |
Class Node Type |
ObjectName |
Commodity Specific Service Limits |
IndustryCommodityCode, FirstSize, FirstSizeUnits, FirstSizeSchedule, SecondSize, SecondSizeUnits, SecondSizeSchedule, MultisizeOption, IndustryCommodityCodeGasket, MaximumTemperature, MaximumPressure |
Component Insulation Exclusion |
PipingCommodityType, FirstSizeFrom, FirstSizeTo, SecondSizeFrom, SecondSizeTo, MultiSizeOption, HeatTracingMedium, InsulationTemperatureFrom, InsulationTemperatureTo |
Conduit Commodity Matl Control Data |
ContractorCommodityCode, FirstSizeFrom, FirstSizeTo, FirstSizeUnits, SecondSizeFrom, SecondSizeTo, SecondSizeUnits |
Conduit Default Cmdty Slcn Rule |
FeatureType |
Conduit Filter |
SpecName, ShortCode, FirstSizeFrom, FirstSizeTo, FirstSizeUnits, SecondSizeFrom, SecondSizeTo, SecondSizeUnits, CommodityOption, OptionCategory, ContractorCommodityCode, Comments, BendRadius, BendRadiusMultiplier, SelectionBasis |
Conduit Nominal Diameters |
SpecName, Npd, NpdUnitType |
Conduit Ports |
Npd, NpdUnitType, EndPreparation, ScheduleThickness, EndStandard, PressureRating, FlowDirection |
Conduit Spec |
SpecName |
Corrosion Allowance |
SpecName, MaterialsCategory, CorrosionAllowance |
Default Change of Direction |
BendAngleFrom, BendAngleTo |
Default Change of Direction Per Spec |
SpecName, BendAngleFrom, BendAngleTo |
Default Commodity Selection Rule |
FeatureType |
DIN Wall Thickness Data |
FirstSize, FirstSizeUnits, SecondSize, SecondSizeUnits, MultiSizeOption, GeometricIndustryStandard, FirstSizeSchedule, SecondSizeSchedule |
End Prep Compatible Exceptions Rule |
EndPreparationEndA, EndStandardEndA, MaterialsCategoryEndA, EndPreparationEndB, EndStandardEndB, MaterialsCategoryEndB |
Field Fit Length |
WeldType, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, ConstructionRequirementEnd1, ConstructionRequirementEnd2, FieldFitLength |
Field Fit Length Per Spec |
SpecName, WeldType, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, ConstructionRequirementEnd1, ConstructionRequirementEnd2, FieldFitLength |
Field Lining Thickness |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits |
Flared Pipe |
NominalPipingDiameter, NominalPipingDiameterUnits, ScheduleThickness |
Flared Pipe Per Spec |
SpecName, NominalPipingDiameter, NominalPipingDiameterUnits, ScheduleThickness, |
Flexible Hose Assembly Rule |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, TopologyType, AssemblyTag, AssemblyOption |
Fluid Density Rule |
FluidCode, TemperatureFrom, TemperatureTo, Density |
Gasket Commodity Code Subst Rule |
ContractorCommodityCode, GasketInsideDiameter, GasketOutsideDiameter, GasketProcurementThickness, RingNumber |
Gasket Part Data |
IndustryCommodityCode, RingNumber, NominalDiameterFrom, NominalDiameterTo, NominalDiameter, NpdUnitType, GasketIndustryStandard |
Gasket Selection Filter |
SpecName, NominalDiameterFrom, NominalDiameterTo, GasketOption, MaximumTemperature, EndPreparation, PressureRating, EndStandard, AlternateEndPreparation, AlternatePressureRating, AlternateEndStandard, FluidCode, ScheduleThickness, MinimumTemperature |
Gasket Selection Filter For Nozzles |
EquipmentTagNumber, NozzleTagNumber, ContractorCommodityCode, GasketRequirements, RingNumber |
Hanger Class Node |
ObjectName |
IFC Clearance Rule |
RuleName, ObjectType1, Aspect1, ObjectType2, Aspect2 |
IFC Post Processor Rule |
RuleName |
Inside Surface Treatment |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, FluidCode |
Instrument Class Data |
TagNumber, GenericTagNumber, FirstSizeFrom, FirstSizeTo, FirstSizeUnits, SecondSizeFrom, SecondSizeTo, SecondSizeUnits, MultiSizeOption |
Insulation Thickness Table |
SpecName, Npd_Lo, Npd_Hi, Temperature_Lo, Temperature_Hi |
Jacket Closure |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, JacketClosureMethod |
Joint Quality Factor |
SpecName, NominalDiameterFrom, NominalDiameterTo, NpdUnitType, CommodityOption |
Lined Connector Selection Filter |
SpecName, NominalDiameterFrom, NominalDiameterTo, NpdUnitType, MaximumTemperature, EndPreparation, PressureRating, EndStandard, AlternateEndPreparation, AlternatePressureRating, AlternateEndStandard |
Liner Thickness Data |
NominalPipingDiameter, NominalDiameterUnits, LiningMaterial, GeometricIndustryStandard |
Mach Bolt Len Cal Tolerance |
BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
Mach Bolt Len Cal Tolerance Per Spec |
SpecName, BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
Materials Data |
DesignStandard, MaterialsGrade, Temperature, WallThicknessFrom, WallThicknessTo, CoefficientY, AllowableStress, MillTolerance, MillTolerancePercentage |
Mating Ports |
EndPrep1, EndPrep2 |
Mech Joint Allow Pipe End Separation |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, GeometricIndustryStandard, GeometricIndustryPractice |
Minimum Pipe Length Rule |
NominalPipingDiameter, NominalPipingDiameterUnits |
Minimum Pipe Length Rule Per Spec |
SpecName, Npd, NpdUnitType |
Min Pipe Length Purchase |
NominalPipingDiameter, PurchaseLength |
Min Pipe Length Purchase Per Spec |
SpecName, NominalPipingDiameter, PurchaseLength |
Multiport Valve Operator Data |
ContractorCommodityCode, PortNumber |
NPD Equivalence |
NPDInPrimaryUnitsOfMeasure, PrimaryUnitsOfMeasure |
Nut Commodity Code Subst Rule |
ContractorCommodityCode, BoltDiameter |
Nut Part Data |
IndustryCommodityCode |
Nut Selection Filter |
SpecName, NutOption, MaximumTemperature, BoltType, BoltDiameter, PressureRating |
Outside Surface Treatment |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, EnvironmentalZone |
Permissible Duct Thickness |
MaterialType, MaterialGrade, PermissibleDuctThickness |
Permissible Jacket And Jumper Sizes |
SpecName, CoreNominalPipeDiameter, CoreNominalPipeDiameterUnits, JacketNominalPipeDiameter, JacketNominalPipeDiameterUnits, JumperNominalPipeDiameter, JumperNominalPipeDiameterUnits |
Permissible Jacket Size Exceptions |
SpecName, CoreNominalPipeDiameter, CoreNominalPipeDiameterUnits, JacketNominalPipeDiameter, JacketNominalPipeDiameterUnits, ShortCode |
Permissible Pipe Bending Machine |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUOM |
Permissible Taps |
SpecName, PermissibleTapNumber |
Pipe Bending Configuration Data |
IsBendPlanar, NominalBendAngleFrom1, NominalBendAngleTo1, NonPlanarRotationAngleFrom2, NonPlanarRotationAngleTo2, NominalBendAngleFrom2, NominalBendAngleTo2, NonPlanarRotationAngleFrom3, NonPlanarRotationAngleTo3, NominalBendAngleFrom3, NominalBendAngleTo3, NonPlanarRotationAngleFrom4, NonPlanarRotationAngleTo4, NominalBendAngleFrom4, NominalBendAngleTo4, NonPlanarRotationAngleFrom5, NonPlanarRotationAngleTo5, NominalBendAngleFrom5, NominalBendAngleTo5, NonPlanarRotationAngleFrom6, NonPlanarRotationAngleTo6, NominalBendAngleFrom6, NominalBendAngleTo6, NonPlanarRotationAngleFrom7, NonPlanarRotationAngleTo7, NominalBendAngleFrom7, NominalBendAngleTo7, NonPlanarRotationAngleFrom8, NonPlanarRotationAngleTo8, NominalBendAngleFrom8, NominalBendAngleTo8 |
Pipe Bending Die Data |
PipeBendingMachineName, NominalPipingDiameter, NominalPipingDiameterUOM, PipeBendRadiusMultiplier |
Pipe Bending Elongation |
NominalPipingDiameter, NominalPipingDiameterUnits, PipeBendRadius, BendAngle |
Pipe Bending Elongation Per Spec |
SpecName, NominalPipingDiameter, NominalPipingDiameterUnits, PipeBendRadius, BendAngle |
Pipe Bending Machine Data |
PipeBendingMachineName |
Pipe Bending Min Tangent Len Data |
PipeBendingMachineName, PipeBendType, MinBendToBendTanLenOption, NominalPipingDiameter, NominalPipingDiameterUOM, PipeBendRadiusMultiplier |
Pipe Branch |
SpecName, HeaderSize, HdrSizeNpdUnitType, BranchSize, BrSizeNpdUnitType, AngleLow, AngleHigh |
Pipe Branch For Jackets |
SpecName, HeaderSize, HdrSizeNpdUnitType, BranchSize, BrSizeNpdUnitType, AngleLow, AngleHigh |
Pipe Mfg Map Symbol |
PartClassName, SKEY, CodeList |
Pipe Mfg Rules |
IsoNames |
Pipe Mfg Spool Rule |
Name |
Pipe Nominal Diameters |
SpecName, Npd, NpdUnitType |
Pipe Part Spec |
SpecName, FirstSizeFrom, FirstSizeTo, FirstSizeUnits, SecondSizeFrom, SecondSizeTo, SecondSizeUnits, ShortCode, OptionCode, MultisizeOption |
Pipe Schedule Thickness |
Npd, NpdUnitType, Schedule, Thickness |
Pipe Spec |
SpecName |
Pipe Takedown Parts |
SpecName, Npd, NpdUnitType |
Piping Commodity Filter |
SpecName, FirstSizeFrom, FirstSizeTo, FirstSizeUnits, SecondSizeFrom, SecondSizeTo, SecondSizeUnits, ShortCode, OptionCode, MultisizeOption, MaximumTemperature, MinimumTemperature, SelectionBasis |
Piping Commodity Matl Control Data |
ContractorCommodityCode, FirstSizeFrom, FirstSizeTo, FirstSizeUnits, SecondSizeFrom, SecondSizeTo, SecondSizeUnits |
Piping Commodity Procurement Data |
CommodityCode, FirstSize, FirstSizeUnits, SecondSize, SecondSizeUnits, MultisizeOption, FirstSizeSchedule, SecondSizeSchedule |
Piping Elbow Nozzles |
Npd, NpdUnitType, EndPreparation, ScheduleThickness, EndStandard, PressureRating, FlowDirection, BendRadius, BendLength |
Piping Generic Data Bolted |
NominalPipingDiameter, NominalDiameterUnits, EndPreparation, EndStandard, PressureRating |
Piping Generic Data Female |
NominalPipingDiameter, NominalDiameterUnits, EndPreparation, EndStandard, PressureRating, Schedule |
Piping Generic Data Mechanical |
NominalPipingDiameter, NominalDiameterUnits, EndPreparation, EndStandard, PressureRating |
Piping Materials Class Data |
SpecName |
Piping Specialty Class Data |
TagNumber, GenericTagNumber, FirstSizeFrom, FirstSizeTo, FirstSizeUnits, SecondSizeFrom, SecondSizeTo, SecondSizeUnits, MultiSizeOption |
Piping Straight Nozzles |
Npd, NpdUnitType, EndPreparation, ScheduleThickness, EndStandard, PressureRating, FlowDirection |
Plain Piping Generic Data |
NominalPipingDiameter, NominalDiameterUnits, EndStandard, Schedule, PressureRating |
Plate Flange Setback Distance |
NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits |
Port Alignment |
NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, EndPreparation |
Port Alignment Per Spec |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, EndPreparation |
Preferred Cap Screw Length |
BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
Preferred Cap Screw Length Per Spec |
SpecName, BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
Preferred Mach Bolt Length |
BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
Preferred Mach Bolt Length Per Spec |
SpecName, BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
Preferred Stud Bolt Length |
BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
Preferred Stud Bolt Length Per Spec |
SpecName, BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
PreferredTapEndStudBoltLength |
BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
PrefTapEndStudBoltLengthPerSpec |
SpecName, BoltType, BoltDiameterFrom, BoltDiameterTo, BoltDiameterIncrement, MaterialsGrade, PreferredBoltLengthFrom, PreferredBoltLengthTo, PreferredBoltLengthIncrement |
Reference Standard |
Name |
Reinforcing Pad Data |
SpecName, HeaderSize, HeaderSizeUnitsOfMeasure, BranchSize, BranchSizeUnitsOfMeasure, AcuteBranchAngleFrom, AcuteBranchAngleTo |
Reinforcing Weld Data |
SpecName, HeaderSize, HeaderSizeUnitsOfMeasure, BranchSize, BranchSizeUnitsOfMeasure, AcuteBranchAngleFrom, AcuteBranchAngleTo |
Report |
Name |
Rootgap |
NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits |
Rootgap Per Spec |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits |
Service Limits |
SpecName, Temperature, Pressure, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits |
Service Limits For Jackets |
SpecName, Temperature, Pressure |
Short Code Hierarchy Rule |
ShortCodeHierarchyType, ShortCode |
Size Reduction |
SizeReductionType, FirstSize, FirstSizeUnits, SecondSize, SecondSizeUnits, SizeReductionPreference |
Size Reduction Per Spec |
SpecName, SizeReductionType, FirstSize, FirstSizeUnits, SecondSize, SecondSizeUnits, SizeReductionPreference |
Slip On Flange Setback Distance |
NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, CompanyPracticeGap, CompanyPracticeRoundOffFactor, EndStandard, MaximumWeldThickness |
Socket Offset Rule |
NominalPipingDiameter, NominalDiameterUnits, EndPreparation, EndStandard, PressureRating, Schedule |
Space Group |
ObjectName |
Standard Notes Data |
Name, Purpose |
Stud Bolt Len Cal Tolerance |
BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
Stud Bolt Len Cal Tolerance Per Spec |
SpecName, BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
Swaged Jacket Pipe Rule |
NominalPipingDiameter, NominalPipingDiameterUnits, Schedule |
Swaged Jacket Pipe Rule Per Spec |
SpecName, NominalPipingDiameter, NominalPipingDiameterUnits, Schedule |
TapEndStudBoltLenCalTol |
BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
TapEndStudBoltLenCalTolPerSpec |
SpecName, BoltType, BoltLengthFrom, BoltLengthTo, BoltDiameterFrom, BoltDiameterTo |
Tap Properties |
TapNumber |
Thickness Data Rule |
SpecName, NominalPipingDiameter, NominalPipingDiameterUnits, ScheduleThickness |
Valve Operator Matl Control Data |
OperatorPartNumber |
Washer Commodity Code Subst Rule |
ContractorCommodityCode, BoltDiameter |
Washer Part Data |
IndustryCommodityCode |
Washer Selection Filter |
SpecName, WasherOption, MaximumTemperature, BoltDiameter, PressureRating |
Weld Clearance Rule |
SpecName, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, WeldClass |
Weld Gap Rule |
SpecName, WeldType, NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits |
Weld Model Representation Rule |
NominalPipingDiameterFrom, NominalPipingDiameterTo, NominalPipingDiameterUnits, WeldClass |
Weld Type Rule |
FabricationTypeOfEnd1, ConstructionRequirementOfEnd1, FabricationTypeOfEnd2, ConstructionRequirementOfEnd2 |