The purpose of the STRATUS. Parameters and Properties page is to provide definitions of all available STRATUS.* parameters and properties.
STRATUS.Package.*
STRATUS.Package.BIMAbbreviation
Where Available: In Fields, Filters, Reports where Type is Package, and Templates Report Field where Template Type is Package Details.
Property Purpose: Enables Admins to use the Package BIM Abbreviation set under Projects > Areas > Abbreviation.
Note: The BIM Area value that populates the STRATUS.Package.BIMAbbreviation property is set in the following locations:
In the create New Package dialog
- Under the Package’s > Properties tab
STRATUS.Package.BOMIsLocked
Where Available: In reports where Type is Package.
Property Purpose: When checked, indicates that the Package BOM has been Locked. As a result, this BOM will be available in the Purchasing module to send requests to suppliers. Set Format = Boolean.
STRATUS.Package.BOMGeneratedDT
Where Available: In reports where Type is Package.
Property Purpose: Displays the date the BOM was generated. When setting the Report Field Format:
String - Use String to display the date and time. Packages, where a BOM has not been generated, will display a blank cell.
Date - Use Date to display the date only. Packages, where a BOM has not been generated, will display the word Empty.
STRATUS.Package.BOMDivision
Where Available: In reports where Type is Package.
Property Purpose: Displays the current Division for the BOM.
STRATUS.Package.BOMRequiredDT
Where Available: In reports where Type is Package.
Property Purpose: Displays the BOM Required Date. When setting the Report Field Format:
String - Use String to display the date only. Packages, where a BOM has not been generated, will display a blank cell.
Date - Use Date to display the date only. Packages, where a BOM has not been generated, will display the word Empty.
STRATUS.Package.CanBOM
Where Available: In reports where Type is Package.
Property Purpose: When checked, indicates that the Package is in a Can BOM Tracking Status. Set Format = Boolean.
STRATUS.Package.CategoryAbbreviation
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Package Category Abbreviation.
STRATUS.Package.CategoryDescription
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Package Category Abbreviation.
STRATUS.Package.CategoryID
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Package Category ID.
STRATUS.Package.CategoryName
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Package Category Name.
STRATUS.Package.CompanyName
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the part's Company Name.
STRATUS.Package.Container
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the package's Container Name if the package has been added to a container. When used on a Packages Dashboard report or on a Packages Items report, relevant information will display including the Division (if any), a link to the container, the Container Status, and the Container comments (if any).
STRATUS.Package.CreatedBy
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the first and last name of the person who created the package.
STRATUS.Package.CreatedDT
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the date and time the package was created.
STRATUS.Package.Description
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the package description, if any.
STRATUS.Package.HasBOM
Where Available: In reports where Type is Package.
Property Purpose: When checked, indicates that a BOM has been generated for the Package.
STRATUS.Package.HoursActual
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the calculated number of hours to complete the package.
STRATUS.Package.HoursEstimatedOffice
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the calculated estimated number of hours to complete the package.
STRATUS.Package.HoursEstimatedPurchasing
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the calculated estimated number of hours to complete the package.
STRATUS.Package.HoursEstimatedShop
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the calculated estimated number of hours to complete the package.
Note: The STRATUS release v5.4.3 converted STRATUS.Package.HoursEstimated field data to STRATUS.Package.HoursEstimatedShop. The STRATUS.Package.HoursEstimated field is no longer available.
STRATUS.Package.HoursEstimatedField
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the calculated estimated number of hours to complete the package.
STRATUS.Package.HoursEstimatedTotal
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the calculated estimated number of hours adding up STRATUS.Package.HoursEstimatedOffice, STRATUS.Package.HoursEstimatedPurchasing, STRATUS.Package.HoursEstimatedShop, and STRATUS.Package.HoursEstimatedField into a total..
STRATUS.Package.ID
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the unique ID of the package.
STRATUS.Package.InstalledDT
Where Available: In reports where Type is Package,
Property Purpose: Includes the package's editable Install Date.
STRATUS.Package.ModelId
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the unique Model ID from which the model containing the package was created.
STRATUS.Package.ModelName
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Model Name from which the model containing the package was created.
STRATUS.Package.ModifiedBy
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the first and last name of the person who last modified the package.
STRATUS.Package.ModifiedDT
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the date and time the package was modified.
STRATUS.Package.Name
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Package Name.
STRATUS.Package.Notes
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes any notes that have been added to the part. See the Notes (Admin) article for more information.
STRATUS.Package.NumAssemblies
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Number of Assemblies in the Package.
STRATUS.Package.Number
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Package Number.
STRATUS.Package.NumParts
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes a count of all parts that are in a package but are not assembled.
STRATUS.Package.NumTasks
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Number of Tasks for the Package.
STRATUS.Package.OfficeLeadDays
Where Available: In reports where Type is Package.
Property Purpose: Includes the Office Phase Lead Days for the Package. The Lead Day Report Field property is directly linked to the Package > Properties > Planning section for each package. See the Lead Days Package Level Configuration article for more information.
STRATUS.Package.OfficeStartDT
Where Available: In reports where Type is Package.
Property Purpose: Includes the Office Phase Start Date for the Package. The Start Date Field property is directly linked to the Package > Properties > Planning section for each package. See the Lead Days Package Level Configuration article for more information.
STRATUS.Package.PercentComplete
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Package's Percent Complete calculation.
Package Completeness is calculated based on one of two methods:
Method #1 is used when Tasks are enabled, where a task can have one of four states: Pending, To Do, In Progress, Done. The percent complete will be based on those tasks in the "Done" status.
Method #2 is from the Tracking Statuses table in Admin -> Company, where there are percentages assigned to each status. Those are aggregated for parts.
STRATUS.Package.Division
Where Available: In reports where Type is Package and Package Details.
Property Purpose: Includes the Division assigned to the Package.
STRATUS.Package.ProjectID
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Project ID.
STRATUS.Package.ProjectName
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Project Name.
STRATUS.Package.ProjectNumber
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Project Number.
STRATUS.Package.PurchaseStatusList
Where Available: In reports where Type is Package.
Property Purpose: When used the column will report the number of parts in each Purchasing tracking status greater than 0. In the package below, there are 0 parts in None, 16 parts in Purchase Order Processed, and 2 parts in Shipped.
STRATUS.Package.PurchaseStatusLowest
Where Available: In reports where Type is Package.
Property Purpose: When used the column will report the lowest tracking status for a package based on the statuses of its individual parts. For example:
- if any part in a package has the status of None, then the lowest tracking status will be None.
- If all parts in the package have a status other than None, then the lowest tracking status will be the lowest (Ex. Purchase Order Processed).
STRATUS.Package.PurchasingLeadDays
Where Available: In reports where Type is Package.
Property Purpose: Includes the Purchasing Phase Lead Days for the Package. The Lead Day Report Field property is directly linked to the Package > Properties > Planning section for each package. See the Lead Days Package Level Configuration article for more information.
STRATUS.Package.PurchasingStartDT
Where Available: In reports where Type is Package.
Property Purpose: Includes the Purchasing Phase Start Date for the Package. The Start Date Field property is directly linked to the Package > Properties > Planning section for each package. See the Lead Days Package Level Configuration article for more information.
STRATUS.Package.QRCode
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Displays the package's QR Code.
STRATUS.Package.ShopLeadDays
Where Available: In reports where Type is Package.
Property Purpose: Includes the Shop Phase Lead Days for the Package. The Lead Day Report Field property is directly linked to the Package > Properties > Planning section for each package. See the Lead Days Package Level Configuration article for more information.
STRATUS.Package.StartDT
Where Available: In reports where Type is Package.
Property Purpose: Includes the Shop Phase Start Date for the Package. The Start Date Field property is directly linked to the Package > Properties > Planning section for each package. See the Lead Days Package Level Configuration article for more information.
STRATUS.Package.Station
Where Available: In reports where Type is Package or Package Details.
Property Purpose: Includes the current Station of the Package.
STRATUS.Package.RequiredDT
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the Field Phase Start Date for the Package and indicates that the package materials are required to be on-site and ready for fieldwork to begin. The Start Date Field property is directly linked to the Package > Properties > Planning section for each package. See the Lead Days Package Level Configuration article for more information.
STRATUS.Package.TotalNumParts
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes a count of every part in that package assembled or not.
STRATUS.Package.TrackingComments
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: The Tracking Comments displays a semi-colon (Ex. ; ) separated list of all tracking log comments in the order that matches tracking log entries.
STRATUS.Package.TrackingHours
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: The Tracking Hours returns the combined total hours from the Package and its child Assemblies and Parts, along with its child Assembly’s child Parts tracking log entries.
STRATUS.Package.TrackingStatus
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the current Tracking Status of the package.
STRATUS.Package.TrackingStatusLogComments
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes a semi-colon delimited list of comments made during tracking status changes.
STRATUS.Package.TrackingStatusLogDT
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the date-time when a package tracking status became active.
STRATUS.Package.TrackingStatusColor
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the current Hex Color Code of the package.
STRATUS.Package.TrackingStatusStatusId
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the current Tracking Status ID of the package.
STRATUS.Package.TrackingStatusIndex
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: Includes the current Tracking Status Index number of the package. The index number matches the sequence number of the Tracking Status on the Admin > Company > Tracking Statuses page. This property can be used in filters more easily than the STRATUS.Package.TrackingStatus property.
STRATUS.Package.TrackingStatusLog
Where Available: In reports where Type is Package, Package Details, or Part.
Property Purpose: The Tracking Status Log displays a semi-colon (Ex. ; ) separated list of all tracking status changes in the order that matches tracking status entries. For example, the Tracking Status of a package might initially be Packaged, then changes to Shipped. This would result in the Tracking Status Log "Packaged;Shipped".
STRATUS.Package.TrackingStatusLogDivision
Where Available: In reports where Type is Package or Package Details.
Property Purpose: Includes the current Tracking Status Log Division of the Package.
STRATUS.Assembly.*
The STRATUS.Assembly.* properties are available in reports where Type is Assembly or Package Details.
STRATUS.Assembly.AssemblyType
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the assembly type as Assembly, Family, Spool, or Hanger.
STRATUS.Assembly.BIMArea
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the assembly's BIM Area.
STRATUS.Assembly.CadId
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the assembly's CadId.
STRATUS.Assembly.CompanyName
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the assembly's Company Name.
STRATUS.Assembly.ConnectedAssembly.Single
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: This property will print only one label per connected assembly, which may be a better option for a rack.
STRATUS.Assembly.ConnectedAssembly.Multiple
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: This property will print a label for each connection.
STRATUS.Assembly.Container
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the assembly's Container Name if the assembly has been added to a container. When used on a Packages Dashboard report or on a Packages Items report, relevant information will display including the Division (if any), a link to the container, the Container Status, and the Container comments (if any).
STRATUS.Assembly.CreatedBy
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the first and last name of the person who created the assembly.
STRATUS.Assembly.CreatedDT
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the date and time the assembly was created.
STRATUS.Assembly.Id
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the unique ID of the assembly.
STRATUS.Assembly.ModelId
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the unique Model ID from which the model containing the assembly was created.
STRATUS.Assembly.ModelName
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the Model Name from which the model containing the assembly was created.
STRATUS.Assembly.ModifiedBy
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the first and last name of the person who last modified the assembly.
STRATUS.Assembly.ModifiedDT
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the date and time the assembly was modified.
STRATUS.Assembly.Name
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the assembly name.
STRATUS.Assembly.Notes
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes any notes that have been added to the assembly. See the the Notes (Admin) article or the Tags of Parameter, Note, or Field Data section of the Assemblies Viewer article for more information.
STRATUS.Assembly.NumParts
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the number of parts in the assembly.
STRATUS.Assembly.PackageId
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the unique Package ID if the assembly is included in a package.
STRATUS.Assembly.PackageName
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the Package Name if the assembly is included in a package.
STRATUS.Assembly.PackageNumber
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the Package Number if the assembly is included in a package.
STRATUS.Assembly.Division
Where Available: In reports where Type is Assembly.
Property Purpose: Includes the Division assigned to the Assembly.
STRATUS.Assembly.ProjectName
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the Project Name.
STRATUS.Assembly.ProjectNumber
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the Project Number.
STRATUS.Assembly.QRCode
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Displays the assembly's QR Code.
STRATUS.Assembly.Station
Where Available: In reports where Type is Assembly.
Property Purpose: Includes the current Station of the Assembly.
STRATUS.Assembly.TrackingComments
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: The Tracking Comments displays a semi-colon (Ex. ; ) separated list of all tracking log comments in the order that matches tracking log entries. For example, when an assembly is added to a package, the automatic Tracking Comment is "STRATUS Added to Package".
STRATUS.Assembly.TrackingStatusLogComments
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes a semi-colon delimited list of comments made during tracking status changes.
STRATUS.Assembly.TrackingHours
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Returns the combined total hours from the Assembly and its child Parts tracking log entries.
STRATUS.Assembly.TrackingStatus
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the current Tracking Status of the assembly.
STRATUS.Assembly.TrackingStatusLogDT
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the date-time when an assembly tracking status became active.
STRATUS.Assembly.TrackingStatusLogDivision
Where Available: In reports where Type is Assembly.
Property Purpose: Includes the current Tracking Status Log Division of the Assembly.
STRATUS.Assembly.TrackingStatusColor
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the current Hex Color Code of the assembly.
STRATUS.Assembly.TrackingStatusId
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the current Tracking Status ID of the assembly.
STRATUS.Assembly.TrackingStatusIndex
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: Includes the current Tracking Status Index number of the assembly. The index number matches the sequence number of the Tracking Status on the Admin > Company > Tracking Statuses page. This property can be used in filters more easily than the STRATUS.Assembly.TrackingStatus property.
STRATUS.Assembly.TrackingStatusLog
Where Available: In reports where Type is Assembly or Package Details.
Property Purpose: The Tracking Status Log displays a semi-colon (Ex. ; ) separated list of all tracking status changes in the order that matches tracking status entries. For example, the Tracking Status of an assembly might initially be Issued, then changes to Packages. This would result in the Tracking Status Log "Issued;Packaged".
STRATUS.Part.*
The STRATUS.Part.* properties are available in reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
STRATUS.Part.AssemblyCadId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Assembly CadID if the part is included in an assembly.
STRATUS.Part.AssemblyId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Assembly ID if the part is included in an assembly.
STRATUS.Part.AssemblyName
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Assembly Name if the part is included in an assembly.
STRATUS.Part.AssemblyQRCode
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: The STRATUS.Part.AssemblyQRCode will add the QR code for the parts in an assembly to the report.
STRATUS.Part.BIMAbbreviation
Where Available: In reports where Type is Part and Assembly Viewer is checked.
Property Purpose: Displays the BIM Abbreviation defined under Admin > Project > Template > Areas > Abbreviation. See the Areas (Admin) article for more information. Displays in the Properties panel and in the Assemblies > Viewer > Parts tab with the report selected.
STRATUS.Part.BIMArea
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's BIM Area.
STRATUS.Part.BOMAdditionalInfo
Where Available: In reports where Type is BOM.
Property Purpose: Displays the Additional Info data entered for a BOM.
STRATUS.Part.BOMDescription
Where Available: In reports where Type is BOM.
Property Purpose: Includes the Description override configured under Admin > Company > Part Templates > BOM Mappings. The Description property in the Company BOM Line Item Mappings section can be overridden and will display in the STRATUS.Part.BOMDescription property. For example:
Below is the BOM Mappings tab for a Butterfly Valve. The Description can be overridden with a manual or a property value.
- As a result, in the part’s properties, the overridden Description will display in the STRATUS.Part.BOMDescription property.
- After adding the STRATUS.Part.BOMDescription property and/or the STRATUS.Part.ProjectId to a report where Item Type = BOM, the BOM report will display the property.
STRATUS.Part.BOMDiameter
Where Available: In reports where Type is BOM.
Property Purpose: Displays the part diameter.
STRATUS.Part.BOMLength
Where Available: In reports where Type is BOM.
Property Purpose: Displays the part length.
STRATUS.Part.BOMManufacturer
Where Available: In reports where Type is BOM.
Property Purpose: Displays the part manufacturer.
STRATUS.Part.BOMMaterial
Where Available: In reports where Type is BOM.
Property Purpose: Displays the part material.
STRATUS.Part.BOMProductCode
Where Available: In reports where Type is BOM.
Property Purpose: Displays the part product code.
STRATUS.Part.BOMSize
Where Available: In reports where Type is BOM.
Property Purpose: Displays the part size.
STRATUS.Part.BOMWidth
Where Available: In reports where Type is BOM.
Property Purpose: Displays the part width.
STRATUS.Part.C1
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: For Fabrication Parts C1 and C2; otherwise, return values from part template 'Consider for Multi-Axis Cutting' End 1 and End 2; or else the field will be empty.
STRATUS.Part.C1AssembledTo
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Properties for each connector will return the part description of the connected part or be empty based on whether the part is connected to another part within the same assembly. By default, this property displays the connected part's Description and can be changed to use the connect part's Company BOM Line Item Mapping Description. See the BOM Line Item Mappings article for more information.
Example - To distinguish between Shop welds from Field welds, the Filter below looks at parts adjacent to weld parts (C1 and C2). While STRATUS understands connected parts, these Properties inform STRATUS about the parts on each side of the weld and whether or not the parts are included in the same assembly as the weld. If they are, it means the weld is a shop weld. The filter below says, if STRATUS.Part.C2AssembledTo and STRATUS.Part.C2AssembledTo have a connected part (DoesNotEqual Empty) then it is a shop weld. Contrarily, if either property is empty, then it is a field weld.
STRATUS.Part.C1ConnectedTo
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Properties for each connector will return the part description of the connected part or be empty based on whether the part is connected to. For Revit Systems Ductwork the property displays the Type and Size properties. By default, this property displays the connected part's Description and can be changed to use the connect part's Company BOM Line Item Mapping Description. See the BOM Line Item Mappings article for more information.
STRATUS.Part.C2
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: For Fabrication Parts C1 and C2; otherwise, return values from part template 'Consider for Multi-Axis Cutting' End 1 and End 2; or else the field will be empty.
STRATUS.Part.C2AssembledTo
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Properties for each connector will return the part description of the connected part or be empty based on whether the part is connected to another part within the same assembly. By default, this property displays the connected part's Description and can be changed to use the connect part's Company BOM Line Item Mapping Description. See the BOM Line Item Mappings article for more information.
Example - To distinguish between Shop welds from Field welds, the Filter below looks at parts adjacent to weld parts (C1 and C2). While STRATUS understands connected parts, these Properties inform STRATUS about the parts on each side of the weld and whether or not the parts are included in the same assembly as the weld. If they are, it means the weld is a shop weld. The filter below says if STRATUS.Part.C2AssembledTo and STRATUS.Part.C2AssembledTo have a connected part (DoesNotEqual Empty) then it is a shop weld. Contrarily, if either property is empty, then it is a field weld.
STRATUS.Part.C2ConnectedTo
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Properties for each connector will return the part description of the connected part or be empty based on whether the part is connected to. For Revit Systems Ductwork the property displays the Type and Size properties. By default, this property displays the connected part's Description and can be changed to use the connect part's Company BOM Line Item Mapping Description. See the BOM Line Item Mappings article for more information.
STRATUS.Part.CadId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's CadId.
STRATUS.Part.CadType
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Cad Type (Ex. Autodesk.Fabrication.Item, Autodesk.Revit.DB.FabricationPart, etc.).
STRATUS.Part.CompanyName
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Company Name.
STRATUS.Part.Container
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Container Name if the part has been added to a container. When used on a Packages Dashboard report or on a Packages Items report, relevant information will display including the Division (if any), a link to the container, the Container Status, and the Container comments (if any).
STRATUS.Part.ContainerType
Where Available: In reports where Type is BOM, Package Details, or Part and in the Part's Properties.
Property Purpose: Includes a list of containers that part has been assigned to.
STRATUS.Part.CostCategory
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's cost category if one was part of the database when the model was published, or added to the part in STRATUS after the model was published.
STRATUS.Part.CreatedBy
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the first and last name of the person who created the part.
STRATUS.Part.CreatedDT
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the date and time the part was first published to STRATUS.
STRATUS.Part.CutDT
Where Available: In reports where Type is Part.
Property Purpose: (DateTime) - The part’s most recent cut date time.
STRATUS.Part.CutDTHistory
Where Available: In reports where Type is Part.
Property Purpose: (String) - Semi-colon delimited list of cut dates times.
STRATUS.Part.CutLengthAdjustment
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Cut Length Adjustment value made using the STRATUS Spool Checker tool in the Assemblies > Viewer. See the Spool Checker section of the Assemblies Viewer article for more information.
STRATUS.Part.CutLengthDecimal
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's cut length value in decimal units.
STRATUS.Part.CutLengthFeetAndInches
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's cut length value in feet-inch-fraction units.
STRATUS.Part.CutLengthHistory
Where Available: In reports where Type is Part.
Property Purpose: (String) - Semi-colon delimited list of actual cut lengths in decimal, using model units (Ex. Revit = feet; AutoCAD = inches).
Note: If a cut list is deleted, it will not appear in the Cut Length History. Therefore, the only way to see items having multiple cut date times is if the part is in two different packages (of different categories) and a cut in each one.
STRATUS.Part.Description
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Description value from the model.
STRATUS.Part.GridOffsetA.X
Where Available: In reports where Type is BOM, Package Details, or Part and in the Part's Properties.
Property Purpose: Includes the part's Grid Offset value.
STRATUS.Part.GridOffsetA.Y
Where Available: In reports where Type is BOM, Package Details, or Part and in the Part's Properties.
Property Purpose: Includes the part's Grid Offset value.
STRATUS.Part.GridOffsetB.X
Where Available: In reports where Type is BOM, Package Details, or Part and in the Part's Properties.
Property Purpose: Includes the part's Grid Offset value.
STRATUS.Part.GridOffsetB.Y
Where Available: In reports where Type is BOM, Package Details, or Part and in the Part's Properties.
Property Purpose: Includes the part's Grid Offset value.
STRATUS.Part.GridOffsetC.X
Where Available: In reports where Type is BOM, Package Details, or Part and in the Part's Properties.
Property Purpose: Includes the part's Grid Offset value.
STRATUS.Part.GridOffsetC.Y
Where Available: In reports where Type is BOM, Package Details, or Part and in the Part's Properties.
Property Purpose: Includes the part's Grid Offset value.
STRATUS.Part.HoleInfo
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: The STRATUS.Part.HoleInfo Report Field will display holes in pipe. When added to a STRATUS Sheet report, the report column will include a list of all holes separated by semi-colons in the following format per hole:
<hole size> <clocking angle from start>d <distance from start> E-C <mating angle from start>d out
Note: Clockwise is a positive angle looking downpipe from start to end.
When used for Olets or Tap parts, the format is “Tap <size> <radialAngle>d” (below).
STRATUS.Part.Id
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the unique ID of the part.
STRATUS.Part.IsCut
Where Available: In reports where Type is Part.
Property Purpose: (Integer) - 0 indicates the part has not been cut; 1 indicates the part has been cut.
STRATUS.Part.ModelId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the unique Model ID from which the model containing the part was created.
STRATUS.Part.ModelName
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Model Name from which the model containing the part was created.
STRATUS.Part.ModifiedBy
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the first and last name of the person who last modified the part.
STRATUS.Part.ModifiedDT
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the date and time the part was modified.
STRATUS.Part.Notes
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes any notes that have been added to the part. See the Notes (Admin) article for more information.
STRATUS.Part.PackageId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Package ID if the part is included in a package. If the part is assigned to multiple packages, the PackageID's will be separated by a semi-colon.
STRATUS.Part.PackageName
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Package Name if the part is included in a package. If the part is assigned to multiple packages, the Package Name's will be separated by a semi-colon.
STRATUS.Part.PackageNumber
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Package Number if the part is included in a package. If the part is assigned to multiple packages, the Package Number's will be separated by a semi-colon.
STRATUS.Part.PackageQRCode
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Package QR Code if the part is included in a package. If the part is assigned to multiple packages, the Package QR Code's will be separated by a semi-colon.
STRATUS.Part.Point
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's space-separated X Y Z centroid coordinates. Alternatively, see the individual STRATUS.Part.PointX, STRATUS.Part.PointY, and STRATUS.Part.PointZ properties. Calculations are made from the hanger’s insertion point node.
STRATUS.Part.Point.AFF
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: The parameter STRATUS.Part.Point.AFF is reportable and displays in the part’s Properties. To use this field in an expression, you must wrap the stratus part property value with AsNumber( ) in the field expression. An example of this syntax would be:
AsNumber({STRATUS.Part.Point.AFF})-{Hanger Diameter}*0.5
In this example, the STRATUS.Part.Point.AFF value displays in the part’s properties. Here on the 4th Level (Floor), the STRATUS.Part.Point.Z = 1,358.88 while the STRATUS.Part.Point.AFF = 0.63. If there are no levels in the model, STRATUS.Part.Point.Z will equal STRATUS.Part.Point.AFF. The measurement is taken from the part’s centroid.
STRATUS.Part.Point.X; STRATUS.Part.Point.Y; STRATUS.Part.Point.Z - The X, Y, and Z coordinates of a part’s bounding box center can now be extracted. This means that you can use something like a nested rod family in conjunction with control points, a filter, and a report to generate your own point files in whatever configuration you need.
STRATUS.Part.Point.X
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's X centroid coordinate. Alternatively, see the STRATUS.Part.Point property.
STRATUS.Part.Point.Y
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Y centroid coordinate. Alternatively, see the STRATUS.Part.Point property.
STRATUS.Part.Point.Z
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Y centroid coordinate. Alternatively, see the STRATUS.Part.Point property. Calculations are made from the hanger’s insertion point node.
STRATUS.Part.Division
Where Available: In reports where Type is Part.
Property Purpose: Includes the Division assigned to the Part.
STRATUS.Part.ProjectId
Where Available: In reports where Type is BOM.
Property Purpose: The STRATUS.Part.ProjectId also displays in the:
- Part’s Properties.
- After adding the STRATUS.Part.BOMDescription property and/or the STRATUS.Part.ProjectId to a report where Item Type = BOM, the BOM report will display the property.
STRATUS.Part.ProjectName
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Project Name.
STRATUS.Part.ProjectNumber
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the Project Number.
STRATUS.Part.PropertyTemplateId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Cad Type followed by the Part Template Number. Ex. Autodesk.Fabrication.Item.2041 or Autodesk.Revit.DB.FabricationPart.2523.
STRATUS.Part.PurchaseStatus
Where Available: In reports where Type is Part.
Property Purpose: When used the column will report the Purchasing status of its individual parts.
STRATUS.Part.QRCode
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Displays the part's unique QR Code hyperlink.
STRATUS.Part.Station
Where Available: In reports where Type is Part.
Property Purpose: Includes the current Station of the part.
STRATUS.Part.TrackingHours
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Returns total hours for Part tracking log entries.
STRATUS.Part.TrackingStatus
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the current Tracking Status of the part.
STRATUS.Part.TrackingStatusColor
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the current Hex Color Code of the part.
STRATUS.Part.TrackingStatusId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the current Tracking Status ID of the part.
STRATUS.Part.TrackingStatusIndex
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the current Tracking Status Index number of the part. The index number matches the sequence number of the Tracking Status on the Admin > Company > Tracking Statuses page. This property can be used in filters more easily than the STRATUS.Part.TrackingStatus property.
STRATUS.Part.TrackingStatusLog
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: When used in a report, the history of part’s tracking statuses will be separated by a semi-colon. One use case for including this field in a report is to check if the material was ordered for a part, knowing that “Ordered” tracking status may not be the current status. You could either:
1. Search a report for the tracking status, or,
2. Configure a Filter that “Contains” the value “Ordered” and assign the filter to a report. Then when the report is run on parts in the model only those that match the filter will be included.
STRATUS.Part.TrackingStatusLogComments
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes a semi-colon delimited list of comments made during tracking status changes.
STRATUS.Part.TrackingStatusLogDT
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes a date-time when a part tracking status became active.
STRATUS.Part.TrackingStatusLogDivision
Where Available: In reports where Type is Part.
Property Purpose: Includes the current Tracking Status Log Division of the Part.
STRATUS.Part.WebId
Where Available: In reports where Type is BOM, Package Details, Part, or Purchasing and in the Part's Properties.
Property Purpose: Includes the part's Web ID.
STRATUS.Ancillary.*
The STRATUS.Assembly.* properties are available in reports where Type is BOM or Part and in the Part's Properties.
STRATUS.Ancillary.Length
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the ancillary part's Length. If multiple components makeup the Ancillary Part, then each Length will be semi-colon separated and will align with the other STRATUS.Ancillary properties.
STRATUS.Ancillary.Name
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the ancillary part's Name. If multiple components makeup the Ancillary Part, then each Name will be semi-colon separated and will align with the other STRATUS.Ancillary properties.
STRATUS.Ancillary.Quantity
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the ancillary part's Quantity. If multiple components makeup the Ancillary Part, then each Quantity will be semi-colon separated and will align with the other STRATUS.Ancillary properties.
STRATUS.Ancillary.ProductCode
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the ancillary part's Product Code. A Product Code is a code used by a Supplier to identify products in the Supplier Portal.
STRATUS.Ancillary.ProductDescription
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the product Description used for BOM's and the Supplier Portal.
STRATUS.Ancillary.ProductManufacturer
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: The Manufacturer of the product used for BOM's and the Supplier Portal.
STRATUS.Ancillary.ProductMaterial
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: The Product Material used for BOM's and the Supplier Portal.
STRATUS.Ancillary.Size
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the ancillary part's Size. If multiple components makeup the Ancillary Part, then each Size will be semi-colon separated and will align with the other STRATUS.Ancillary properties.
STRATUS.Ancillary.Type
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the ancillary part's Type. If multiple components makeup the Ancillary Part, then each Type will be semi-colon separated and will align with the other STRATUS.Ancillary properties. Type values can include the following: (AirturnTrack, AirturnVane, AncillaryMaterial, Clip, Corner, Fixing, Gasket, Isolator, Sealant, SeamMaterial, SupportRod, TieRod, SupportSeismic, Unknown).
STRATUS.Ancillary.Usage
Where Available: In reports where Type is BOM or Part and in the Part's Properties.
Property Purpose: Includes the ancillary part's Usage. If multiple components makeup the Ancillary Part, then each Usage will be semi-colon separated and will align with the other STRATUS.Ancillary properties. Usage can include the following: (Airturn, Connector, Hanger, Loose, Seam, Splitter, or Stiffener).
STRATUS.Container
STRATUS.Container.CompanyName
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the Company name.
STRATUS.Container.Description
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the Description of the Container defined under Admin > Company > Containers.
STRATUS.Container.Division
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the Division of the Container defined under Admin > Company > Containers.
STRATUS.Container.Id
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the container's unique Container ID.
STRATUS.Container.Location
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the Location of the Container defined under Admin > Company > Containers.
STRATUS.Container.Name
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the Name of the Container defined under Admin > Company > Containers.
STRATUS.Container.QRCode
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the container's QR Code. When scanned, a Container QR Code Scanned landing page will display where the Contents of the Container can be expanded, emptied, and the status of the container can be updated which changes the status of the packages, assemblies, and parts within the container. 
STRATUS.Container.Type
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the Container Type of the Container defined under Admin > Company > Containers.
STRATUS.Container.TrackingStatus
Where Available: In reports where Type is Container.
Property Purpose: When used in the report's Label Template, displays the Tracking Status of the Container.
STRATUS.Report
STRATUS.Report.CurrentDate
Where Available: In Templates under under Admin > Company > Templates.
Property Purpose: Add Current Date onto reports that reference the template. The date format will be 3/10/2021.
STRATUS.Report.CurrentDateLong
Where Available: In Templates under under Admin > Company > Templates.
Property Purpose: Add Current Date onto reports that reference the template. The date format will be Wednesday, March 10, 2021.
STRATUS.Report.CurrentDateTime
Where Available: In Templates under under Admin > Company > Templates.
Property Purpose: Add Current Date onto reports that reference the template. The date-time format will be 3/10/2021 9:22 AM.
STRATUS.Report.CurrentTime
Where Available: In Templates under under Admin > Company > Templates.
Property Purpose: Add Current Date onto reports that reference the template. The time format will be 9:22 AM.
STRATUS.Project
STRATUS.Project.A360BusinessUnit
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value under Admin > Company > Projects > A360 Business Unit.
STRATUS.Project.A360ConstructionType
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > A360 Construction Type.
STRATUS.Project.A360ProjectType
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > A360 Project Type.
STRATUS.Project.Address1
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Address (line1).
STRATUS.Project.Address2
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Address (line 2).
STRATUS.Project.City
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > City.
STRATUS.Project.Color
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Color.
STRATUS.Project.Description
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Description.
STRATUS.Project.IsTaxExempt
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Tax Exempt?.
STRATUS.Project.ManufactureSourceType
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Manufacturer Source Type.
STRATUS.Project.Name
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Name.
STRATUS.Project.Number
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Number.
STRATUS.Project.ShippingAddress
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses.
STRATUS.Project.ShippingAddress.Address1
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > Address 1.
STRATUS.Project.ShippingAddress.Address2
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > Address 1.
STRATUS.Project.ShippingAddress.Attention
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > Attention.
STRATUS.Project.ShippingAddress.City
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > City.
STRATUS.Project.ShippingAddress.Instructions
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses >Instructions.
STRATUS.Project.ShippingAddress.Name
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > Address Name.
STRATUS.Project.ShippingAddress.Phone
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > Phone.
STRATUS.Project.ShippingAddress.State
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > State.
STRATUS.Project.ShippingAddress.Zip
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Projects > Shipping Addresses > Zip.
STRATUS.Project.State
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > State.
STRATUS.Project.TargetStartDate
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > TargetStartDate.
STRATUS.Project.Zip
Where Available: In reports where Type is Package.
Property Purpose: The field will match the value set under Admin > Company > Projects > Zip.