JDBC Driver for Microsoft Project

Build 22.0.8462

Assignments

Retrieve assignments.

Columns

Name Type References Description
AssignmentId [KEY] String
ProjectId [KEY] String
AssignmentActualCost Decimal
AssignmentActualFinishDate Datetime
AssignmentActualOvertimeCost Decimal
AssignmentActualOvertimeWork Decimal
AssignmentActualRegularCost Decimal
AssignmentActualRegularWork Decimal
AssignmentActualStartDate Datetime
AssignmentActualWork Decimal
AssignmentACWP Decimal
AssignmentAllUpdatesApplied Bool
AssignmentBCWP Decimal
AssignmentBCWS Decimal
AssignmentBookingDescription String
AssignmentBookingId Int
AssignmentBookingName String
AssignmentBudgetCost Decimal
AssignmentBudgetMaterialWork Decimal
AssignmentBudgetWork Decimal
AssignmentCost Decimal
AssignmentCostVariance Decimal
AssignmentCreatedDate Datetime
AssignmentCreatedRevisionCounter Int
AssignmentCV Decimal
AssignmentDelay Decimal
AssignmentFinishDate Datetime
AssignmentFinishVariance Decimal
AssignmentIsOverallocated Bool
AssignmentIsPublished Bool
AssignmentMaterialActualWork Decimal
AssignmentMaterialWork Decimal
AssignmentModifiedDate Datetime
AssignmentModifiedRevisionCounter Int
AssignmentOvertimeCost Decimal
AssignmentOvertimeWork Decimal
AssignmentPeakUnits Decimal
AssignmentPercentWorkCompleted Int
AssignmentRegularCost Decimal
AssignmentRegularWork Decimal
AssignmentRemainingCost Decimal
AssignmentRemainingOvertimeCost Decimal
AssignmentRemainingOvertimeWork Decimal
AssignmentRemainingRegularCost Decimal
AssignmentRemainingRegularWork Decimal
AssignmentRemainingWork Decimal
AssignmentResourcePlanWork Decimal
AssignmentResourceType Int
AssignmentStartDate Datetime
AssignmentStartVariance Decimal
AssignmentSV Decimal
AssignmentType Int
AssignmentUpdatesAppliedDate Datetime
AssignmentVAC Decimal
AssignmentWork Decimal
AssignmentWorkVariance Decimal
CostType_R String
FlagStatus_T Bool
Health_T String
IsPublic Bool
ProjectName String
RBS_R String
ResourceId String
ResourceName String
TaskId String
TaskIsActive Bool
TaskName String
TimesheetClassId String
TypeDescription String
TypeName String
LinkedBaseline String
LinkedProject String
LinkedResource String
LinkedTask String
LinkedTimephasedData String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462