Parameter | Description |
sectionName | Section name. Mandatory. |
includeDetails | Whether to include an initiative’s description, creation date, and latest modification date. Mandatory. |
Column name | Description |
Id | Initiative ID (integer number) |
Name | Initiative name |
Description | Initiative description |
MeasureName | Initiative measure name |
LocationName | Initiative location name |
CreationDate | Initiative creation date |
ModificationDate | Initiative latest modification date |
IsFavourite | Whether the initiative is a favorite for a user |
IsHidden | Whether the initiative is hidden |
IsRoot | Whether the initiative is a root initiative |
HasChildren | Whether the initiative has children |
Level | Initiative level (integer number) |
ParentId | Initiative parent ID (integer number) |
Sequence | Initiative sequence number as a child (integer number) |
Weight | Initiative weight (floating point number) |
StartDate_A | Actual start date |
StartDate_F | Forecasted start date |
StartDate_P | Planned start date |
StartDate_AvF | Actual vs. Forecasted start date deviation |
StartDate_AvF_RangeName | Actual vs. Forecasted start date performance range name |
StartDate_AvF_Color | Actual vs. Forecasted start date performance range background color |
StartDate_AvF_Text Color | Actual vs. Forecasted start date performance range text color |
StartDate_AvP | Actual vs. Planned start date deviation |
StartDate_AvP_RangeName | Actual vs. Planned start date performance range name |
StartDate_AvP_Color | Actual vs. Planned start date performance range background color |
StartDate_AvP_Text Color | Actual vs. Planned start date performance range text color |
StartDate_FvP | Forecasted vs. Planned start date deviation |
StartDate_FvP_RangeName | Forecasted vs. Planned start date performance range name |
StartDate_FvP_Color | Forecasted vs. Planned start date performance range background color |
StartDate_FvP_Text Color | Forecasted vs. Planned start date performance range text color |
EndDate_A | Actual end date |
EndDate_F | Forecasted end date |
EndDate_P | Planned end date |
EndDate_AvF | Actual vs. Forecasted end date deviation |
EndDate_AvF_RangeName | Actual vs. Forecasted end date performance range name |
EndDate_AvF_Color | Actual vs. Forecasted end date performance range background color |
EndDate_AvF_Text Color | Actual vs. Forecasted end date performance range text color |
EndDate_AvP | Actual vs. Planned end date deviation |
EndDate_AvP_RangeName | Actual vs. Planned end date performance range name |
EndDate_AvP_Color | Actual vs. Planned end date performance range background color |
EndDate_AvP_Text Color | Actual vs. Planned end date performance range text color |
EndDate_FvP | Forecasted vs. Planned end date deviation |
EndDate_FvP_RangeName | Forecasted vs. Planned end date performance range name |
EndDate_FvP_Color | Forecasted vs. Planned end date performance range background color |
EndDate_FvP_Text Color | Forecasted vs. Planned end date performance range text color |
BudgetDate_A | Actual budget |
BudgetDate_F | Forecasted budget |
BudgetDate_P | Planned budget |
BudgetDate_AvF | Actual vs. Forecasted budget deviation |
BudgetDate_AvF _RangeName | Actual vs. Forecasted budget performance range name |
BudgetDate_AvF _Color | Actual vs. Forecasted budget performance range background color |
BudgetDate_AvF _TextColor | Actual vs. Forecasted budget performance range text color |
BudgetDate_AvP | Actual vs. Planned budget deviation |
BudgetDate_AvP _RangeName | Actual vs. Planned budget performance range name |
BudgetDate_AvP _Color | Actual vs. Planned budget performance range background color |
BudgetDate_AvP _TextColor | Actual vs. Planned budget performance range text color |
BudgetDate_FvP | Forecasted vs. Planned budget deviation |
BudgetDate_FvP _RangeName | Forecasted vs. Planned budget performance range name |
BudgetDate_FvP _Color | Forecasted vs. Planned budget performance range background color |
BudgetDate_FvP _TextColor | Forecasted vs. Planned budget performance range text color |
PercentComplete | Percent completed (floating point number) |
Rating | User rating (floating point number) |
Rating_RangeName | User rating performance range name |
Rating_Color | User rating performance range background color |
Rating_TextColor | User rating performance range text color |