Data Source Fields for Model Basic

(NUMBER) = returns a whole number .
(FLOAT) = returns a decimal number .
(STRING) = returns a string of characters.
(BOOL) = boolean ; returns Yes or No or 1 or 0.
(DIM_NUM) = returns a decimal number of inches.
(DIM) = returns an imperial dimension expressed using fractions and hyphens.
(DATE) = returns a date .
(ANGLE) = returns a decimal number in radians.
(WEIGHT) = returns a decimal number in pounds.
(LOAD) = returns a load in kips (or kips-inches for a moment load).

Field names in this database are hard coded. However, your reports will still work if you choose to use field names for which there are aliases in the dictionary_aliases.txt files that are stored in the reports and reports/SDS2 folders in the data directory used by the current version of the SDS2 program you are running. Do not alter the file in reports/default folder -- that file preserves backwards compatibility with previous versions of the Report Writer databases. If you want to add your own aliases for field names, you should do so by making changes to the dictionary_aliases.txt file in the reports folder. The format of these files is your_new_name = current_database_name . You may enter either a name segment ( c = C ) or a full path ( a.b.c = A.B.C ) to either side of the equal sign. For example, you could enter a name segment to subtitute for a full path ( c = A.B.C ).

Tip : You need to have done a Create Group Member to get information from data source fields in the GroupedMember. folder.

GroupedMember.

|- GroupMemberNumber (NUMBER) - see Member.GroupNumber

|- Piecemark (STRING)

Tip : With the exception of GroupMemberDrawing.Piecemark, you need to Detail Member Groups to get information from data source fields in the GroupMemberDrawing. folder.

GroupMemberDrawing.

|- Piecemark (STRING)

|- DetailType (STRING)

|- Quantity (NUMBER)

Tip : Data source fields in the Member. folder apply to members or to member main material. You need to Process and Create Solids to allow the Report Writer to get up-to-date information from data source fields in the Member. folder.

Member.

|- MemberNumber (NUMBER)

|- Piecemark (STRING)

|- TypeDescription (STRING)

Member.LeftEnd.

|- |- ConnectionHasFailed (BOOL)

Member.RightEnd.

|- |- ConnectionHasFailed (BOOL)

Member.MaterialFile.

Data source fields under Member.MaterialFile provide specifications from the local shape file on the " Section size " that is entered as the member main material. See the Shapes Properties for more information.

|- |- SectionSize (STRING)

|- |- MaterialType (STRING)

|- |- JoistTypeDescription (STRING)

|- |- DepthDimension (DIM)

|- |- FlangeWidthDimension (DIM)

|- |- FlangeThicknessDimension (DIM)

|- |- WebThicknessDimension (DIM)

|- |- WeightPerFoot (WEIGHT)

|- |- NominalDepthDimension (DIM)

|- |- FlangeGaugeDimension (DIM)

Member.CustomProperties.

|- |- Log (STRING)

|- |- Notes (STRING)

Member.

|- CategoryDescription (STRING)

|- MaterialGrade (STRING)

|- ErectionZone (STRING)

|- ErectionSequence (STRING)

|- MaterialDetailLengthDimension (DIM)

|- CamberDimension (DIM)

|- MiscMemberDescription (STRING)

|- MemberDescription (STRING)

Tip : You need to Detail Members to allow the Report Writer to get information from data source fields in the PiecemarkDrawing. folder.

PiecemarkDrawing.

|- Piecemark (STRING)

|- DetailTypeDescription (STRING)

|- Quantity (NUMBER)

Tip : You need to Process and Create Solids to allow the Report Writer to get up-to-date information from data source fields under the MemberMaterial. folder.

MemberMaterial.

MemberMaterial.Material.

|- |- MinorMark (STRING)

|- |- MainMaterial (NUMBER)

|- |- ConnectionMaterial (BOOL)

MemberMaterial.Material.SubMaterial.

MemberMaterial.Material.SubMaterial.Hole.

|- |- |- |- LengthDimension (DIM)

