DESTINIData SQL Views and Descriptions

There are several views that can be used for data analytics. This article will list out those views, their intent, and the fields and descriptions contained within.

We highly recommend that you use these views and not the raw tables since these views will be maintained as the database structure changes.

EstimateSummaryDataDetails
Intent: High level summary of each estimate
Field Name	Description
EstimateKey	The unique identifier for the estimate
EstimateName	The name of the estimate.
VersionName	The name of the version
EstimateNumber	The job number for the estimate.
ProjectName	The name of the project.
ClientName	The client’s name.
ClientAddress	The client’s street address.
ClientCity	The client’s city location.
ClientState	The client’s state location.
ClientZipCode	The client’s postal code.
TotalCost	The total cost (direct + indirect) of the estimate.
TotalCostPerArea	The total cost (direct + indirect) per total building area of the estimate.
DirectCost	The direct cost of the estimate.
DirectCostPerArea	The direct cost per total building area of the estimate.
ProjectType	The type of the project.
EstimateStatus	The status of the estimate.
CreateYear	The year the estimate was created in DESTINI Estimator.

EstimatePropertyDataDetails
Intent: High level summary of each estimate and its properties.
Field Name	Description
EstimateName	The name of the estimate.
EstimateKey	The unique identifier for the estimate.
CreatedBy	The estimator that added the property to the estimate.
Property	The name of the property in the project tab.
Value	The value of the project property

EstimateWBSProperties
Intent: List of WBS Properties in all of the estimates.
Field Name	Description
WBSPropertyName	The name of the WBS property.

EstimateWBSPropertyValues
Intent: List of WBS Properties and their default values in the estimates.
Field Name	Description
EstimateKey	The unique identifier for the estimate.
WBSPropertyName	The name of the WBS property.
WBSPropertyType	The type of WBS property (i.e., Estimate specific- or database level).
WBSPropertyValue	The default value of the WBS property for that estimate.

HistoricalCostData
Intent: Detailed set of line items across an estimate.
Field Name	Description
EstimateKey	The uniqueidentifier for the estimate.
Key	The uniqueidentifier for the line item
Username	The name of the estimator that currently “owns” the record.
Name	The line item’s item number.
Description	The line item’s description.
Quantity	The line item’s total quantity.
Unit	The line item quantity’s unit of measure.
LaborPrice	The line item’s labor unit cost.
MaterialPrice	The line item’s material unit cost.
EquipmentPrice	The line item’s equipment unit cost.
SubPrice	The line item’s sub/install unit cost.
OtherPrice	The line item’s other/misc unit cost.
TotalUnitCost	The line item’s total unit cost.
TotalCost	The line item’s total cost.
TotalCostPerUnit	The line item’s total cost per unit.
CostPerUnitResource	The resource TotalCostPerUnit is based on.
DistributedFeeAmount	The line item’s distributed fee amount.
DistributedEquipmentFeeAmount	The line item’s distributed equipment fee amount.
DistributedLaborFeeAmount	The line item’s distributed labor fee amount.
DistributedMaterialFeeAmount	The line item’s distributed material fee amount.
DistributedOtherFeeAmount	The line item’s distributed fee amount.
DistributedSubFeeAmount	The line item’s distributed fee amount.
CreatedBy	The estimator that added the line item to the estimate.
LaborResourceGroupDuration	The line item’s labor duration.
LaborResourceGroupDurationUnit	The line item’s labor duration unit. (a number that represents hour, month, days, year, etc.)
LaborResourceDuration	The line item’s labor resource duration.
LaborResourceDurationUnit	The line item’s labor resource duration unit.
LaborResourceGroup	The line item’s labor resource group.
LaborUnitsPerManHour	The line item’s labor units per man hour
QuantityPerLaborResourceUnit	The line item’s quantity per labor resource unit.
MaterialResourceGroupDuration	The line item’s Material duration.
MaterialResourceGroupDurationUnit	The line item’s Material duration unit. (a number that represents hour, month, days, year, etc.)
MaterialResourceDuration	The line item’s Material resource duration.
MaterialResourceDurationUnit	The line item’s Material resource duration unit.
MaterialResourceGroup	The line item’s Material resource group.
MaterialUnitsPerManHour	The line item’s Material units per man hour
QuantityPerMaterialResourceUnit	The line item’s quantity per Material resource unit.
EquipmentResourceGroupDuration	The line item’s Equipment duration.
EquipmentResourceGroupDurationUnit	The line item’s Equipment duration unit. (a number that represents hour, month, days, year, etc.)
EquipmentResourceDuration	The line item’s Equipment resource duration.
EquipmentResourceDurationUnit	The line item’s Equipment resource duration unit.
EquipmentResourceGroup	The line item’s Equipment resource group.
EquipmentUnitsPerManHour	The line item’s Equipment units per man hour
QuantityPerEquipmentResourceUnit	The line item’s quantity per Equipment resource unit.
SubResourceGroupDuration	The line item’s Sub duration.
SubResourceGroupDurationUnit	The line item’s Sub duration unit. (a number that represents hour, month, days, year, etc.)
SubResourceDuration	The line item’s Sub resource duration.
SubResourceDurationUnit	The line item’s Sub resource duration unit.
SubResourceGroup	The line item’s Sub resource group.
SubUnitsPerManHour	The line item’s Sub units per man hour
QuantityPerSubResourceUnit	The line item’s quantity per Sub resource unit.
OtherResourceGroupDuration	The line item’s Other duration.
OtherResourceGroupDurationUnit	The line item’s Other duration unit. (a number that represents hour, month, days, year, etc.)
OtherResourceDuration	The line item’s Other resource duration.
OtherResourceDurationUnit	The line item’s Other resource duration unit.
OtherResourceGroup	The line item’s Other resource group.
OtherUnitsPerManHour	The line item’s Other units per man hour
QuantityPerOtherResourceUnit	The line item’s quantity per Other resource unit.
Uniformat 1	Uniformat Level 1 classification.
Uniformat 2	Uniformat Level 2 classification.
Uniformat 3	Uniformat Level 3 classification.
Uniformat 4	Uniformat Level 4 classification.
….	Any other user defined WBS_Property

In Power BI, this table is referred to as EstimateCostDataDetails

EstimateFeeDataDetails
Intent: High level summary of each estimate and its properties.
Field Name	Description
EstimateName	The name of the estimate.
EstimateKey	The unique identifier for the estimate.
Name	The name of the fee.
Type	The type of the fee (i.e., Lump Sum, Bond).
EvalOrder	The order of the fee in the fee table.
Amount	The amount of the fee.
Value	The value of the fee.
Distributed	A boolean of if the fee is distributed.
CreatedBy	The estimator that added the fee.
IsTurnedOn	A boolean of if the fee is turned on.
LastUpdatedBy	The estimator that last changed the fee.
IsDistributedtoEquipment	A boolean of if the fee is distributed to equipment.
IsDistributedToLabor	A boolean of if the fee is distributed to labor.
IsDistributedToMaterial	A boolean of if the fee is distributed to material.
IsDistributedToOther	A boolean of if the fee is distributed to other.
IsDistributedToSub	A boolean of if the fee is distributed to sub.