SELECT [MenuNavigation].[Id] AS [Id], [MenuNavigation].[Display] AS [Display], [MenuNavigation].[Link] AS [Link], [MenuNavigation].[Value] AS [Value] FROM [dbo].[MenuNavigation] AS [MenuNavigation] SELECT [Type2WorkFlowScheme].[Id] AS [Id], [Type2WorkFlowScheme].[ProjectTypeId] AS [ProjectTypeId], [Type2WorkFlowScheme].[WorkFlowSchemeId] AS [WorkFlowSchemeId] FROM [dbo].[Type2WorkFlowScheme] AS [Type2WorkFlowScheme] SELECT [BLL_Objects].[Id] AS [Id], [BLL_Objects].[EntityName] AS [EntityName] FROM [dbo].[BLL_Objects] AS [BLL_Objects] SELECT [GLAccountClientsCount].[Id] AS [Id], [GLAccountClientsCount].[ClientCount] AS [ClientCount] FROM [dbo].[GLAccountClientsCount] AS [GLAccountClientsCount] SELECT [GLAccountExpCatsCount].[Id] AS [Id], [GLAccountExpCatsCount].[ExpCatCount] AS [ExpCatCount] FROM [dbo].[GLAccountExpCatsCount] AS [GLAccountExpCatsCount] SELECT [VW_ActualCapacityAdjusted].[PeopleResourceId] AS [PeopleResourceId], [VW_ActualCapacityAdjusted].[TeamId] AS [TeamId], [VW_ActualCapacityAdjusted].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ActualCapacityAdjusted].[WeekEndingDate] AS [WeekEndingDate], [VW_ActualCapacityAdjusted].[QuantityDirect] AS [QuantityDirect], [VW_ActualCapacityAdjusted].[CostDirect] AS [CostDirect], [VW_ActualCapacityAdjusted].[QuantityAdjusted] AS [QuantityAdjusted], [VW_ActualCapacityAdjusted].[CostAdjusted] AS [CostAdjusted], [VW_ActualCapacityAdjusted].[AdjustmentKoeff] AS [AdjustmentKoeff] FROM [dbo].[VW_ActualCapacityAdjusted] AS [VW_ActualCapacityAdjusted] SELECT [VW_ActualCapacityAdjustmentByExpCats].[ResourcesTotalOffHrs] AS [ResourcesTotalOffHrs], [VW_ActualCapacityAdjustmentByExpCats].[ResourcesTotalOffCost] AS [ResourcesTotalOffCost], [VW_ActualCapacityAdjustmentByExpCats].[ActualCapacityScenarioId] AS [ActualCapacityScenarioId], [VW_ActualCapacityAdjustmentByExpCats].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ActualCapacityAdjustmentByExpCats].[TeamId] AS [TeamId], [VW_ActualCapacityAdjustmentByExpCats].[WeekEndingDate] AS [WeekEndingDate] FROM [dbo].[VW_ActualCapacityAdjustmentByExpCats] AS [VW_ActualCapacityAdjustmentByExpCats] SELECT [VW_ActualCapacityByTeamsAdjusted].[TeamId] AS [TeamId], [VW_ActualCapacityByTeamsAdjusted].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ActualCapacityByTeamsAdjusted].[WeekEndingDate] AS [WeekEndingDate], [VW_ActualCapacityByTeamsAdjusted].[QuantityDirect] AS [QuantityDirect], [VW_ActualCapacityByTeamsAdjusted].[CostDirect] AS [CostDirect], [VW_ActualCapacityByTeamsAdjusted].[QuantityAdjusted] AS [QuantityAdjusted], [VW_ActualCapacityByTeamsAdjusted].[CostAdjusted] AS [CostAdjusted], [VW_ActualCapacityByTeamsAdjusted].[ResourcesDirect] AS [ResourcesDirect], [VW_ActualCapacityByTeamsAdjusted].[ResourcesAdjusted] AS [ResourcesAdjusted] FROM [dbo].[VW_ActualCapacityByTeamsAdjusted] AS [VW_ActualCapacityByTeamsAdjusted] SELECT [VW_ActualCapacityByTeamsDirect].[TeamId] AS [TeamId], [VW_ActualCapacityByTeamsDirect].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ActualCapacityByTeamsDirect].[WeekEndingDate] AS [WeekEndingDate], [VW_ActualCapacityByTeamsDirect].[Quantity] AS [Quantity], [VW_ActualCapacityByTeamsDirect].[Cost] AS [Cost], [VW_ActualCapacityByTeamsDirect].[Resources] AS [Resources] FROM [dbo].[VW_ActualCapacityByTeamsDirect] AS [VW_ActualCapacityByTeamsDirect] SELECT [VW_ActualCapacityDirect].[PeopleResourceId] AS [PeopleResourceId], [VW_ActualCapacityDirect].[TeamId] AS [TeamId], [VW_ActualCapacityDirect].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ActualCapacityDirect].[WeekEndingDate] AS [WeekEndingDate], [VW_ActualCapacityDirect].[Quantity] AS [Quantity], [VW_ActualCapacityDirect].[Cost] AS [Cost], [VW_ActualCapacityDirect].[Rate] AS [Rate] FROM [dbo].[VW_ActualCapacityDirect] AS [VW_ActualCapacityDirect] SELECT [VW_Company2View].[CompanyId] AS [CompanyId], [VW_Company2View].[ViewId] AS [ViewId] FROM [dbo].[VW_Company2View] AS [VW_Company2View] SELECT [VW_ExpCategoriesInScenario].[Id] AS [Id], [VW_ExpCategoriesInScenario].[ExpenditureCategoryName] AS [ExpenditureCategoryName], [VW_ExpCategoriesInScenario].[ExpenditureName] AS [ExpenditureName], [VW_ExpCategoriesInScenario].[ECType] AS [ECType], [VW_ExpCategoriesInScenario].[ScenarioType] AS [ScenarioType], [VW_ExpCategoriesInScenario].[ScenarioID] AS [ScenarioID], [VW_ExpCategoriesInScenario].[ScenarioName] AS [ScenarioName], [VW_ExpCategoriesInScenario].[SortOrder] AS [SortOrder], [VW_ExpCategoriesInScenario].[UseType] AS [UseType], [VW_ExpCategoriesInScenario].[GLId] AS [GLId], [VW_ExpCategoriesInScenario].[ExpCategoryWithCcName] AS [ExpCategoryWithCcName], [VW_ExpCategoriesInScenario].[AllowResourceAssignment] AS [AllowResourceAssignment] FROM [dbo].[VW_ExpCategoriesInScenario] AS [VW_ExpCategoriesInScenario] SELECT [VW_Expenditure2Calculation].[Id] AS [Id], [VW_Expenditure2Calculation].[ExpenditureCategoryID] AS [ExpenditureCategoryID], [VW_Expenditure2Calculation].[ExpenditureCategoryName] AS [ExpenditureCategoryName], [VW_Expenditure2Calculation].[GLId] AS [GLId], [VW_Expenditure2Calculation].[UOMId] AS [UOMId], [VW_Expenditure2Calculation].[Type] AS [Type], [VW_Expenditure2Calculation].[UseType] AS [UseType], [VW_Expenditure2Calculation].[CGEFX] AS [CGEFX], [VW_Expenditure2Calculation].[SortOrder] AS [SortOrder], [VW_Expenditure2Calculation].[SystemAttributeOne] AS [SystemAttributeOne], [VW_Expenditure2Calculation].[SystemAttributeTwo] AS [SystemAttributeTwo], [VW_Expenditure2Calculation].[ExpenditureName] AS [ExpenditureName], [VW_Expenditure2Calculation].[FactorType] AS [FactorType], [VW_Expenditure2Calculation].[FactorInt] AS [FactorInt], [VW_Expenditure2Calculation].[ProcessOrder] AS [ProcessOrder], [VW_Expenditure2Calculation].[ParentId] AS [ParentId], [VW_Expenditure2Calculation].[CreditId] AS [CreditId], [VW_Expenditure2Calculation].[WksSubjectToFee] AS [WksSubjectToFee], [VW_Expenditure2Calculation].[ExpCategoryWithCcName] AS [ExpCategoryWithCcName], [VW_Expenditure2Calculation].[AllowResourceAssignment] AS [AllowResourceAssignment] FROM [dbo].[VW_Expenditure2Calculation] AS [VW_Expenditure2Calculation] SELECT [VW_Expenditure2Category].[Id] AS [Id], [VW_Expenditure2Category].[ExpenditureId] AS [ExpenditureId], [VW_Expenditure2Category].[ExpenditureCategoryName] AS [ExpenditureCategoryName], [VW_Expenditure2Category].[GLId] AS [GLId], [VW_Expenditure2Category].[UOMId] AS [UOMId], [VW_Expenditure2Category].[Type] AS [Type], [VW_Expenditure2Category].[UseType] AS [UseType], [VW_Expenditure2Category].[CGEFX] AS [CGEFX], [VW_Expenditure2Category].[SortOrder] AS [SortOrder], [VW_Expenditure2Category].[ExpenditureName] AS [ExpenditureName], [VW_Expenditure2Category].[GLNumber] AS [GLNumber], [VW_Expenditure2Category].[GLName] AS [GLName], [VW_Expenditure2Category].[UOMName] AS [UOMName], [VW_Expenditure2Category].[CreditId] AS [CreditId], [VW_Expenditure2Category].[SystemAttributeOne] AS [SystemAttributeOne], [VW_Expenditure2Category].[SystemAttributeTwo] AS [SystemAttributeTwo], [VW_Expenditure2Category].[CreditName] AS [CreditName], [VW_Expenditure2Category].[WksSubjectToFee] AS [WksSubjectToFee], [VW_Expenditure2Category].[SystemAttributeNameOne] AS [SystemAttributeNameOne], [VW_Expenditure2Category].[SystemAttributeTypeOne] AS [SystemAttributeTypeOne], [VW_Expenditure2Category].[SystemAttributeNameTwo] AS [SystemAttributeNameTwo], [VW_Expenditure2Category].[SystemAttributeTypeTwo] AS [SystemAttributeTypeTwo], [VW_Expenditure2Category].[ExpCategoryWithCcName] AS [ExpCategoryWithCcName], [VW_Expenditure2Category].[AllowResourceAssignment] AS [AllowResourceAssignment] FROM [dbo].[VW_Expenditure2Category] AS [VW_Expenditure2Category] SELECT [VW_Expenditure2FeeCalculation].[Id] AS [Id], [VW_Expenditure2FeeCalculation].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_Expenditure2FeeCalculation].[MinShot] AS [MinShot], [VW_Expenditure2FeeCalculation].[MaxShot] AS [MaxShot], [VW_Expenditure2FeeCalculation].[Quantity] AS [Quantity], [VW_Expenditure2FeeCalculation].[WksSubjectToFee] AS [WksSubjectToFee] FROM [dbo].[VW_Expenditure2FeeCalculation] AS [VW_Expenditure2FeeCalculation] SELECT [VW_ExpenditureCategory].[Id] AS [Id], [VW_ExpenditureCategory].[ExpenditureId] AS [ExpenditureId], [VW_ExpenditureCategory].[GLId] AS [GLId], [VW_ExpenditureCategory].[UOMId] AS [UOMId], [VW_ExpenditureCategory].[UOMName] AS [UOMName], [VW_ExpenditureCategory].[UOMValue] AS [UOMValue], [VW_ExpenditureCategory].[CreditId] AS [CreditId], [VW_ExpenditureCategory].[Type] AS [Type], [VW_ExpenditureCategory].[UseType] AS [UseType], [VW_ExpenditureCategory].[CGEFX] AS [CGEFX], [VW_ExpenditureCategory].[SortOrder] AS [SortOrder], [VW_ExpenditureCategory].[WksSubjectToFee] AS [WksSubjectToFee], [VW_ExpenditureCategory].[SystemAttributeOne] AS [SystemAttributeOne], [VW_ExpenditureCategory].[SystemAttributeTwo] AS [SystemAttributeTwo], [VW_ExpenditureCategory].[Name] AS [Name], [VW_ExpenditureCategory].[AllowResourceAssignment] AS [AllowResourceAssignment], [VW_ExpenditureCategory].[ExpCategoryWithCcName] AS [ExpCategoryWithCcName] FROM [dbo].[VW_ExpenditureCategory] AS [VW_ExpenditureCategory] SELECT [VW_ExpendituresWithAdjustmentFactor].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ExpendituresWithAdjustmentFactor].[WeekEndingDate] AS [WeekEndingDate], [VW_ExpendituresWithAdjustmentFactor].[AdjustmentFactor] AS [AdjustmentFactor] FROM [dbo].[VW_ExpendituresWithAdjustmentFactor] AS [VW_ExpendituresWithAdjustmentFactor] SELECT [VW_Holiday].[Id] AS [Id], [VW_Holiday].[Name] AS [Name], [VW_Holiday].[WorkingDays] AS [WorkingDays], [VW_Holiday].[HolidayGroupId] AS [HolidayGroupId], [VW_Holiday].[EffectiveChangeDate] AS [EffectiveChangeDate], [VW_Holiday].[CreatedAt] AS [CreatedAt], [VW_Holiday].[Options] AS [Options], [VW_Holiday].[StartDate] AS [StartDate], [VW_Holiday].[EndDate] AS [EndDate], [VW_Holiday].[CompanyImpact] AS [CompanyImpact], [VW_Holiday].[IsInclude] AS [IsInclude], [VW_Holiday].[ValidTo] AS [ValidTo] FROM [dbo].[VW_Holiday] AS [VW_Holiday] SELECT [VW_HolidayAllocation].[PeopleResourceId] AS [PeopleResourceId], [VW_HolidayAllocation].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_HolidayAllocation].[TeamId] AS [TeamId], [VW_HolidayAllocation].[WeekEndingDate] AS [WeekEndingDate], [VW_HolidayAllocation].[AdjustmentKoeff] AS [AdjustmentKoeff] FROM [dbo].[VW_HolidayAllocation] AS [VW_HolidayAllocation] SELECT [VW_NonProjectTimeAllocation].[NonProjectTimeId] AS [NonProjectTimeId], [VW_NonProjectTimeAllocation].[NonProjectTimeName] AS [NonProjectTimeName], [VW_NonProjectTimeAllocation].[TeamId] AS [TeamId], [VW_NonProjectTimeAllocation].[PeopleResourceId] AS [PeopleResourceId], [VW_NonProjectTimeAllocation].[WeekEndingDate] AS [WeekEndingDate], [VW_NonProjectTimeAllocation].[HoursOff] AS [HoursOff], [VW_NonProjectTimeAllocation].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_NonProjectTimeAllocation].[NonProjectTimeCategoryId] AS [NonProjectTimeCategoryId], [VW_NonProjectTimeAllocation].[NonProjectTimeCategoryName] AS [NonProjectTimeCategoryName], [VW_NonProjectTimeAllocation].[IsTeamNonProjectTime] AS [IsTeamNonProjectTime], [VW_NonProjectTimeAllocation].[Rate] AS [Rate] FROM [dbo].[VW_NonProjectTimeAllocation] AS [VW_NonProjectTimeAllocation] SELECT [VW_NonProjectTimeInvalidItems].[NonProjectTimeId] AS [NonProjectTimeId], [VW_NonProjectTimeInvalidItems].[NonProjectTimeName] AS [NonProjectTimeName], [VW_NonProjectTimeInvalidItems].[StartDate] AS [StartDate], [VW_NonProjectTimeInvalidItems].[EndDate] AS [EndDate], [VW_NonProjectTimeInvalidItems].[PeopleResourceId] AS [PeopleResourceId], [VW_NonProjectTimeInvalidItems].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_NonProjectTimeInvalidItems].[NonProjectTimeCategoryId] AS [NonProjectTimeCategoryId], [VW_NonProjectTimeInvalidItems].[NonProjectTimeCategoryName] AS [NonProjectTimeCategoryName], [VW_NonProjectTimeInvalidItems].[Details] AS [Details] FROM [dbo].[VW_NonProjectTimeInvalidItems] AS [VW_NonProjectTimeInvalidItems] SELECT [VW_PeopleResourceAllocationsInfo].[PeopleResourceId] AS [PeopleResourceId], [VW_PeopleResourceAllocationsInfo].[Type] AS [Type], [VW_PeopleResourceAllocationsInfo].[MinDate] AS [MinDate], [VW_PeopleResourceAllocationsInfo].[MaxDate] AS [MaxDate] FROM [dbo].[VW_PeopleResourceAllocationsInfo] AS [VW_PeopleResourceAllocationsInfo] SELECT [VW_PlanningCapacityAdjusted].[ScenarioId] AS [ScenarioId], [VW_PlanningCapacityAdjusted].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_PlanningCapacityAdjusted].[TeamId] AS [TeamId], [VW_PlanningCapacityAdjusted].[WeekEndingDate] AS [WeekEndingDate], [VW_PlanningCapacityAdjusted].[AdjustmentKoeff] AS [AdjustmentKoeff] FROM [dbo].[VW_PlanningCapacityAdjusted] AS [VW_PlanningCapacityAdjusted] SELECT [VW_ProjectAccessByUserExtended].[Id] AS [Id], [VW_ProjectAccessByUserExtended].[CompanyId] AS [CompanyId], [VW_ProjectAccessByUserExtended].[ClientId] AS [ClientId], [VW_ProjectAccessByUserExtended].[TypeId] AS [TypeId], [VW_ProjectAccessByUserExtended].[StatusId] AS [StatusId], [VW_ProjectAccessByUserExtended].[Name] AS [Name], [VW_ProjectAccessByUserExtended].[ProjectNumber] AS [ProjectNumber], [VW_ProjectAccessByUserExtended].[Color] AS [Color], [VW_ProjectAccessByUserExtended].[Details] AS [Details], [VW_ProjectAccessByUserExtended].[Priority] AS [Priority], [VW_ProjectAccessByUserExtended].[Probability] AS [Probability], [VW_ProjectAccessByUserExtended].[IsRevenueGenerating] AS [IsRevenueGenerating], [VW_ProjectAccessByUserExtended].[Deadline] AS [Deadline], [VW_ProjectAccessByUserExtended].[ParentProjectId] AS [ParentProjectId], [VW_ProjectAccessByUserExtended].[HasChildren] AS [HasChildren], [VW_ProjectAccessByUserExtended].[PerformanceRedThreshold] AS [PerformanceRedThreshold], [VW_ProjectAccessByUserExtended].[PerformanceYellowThreshold] AS [PerformanceYellowThreshold], [VW_ProjectAccessByUserExtended].[PartNum] AS [PartNum], [VW_ProjectAccessByUserExtended].[EditTimestamp] AS [EditTimestamp], [VW_ProjectAccessByUserExtended].[UserId] AS [UserId], [VW_ProjectAccessByUserExtended].[StatusName] AS [StatusName], [VW_ProjectAccessByUserExtended].[CompanyName] AS [CompanyName], [VW_ProjectAccessByUserExtended].[ClientName] AS [ClientName], [VW_ProjectAccessByUserExtended].[TypeName] AS [TypeName], [VW_ProjectAccessByUserExtended].[ActiveScenarioId] AS [ActiveScenarioId], [VW_ProjectAccessByUserExtended].[ActiveScenarioName] AS [ActiveScenarioName], [VW_ProjectAccessByUserExtended].[Read] AS [Read], [VW_ProjectAccessByUserExtended].[Write] AS [Write], [VW_ProjectAccessByUserExtended].[ParentProjectName] AS [ParentProjectName], [VW_ProjectAccessByUserExtended].[ParentProjectColor] AS [ParentProjectColor] FROM [dbo].[VW_ProjectAccessByUserExtended] AS [VW_ProjectAccessByUserExtended] SELECT [VW_ProjectDependencies].[Id] AS [Id], [VW_ProjectDependencies].[SourceProjectId] AS [SourceProjectId], [VW_ProjectDependencies].[TargetProjectId] AS [TargetProjectId], [VW_ProjectDependencies].[Type] AS [Type], [VW_ProjectDependencies].[SourceProjectName] AS [SourceProjectName], [VW_ProjectDependencies].[TargetProjectName] AS [TargetProjectName], [VW_ProjectDependencies].[SourceStartDate] AS [SourceStartDate], [VW_ProjectDependencies].[SourceEndDate] AS [SourceEndDate], [VW_ProjectDependencies].[TargetStartDate] AS [TargetStartDate], [VW_ProjectDependencies].[TargetEndDate] AS [TargetEndDate], [VW_ProjectDependencies].[SourceDeadline] AS [SourceDeadline], [VW_ProjectDependencies].[TargetDeadline] AS [TargetDeadline], [VW_ProjectDependencies].[SourceHasActuals] AS [SourceHasActuals], [VW_ProjectDependencies].[TargetHasActuals] AS [TargetHasActuals] FROM [dbo].[VW_ProjectDependencies] AS [VW_ProjectDependencies] SELECT [VW_ProjectNeedUnassigned].[ProjectId] AS [ProjectId], [VW_ProjectNeedUnassigned].[ScenarioId] AS [ScenarioId], [VW_ProjectNeedUnassigned].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ProjectNeedUnassigned].[WeekEndingDate] AS [WeekEndingDate], [VW_ProjectNeedUnassigned].[RemainingQuantity] AS [RemainingQuantity] FROM [dbo].[VW_ProjectNeedUnassigned] AS [VW_ProjectNeedUnassigned] SELECT [VW_ProjectPerformance].[ForecastScenarioId] AS [ForecastScenarioId], [VW_ProjectPerformance].[ActualsScenarioId] AS [ActualsScenarioId], [VW_ProjectPerformance].[ForecastScenarioType] AS [ForecastScenarioType], [VW_ProjectPerformance].[ForecastTotalCost] AS [ForecastTotalCost], [VW_ProjectPerformance].[ActualsTotalCost] AS [ActualsTotalCost], [VW_ProjectPerformance].[VariationPercent] AS [VariationPercent], [VW_ProjectPerformance].[ForecastTotalQuantity] AS [ForecastTotalQuantity], [VW_ProjectPerformance].[ActualsTotalQuantity] AS [ActualsTotalQuantity], [VW_ProjectPerformance].[VariationQuantityPercent] AS [VariationQuantityPercent], [VW_ProjectPerformance].[Status] AS [Status], [VW_ProjectPerformance].[BUDirectCosts] AS [BUDirectCosts], [VW_ProjectPerformance].[ScenarioEndDate] AS [ScenarioEndDate], [VW_ProjectPerformance].[ScenarioStartDate] AS [ScenarioStartDate], [VW_ProjectPerformance].[ProjectId] AS [ProjectId], [VW_ProjectPerformance].[ProjectName] AS [ProjectName], [VW_ProjectPerformance].[ProjectTypeId] AS [ProjectTypeId], [VW_ProjectPerformance].[ProjectPriority] AS [ProjectPriority], [VW_ProjectPerformance].[StatusId] AS [StatusId], [VW_ProjectPerformance].[ClientId] AS [ClientId], [VW_ProjectPerformance].[ProjectTypeName] AS [ProjectTypeName], [VW_ProjectPerformance].[StrategicGoalId] AS [StrategicGoalId], [VW_ProjectPerformance].[TagID] AS [TagID], [VW_ProjectPerformance].[ActualsCostForecasted] AS [ActualsCostForecasted], [VW_ProjectPerformance].[ActualsCostVariation] AS [ActualsCostVariation], [VW_ProjectPerformance].[ActualsQuantityVariation] AS [ActualsQuantityVariation], [VW_ProjectPerformance].[ProjectWeight] AS [ProjectWeight], [VW_ProjectPerformance].[FiscalPeriodId] AS [FiscalPeriodId], [VW_ProjectPerformance].[ScenarioGroupId] AS [ScenarioGroupId] FROM [dbo].[VW_ProjectPerformance] AS [VW_ProjectPerformance] SELECT [VW_ProjectTeamsResourceAllocated].[ProjectId] AS [ProjectId], [VW_ProjectTeamsResourceAllocated].[ScenarioId] AS [ScenarioId], [VW_ProjectTeamsResourceAllocated].[ScenarioType] AS [ScenarioType], [VW_ProjectTeamsResourceAllocated].[TeamId] AS [TeamId] FROM [dbo].[VW_ProjectTeamsResourceAllocated] AS [VW_ProjectTeamsResourceAllocated] SELECT [VW_Scenario2Project].[Id] AS [Id], [VW_Scenario2Project].[ParentId] AS [ParentId], [VW_Scenario2Project].[TemplateId] AS [TemplateId], [VW_Scenario2Project].[Type] AS [Type], [VW_Scenario2Project].[Name] AS [Name], [VW_Scenario2Project].[ProjectedRevenue] AS [ProjectedRevenue], [VW_Scenario2Project].[ExpectedGrossMargin] AS [ExpectedGrossMargin], [VW_Scenario2Project].[CalculatedGrossMargin] AS [CalculatedGrossMargin], [VW_Scenario2Project].[CGSplit] AS [CGSplit], [VW_Scenario2Project].[EFXSplit] AS [EFXSplit], [VW_Scenario2Project].[StartDate] AS [StartDate], [VW_Scenario2Project].[EndDate] AS [EndDate], [VW_Scenario2Project].[Duration] AS [Duration], [VW_Scenario2Project].[Priority] AS [Priority], [VW_Scenario2Project].[Probability] AS [Probability], [VW_Scenario2Project].[TDDirectCosts] AS [TDDirectCosts], [VW_Scenario2Project].[BUDirectCosts] AS [BUDirectCosts], [VW_Scenario2Project].[Shots] AS [Shots], [VW_Scenario2Project].[TDRevenueShot] AS [TDRevenueShot], [VW_Scenario2Project].[BURevenueShot] AS [BURevenueShot], [VW_Scenario2Project].[FreezeRevenue] AS [FreezeRevenue], [VW_Scenario2Project].[LastUpdate] AS [LastUpdate], [VW_Scenario2Project].[ShowObjectID] AS [ShowObjectID], [VW_Scenario2Project].[ShowName] AS [ShowName], [VW_Scenario2Project].[CompanyId] AS [CompanyId], [VW_Scenario2Project].[ClientId] AS [ClientId], [VW_Scenario2Project].[TypeId] AS [TypeId], [VW_Scenario2Project].[StatusId] AS [StatusId], [VW_Scenario2Project].[Color] AS [Color], [VW_Scenario2Project].[Status] AS [Status], [VW_Scenario2Project].[UseLMMargin] AS [UseLMMargin], [VW_Scenario2Project].[ExpectedGrossMargin_LM] AS [ExpectedGrossMargin_LM], [VW_Scenario2Project].[CalculatedGrossMargin_LM] AS [CalculatedGrossMargin_LM], [VW_Scenario2Project].[TDDirectCosts_LM] AS [TDDirectCosts_LM], [VW_Scenario2Project].[BUDirectCosts_LM] AS [BUDirectCosts_LM], [VW_Scenario2Project].[BURevenueShot_LM] AS [BURevenueShot_LM], [VW_Scenario2Project].[ShotStartDate] AS [ShotStartDate], [VW_Scenario2Project].[GrowthScenario] AS [GrowthScenario], [VW_Scenario2Project].[Actuals_BUDirectCosts] AS [Actuals_BUDirectCosts], [VW_Scenario2Project].[Actuals_BUDirectCosts_LM] AS [Actuals_BUDirectCosts_LM], [VW_Scenario2Project].[SystemAttributeObjectID] AS [SystemAttributeObjectID], [VW_Scenario2Project].[GroupId] AS [GroupId], [VW_Scenario2Project].[CostSavings] AS [CostSavings], [VW_Scenario2Project].[ParentProjectId] AS [ParentProjectId], [VW_Scenario2Project].[ParentProjectName] AS [ParentProjectName], [VW_Scenario2Project].[ParentProjectColor] AS [ParentProjectColor] FROM [dbo].[VW_Scenario2Project] AS [VW_Scenario2Project] SELECT [VW_ScenarioAndProxyDetails].[Id] AS [Id], [VW_ScenarioAndProxyDetails].[ParentID] AS [ParentID], [VW_ScenarioAndProxyDetails].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_ScenarioAndProxyDetails].[WeekEndingDate] AS [WeekEndingDate], [VW_ScenarioAndProxyDetails].[Quantity] AS [Quantity], [VW_ScenarioAndProxyDetails].[WeekOrdinal] AS [WeekOrdinal], [VW_ScenarioAndProxyDetails].[Cost] AS [Cost], [VW_ScenarioAndProxyDetails].[ExpenditureCategoryName] AS [ExpenditureCategoryName], [VW_ScenarioAndProxyDetails].[ExpenditureName] AS [ExpenditureName], [VW_ScenarioAndProxyDetails].[GLId] AS [GLId], [VW_ScenarioAndProxyDetails].[UOMId] AS [UOMId], [VW_ScenarioAndProxyDetails].[CreditId] AS [CreditId], [VW_ScenarioAndProxyDetails].[Type] AS [Type], [VW_ScenarioAndProxyDetails].[UseType] AS [UseType], [VW_ScenarioAndProxyDetails].[CGEFX] AS [CGEFX], [VW_ScenarioAndProxyDetails].[SystemAttributeOne] AS [SystemAttributeOne], [VW_ScenarioAndProxyDetails].[SystemAttributeTwo] AS [SystemAttributeTwo], [VW_ScenarioAndProxyDetails].[SortOrder] AS [SortOrder], [VW_ScenarioAndProxyDetails].[ExpCategoryWithCcName] AS [ExpCategoryWithCcName], [VW_ScenarioAndProxyDetails].[AllowResourceAssignment] AS [AllowResourceAssignment] FROM [dbo].[VW_ScenarioAndProxyDetails] AS [VW_ScenarioAndProxyDetails] SELECT [VW_ScenarioPerformance].[ForecastScenarioId] AS [ForecastScenarioId], [VW_ScenarioPerformance].[ActualsScenarioId] AS [ActualsScenarioId], [VW_ScenarioPerformance].[ForecastScenarioType] AS [ForecastScenarioType], [VW_ScenarioPerformance].[ForecastTotalCost] AS [ForecastTotalCost], [VW_ScenarioPerformance].[ActualsTotalCost] AS [ActualsTotalCost], [VW_ScenarioPerformance].[ForecastTotalQuantity] AS [ForecastTotalQuantity], [VW_ScenarioPerformance].[ActualsTotalQuantity] AS [ActualsTotalQuantity], [VW_ScenarioPerformance].[VariationPercent] AS [VariationPercent], [VW_ScenarioPerformance].[VariationQuantityPercent] AS [VariationQuantityPercent] FROM [dbo].[VW_ScenarioPerformance] AS [VW_ScenarioPerformance] SELECT [VW_Skill2Resource].[Id] AS [Id], [VW_Skill2Resource].[Type] AS [Type], [VW_Skill2Resource].[EffectiveDate] AS [EffectiveDate], [VW_Skill2Resource].[SkillId] AS [SkillId], [VW_Skill2Resource].[ResourceId] AS [ResourceId], [VW_Skill2Resource].[Level] AS [Level], [VW_Skill2Resource].[Interested] AS [Interested], [VW_Skill2Resource].[DateCreated] AS [DateCreated], [VW_Skill2Resource].[SkillGroupId] AS [SkillGroupId], [VW_Skill2Resource].[AssignedToGroup] AS [AssignedToGroup], [VW_Skill2Resource].[PastYearDateOffset] AS [PastYearDateOffset], [VW_Skill2Resource].[FutureYearDateOffset] AS [FutureYearDateOffset] FROM [dbo].[VW_Skill2Resource] AS [VW_Skill2Resource] SELECT [VW_Team2View].[ViewId] AS [ViewId], [VW_Team2View].[TeamId] AS [TeamId] FROM [dbo].[VW_Team2View] AS [VW_Team2View] SELECT [VW_TeamResource].[Id] AS [Id], [VW_TeamResource].[FirstName] AS [FirstName], [VW_TeamResource].[LastName] AS [LastName], [VW_TeamResource].[IsActiveEmployee] AS [IsActiveEmployee], [VW_TeamResource].[ExpenditureCategoryId] AS [ExpenditureCategoryId], [VW_TeamResource].[StartDate] AS [StartDate], [VW_TeamResource].[EndDate] AS [EndDate], [VW_TeamResource].[EmployeeID] AS [EmployeeID], [VW_TeamResource].[Email] AS [Email], [VW_TeamResource].[WorkWeekId] AS [WorkWeekId], [VW_TeamResource].[TeamId] AS [TeamId], [VW_TeamResource].[TeamStartDate] AS [TeamStartDate], [VW_TeamResource].[TeamEndDate] AS [TeamEndDate], [VW_TeamResource].[Allocation] AS [Allocation] FROM [dbo].[VW_TeamResource] AS [VW_TeamResource] SELECT [VW_User2Company].[UserId] AS [UserId], [VW_User2Company].[CompanyId] AS [CompanyId], [VW_User2Company].[Read] AS [Read], [VW_User2Company].[Write] AS [Write] FROM [dbo].[VW_User2Company] AS [VW_User2Company] SELECT [VW_User2Company4Display].[UserId] AS [UserId], [VW_User2Company4Display].[CompanyId] AS [CompanyId], [VW_User2Company4Display].[Read] AS [Read], [VW_User2Company4Display].[Write] AS [Write] FROM [dbo].[VW_User2Company4Display] AS [VW_User2Company4Display] SELECT [VW_User2Team].[UserId] AS [UserId], [VW_User2Team].[TeamId] AS [TeamId], [VW_User2Team].[TeamName] AS [TeamName], [VW_User2Team].[CompanyId] AS [CompanyId], [VW_User2Team].[Read] AS [Read], [VW_User2Team].[Write] AS [Write] FROM [dbo].[VW_User2Team] AS [VW_User2Team] SELECT [vw_User2Team2WorkflowRoleContactInfo].[Id] AS [Id], [vw_User2Team2WorkflowRoleContactInfo].[UserName] AS [UserName], [vw_User2Team2WorkflowRoleContactInfo].[FirstName] AS [FirstName], [vw_User2Team2WorkflowRoleContactInfo].[LastName] AS [LastName], [vw_User2Team2WorkflowRoleContactInfo].[Email] AS [Email], [vw_User2Team2WorkflowRoleContactInfo].[TeamId] AS [TeamId], [vw_User2Team2WorkflowRoleContactInfo].[Name] AS [Name], [vw_User2Team2WorkflowRoleContactInfo].[RoleName] AS [RoleName] FROM [dbo].[vw_User2Team2WorkflowRoleContactInfo] AS [vw_User2Team2WorkflowRoleContactInfo] SELECT [vw_User2WorkFlowRoles].[Id] AS [Id], [vw_User2WorkFlowRoles].[UserName] AS [UserName], [vw_User2WorkFlowRoles].[FirstName] AS [FirstName], [vw_User2WorkFlowRoles].[LastName] AS [LastName], [vw_User2WorkFlowRoles].[Email] AS [Email], [vw_User2WorkFlowRoles].[RoleName] AS [RoleName] FROM [dbo].[vw_User2WorkFlowRoles] AS [vw_User2WorkFlowRoles] SELECT [vw_WorkflowApprovalHistoryInfo].[FirstName] AS [FirstName], [vw_WorkflowApprovalHistoryInfo].[LastName] AS [LastName], [vw_WorkflowApprovalHistoryInfo].[ScenarioName] AS [ScenarioName], [vw_WorkflowApprovalHistoryInfo].[ScenarioId] AS [ScenarioId], [vw_WorkflowApprovalHistoryInfo].[TeamName] AS [TeamName], [vw_WorkflowApprovalHistoryInfo].[Approved] AS [Approved], [vw_WorkflowApprovalHistoryInfo].[DateApproved] AS [DateApproved], [vw_WorkflowApprovalHistoryInfo].[StepName] AS [StepName] FROM [dbo].[vw_WorkflowApprovalHistoryInfo] AS [vw_WorkflowApprovalHistoryInfo] SELECT [VW_WorkflowModelView].[Id] AS [Id], [VW_WorkflowModelView].[Name] AS [Name], [VW_WorkflowModelView].[Code] AS [Code], [VW_WorkflowModelView].[ProcessType] AS [ProcessType], [VW_WorkflowModelView].[isDefault] AS [isDefault], [VW_WorkflowModelView].[CreatedBy] AS [CreatedBy], [VW_WorkflowModelView].[DateCreated] AS [DateCreated], [VW_WorkflowModelView].[UpdatedBy] AS [UpdatedBy], [VW_WorkflowModelView].[UpdateDate] AS [UpdateDate], [VW_WorkflowModelView].[isActive] AS [isActive], [VW_WorkflowModelView].[Scheme] AS [Scheme], [VW_WorkflowModelView].[isTemplate] AS [isTemplate], [VW_WorkflowModelView].[totalRecordInWorkFlow] AS [totalRecordInWorkFlow] FROM [dbo].[VW_WorkflowModelView] AS [VW_WorkflowModelView] SELECT [VW_WorkflowRoleModelView].[Id] AS [Id], [VW_WorkflowRoleModelView].[RoleName] AS [RoleName], [VW_WorkflowRoleModelView].[UsersInRole] AS [UsersInRole] FROM [dbo].[VW_WorkflowRoleModelView] AS [VW_WorkflowRoleModelView]