Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Element

Data Type

Required?

Default

Description

Sample Data

BillingAdjustedRevenue

Double

On Insert: No

On Update: No

The billing adjusted revenue amount associated with the project time baseline bucket/interval. This is applicable only when billing adjusted revenue is set as an active metric (i.e. BarMetricActiveFlag = true).


ChargeableMinutes

Int32

On Insert: No

On Update: No

The chargeable minutes associated with the project time baseline bucket/interval. This is applicable only when chargeable hours is set as an active mentric (i.e. ChgMetricActiveFlag = true).


ContractRevenue

Double

On Insert: No

On Update: No

The contract revenue associated with the project time baseline bucket/interval. This is applicable only when the contract revenue is set as an active metric (i.e. CrMetricActiveFlag = true).


DepartmentIdentity

PwsDepartmentRef

On Insert: Yes (if the project time baseline "Dimension" is set to "D" for department)

On Update: No

The department associated with the project time baseline bucket/interval. This is applicable only when the dimension is set to resource department (i.e. Dimension = "D").


EndDate

DateTime

On Insert: Yes

On Update: No

The end date of the project time baseline bucket/ interval.


ProjectRateTypeIdentity

PwsProjectRateTypeRef

On Insert: Yes (if the project time baseline "Dimension" is set to "M" for rate type)

On Update: No

The rate type associated with the project time baseline bucket/interval. This is applicable only when the dimension is set to rate type (i.e. Dimension = "M").


ProjectRoleIdentity

PwsProjectRoleRef

On Insert: Yes (if the project time baseline "Dimension" is set to "R" for role)

On Update: No

The role associated with the project time baseline bucket/interval. This is applicable only when the dimension is set to role (i.e. Dimension = "R").


ProjectTaskTypeIdentity

PwsProjectTaskTypeRef

On Insert: Yes (if the project time baseline "Dimension" is set to "K" for task type)

On Update: No

The task type associated with the project time baseline bucket/interval. This is applicable only when the dimension is set to task type (i.e. Dimension = "K").


ResourceDirectCost

Double

On Insert: No

On Update: No

The resource direct cost amount associated with the project time baseline bucket/interval. This is applicable only when resource direct cost is set as an active metric (RdcMetricActiveFlag = true).


ResourceIdentity

PwsResourceRef

On Insert: Yes (if the project time baseline "Dimension" is set to "S" for task type)

On Update: No

The resource associated with the project time baseline bucket/interval. This is applicable only when the dimension is set to resource (i.e. Dimension = "S").


StartDate

DateTime

On Insert: Yes (unless it is the first bucket/interval in the baseline)

On Update: No

The start date (in midnight UTC) of the project cost baseline bucket/interval.  


TitleIdentity

PwsTitleRef

On Insert: Yes (if the project time baseline "Dimension" is set to "T" for department)

On Update: No

The resource title associated with the project time baseline bucket/interval. This is applicable only when the dimension is set to resource title (i.e. Dimension = "T").


WorkMinutes

Int32

On Insert: No

On Update: No

The work minutes associated with the project time baseline bucket/interval. This is applicable only when hours is set as an active metric (HrsMetricActiveFlag = true)


...