CData SSIS Components for Microsoft Project 2019J - Online Help

ProjectResources

CData SSIS Components for Microsoft Project 2019J - Build 19.0.7354

Create, update, delete, and query ProjectResources entries.

テーブル固有の情報

Select

WHERE 句にProjectId が指定されていない場合は、次のクエリのように、すべてのプロジェクトからのリソースが返されます。

SELECT * FROM [ProjectResources]

ProjectId をWHERE 句に指定すると、他のフィルタが本製品 のクライアント側で実行される一方、本製品 はMicrosoft Project API を使用してProjectId による結果をフィルタリングします。例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM [ProjectResources] WHERE ProjectId='4aa966f0-c449-459a-ba81-2de3511c6112' 
SupportEnhancedSQL をfalse に設定すると、クライアント側の実行をオフにできます。その場合、その他のカラムを参照する検索条件でエラーが発生します。

Insert

ProjectResources エンティティを挿入するには、ProjectId カラムを指定する必要があります。

INSERT INTO ProjectResources(Name,ProjectId) VALUES('New Resource','27b489b4-6456-e711-80db-00155dc03e04')

Update

ProjectResources エンティティを更新するには、Id とProjectId カラムが必須です。

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

Delete

ProjectResources エンティティを削除するには、Id とProjectId カラムが必須です。

DELETE FROM ProjectResources 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 project resource.

ProjectId [KEY] String False true

The unique identifier of the project.

ActualCost Decimal False false

The costs incurred for work that has been performed by the project resource, along with any other recorded costs.

ActualCostWorkPerformed String False false

A string containing the actual cost for work that has been performed by the project resource to date.

ActualCostWorkPerformedMilliseconds Integer False false

An integer containing containing the actual cost for work that has been performed by the project resource to date in milliseconds.

ActualCostWorkPerformedTimeSpan String False false

The time interval for the actual cost for work that has been performed by the project resource to date.

ActualOvertimeCost Decimal False false

The actual cost incurred for overtime work that has been performed by the project resource.

ActualOvertimeWork String False false

A string containing the actual amount of overtime work that has been performed by the project resource.

ActualOvertimeWorkMilliseconds Integer False false

An integer containing the actual amount of overtime work that has been performed by the project resource in milliseconds.

ActualOvertimeWorkTimeSpan String False false

The time interval for the actual amount of overtime work that has been performed by the project resource.

ActualWork String False false

A string containing the actual amount of work that has already been performed by the project resource.

ActualWorkMilliseconds Integer False false

An integer containing the actual amount of work that has already been performed by the project resource in milliseconds.

ActualWorkTimeSpan String False false

The time interval for the actual amount of work that has already been performed by the project resource.

AvailableFrom Datetime False false

The starting date that the project resource is available for work, at the units specified for the current time period.

AvailableTo Datetime False false

The end date that the project resource is available for work, at the units specified for the current time period.

BaselineCost Decimal False false

The planned total cost for work to be performed by the project resource.

BaselineWork String False false

A string containing the planned amount of work to be performed by the project resource.

BaselineWorkMilliseconds Integer False false

An integer containing the planned amount of work to be performed by the project resource in milliseconds.

BaselineWorkTimeSpan String False false

The time interval for the planned amount of work to be performed by the project resource.

BudetCostWorkPerformed Decimal False false

The budgeted cost for work performed by the project resource to date.

BudgetedCost Decimal False false

The total budgeted cost for work performed by the project resource.

BudgetedCostWorkScheduled Decimal False false

The budgeted cost of scheduled work for the project resource.

BudgetedWork String False false

A string containing the total budgeted amount of work to be performed by the project resource.

BudgetedWorkMilliseconds Integer False false

An integer containing the total budgeted amount of work to be performed by the project resource in milliseconds.

BudgetedWorkTimeSpan String False false

The time interval for the total budgeted amount of work to be performed by the project resource.

CanLevel Boolean False false

A value that indicates whether resource leveling can be performed on the resource.

Code Integer False false

Any code, abbreviation, or number that is entered as part of the information about the resource.

Cost Decimal False false

The total scheduled or estimated cost for work that has been performed, and work that remains to be performed, by the project resource.

CostAccrual Decimal False false

A value that represents how and when to charge resource costs to the cost of a task.

CostCenter Integer False false

Any code, abbreviation, or number that has been entered as part of the information about the resource.

CostPerUse Decimal False false

The cost per use of the resource.

CostVariance Decimal False false

The difference between the baseline cost and actual cost for the project resource.

CostVarianceAtCompletion Decimal False false

The difference between the baseline cost and actual cost of the project resource at the completion of a project.

Created Datetime True false

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

CurrentCostVariance Decimal False false

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

