Data Warehouse Tables and Views

Tables

dbo.DM_Audit

dbo.DM_ProgramLog

dbo.DM_AuditDollarType

dbo.DM_Project

dbo.DM_AuditEstimateType

dbo.DM_ProjectHeader

dbo,DM_AuditOperationType

dbo.DM_Resource

dbo.DM_AuditRecordType

dbo.DM_ResourceDept

dbo.DM_BasisofEstimate

dbo.DM_Site

dbo.DM_Burden

dbo.DM_SpreadCurve

dbo.DM_BurdenApplyToType

dbo.DM_ValueType

dbo.DM_BurdenTemplates

dbo.DM_WBS

dbo.DM_CLIN

dbo.DM_WBSBCWPBase

dbo.DM_COC

dbo.DM_WBSElementType

dbo.DM_CostElementType

dbo.DM_WBSEVM

dbo.DM_EOC

dbo.DM_WBSTree

dbo.DM_EstimateType

dbo.DM_Week

dbo.DM_FiscalCalendar

dbo.DM_XREF_EST

dbo.DM_Global

dbo.DM_Year

dbo.DM_HeaderThresholdReportLabels

dbo.FT_ResourceRollupDetail

dbo.DM_HeaderThresholdsReports

dbo.FT_ResourceRollupDetailWeekly

dbo.DM_LaborLookup

dbo.FT_ResourceRollupEOC

dbo.DM_Milestone

dbo.FT_ResourceRollupSummary

dbo.DM_Month

dbo.FT_WBSBCWP

dbo.DM_OBSPerformingDept

dbo.SSISDetailLog

dbo.DM_OBSResponsibleDept

dbo.SSISMasterLog

dbo.DM_Overtime

Views

dbo.DM_WBS_Leaves

dbo.View_HeaderThresholds

dbo.View_Burden

dbo.View_OBSPerformingDept

dbo.View_BurdenRates

dbo.View_OBSResponsibleDept

dbo.View_BurdenTemplates

dbo.View_SpreadCurve

dbo.View_CLIN

dbo.View.WBS

dbo.View_ElementofCost

dbo.View_Week

Additional Views created for OLAP when it is deployed

dbo.DM_Estimate

dbo.View_DM_Resource

dbo.FT_ResourceRollupDetail_By_Month

dbo.View_DM_ResourceDept

dbo.FT_ResourceRollupEOC_By_Month

dbo.View_ FT_ACWP

dbo.View_DM_COC

dbo.View_ FT_BCWP

dbo.View_DM_EOC

dbo.View_ FT_BCWS

dbo.View_DM_Global

dbo.View_ FT_ETC

dbo.View_DM_OBSPerformingDept

dbo.View_ FT_Future_ETC

dbo.View_DM_OBSResponsibleDept