CData SSIS Components for Microsoft Project 2019J - Online Help

Projects

CData SSIS Components for Microsoft Project 2019J - Build 19.0.7354

Create, update, delete, and query Projects entries.

テーブル固有の情報

Select

Projects テーブルに対して実行されるフィルタは、本製品 内のクライアント側で処理されます。 SupportEnhancedSQL をfalse に設定すると、クライアント側の実行をオフにできます。その場合、検索条件でエラーが発生します。

Insert

Project を挿入するには、少なくともName カラムを指定する必要があります。挿入する際は、Name、StartDate、およびDescripton フィールドのみが指定できます。他のフィールドの値を変更するには、後続のUPDATE ステートメントを使用してください。

INSERT INTO Projects (Name,StartDate) VALUES ('New Project','2017-05-16 09:41')

Update

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

UPDATE Projects SET Name='new name', Description='new desc' WHERE Id='4aa966f0-c449-459a-ba81-2de3511c6112'

Delete

Project を削除するには、Id を指定する必要があります。

Delete FROM Projects WHERE Id='4aa966f0-c449-459a-ba81-2de3511c6112'

Columns

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

The unique identifier of the project.

ApprovedEnd Datetime False false

The approved end date in the project portfolio planner.

ApprovedStart Datetime False false

The approved start date in the project portfolio planner.

CalculateActualCosts Boolean True false

Indicates whether Project Server automatically calculates actual and remaining work and costs.

CalculatesActualCosts Boolean True false

Indicates whether the project always calculates actual costs.

CheckOutDescription String False false

The description of the current checkout action for the project.

CheckOutId String False false

The unique identifier that is associated with the current check out.

CheckedOutDate Datetime True false

The date when project was checked out.

CreatedDate Datetime True false

The date when the project was created.

CriticalSlackLimit Integer False false

The number of days that a task can go past its end date before the project marks that task as critical.

CurrencyCode String False false

The currency code of the project, as defined in ISO 4217.

CurrencyDigits Integer False false

The number of decimal digits in currency values.

CurrencyPosition Integer False false

The placement of the currency symbol in relation to the currency value.

CurrencySymbol String False false

The currency symbol that represents the type of currency that is used in the project.

CurrentDate Datetime True false

The current date for the project.

DaysPerMonth Integer False false

The default number of working days per month.

DefaultEffortDriven Boolean False false

Indicates whether the scheduling of new tasks is effort-driven.

DefaultEstimatedDuration Boolean False false

Indicates whether new tasks have estimated durations.

DefaultFinishTime Datetime True false

The default end time of a working day.

DefaultFixedCostAccrual Integer False false

Indicates which default fixed cost accrual method to use on new tasks.

DefaultOvertimeRate Integer False false

The default overtime rate.

DefaultOvertimeRateUnits Integer False false

The time unit for the default overtime rate.

DefaultStandardRate Integer False false

The default standard rate.

DefaultStandardRateUnits Integer False false

The time unit for the default standard rate.

DefaultStartTime Datetime True false

The default start time of a working day.

DefaultTaskType Integer False false

The default type for tasks in the project.

DefaultWorkFormat Integer False false

The default format for work duration.

Description String False false

The project description.

FinishDate Datetime False false

The project finish date.

FiscalYearStartMonth Integer False false

The number of the first month in the fiscal year.

HonorConstraintegers Boolean False false

Indicates whether scheduling constraints take precedence over dependencies.

IsCheckedOut Boolean False false

A boolean value that indicates whether the project is checked out.

LastPublishedDate Datetime True false

The most recent date when the project was published.

LastSavedDate Datetime True false

The most recent date when the project was saved.

MinutesPerDay Integer False false

The default number of minutes per day.

MinutesPerWeek Integer False false

The default number of minutes per week.

MoveActualIfLater Boolean False false

Indicates whether to move the end date of completed parts forward to the status date, if the actual end date falls before the status date.

MoveActualToStatus Boolean False false

Indicates whether to move the end date of completed parts back to the status date, if the actual end data falls after the status date.

MoveRemainingIfEarlier Boolean False false

Indicates whether to move the start date of remaining parts forward to the status date, if the actual start date falls before the status date.

MoveRemainingToStatus Boolean False false

Indicates whether to move the start date of the remaining parts back to the status date, if the actual start date falls after the status date.

MultipleCriticalPaths Boolean False false

Indicates whether to calculate multiple critical paths.

Name String False true

The project name.

NewTasksAreManual Boolean False false

Indicates whether new tasks are manually scheduled.

NumberFiscalYearFromStart Boolean False false

Indicates whether to use the project start year for fiscal year numbering.

OptimizerDecision Integer False false

The result of the Optimizer in a project portfolio analysis.

PercentComplete Integer False false

The percentage complete of the project summary task.

PlannerDecision Integer False false

The result of the Planner in a project portfolio analysis.

ProjectIdentifier String False false

The project secondary identifer.

ProjectType Integer False false

The type of project (standard project, template, master project, or subproject).

ProtectedActualsSynch Boolean False false

Indicates whether the project actuals are synchronized with the protected actuals.

ScheduledFromStart Boolean False false

Indicates whether the project is scheduled from the start date instead of the finish date.

ShowEstimatedDurations Boolean False false

Indicates whether a question mark is displayed after an estimated duration for a task.

SplitInProgress Boolean False false

Indicates whether to split tasks that are in progress.

SpreadActualCostsToStatus Boolean False false

Indicates whether the consideration period for actual costs is spread to the status date or to the stop date.

SpreadPercentCompleteToStatus Boolean False false

Indicates whether the consideration period for task percentage complete is spread to the status date or to the task finish date.

StartDate Datetime False false

The project start date.

StatusDate Datetime True false

The current status date for the project.

SummaryTaskId String False false

The unique identifier of the summary task.

TrackingMode Integer False false

The default tracking method for all assignments in the project.

UtilizationDate Datetime False false

The start date and time for use of the resource plan.

UtilizationType Integer False false

An enumerated value that represents the utilization type of a resource plan.

WeekStartDay Integer False false

The day of the week on which a work week starts.

WinprojVersion Double False false

The version of Project Professional that created the draft project.

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