|- |- |- |- HoleTypeDescription (STRING)

|- |- |- |- MaterialFaceDescription (STRING)

MemberMaterial.Material.SubMaterial.Hole.CustomProperties.

|- |- |- |- |- Log (STRING)

|- |- |- |- |- Notes (STRING)

MemberMaterial.Material.SubMaterial.HoleGroup.

|- |- |- |- DiameterDimension (DIM)

|- |- |- |- SlotLengthDimension (DIM)

|- |- |- |- SlotRotation (ANGLE)

|- |- |- |- BoltDiameterDimension (DIM)

|- |- |- |- BoltTypeDescription (STRING)

MemberMaterial.Material.SubMaterial.

|- |- |- Quantity (NUMBER)

MemberMaterial.Material.SubMaterial.MaterialFile.

|- |- |- |- SectionSize (STRING)

|- |- |- |- MaterialType (STRING)

|- |- |- |- JoistTypeDescription (STRING)

|- |- |- |- DepthDimension (DIM)

|- |- |- |- FlangeWidthDimension (DIM)

|- |- |- |- FlangeThicknessDimension (DIM)

|- |- |- |- WebThicknessDimension (DIM)

|- |- |- |- WeightPerFoot (WEIGHT)

|- |- |- |- NominalDepthDimension (DIM)

|- |- |- |- FlangeGaugeDimension (DIM)

MemberMaterial.Material.SubMaterial.

|- |- |- MaterialType (STRING)

|- |- |- Sequence (STRING)

|- |- |- Zone (STRING)

|- |- |- MaterialDescription (STRING)

|- |- |- ImperialDescription (STRING)

|- |- |- MetricDescription (STRING)

|- |- |- Weight (WEIGHT)

|- |- |- SurfaceAreaDimension (DIM)

|- |- |- MaterialGradeDescription (STRING)

MemberMaterial.Material.SubMaterial.TypeSpecificMaterial.

MemberMaterial.Material.SubMaterial.TypeSpecificMaterial.Material.

|- |- |- |- |- OrderLengthDimension (DIM)

|- |- |- |- |- PartLengthDimension (DIM)

|- |- |- |- |- WidthDimension (DIM)

|- |- |- |- |- ThicknessDimension (DIM)

|- |- |- |- |- MidOrdinate (DIM_NUM)

MemberMaterial.Material.

|- |- ShipLoose (BOOL)

|- |- ConnectionBoltDescription (STRING)

|- |- MiscellaneousMaterial (BOOL)

|- |- StandardPart (BOOL)

MemberMaterial.Material.CustomProperties.

||- |- |- Log (STRING)

|- |- |- Notes (STRING)

MemberMaterial.Bolt.

|- |- DiameterDimension (DIM)

|- |- LengthDimension (DIM)

|- |- Weight (WEIGHT)

|- |- WasherWeight (WEIGHT)

|- |- FinishDescription (STRING)

|- |- GripDimension (DIM)

|- |- IsFieldBolt (BOOL)

|- |- IsTensionControl (BOOL)

|- |- HasBolt (BOOL)

|- |- HasNut (BOOL)

|- |- HasWasher (BOOL)

|- |- WasherDescription (BOOL)

MemberMaterial.Bolt.PrimaryHeadWasher.

|- |- |- TypeDescription (STRING)

|- |- |- Quantity (USHORT)

|- |- |- ThicknessDimension (DIM)

|- |- |- WidthDimension (DIM)

|- |- |- Rotation (ANGLE)

MemberMaterial.Bolt.SecondaryHeadWasher.

|- |- |- TypeDescription (STRING)

|- |- |- Quantity (USHORT)

|- |- |- ThicknessDimension (DIM)

|- |- |- WidthDimension (DIM)

|- |- |- Rotation (ANGLE)

MemberMaterial.Bolt.TertiaryHeadWasher.

|- |- |- TypeDescription (STRING)

|- |- |- Quantity (USHORT)

|- |- |- ThicknessDimension (DIM)

|- |- |- WidthDimension (DIM)

