CData SSIS Components for Microsoft Project 2019J - Online Help

Tasks

CData SSIS Components for Microsoft Project 2019J - Build 19.0.7354

Create, update, delete, and query Tasks entries.

テーブル固有の情報

Select

フィルタが指定されていない場合は、次のクエリのように、すべてのProject Tasks が返されます。

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

Insert

Task を挿入するには、少なくともProjectId とName を指定する必要があります。

INSERT INTO Tasks(Name,ProjectId) VALUES('New Task','4aa966f0-c449-459a-ba81-2de3511c6112')

Update

Task を更新するには、ProjectId とId を指定する必要があります。

UPDATE Tasks SET Name='New Name' where ProjectId='4aa966f0-c449-459a-ba81-2de3511c6112' and Id='6b643009-4a2f-e711-a9d5-005056c00008'

Delete

Task を削除するには、Id とProjectId が必須です。

DELETE FROM Tasks WHERE ProjectId='4aa966f0-c449-459a-ba81-2de3511c6112' AND Id='6b643009-4a2f-e711-a9d5-005056c00008'

Columns

Name Type ReadOnly Required Description
Id [KEY] String True false

The unique identifier of the task.

ProjectId [KEY] String True true

The unique identifier of the project.

ActualCost Double False false

The costs incurred for work already performed on a task, together with any other recorded costs that are associated with a task.

ActualCostWorkPerformed Double False false

The costs incurred for work already performed on a task to date.

ActualDuration String False false

A string containing the span of active working time that is required to complete a task.

ActualDurationMilliseconds Integer False false

An integer containing the span of active working time that is required to complete a task in milliseconds.

ActualDurationTimeSpan String False false

The total time interval for the span of active working time that is required to complete a task.

ActualFinish Datetime False false

The date and time when a task is complete.

ActualOvertimeCost Integer False false

The costs incurred for overtime work already performed on a task.

ActualOvertimeWork String False false

A string containing the actual amount of overtime work already performed on a task.

ActualOvertimeWorkMilliseconds Integer False false

An integer containing the actual amount of overtime work already performed on a task.

ActualOvertimeWorkTimeSpan String False false

The time interval for the actual amount of overtime work already performed on a task.

ActualStart Datetime False false

The date and time that a task actually began, based on progress information that has been entered.

ActualWork String False false

A string containing the amount of work that has already been performed on a task.

ActualWorkMilliseconds Integer False false

An integer containing the amount of work that has already been performed on a task.

ActualWorkTimeSpan String False false

The time interval for the amount of work that has already been performed on a task.

BaselineCost Integer False false

The total planned cost for the task.

BaselineDuration String False false

A string containing the original span of time that is planned to complete the task, established at the time of the project baseline.

BaselineDurationMilliseconds Integer False false

An integer containing the original span of time that is planned to complete the task in milliseconds, established at the time of the project baseline.

BaselineDurationTimeSpan String False false

The total time interval for the original span of time that is planned to complete the task, established at the time of the project baseline.

BaselineFinish Datetime False false

The planned task completion date that was set at the time that the baseline was saved.

BaselineStart Datetime False false

The planned task start date that was set at the time that the baseline was saved.

BaselineWork String False false

A string containing the total planned person-hours that are scheduled for a task, as established at the time of the project baseline.

BaselineWorkMilliseconds Integer False false

An integer containing the total planned person-hours that are scheduled for a task in milliseconds, as established at the time of the project baseline.

BaselineWorkTimeSpan String False false

The total time interval for the total planned person-hours that are scheduled for the task, as established at the time of the project baseline.

BudgetCost Integer False false

The budget costs for budget cost resources.

BudgetWork String False false

A string containing the amount of work that is estimated to be performed on a task.

BudgetWorkMilliseconds Integer False false

An integer containing the amount of work that is estimated to be performed on a task.

BudgetWorkTimeSpan String False false

The time interval for the amount of work that is estimated to be performed on a task.

BudgetedCostWorkPerformed Double False false