DefaultBookingType Integer False false

The default booking type for the resource.

Email String False false

The email address of the resource.

Finish Datetime False false

The date when the project resource is scheduled to complete work on all assigned tasks.

Group String False false

The name of a group to which a project resource belongs.

Initials String False false

The short name for the resource.

IsBudgeted Boolean False false

A value that indicates whether the project resource is used for budgeting purposes or is a regular resource.

IsGenericResource Boolean False false

A value that indicates whether the project resource is a generic placeholder.

IsOverAllocated Boolean False false

A value that indicates whether the project resource is assigned to do more work on all assigned tasks than can be done within the normal working capacity.

MaterialLabel String False false

The unit of measure for supplies or other consumable items that are used in a project.

MaximumCapacity Integer False false

The percentage, or the number of units, that represent the maximum capacity for which the resource is available during the current time period.

Modified Datetime True false

The date of modification.

Name String False true

The name of the project resource.

Notes String False false

Comments entered about the project resource.

OvertimeCost Decimal False false

The total overtime cost for a project resource on all assigned tasks.

OvertimeRate Decimal False false

The hourly rate of pay for overtime for the resource.

OvertimeRateUnits Integer False false

The rate description format in which the overtime rate is displayed.

OvertimeWork String False false

A string containing the amount of overtime work that is scheduled to be performed on all tasks assigned to the project resource and that is charged at the overtime rates of the project resource involved.

OvertimeWorkMilliseconds Integer False false

An integer containing the amount of overtime work in milliseconds that is scheduled to be performed on all tasks assigned to the project resource and that is charged at the overtime rates of the project resource involved.

OvertimeWorkTimeSpan String False false

The time interval for the amount of overtime work that is scheduled to be performed on all tasks assigned to the project resource and that is charged at the overtime rates of the project resource involved.

PeakWork String False false

The maximum effort that the project resource is scheduled to work on all assigned tasks.

PeakWorkMilliseconds Integer False false

The maximum effort that the project resource is scheduled to work on all assigned tasks in milliseconds.

PeakWorkTimeSpan String False false

The duration of the maximum effort that the project resource is scheduled to work on all assigned tasks.

PercentWorkComplete Integer False false

The current status of the project resource, expressed as the percentage of work that has been completed by the project resouce.

Phonetics String False false

The phonetic information in either the Japanese Hiragana writing system or the Katakana writing system for resource names.

RegularWork String False false

A string containing the total amount of non-overtime work that is scheduled to be performed by the project resource.

RegularWorkMilliseconds Integer False false

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

RegularWorkTimeSpan String False false

The time interval for the total amount of non-overtime work that is scheduled to be performed by the project resource.

RemainingCost Decimal False false

The remaining scheduled expense that will be incurred by the project resource in completing the remaining scheduled work.

RemainingOvertimeCost Decimal False false

The remaining scheduled overtime expense for the project resource.

RemainingOvertimeWork String False false

A string containing the amount of remaining scheduled overtime work for the project resource.

RemainingOvertimeWorkMilliseconds Integer False false

An integer containing the amount of remaining scheduled overtime work for the project resource in milliseconds.

RemainingOvertimeWorkTimeSpan String False false

The time interval for the amount of remaining scheduled overtime work for the project resource.

RemainingWork String False false

A string containing the amount of time, such as person-hours or days, that is still required for the project resource to complete a task or set of tasks.

RemainingWorkMilliseconds Integer False false

An integer containing the amount of time, in milliseconds, that is still required for the project resource to complete a task or set of tasks.

RemainingWorkTimeSpan String False false

The time interval for the amount of time, such as person-hours or days, that is still required for the project resource to complete a task or set of tasks.

ScheduleCostVariance Decimal False false

The scheduled cost variance for the project resource.

StandardRate Decimal False false

The rate of pay per hour for regular, non-overtime work that is performed by the resource.

StandardRateUnits Decimal False false

The rate description format in which the standard rate is displayed.

Start Datetime False false

The date when an assigned resource is scheduled to begin working on a task

Work String False false

A string containing the total amount of time to which the project resource is scheduled for a task.

WorkMilliseconds Integer False false

An integer containing the total amount of time to which the project resource is scheduled for a task in milliseconds.

WorkTimeSpan String False false

The time interval for the total amount of time to which the project resource is scheduled for a task.

WorkVariance String False false

A string containing the difference between baseline work of a project resource and the currently scheduled work.

WorkVarianceMilliseconds Integer False false

An integer containing the difference between baseline work of a project resource and the currently scheduled work in milliseconds.

WorkVarianceTimeSpan String False false

The time interval for the difference between baseline work of a project resource and the currently scheduled work.

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