|- |- |- Rotation (ANGLE)

MemberMaterial.Bolt.

|- |- HillsideWasherAngle

MemberMaterial.Bolt.CustomProperties.

|- |- |- Log (STRING)

|- |- |- Notes (STRING)

MemberMaterial.Nut.

MemberMaterial.Nut.PrimaryNutWasher.

|- |- |- TypeDescription (STRING)

|- |- |- Quantity (USHORT)

|- |- |- ThicknessDimension (DIM)

|- |- |- WidthDimension (DIM)

|- |- |- Rotation (ANGLE)

MemberMaterial.Nut.SecondaryNutWasher.

|- |- |- TypeDescription (STRING)

|- |- |- Quantity (USHORT)

|- |- |- ThicknessDimension (DIM)

|- |- |- WidthDimension (DIM)

|- |- |- Rotation (ANGLE)

MemberMaterial.Nut.TertiaryNutWasher.

|- |- |- TypeDescription (STRING)

|- |- |- Quantity (USHORT)

|- |- |- ThicknessDimension (DIM)

|- |- |- WidthDimension (DIM)

|- |- |- Rotation (ANGLE)

MemberMaterial.Nut.

|- |- PrimaryNutTypeDescription (STRING)

|- |- SecondaryNutTypeDescription (STRING)

|- |- IsFieldBolt (BOOL)

|- |- IsTensionControl (BOOL)

MemberMaterial.Weld.

|- |- SizeDimension (DIM)

|- |- LengthDimension (DIM)

|- |- LeftSetback (DIM_NUM)

|- |- LeftSetbackDimension (DIM)

|- |- WeldTypeDescription (STRING)

|- |- FieldWeld (BOOL)

MemberMaterial.Weld.CustomProperties.

|- |- |- Log (STRING)

|- |- |- Notes (STRING)

Tip : You need to Detail Submaterial to allow the Report Writer to get information from data source fields in the MaterialDrawing. folder.

MaterialDrawing.

|- MinorMark (STRING)

|- DetailTypeDescription (STRING)

|- Quantity (NUMBER)

Tip : For materials in the model to contain up-to-date information that the Report Writer can read, you may need to create a " New " ABM or " Update ABM ."

ABM.

|- Page (NUMBER)

|- Line (NUMBER)

|- LengthDimension (DIM)

|- WidthDimension (DIM)

|- ThickDimension (DIM)

|- CamberDimension (DIM)

|- SurfaceAreaDimension (DIM)

|- PlateAreaDimension (DIM)

|- UnitWeight (WEIGHT)

|- MemberTypeDescription (STRING)

|- MaterialType (STRING)

|- MainMaterial (BOOL)

|- ConnectionMaterial (BOOL)

|- MiscellaneousMaterial (BOOL)

|- StandardPart (BOOL)

|- Count (NUMBER)

|- RevisionDate (DATE)

|- RevisionLevel (NUMBER)

|- Paint (NUMBER)

|- MemberCategoryDescription (STRING)

|- Piecemark (STRING)

|- Description (STRING)

|- ABMString (STRING)

|- MemberNumber (NUMBER)

|- Remarks (STRING)

|- Sequence (STRING)

|- Grade (STRING)

DetailSheet.

|- DetailSheetName (STRING)

|- DetailTypeDescription (STRING)

|- Quantity (NUMBER)

GatherSheet.

|- GatherSheetName (STRING)

|- DetailTypeDescription (STRING)

|- Quantity (NUMBER)

ErectionView.

|- ErectionViewName (STRING)

|- DetailTypeDescription (STRING)

|- Quantity (USHORT)

ErectionSheet.

|- ErectionSheetName (STRING)

|- DetailTypeDescription (STRING)

|- Quantity (USHORT)

CurrentLocation.

|- Job (STRING)

CurrentLocation.JobCustomProperties.

|- |- Log (STRING)

|- |- Notes (STRING)

CurrentLocation.

|- Fabricator (STRING)

|- FabricatorIsMetric (BOOL)