The estimated cost of work performed to date on a task.

BudgetedCostWorkScheduled Double False false

The estimated cost of scheduled work on a task.

Completion Datetime False false

The completion date for a task.

ConstraintStartEnd Datetime False false

A constraint start date or end date for a task.

ConstraintType Integer False false

The time constraint type for a task.

Contact String False false

A task contact.

Cost Double False false

The total scheduled or projected cost based on costs already incurred for work performed on a task, in addition to the costs planned for the remaining work.

CostPerformanceIndex Double False false

The ratio of the baseline costs of work that has been performed on the task to the actual costs of work that has been performed, calculated up to the project status date or today's date.

CostVariance Double False false

The difference between the baseline cost and the total cost for the task.

CostVarianceAtCompletion Double False false

The difference between the baseline cost and the total cost at the completion of the task.

CostVariancePercentage Integer False false

The ratio of cost variance (CV) to the budgeted cost of work that has been performed on the task (BCWP), expressed as a percentage.

Created Datetime True false

The date and the time when the task was added to the project.

CurrentCostVariance Double False false

The difference between the baseline cost and the actual cost of the project resource to date.

Deadline Datetime False false

The date that was entered as a deadline for a task.

Duration String False false

A string containing the amount of time that it takes to complete a task.

DurationMilliseconds Integer False false

An integer containing the amount of time that it takes to complete a task in milliseconds.

DurationTimeSpan String False false

The time interval for the amount of time that it takes to complete a task.

DurationVariance String False false

A string containing he difference between the baseline duration of the task and the total duration, or current estimated duration, of the task.

DurationVarianceMilliseconds Integer False false

An integer containing he difference between the baseline duration of the task and the total duration, or current estimated duration, of the task in milliseconds.

DurationVarianceTimeSpan String False false

The total time interval for the difference between the baseline duration of the task and the total duration, or current estimated duration, of the task.

EarliestFinish Datetime False false

The earliest date that the task could possibly finish, based on the early finish dates of predecessor and successor tasks, other constraints, and any leveling delay.

EarliestStart Datetime False false

The earliest date that the task could possibly begin, based on the early start dates of predecessor and successor tasks and other constraints.

EstimateAtCompletion Double False false

The estimate cost at completion (EAC) for the task.

Finish Datetime False false

The task finish date.

FinishSlack String False false

A string containing the duration between the EarlyFinish date and the LateFinish date.

FinishSlackMilliseconds Integer False false

An integer containing the duration between the EarlyFinish date and the LateFinish date in milliseconds.

FinishSlackTimeSpan String False false

The total time interval of planned person-hours scheduled for an assignment, at the time of the project baseline.

FinishText Datetime False false

A datetime value containing the task finish date.

FinishVariance String False false

A string containing the time that represents the difference between the baseline finish date of the task and the current finish date.

FinishVarianceMilliseconds Integer False false

An integer containing the time that represents the difference between the baseline finish date of the task and the current finish date in milliseconds.

FinishVarianceTimeSpan String False false

The time interval for the variance of the finish date of the task.

FixedCost Integer False false

Any non-resource task expense.

FixedCostAccrual Integer False false

The choices for how and when fixed costs are to be charged to the cost of a task.

FreeSlack String False false

A string containing the amount of time that the task can be delayed without delaying successor tasks.

FreeSlackMilliseconds Integer False false

An integer containing the amount of time that the task can be delayed without delaying successor tasks in milliseconds.

FreeSlackTimeSpan String False false

The amount of time that the task can be delayed without delaying successor tasks.

IgnoreResourceCalendar Boolean False false

Indicates whether the scheduling of the task takes into account the calendars of the resources assigned to the task.

IsActive Boolean False false

Indicates whether a task is active.

IsCritical Boolean False false

Indicates whether the timing for the task is critical or whether there can be any slack in the timing.

IsEffortDriven Boolean False false

Indicates whether the scheduling of a task is effort-driven.

IsExternalTask Boolean False false

