CData SSIS Components for Microsoft Project 2019J - Online Help

Assignments

CData SSIS Components for Microsoft Project 2019J - Build 19.0.7354

Create, update, delete, and query Assignments entries.

テーブル固有の情報

Select

フィルタが指定されていない場合は、次のクエリのように、すべてのプロジェクトからのAssignments が返されます。

SELECT * FROM [Assignments]
ProjectId またはResourceId が指定されている場合は、本製品 はMicrosoft Project API を使用して結果をフィルタリングします。その他のフィルタは本製品 内でクライアント側で実行されます。例えば、次のクエリはサーバー側で実行されます。
SELECT * FROM [Assignments] WHERE ProjectId='4aa966f0-c449-459a-ba81-2de3511c6112'
SupportEnhancedSQL をfalse に設定すると、クライアント側の実行をオフにできます。その場合、その他のカラムを参照する検索条件でエラーが発生します。

Columns

Name Type Description
Id [KEY] String The unique identifier of the assignment.
ProjectId [KEY] String The unique identifier of the project.
ResourceId [KEY] String The unique identifier of the resource.
ActualCost Decimal The costs incurred for work already performed on the assignment, together with any other recorded costs that are associated with the assignment.
ActualCostWorkPerformed Integer The actual cost of work performed (ACWP) for the assignment to date.
ActualFinish Datetime The date and time when the assignment is complete.
ActualOvertimeCost Decimal The actual overtime cost for the assignment.
ActualOvertimeWork String A string containing the actual amount of overtime work that has already been performed on the assignment.
ActualOvertimeWorkMilliseconds Integer An integer containing the actual amount of overtime work that has already been performed on the assignment in milliseconds.
ActualOvertimeWorkTimeSpan String The time interval for the actual amount of overtime work that has already been performed on the assignment
ActualStart Datetime The date and time that the assignment actually began, based on progress information that was entered.
ActualWork String A string containing the amount of work that has already been performed on the assignment.
ActualWorkMilliseconds Integer An integer containing the amount of work that has already been performed on the assignment in milliseconds.
ActualWorkTimeSpan String The time interval for the amount of work that has already been performed on the assignment.
BaselineCost Decimal The total planned costs of the assignment.
BaselineCostPerUse Decimal The cost per use of a resource on an assignment, at the time of the project baseline.
BaselineFinish Datetime The planned completion date for an assignment, at the time of the project baseline.
BaselineStart Datetime The planned start date for an assignment, at the time of the project baseline.
BaselineWork String A string containing the total planned person-hours scheduled for an assignment, at the time of the project baseline.
BaselineWorkMilliseconds Integer An integer containing the total planned person-hours scheduled for an assignment, at the time of the project baseline, in milliseconds.
BaselineWorkTimeSpan String The total time interval of planned person-hours scheduled for an assignment, at the time of the project baseline.
BudgetedCost Decimal The budgeted cost for the assignment.
BudgetedCostWorkPerformed Decimal The budgeted cost of work performed (BCWP).
BudgetedCostWorkScheduled Decimal The budgeted cost of work scheduled (BCWS) for the assignment.
BudgetedWork String A string containing the budgeted work for the assignment.
BudgetedWorkMilliseconds Integer An integer containing the budgeted work for the assignment in milliseconds.
BudgetedWorkTimeSpan String The time interval for the budgeted work for the assignment.
Cost Decimal The total scheduled or projected cost for the assignment.
CostRateTable Decimal The cost rate table to use for the resources assigned to a task.
CostVariance Decimal The cost variance (CV), which is the difference between the baseline cost and the total cost of the assignment.
CostVarianceAtCompletion Decimal The cost variance at completion (VAC) for the assignment.
Created Datetime The date when the assignment was created.
CurrentCostVariance Decimal The current cost variance (CV).
DefaultBookingType Integer The default booking type for the assignment.
Delay String A string containing the amount of time that passes after the start date, before work on the assignment starts.
DelayMilliseconds Integer An integer containing the amount of time that passes after the start date, in milliseconds, before work on the assignment starts.
DelayTimeSpan String The time interval for the amount of time that passes after the start date, before work on the assignment starts.
Finish Datetime The date when the assignment is scheduled to be completed.
FinishVariance String A string containing the variance of the finish date of the assignment.
FinishVarianceMilliseconds Integer An integer containing the variance of the finish date of the assignment in milliseconds.
FinishVarianceTimeSpan String The time interval for the variance of the finish date of the assignment.
IsConfirmed Boolean A value that shows whether the resource has accepted the assignment.
IsLockedByManager Boolean Indicates whether the assignment has been locked for changes by a manager.
IsOverAllocated Boolean A value that indicates whether the resource is overallocated during the time of the assignment.
IsPublished Boolean A value that indicates whether the assignment is published.
IsResponsePending Boolean A value that shows whether the assignment update has been sent to the resource.
IsUpdateNeeded Boolean A value that indicates whether an assignment update should be sent to the resource.
IsWorkResource Boolean Indicates whether an assignment resource is a work resource or a material resource.
LevelingDelay String A string containing the amount of time that resource leveling can delay the assignment from its early start date.
LevelingDelayMilliseconds Integer An integer containing the amount of time that resource leveling can delay the assignment from its early start date in milliseconds.
LevelingDelayTimeSpan String The time interval for the amount of time that resource leveling can delay the assignment from its early start date.
Modified Datetime The date when the assignment was modified.
Notes String Comments about the assignment.
OvertimeCost Decimal The total overtime cost of the assignment.
OvertimeWork String A string containing the amount of overtime that is scheduled to be performed on the assignment.
OvertimeWorkMilliseconds Integer An integer containing the amount of overtime that is scheduled to be performed on the assignment in milliseconds.
OvertimeWorkTimeSpan String The time interval for the amount of overtime that is scheduled to be performed on the assignment.
PercentWorkComplete Integer The amount of work that has been done on the assignment, expressed as a percentage of the total work.
RegularWork String A string containing the total amount of nonovertime work that is scheduled to be performed on the assignment.
RegularWorkMilliseconds Integer An integer containing the total amount of nonovertime work that is scheduled to be performed on the assignment in milliseconds.
RegularWorkTimeSpan String The time interval for the total amount of nonovertime work that is scheduled to be performed on the assignment.
RemainingCost Decimal The total remaining cost of the assignment, as scheduled.
RemainingOvertimeCost Decimal The scheduled remaining overtime cost of the assignment.
RemainingOvertimeWork String A string containing the amount of remaining scheduled overtime work on the assignment.
RemainingOvertimeWorkMilliseconds Integer An integer containing the amount of remaining scheduled overtime work on the assignment in milliseconds.
RemainingOvertimeWorkTimeSpan String The time interval for the amount of remaining scheduled overtime work on the assignment.
RemainingWork String A string containing the amount of time, such as person-hours or days, that is still required to complete the assignment.
RemainingWorkMilliseconds Integer An integer containing the amount of time, in milliseconds, that is still required to complete the assignment.
RemainingWorkTimeSpan String The time interval for the amount of time, such as person-hours or days, that is still required to complete the assignment
ResourceCapacity Double Indicates how much work the resource performs on the assignment, expressed as a percentage of the resource's theoretical full capacity.
Resume Datetime The date and time when a resource resumes work on the assignment.
ScheduleCostVariance Decimal The schedule cost variance (CV), which is the difference between the baseline cost and the scheduled cost of the assignment.
Start Datetime The date and time that a resource is scheduled to start the assignment.
StartVariance String A string containing the variance of the assignment start date.
StartVarianceMilliseconds Integer An integer containing the variance of the assignment start date in milliseconds.
StartVarianceTimeSpan String The time interval for the variance of the assignment start date.
Stop Datetime The date and time when a resource stops work on the assignment.
Work String A string containing the total amount of time that is scheduled for the assignment.
WorkContourType Integer Determines how work for an assignment is to be distributed across the duration of the assignment.
WorkMilliseconds Integer An integer containing the total amount of time that is scheduled for the assignment in milliseconds.
WorkTimeSpan String The time interval for the total amount of time that is scheduled for the assignment.
WorkVariance String A string containing the difference between baseline work and currently scheduled work on the assignment.
WorkVarianceMilliseconds Integer An integer containing the difference between baseline work and currently scheduled work on the assignment.
WorkVarianceTimeSpan String The time interval for the difference between baseline work and currently scheduled work on the assignment.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0