SSIS Components for Microsoft Project

Build 21.0.7930

AssignmentTimephasedDataSet

Retrieve assignment timephased dataset.

Columns

Name Type References Description
AssignmentId [KEY] String
ProjectId [KEY] String
TimeByDay [KEY] Datetime
AssignmentActualCost Decimal
AssignmentActualOvertimeCost Decimal
AssignmentActualOvertimeWork Decimal
AssignmentActualRegularCost Decimal
AssignmentActualRegularWork Decimal
AssignmentActualWork Decimal
AssignmentBudgetCost Decimal
AssignmentBudgetMaterialWork Decimal
AssignmentBudgetWork Decimal
AssignmentCombinedWork Decimal
AssignmentCost Decimal
AssignmentMaterialActualWork Decimal
AssignmentMaterialWork Decimal
AssignmentModifiedDate Datetime
AssignmentOvertimeCost Decimal
AssignmentOvertimeWork Decimal
AssignmentRegularCost Decimal
AssignmentRegularWork Decimal
AssignmentRemainingCost Decimal
AssignmentRemainingOvertimeCost Decimal
AssignmentRemainingOvertimeWork Decimal
AssignmentRemainingRegularCost Decimal
AssignmentRemainingRegularWork Decimal
AssignmentRemainingWork Decimal
AssignmentResourcePlanWork Decimal
AssignmentWork Decimal
FiscalPeriodId String
ProjectName String
ResourceId String
TaskId String
TaskIsActive Bool
TaskName String
LinkedAssignment String
LinkedProject String
LinkedTask String
LinkedTime String

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930