Indicates whether this is a ghost task from another project created by Project Professional.

IsLockedByManager Boolean False false

Indicates whether a task has been locked for changes by a manager.

IsManual Boolean False false

Indicates whether a task is manually scheduled.

IsMarked Boolean False false

Indicates whether a task has been marked as having special meaning.

IsMilestone Boolean False false

Indicates whether a task is a milestone.

IsOverAllocated Boolean False false

Indicates whether the task is overallocated.

IsRecurring Boolean False false

Indicates whether the task is part of a recurring series.

IsRecurringSummary Boolean False false

Indicates whether the task is the parent of a recurring series.

IsRolledUp Boolean False false

Indicates whether information on the subtask Gantt bars is rolled up to the summary task bar.

IsSubProject Boolean False false

Indicates whether the task represents a subproject.

IsSubProjectReadOnly Boolean False false

Indicates whether a subproject for this task is read-only.

IsSubProjectScheduledFromFinish Boolean False false

Indicates whether a subproject for this task is set to schedule from finish.

IsSummary Boolean False false

Indicates whether the task is a summary task.

LatestFinish Datetime False false

The latest date that the task can finish without delaying the finish of the project.

LatestStart Datetime False false

The latest date that the task can start without delaying the finish of the project.

LevelingAdjustsAssignments Boolean False false

Indicates whether leveling can delay or split assignments (rather than the task itself) to resolve overallocations.

LevelingCanSplit Boolean False false

Indicates whether leveling can interrupt and split a task.

LevelingDelay String False false

A string containing the amount of time that leveling can delay a task from its early start.

LevelingDelayMilliseconds Integer False false

An integer containing the amount of time that leveling can delay a task from its early start in milliseconds.

LevelingDelayTimeSpan String False false

The time interval for the amount of time that leveling can delay a task from its early start.

Modified Datetime True false

The modified date.

Name String False true

The name of a task.

Notes String False false

The notes about the task.

OutlineLevel Integer False false

The task outline level in a hierarchical task list.

OutlinePosition String False false

The position of the task in the project outline hierarchy.

OvertimeCost Integer False false

The total overtime cost for the task.

OvertimeWork String False false

A string containing the amount of overtime scheduled to be performed on the task.

OvertimeWorkMilliseconds Integer False false

An integer containing the amount of overtime scheduled to be performed on the task in milliseconds.

OvertimeWorkTimeSpan String False false

The total time interval for the amount of overtime scheduled to be performed on the task.

PercentComplete Integer False false

The percent of duration completed on a task.

PercentPhysicalWorkComplete Integer False false

The percentage of physical work completed on a task.

PercentWorkComplete Integer False false

The current status of the task, expressed as the percentage of work that has been completed.

PreLevelingFinish Datetime False false

The finish date of the task as it was before resource leveling was performed.

PreLevelingStart Datetime False false

The start date of the task as it was before resource leveling was performed.

Priority Integer False false

The task priority.

RegularWork String False false

A string containing the total amount of non-overtime work that is scheduled to be performed on the task.

RegularWorkMilliseconds Integer False false

An integer containing the total amount of non-overtime work that is scheduled to be performed on the task in milliseconds.

RegularWorkTimeSpan String False false

The total time interval for the total amount of non-overtime work that is scheduled to be performed on the task.

RemainingCost Double False false

The remaining scheduled expense that will be incurred during completion of the remaining scheduled work on the task.

RemainingDuration String False false

A string containing the remaining task duration.

RemainingDurationMilliseconds Integer False false

An integer containing the remaining task duration in milliseconds.

RemainingDurationTimeSpan String False false

The time interval for the remaining task duration.

RemainingOvertimeCost Integer False false

The remaining scheduled overtime expense for the task.

RemainingOvertimeWork String False false

A string containing the amount of time, such as person-hours or days, that is required to complete the remaining overtime work for a task.

RemainingOvertimeWorkMilliseconds Integer False false

An integer containing the amount of time that is required to complete the remaining overtime work for a task in milliseconds.

RemainingOvertimeWorkTimeSpan String False false

The total time interval for the amount of time, such as person-hours or days, that is required to complete the remaining overtime work for a task.

RemainingWork String False false

A string containing the time, such as person-hours or days, that is required to complete the task or set of tasks.

RemainingWorkMilliseconds Integer False false

An integer containing the time that is required to complete the task or set of tasks in milliseconds.

RemainingWorkTimeSpan String False false

The total time interval for the time, such as person-hours or days, that is required to complete the task or set of tasks.

Resume Datetime False false

The date that the remaining part of the task is scheduled to resume after progress is entered.

ScheduleCostVariance Double False false

The difference in cost terms between the current progress and the baseline planned progress for a resource on the task.

SchedulePerformanceIndex Double False false

The ratio of the budgeted cost of work performed to the budgeted cost of work scheduled.

ScheduleVariancePercentage Integer False false

The ratio of schedule variance (SV) to budgeted cost of work scheduled (BCWS), expressed as a percentage.

ScheduledDuration String False false

A string containing the total span of active working time for the task as entered or as calculated based on the start date, the finish date, calendars, and other scheduling factors.

ScheduledDurationMilliseconds Integer False false

An integer containing the total span of active working time for the task as entered or as calculated based on the start date, the finish date, calendars, and other scheduling factors in milliseconds.

ScheduledDurationTimeSpan String False false

The time interval for the total span of active working time for the task as entered or as calculated based on the start date, the finish date, calendars, and other scheduling factors.

ScheduledFinish Datetime False false

The date when work on the task is scheduled to be complete as it was calculated based on the start date, the duration, dependencies, calendars, and other scheduling factors.

ScheduledStart Datetime False false

The date when work on the task is scheduled to begin as it was calculated based on dependencies, constraints, calendars, and other scheduling factors.

Start Datetime False false

The task start date.

StartSlack String False false

A string containing the duration between the EarlyStart date and the LateStart date.

StartSlackMilliseconds Integer False false

An integer containing the duration between the EarlyStart date and the LateStart date in milliseconds.

StartSlackTimeSpan String False false

The time interval for the duration between the EarlyStart date and the LateStart date.

StartText Datetime False false

A datetime value containing the task start date.

StartVariance String False false

A string that represents the difference between a baseline start date of the task and its currently scheduled start date.

StartVarianceMilliseconds Integer False false

An integer that represents the difference between a baseline start date of the task and its currently scheduled start date.

StartVarianceTimeSpan String False false

The time interval for the variance of the task start date.

Stop Datetime False false

The date that represents the end of the actual portion of the task.

TaskType Integer False false

The task type.

ToCompletePerformanceIndex Double False false

A numerical value that represents the performance index.

TotalSlack String False false

A string containing the time that the task's finish date can be delayed without delaying the project's finish date.

TotalSlackMilliseconds Integer False false

An integer containing the time that the task's finish date can be delayed without delaying the project's finish date in milliseconds.

TotalSlackTimeSpan String False false

The total time interval for the amount of time that the task finish date can be delayed without delaying the project's finish date.

UsePercentPhysicalWorkComplete Boolean False false

Indicates whether to use PercentPhysicalWorkComplete or PercentComplete to compute earned value.

Work String False false

A string containing the total time scheduled for a task.

WorkBreakdownStructure String False false

A code that identifies a location in a hierarchical structure that is used to organize tasks for reporting schedules and tracking costs.

WorkMilliseconds Integer False false

An integer containing the total time scheduled for a task in milliseconds.

WorkTimeSpan String False false

The time interval for the total time scheduled for a task.

WorkVariance String False false

A string containing the difference between baseline work and currently scheduled work on a task, expressed as, for example, the number of person-hours or days.

WorkVarianceMilliseconds Integer False false

An integer containing the difference between baseline work and currently scheduled work on a task, in milliseconds

WorkVarianceTimeSpan String False false

The total time interval for the difference between baseline work and currently scheduled work on the task.

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