This article explains what data tables are available in the OnePlan OData feed, along with some best practices when working with this data.
The information in this article is designed to get you familiar with the data in the OData feed.
This section details all of the stable, or consistent data tables that will always be available in the OData feed, regardless of how your OnePlan environment is configured.
Description: The Association table stores all of the associations between all of the different plan types. So if you connect a program to an objective, or if you connect a key result to an objective, or a project to a epic, etc., the Association table grabs all of the plan level look up fields, finds all the dependencies including multi select lookups, and lays them all out for you.
Out of the Box Links to Other Tables:
Best Practices, Tips, and Tricks:
Available Fields:
-
AssociationId
-
Field
-
PlanId
-
RelatedId
Description: The Capacity table holds data on the amount of hours that resources are available in any given month or day. There a a row per resource per month.
Out of the Box Links to Other Tables: Capacity -> Date Dimension; Capacity -> Resources
Table 1.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Capacity (ResourceID) |
-> |
Resources (UserID) |
|
Capacity (Date) |
-> |
Date Dimension (Date) |
Best Practices, Tips, and Tricks:
Available Fields:
-
ResourceId
-
Date
-
Capacity
-
Units
Description: The Costs table contains data on all financial plans create in the Financial Planner. In the Costs table, there is a line for each row of data or cost category and or detail row. This would generally be joined back to Plans table.
Out of the Box Links to Other Tables:
Table 2.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Cost (Date) |
-> |
Date Dimension (Date) |
|
Cost (WorkPlanId) |
-> |
Plans (Id) |
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
TpId
-
CostTypeId
-
CostType
-
ParentCostCategoryId
-
CostCategory
-
WorkPlanId
-
Date
-
Cost
-
DetailRow
-
ExternalId
-
IsLeaf
-
Cost_USD
-
Cost_CAD
-
Cost_AUD
-
ExpenseType
-
ExpenseType_Id
-
Description
Description: The ModelerModel table contains all of the information for a Model created in the Portfolio Modeler.
Out of the Box Links to Other Tables:
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
Name
-
Description
-
ParentId
-
Created
-
CreatedBy
-
Modified
-
ModifiedBy
-
NumberOfScenarios
Description: The ModelScenario table holds all data for Scenarios created within Models in the Portfolio Modeler. Each Model may contain one or more scenarios. Data on those Scenarios is stored in this table, and related back to the ModelerModel table using the ParentModelId.
Out of the Box Links to Other Tables:
Table 3.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
ModelerScenatio (UserId) |
-> |
Resources (UserId) |
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
Name
-
UserId
-
ParentModelId
-
Personal
-
TotalPlans
-
TotalCheckedPlans
-
TotalBenefits
-
TargetBenefits
-
TotalBudget
-
TargetBudget
-
TotalForecast
-
TargetForecast
Description: The ModelScenarioPlan table contains data on all plans that are associated with the different Scenarios in a Model. Each Scenario may contain one or more plans. Data on those plans is stored in this table, and related back to the ModelerScenario table using the ParentScenarioId.
Out of the Box Links to Other Tables:
Table 4.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
ModelerScenarioPlan (id) |
-> |
Plans (Id) |
|
ModelerScenarioPlan (Name) |
-> |
Plan_Project (Name) |
|
ModelerScenarioPlan (Name) |
-> |
Plan_Project_Epic (Name) |
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
ParentScenarioId
-
ParentScenarioName
-
Name
-
Checked
-
Priority
Description: The Plans table holds data on all of the Plans of all Plan Types in your OnePlan environment. This is the main and most important data table in the oData feed.
Out of the Box Links to Other Tables:
Table 5.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Plans (Id) |
<-> |
Plan_Project_Epic (Id) |
|
Plans (ProgramId) |
<-> |
Plan_Program (Id) |
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
Creator
-
Editor
-
Folder
-
ParentPlanId
-
ProcessStep
-
ProcessStepStart
-
ProcessStepIndex
-
Archived
-
PlanType
-
PlanId
-
PortfolioPriority
-
Summary_Milestone
-
State_Id
-
State_Value
-
Priority_Id
-
Priority_Value
-
Budget
-
TimesheetHours
-
TimesheetType_Id
-
TimesheetType_Value
-
TimesheetChargeLevel_Id
-
TimesheetChargeLevel_Value
-
EstimatedStart
-
EstimatedEnd
-
ExecutiveSponsor
-
ExecutiveSponsor_Value
-
Manager
-
Manager_Value
-
Stage_Id
-
Stage_Value
-
ProjectType_Id
-
ProjectType_Value
-
BusinessUnit_Id
-
BusinessUnit_Value
-
Forecast
-
RemainingBudget
-
BudgetVariance
-
Benefits
-
ROI
-
FundingAvailable
-
FundingSource_Id
-
FundingSource_Value
-
CommittedEffort
-
ScheduledEffort
-
RemainingEffort
-
EffortVariance
-
OverallHealth_Id
-
OverallHealth_Value
-
ScheduleHealth_Id
-
ScheduleHealth_Value
-
FinancialHealth_Id
-
FinancialHealth_Value
-
EffortHealth_Id
-
EffortHealth_Value
-
IssueHealth_Id
-
IssueHealth_Value
-
NeedsStaffing
-
StrategicAlignment_Id
-
StrategicAlignment_Value
-
LowerCost_Id
-
LowerCost_Value
-
ImproveEmployeeRetention_Id
-
ImproveEmployeeRetention_Value
-
Risk_Id
-
Risk_Value
-
PrioritizationScore
-
Actuals
-
PowerAppID
-
Goals_Id
-
Goals_Value
-
Description
-
BusinessCase
-
ValueStatement
-
Accomplishments
-
PlannedActivities
-
AdditionalComments
-
PlanType_EnterpriseProject_Id
-
PlanType_EnterpriseProject_Value
-
PlanType_Program_Id
-
PlanType_Program_Value
-
ProgramBudget
-
RemainingBudgetAllocation
-
JiraProjectNames_Id
-
JiraProjectNames_Value
-
TeamProjectsAreas_Id
-
TeamProjectsAreas_Value
-
ActiveRisks
-
ActiveIssues
-
ActiveChanges
-
TasksinProgress
-
TasksAtRisks
-
TasksOffTrack
-
ofBacklogTasks
-
ofFeatures
-
ofUserStories
-
BacklogPoints
-
BusinessValue_Id
-
BusinessValue_Value
-
RiskReduction_Id
-
RiskReduction_Value
-
SWAG_Id
-
SWAG_Value
-
TimeCriticality_Id
-
TimeCriticality_Value
-
CostofDelay
-
WSJF
-
ValueArea_Id
-
ValueArea_Value
-
EpicPoints
-
RemainingPoints
-
PlanType_Objective_Id
-
PlanType_Objective_Value
-
Lead
-
Lead_Value
-
Metric_Id
-
Metric_Value
-
CurrentNumber
-
TargetNumber
-
CurrentMetric
-
Status_Id
-
Status_Value
-
AssociatedObjectives
-
AssociatedObjectives_Value
-
RequestedBy
-
RequestedBy_Value
-
Product_Id
-
Product_Value
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedPrograms_Value
-
NoofInProgressTasks
-
NoofNotStartedTasks
-
Insights_Compliance
-
Insights_Problems
-
Insights_Warnings
-
NoofLateTasks
-
ApprovalStatus_Id
-
ApprovalStatus_Value
-
AssociatedResults
-
AssociatedResults_Value
-
ProjectCount
-
Count
-
DefaultTaskType_Id
-
DefaultTaskType_Value
-
OverallHealthTrend
-
BudgetTrend
-
ComplianceTrend
-
ActiveIssuesTrend
-
ActiveChangesTrend
-
StateTrend
-
PlanBudget
-
MetricTrend
-
CurrentMetricTrend
-
DefaultTaskMode_Id
-
DefaultTaskMode_Value
-
PlanType_EnterpriseArchitecture_Id
-
PlanType_EnterpriseArchitecture_Value
-
AssociatedApplications
-
AssociatedApplications_Value
-
AssociatedCapabilities
-
AssociatedCapabilities_Value
-
AssociatedProducts
-
AssociatedProducts_Value
-
ValueProposition
-
Solutions
-
SolutionContext
-
PeopleandLocations
-
CustomerSegments
-
Channels
-
CustomerRelationships
-
ARTsandSuppliers
-
ValueStreamRoles
-
Vision
-
Mission
-
Strengths
-
Weaknesses
-
Opportunity
-
Threats
-
AssociatedValueStream
-
AssociatedValueStream_Value
-
StatusTrend
-
AssociatedInitiatives
-
AssociatedInitiatives_Value
-
Summary_Status
-
Summary_Complete
-
Summary_EstimatedCost
-
Summary_EstimatedRevenue
-
Summary_State
-
Summary_TimesheetHours
-
Summary_Priority
-
Summary_TaskStatus
-
Summary_StatusNotes
-
Summary_RemainingEffort
-
Summary_ActualCost
-
Summary_RemainingCost
-
Summary_ActualRevenue
-
Summary_RemainingRevenue
-
Summary_Points
-
Summary_Description
-
Summary_Impact
-
Summary_Category
-
Summary_RiskStage
-
Summary_Mitigation
-
Summary_CostImpact
-
Summary_TopicArea
-
Summary_DecisionDate
-
Summary_DecisionImpact
-
Summary_DecisionMakers
-
Summary_ShowinReports
-
Summary_MSPWBS
-
Summary_Contingency
-
Summary_Resolution
-
Summary_Exposure
-
Summary_Probability
-
Summary_Risk
-
Summary_ItemType
-
Summary_BusinessValue
-
Summary_BaselinePercentDone
-
Summary_BaselineEndDate
-
Summary_BaselineEffort
-
Summary_BaselineStartDate
-
Summary_BaselineRemainingEffort
-
Summary_ChargeType
-
Summary_Team
-
Summary_FixedCost
-
Summary_FixedRevenue
-
Summary_Rate
-
Summary_LastBaselineDate
-
Summary_StartDate
-
Summary_EndDate
-
Summary_Effort
-
Summary_Duration
-
Summary_PercentDone
-
Summary_taskorder
-
Summary_WBS
Description: The Plan Process Steps table contains data on when a plan transitions through a step.
Out of the Box Links to Other Tables:
Best Practices, Tips, and Tricks: Each row represents a specific occurrence when a plan transitions through a step. Multiple rows can exist for the same step if revisited. If the last step is logged, the start and end times are set to be the same during the start of that step.
Available Fields:
-
Plan ID
-
Step ID
-
Start
-
End
-
State
Description: The Resources table contains data on all of the resources in your OnePlan environment.
Out of the Box Links to Other Tables:
Best Practices, Tips, and Tricks:
Available Fields:
-
UserId
-
Name
-
Email
-
Generic
-
Inactive
-
ExternalId
-
Permissions
-
Quantity
-
Department_Id
-
Department_Value
-
Role_Id
-
Role_Value
-
Cost
-
Rate
-
Manager
-
Manager_DisplayName
-
TimesheetsAdmin
-
TimesheetManager
-
TimesheetManager_DisplayName
-
Insights_Compliance
-
Insights_Problems
-
Insights_Warnings
-
AvailableFrom
-
AvailableTo
Description: The ResPlan table contains data for all resource plans in your OnePlan environment.
Out of the Box Links to Other Tables:
Table 6.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
ResPlan (Date) |
-> |
Date Dimension (Date) |
|
ResPlan (ResourceId) |
-> |
Resources (UserId)) |
|
ResPlan (WorkPlanId) |
<-> |
Plans (Id) |
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
CostTypeId
-
CostType
-
WorkPlanId
-
Date
-
Hours
-
ResourceId
-
ResourceName
-
State
-
ProjectManagerStatus
-
ResourceManagerStatus
-
Notes
Description: The ResPlanLog table contains data that is captured when resource negotiations are turned on. It tracks when things like approvals and rejections happen. Then the ResPlanLog joins back to the ResPlan table. So, for each resource plan (ResPlan) line,, there might be one or more log items saying this line was submitted by this person on this date, and was approved by this person on this date.
Out of the Box Links to Other Tables:
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
ResPlanId
-
PostDate
-
Status
-
ResourceId
-
Message
Description: The StatusReports table contains plan data when you generate a status report. The StatusReports table is kind of a snapshot in time of ta given plan's plan level data.
Out of the Box Links to Other Tables:
Table 7.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
StatusReports (Report_WorkPlanId) |
-> |
Plans (Id) |
Best Practices, Tips, and Tricks:
Available Fields:
-
ActiveChanges
-
ActiveIssues
-
ActiveRisks
-
Actuals
-
AssociatedObjectives
-
AssociatedPortfolio
-
AssociatedPrograms
-
AssociatedResults
-
Budget
-
BudgetTrend
-
BudgetVariance
-
EffortHealth
-
EffortVariance
-
EpicPoints
-
EstimatedEnd
-
EstimatedStart
-
FinancialHealth
-
Forecast
-
Insights_Compliance
-
IssueHealth
-
Name
-
NoofLateTasks
-
OverallHealth
-
Priority
-
RemainingBudget
-
RemainingEffort
-
Report_ApprovalDate
-
Report_SubmitDate
-
Report_WorkPlanId
-
ScheduledEffort
-
ScheduleHealth
-
State
-
Status
-
Status Report End Date
-
Status Report Start Date
-
Summary_BaselineEndDate
-
Summary_BaselineStartDate
-
Summary_EndDate
-
Summary_StartDate
-
TasksAtRisks
-
TasksinProgress
-
TasksOffTrack
Description: The Tasks table holds data on all work items in your OnePlan environment. This includes task issues, risks, changes, etc.. Any work item types that you create will all roll into the Tasks table.
Out of the Box Links to Other Tables:
Table 8.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Tasks (PlanId) |
-> |
Plans (Id) |
Best Practices, Tips, and Tricks:
Available Fields:
-
ActualCost
-
ActualRevenue
-
Assignment
-
BaselineEffort
-
BaselineEndDate
-
BaselinePercentDone
-
BaselineRemainingEffort
-
BaselineStartDate
-
BusinessValue
-
Category
-
ChargeType
-
Committed Effort
-
Complete
-
Contingency
-
CostImpact
-
Created
-
CreatedBy
-
DecistionDate
-
DecisionImpact
-
DecisionMakers
-
Description
-
Due Date
-
Duration
-
DurationUnit
-
Effort
-
Effort Variance
-
EstimatedCost
-
EstimatedRevenue
-
Exposure
-
FixedCost
-
FixedRevenue
-
Id
-
Impact
-
ItemType
-
Late Task
-
Leaf
-
Milestone
-
Modified
-
ModifiedBy
-
MSPWBS
-
Name
-
Overdue Tasks
-
ParentTaskId
-
PercentDone
-
PlanId
-
Points
-
Priority
-
Probability
-
RemainingCost
-
RemainingEffort
-
RemainingRevenue
-
Resolution
-
Risk
-
Risk Stage
-
Scheduled Effort
-
ShowinReports
-
StartDate
-
State
-
Status
-
StatusNotes
-
Task Count
-
taskorder
-
TaskStatus
-
Team
-
TiemsheetHours
-
TopicArea
-
WBS
-
WorkType
-
WorkTypeId
Description: The TimeOff table holds data related to time off requests that are created and tracked in your OnePlan environment.
Out of the Box Links to Other Tables:
Best Practices, Tips, and Tricks:
Available Fields:
-
Id
-
UserId
-
ResourceName
-
TimeOffCategoty
-
Start
-
End
-
HoursPerDay
-
Notes
-
Status
-
Approver
-
ApproverName
-
DateApproved
Description: The TimesheetAudit table contains data that is captured when timesheet approvals are turned on. It tracks when things like approvals and rejections happen.
Out of the Box Links to Other Tables:
Best Practices, Tips, and Tricks:
Available Fields:
-
AuditId
-
TimesheetId
-
TimesheetLineId
-
Action
-
UserOfAction
-
UserIdOfAction
-
DateOfAction
-
Message
-
IsApp
Description: The Timesheets table holds all timesheet data, pulled from the timesheet rows themselves, in your OnePlan environment. Generally, you need to join the Timesheets table back to the Plans,Tasks, and Resources tables.
Out of the Box Links to Other Tables:
Table 9.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Timesheet (EntryDate) |
-> |
Date Dimension (Date) |
|
Timesheet (TaskId) |
-> |
Tasks (Id) |
|
Timesheets (UserId) |
-> |
Resources (UserId) |
Best Practices, Tips, and Tricks:
Available Fields:
-
PeriodIndex
-
PeriodName
-
PeriodStart
-
PeriodEnd
-
UserId
-
TimesheetId
-
PlanId
-
TaskId
-
Submitted
-
TimeApproved
-
PlanApproved
-
ModifiedBy
-
Modified
-
EntryDate
-
Hours
-
Line_Notes
-
Class
-
Billable
-
Day_Notes
-
ChargeType
As you customize OnePlan to meet the needs of your organization, new tables will be created in the OData feed.
Description: "Plan_" tables, such as Plan_Epic can change depending on the configuration of your Plan Types. For each new Plan Type you configure, a new "Plan_" table will be created.
Out of the Box Links to Other Tables:
Table 10.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Plan_Epic (Id) |
<-> |
Plans (Id) |
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
Creator
-
Editor
-
Folder
-
ParentPlanId
-
ProcessStep
-
ProcessStepStart
-
ProcessStepIndex
-
Archived
-
PlanType
-
PlanId
-
PortfolioPriority
-
Summary_Milestone
-
State_Id
-
State_Value
-
Priority_Id
-
Priority_Value
-
Budget
-
TimesheetHours
-
TimesheetType_Id
-
TimesheetType_Value
-
TimesheetChargeLevel_Id
-
TimesheetChargeLevel_Value
-
EstimatedStart
-
EstimatedEnd
-
ExecutiveSponsor
-
ExecutiveSponsor_Value
-
Manager
-
Manager_Value
-
Stage_Id
-
Stage_Value
-
ProjectType_Id
-
ProjectType_Value
-
BusinessUnit_Id
-
BusinessUnit_Value
-
Forecast
-
RemainingBudget
-
BudgetVariance
-
Benefits
-
ROI
-
FundingAvailable
-
FundingSource_Id
-
FundingSource_Value
-
CommittedEffort
-
ScheduledEffort
-
RemainingEffort
-
EffortVariance
-
OverallHealth_Id
-
OverallHealth_Value
-
ScheduleHealth_Id
-
ScheduleHealth_Value
-
FinancialHealth_Id
-
FinancialHealth_Value
-
EffortHealth_Id
-
EffortHealth_Value
-
IssueHealth_Id
-
IssueHealth_Value
-
NeedsStaffing
-
StrategicAlignment_Id
-
StrategicAlignment_Value
-
LowerCost_Id
-
LowerCost_Value
-
ImproveEmployeeRetention_Id
-
ImproveEmployeeRetention_Value
-
Risk_Id
-
Risk_Value
-
PrioritizationScore
-
Actuals
-
PowerAppID
-
Goals_Id
-
Goals_Value
-
Description
-
BusinessCase
-
ValueStatement
-
Accomplishments
-
PlannedActivities
-
AdditionalComments
-
PlanType_EnterpriseProject_Id
-
PlanType_EnterpriseProject_Value
-
PlanType_Program_Id
-
PlanType_Program_Value
-
ProgramBudget
-
RemainingBudgetAllocation
-
TeamProjectsAreas_Id
-
TeamProjectsAreas_Value
-
ActiveRisks
-
ActiveIssues
-
ActiveChanges
-
TasksinProgress
-
TasksAtRisks
-
TasksOffTrack
-
ofBacklogTasks
-
ofFeatures
-
ofUserStories
-
BacklogPoints
-
BusinessValue_Id
-
BusinessValue_Value
-
RiskReduction_Id
-
RiskReduction_Value
-
SWAG_Id
-
SWAG_Value
-
TimeCriticality_Id
-
TimeCriticality_Value
-
CostofDelay
-
WSJF
-
ValueArea_Id
-
ValueArea_Value
-
EpicPoints
-
RemainingPoints
-
PlanType_Objective_Id
-
PlanType_Objective_Value
-
Lead
-
Lead_Value
-
Metric_Id
-
Metric_Value
-
CurrentNumber
-
TargetNumber
-
CurrentMetric
-
Status_Id
-
Status_Value
-
AssociatedObjectives
-
AssociatedObjectives_Value
-
RequestedBy
-
RequestedBy_Value
-
Product_Id
-
Product_Value
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedPrograms_Value
-
NoofInProgressTasks
-
NoofNotStartedTasks
-
Insights_Compliance
-
Insights_Problems
-
Insights_Warnings
-
NoofLateTasks
-
ApprovalStatus_Id
-
ApprovalStatus_Value
-
AssociatedResults
-
AssociatedResults_Value
-
ProjectCount
-
Count
-
DefaultTaskType_Id
-
DefaultTaskType_Value
-
BudgetTrend
-
ComplianceTrend
-
ActiveIssuesTrend
-
ActiveChangesTrend
-
StateTrend
-
PlanBudget
-
MetricTrend
-
CurrentMetricTrend
-
DefaultTaskMode_Id
-
DefaultTaskMode_Value
-
Summary_Status
-
Summary_Complete
-
Summary_EstimatedCost
-
Summary_EstimatedRevenue
-
Summary_State
-
Summary_TimesheetHours
-
Summary_Priority
-
Summary_TaskStatus
-
Summary_StatusNotes
-
Summary_RemainingEffort
-
Summary_ActualCost
-
Summary_RemainingCost
-
Summary_ActualRevenue
-
Summary_RemainingRevenue
-
Summary_Points
-
Summary_Description
-
Summary_Impact
-
Summary_Category
-
Summary_RiskStage
-
Summary_Mitigation
-
Summary_CostImpact
-
Summary_TopicArea
-
Summary_DecisionDate
-
Summary_DecisionImpact
-
Summary_DecisionMakers
-
Summary_ShowinReports
-
Summary_MSPWBS
-
Summary_Contingency
-
Summary_Resolution
-
Summary_Exposure
-
Summary_Probability
-
Summary_Risk
-
Summary_ItemType
-
Summary_BusinessValue
-
Summary_BaselinePercentDone
-
Summary_BaselineEndDate
-
Summary_BaselineEffort
-
Summary_BaselineStartDate
-
Summary_BaselineRemainingEffort
-
Summary_ChargeType
-
Summary_Team
-
Summary_FixedCost
-
Summary_FixedRevenue
-
Summary_StartDate
-
Summary_EndDate
-
Summary_Effort
-
Summary_Duration
-
Summary_PercentDone
-
Summary_taskorder
-
Summary_WBS
-
JiraProjectNames_Id
-
JiraProjectNames_Value
-
OverallHealthTrend
-
PlanType_EnterpriseArchitecture_Id
-
PlanType_EnterpriseArchitecture_Value
-
AssociatedApplications
-
AssociatedApplications_Value
-
AssociatedCapabilities
-
AssociatedCapabilities_Value
-
AssociatedProducts
-
AssociatedProducts_Value
-
ValueProposition
-
Solutions
-
SolutionContext
-
PeopleandLocations
-
CustomerSegments
-
Channels
-
CustomerRelationships
-
ARTsandSuppliers
-
ValueStreamRoles
-
Vision
-
Mission
-
Strengths
-
Weaknesses
-
Opportunity
-
Threats
-
AssociatedValueStream
-
AssociatedValueStream_Value
-
StatusTrend
-
AssociatedInitiatives
-
AssociatedInitiatives_Value
-
Summary_Rate
-
FunctionalFit_Id
-
FunctionalFit_Value
-
Summary_WorkItemType
-
Summary_Synch
-
Summary_LastBaselineDate
Out of the Box Links to Other Tables:
Table 11.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Plan_Idea (Id) |
<-> |
Plans (Id) |
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
Creator
-
ProcessStep
-
ProcessStepStart
-
State
-
Priority
-
EstimatedStart
-
EstimatedEnd
-
Project Type
-
Benefits
-
ROI
-
Approval Status
-
ROI %
-
PrioritizationScore
Out of the Box Links to Other Tables:
Table 12.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Plan_KeyResult (Id) |
<-> |
Plans (Id) |
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
Creator
-
Editor
-
Folder
-
ParentPlanId
-
ProcessStep
-
ProcessStepStart
-
ProcessStepIndex
-
Archived
-
PlanType
-
PlanId
-
PortfolioPriority
-
Summary_Milestone
-
State_Id
-
State_Value
-
Priority_Id
-
Priority_Value
-
Budget
-
TimesheetHours
-
TimesheetType_Id
-
TimesheetType_Value
-
TimesheetChargeLevel_Id
-
TimesheetChargeLevel_Value
-
EstimatedStart
-
EstimatedEnd
-
ExecutiveSponsor
-
ExecutiveSponsor_Value
-
Manager
-
Manager_Value
-
Stage_Id
-
Stage_Value
-
ProjectType_Id
-
ProjectType_Value
-
BusinessUnit_Id
-
BusinessUnit_Value
-
Forecast
-
RemainingBudget
-
BudgetVariance
-
Benefits
-
ROI
-
FundingAvailable
-
FundingSource_Id
-
FundingSource_Value
-
CommittedEffort
-
ScheduledEffort
-
RemainingEffort
-
EffortVariance
-
OverallHealth_Id
-
OverallHealth_Value
-
ScheduleHealth_Id
-
ScheduleHealth_Value
-
FinancialHealth_Id
-
FinancialHealth_Value
-
EffortHealth_Id
-
EffortHealth_Value
-
IssueHealth_Id
-
IssueHealth_Value
-
NeedsStaffing
-
StrategicAlignment_Id
-
StrategicAlignment_Value
-
LowerCost_Id
-
LowerCost_Value
-
ImproveEmployeeRetention_Id
-
ImproveEmployeeRetention_Value
-
Risk_Id
-
Risk_Value
-
PrioritizationScore
-
Actuals
-
PowerAppID
-
Goals_Id
-
Goals_Value
-
Description
-
BusinessCase
-
ValueStatement
-
Accomplishments
-
PlannedActivities
-
AdditionalComments
-
PlanType_EnterpriseProject_Id
-
PlanType_EnterpriseProject_Value
-
PlanType_Program_Id
-
PlanType_Program_Value
-
ProgramBudget
-
RemainingBudgetAllocation
-
TeamProjectsAreas_Id
-
TeamProjectsAreas_Value
-
ActiveRisks
-
ActiveIssues
-
ActiveChanges
-
TasksinProgress
-
TasksAtRisks
-
TasksOffTrack
-
ofBacklogTasks
-
ofFeatures
-
ofUserStories
-
BacklogPoints
-
BusinessValue_Id
-
BusinessValue_Value
-
RiskReduction_Id
-
RiskReduction_Value
-
SWAG_Id
-
SWAG_Value
-
TimeCriticality_Id
-
TimeCriticality_Value
-
CostofDelay
-
WSJF
-
ValueArea_Id
-
ValueArea_Value
-
EpicPoints
-
RemainingPoints
-
PlanType_Objective_Id
-
PlanType_Objective_Value
-
Lead
-
Lead_Value
-
Metric_Id
-
Metric_Value
-
CurrentNumber
-
TargetNumber
-
CurrentMetric
-
Status_Id
-
Status_Value
-
AssociatedObjectives
-
AssociatedObjectives_Value
-
RequestedBy
-
RequestedBy_Value
-
Product_Id
-
Product_Value
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedPrograms_Value
-
NoofInProgressTasks
-
NoofNotStartedTasks
-
Insights_Compliance
-
Insights_Problems
-
Insights_Warnings
-
NoofLateTasks
-
ApprovalStatus_Id
-
ApprovalStatus_Value
-
AssociatedResults
-
AssociatedResults_Value
-
ProjectCount
-
Count
-
DefaultTaskType_Id
-
DefaultTaskType_Value
-
BudgetTrend
-
ComplianceTrend
-
ActiveIssuesTrend
-
ActiveChangesTrend
-
StateTrend
-
PlanBudget
-
MetricTrend
-
CurrentMetricTrend
-
DefaultTaskMode_Id
-
DefaultTaskMode_Value
-
Summary_Status
-
Summary_Complete
-
Summary_EstimatedCost
-
Summary_EstimatedRevenue
-
Summary_State
-
Summary_TimesheetHours
-
Summary_Priority
-
Summary_TaskStatus
-
Summary_StatusNotes
-
Summary_RemainingEffort
-
Summary_ActualCost
-
Summary_RemainingCost
-
Summary_ActualRevenue
-
Summary_RemainingRevenue
-
Summary_Points
-
Summary_Description
-
Summary_Impact
-
Summary_Category
-
Summary_RiskStage
-
Summary_Mitigation
-
Summary_CostImpact
-
Summary_TopicArea
-
Summary_DecisionDate
-
Summary_DecisionImpact
-
Summary_DecisionMakers
-
Summary_ShowinReports
-
Summary_MSPWBS
-
Summary_Contingency
-
Summary_Resolution
-
Summary_Exposure
-
Summary_Probability
-
Summary_Risk
-
Summary_ItemType
-
Summary_BusinessValue
-
Summary_BaselinePercentDone
-
Summary_BaselineEndDate
-
Summary_BaselineEffort
-
Summary_BaselineStartDate
-
Summary_BaselineRemainingEffort
-
Summary_ChargeType
-
Summary_Team
-
Summary_FixedCost
-
Summary_FixedRevenue
-
Summary_StartDate
-
Summary_EndDate
-
Summary_Effort
-
Summary_Duration
-
Summary_PercentDone
-
Summary_taskorder
-
Summary_WBS
-
KeyResultStatusRank
-
StatusNumberValue
Out of the Box Links to Other Tables:
Table 13.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Plan_Objective (Id) |
<-> |
Plans (Id) |
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
ProcessStep
-
ProcessStepStart
-
Priority_Value
-
EstimatedStart
-
EstimatedEnd
-
BusinessUnit_Value
-
CurrentMetric
-
Status_Id
-
Status_Value
-
AssociatedObjectives
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedResults
-
Summary_BaselineEndDate
-
Summary_BaselineStartDate
-
Summary_EndDate
-
AssociatedObjectives_Value
-
AssociatedPrograms_Value
-
AssociatedResults_Value
-
Manager
-
Manager_Value
Available Fields:
-
Id
-
Name
-
Budget
-
ExecutiveSponsor_Value
-
Manager_Value
-
ProjectType_Value
-
Business Value
-
Forecast
-
RemainingBudget
-
BudgetVariance
-
Benefits
-
ROI
-
EffortVariance
-
Overall
-
ScheduleHealth_Value
-
FinancialHealth_Value
-
EffortHealth_Value
-
IssueHealth_Value
-
Actuals
-
Goals_Value
-
ROI %
-
AssociatedObjectives
-
AssociatedObjectives_Value
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedPrograms_Value
-
AssociatedResults
-
AssociatedResults_Value
-
EffortHealthNumberValue
-
FinancialHealthNumberValue
-
IssueHealthNumberValue
-
OverallHealthNumberValue
-
ScheduleHealthNumberValue
Out of the Box Links to Other Tables:
Table 14.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Plan_Program (PlanType_EnterpriseProject_Id) |
<-> |
Plan_Portfolio (Id) |
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
Creator
-
Editor
-
Folder
-
ParentPlanId
-
ProcessStep
-
ProcessStepStart
-
ProcessStepIndex
-
Archived
-
PlanType
-
PlanId
-
PortfolioPriority
-
Summary_Milestone
-
State_Id
-
State_Value
-
Priority_Id
-
Priority_Value
-
Budget
-
TimesheetHours
-
TimesheetType_Id
-
TimesheetType_Value
-
TimesheetChargeLevel_Id
-
TimesheetChargeLevel_Value
-
EstimatedStart
-
EstimatedEnd
-
ExecutiveSponsor
-
ExecutiveSponsor_Value
-
Manager
-
Manager_Value
-
Stage_Id
-
Stage_Value
-
ProjectType_Id
-
ProjectType_Value
-
BusinessUnit_Id
-
Business Unit
-
Forecast
-
Remaining Budget
-
Budget Variance
-
Benefits
-
ROI
-
FundingAvailable
-
FundingSource_Id
-
FundingSource_Value
-
CommittedEffort
-
ScheduledEffort
-
RemainingEffort
-
EffortVariance
-
OverallHealth_Id
-
Overall
-
ScheduleHealth_Id
-
Schedule
-
FinancialHealth_Id
-
Financial
-
EffortHealth_Id
-
Effort
-
IssueHealth_Id
-
Issues
-
NeedsStaffing
-
StrategicAlignment_Id
-
StrategicAlignment_Value
-
LowerCost_Id
-
LowerCost_Value
-
ImproveEmployeeRetention_Id
-
ImproveEmployeeRetention_Value
-
Risk_Id
-
Risk_Value
-
PrioritizationScore
-
Actual Spend
-
PowerAppID
-
Goals_Id
-
Goals_Value
-
Description
-
BusinessCase
-
ValueStatement
-
Accomplishments
-
PlannedActivities
-
AdditionalComments
-
PlanType_EnterpriseProject_Id
-
Portfolio
-
PlanType_Program_Id
-
PlanType_Program_Value
-
Program Budget
-
Remaining Allocation
-
JiraProjectNames_Id
-
JiraProjectNames_Value
-
TeamProjectsAreas_Id
-
TeamProjectsAreas_Value
-
ActiveRisks
-
ActiveIssues
-
ActiveChanges
-
TasksinProgress
-
TasksAtRisks
-
TasksOffTrack
-
ofBacklogTasks
-
ofFeatures
-
ofUserStories
-
BacklogPoints
-
BusinessValue_Id
-
BusinessValue_Value
-
RiskReduction_Id
-
RiskReduction_Value
-
SWAG_Id
-
SWAG_Value
-
TimeCriticality_Id
-
TimeCriticality_Value
-
CostofDelay
-
WSJF
-
ValueArea_Id
-
ValueArea_Value
-
EpicPoints
-
RemainingPoints
-
PlanType_Objective_Id
-
PlanType_Objective_Value
-
Lead
-
Lead_Value
-
Metric_Id
-
Metric_Value
-
CurrentNumber
-
TargetNumber
-
CurrentMetric
-
Status_Id
-
Status_Value
-
AssociatedObjectives
-
AssociatedObjectives_Value
-
RequestedBy
-
RequestedBy_Value
-
Product_Id
-
Product_Value
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedPrograms_Value
-
NoofInProgressTasks
-
NoofNotStartedTasks
-
Insights_Compliance
-
Insights_Problems
-
Insights_Warnings
-
NoofLateTasks
-
ApprovalStatus_Id
-
ApprovalStatus_Value
-
AssociatedResults
-
AssociatedResults_Value
-
ProjectCount
-
Count
-
DefaultTaskType_Id
-
DefaultTaskType_Value
-
BudgetTrend
-
ComplianceTrend
-
ActiveIssuesTrend
-
ActiveChangesTrend
-
StateTrend
-
PlanBudget
-
MetricTrend
-
CurrentMetricTrend
-
DefaultTaskMode_Id
-
DefaultTaskMode_Value
-
Summary_Status
-
Summary_Complete
-
Summary_EstimatedCost
-
Summary_EstimatedRevenue
-
Summary_State
-
Summary_TimesheetHours
-
Summary_Priority
-
Summary_TaskStatus
-
Summary_StatusNotes
-
Summary_RemainingEffort
-
Summary_ActualCost
-
Summary_RemainingCost
-
Summary_ActualRevenue
-
Summary_RemainingRevenue
-
Summary_Points
-
Summary_Description
-
Summary_Impact
-
Summary_Category
-
Summary_RiskStage
-
Summary_Mitigation
-
Summary_CostImpact
-
Summary_Resolution
-
Summary_Exposure
-
Summary_Probability
-
Summary_Risk
-
Summary_ItemType
-
Summary_BusinessValue
-
Summary_BaselinePercentDone
-
Summary_BaselineEffort
-
Summary_BaselineStartDate
-
Summary_BaselineRemainingEffort
-
Summary_ChargeType
-
Summary_Team
-
Summary_FixedCost
-
Summary_FixedRevenue
-
Summary_StartDate
-
Summary_EndDate
-
Summary_Effort
-
Summary_Duration
-
Summary_PercentDone
-
Summary_taskorder
-
Summary_WBS
-
ROI %
-
OverallHealthNumberValue
-
EffortHealthNumberValue
-
FinancialHealthNumberValue
-
IssueHealthNumberValue
-
ScheduleHealthNumberValue
Out of the Box Links to Other Tables:
Table 15.
|
From: Table (Column) |
Relationship Direction |
To: Table (Column) |
|---|---|---|
|
Plan_Project (Id) |
<-> |
Plans (Id) |
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
Creator
-
Editor
-
Folder
-
ParentPlanId
-
ProcessStep
-
ProcessStepStart
-
ProcessStepIndex
-
Archived
-
PlanType
-
PlanId
-
PortfolioPriority
-
Summary_Milestone
-
State_Id
-
State_Value
-
Priority_Id
-
Priority_Value
-
Budget
-
TimesheetHours
-
TimesheetType_Id
-
TimesheetType_Value
-
TimesheetChargeLevel_Id
-
TimesheetChargeLevel_Value
-
EstimatedStart
-
EstimatedEnd
-
ExecutiveSponsor
-
ExecutiveSponsor_Value
-
Manager
-
Manager_Value
-
Stage_Id
-
Stage_Value
-
ProjectType_Id
-
ProjectType_Value
-
BusinessUnit_Id
-
BusinessUnit_Value
-
Forecast
-
RemainingBudget
-
BudgetVariance
-
Benefits
-
ROI
-
FundingAvailable
-
FundingSource_Id
-
FundingSource_Value
-
CommittedEffort
-
ScheduledEffort
-
RemainingEffort
-
EffortVariance
-
OverallHealth_Id
-
OverallHealth_Value
-
ScheduleHealth_Id
-
ScheduleHealth_Value
-
FinancialHealth_Id
-
FinancialHealth_Value
-
EffortHealth_Id
-
EffortHealth_Value
-
IssueHealth_Id
-
IssueHealth_Value
-
NeedsStaffing
-
StrategicAlignment_Id
-
StrategicAlignment_Value
-
LowerCost_Id
-
LowerCost_Value
-
ImproveEmployeeRetention_Id
-
ImproveEmployeeRetention_Value
-
Risk_Id
-
Risk_Value
-
PrioritizationScore
-
Actuals
-
PowerAppID
-
Goals_Id
-
Goals_Value
-
Description
-
BusinessCase
-
ValueStatement
-
Accomplishments
-
PlannedActivities
-
AdditionalComments
-
PlanType_EnterpriseProject_Id
-
PlanType_EnterpriseProject_Value
-
PlanType_Program_Id
-
PlanType_Program_Value
-
ProgramBudget
-
RemainingBudgetAllocation
-
TeamProjectsAreas_Id
-
TeamProjectsAreas_Value
-
ActiveRisks
-
ActiveIssues
-
ActiveChanges
-
TasksinProgress
-
TasksAtRisks
-
TasksOffTrack
-
ofBacklogTasks
-
ofFeatures
-
ofUserStories
-
BacklogPoints
-
BusinessValue_Id
-
BusinessValue_Value
-
RiskReduction_Id
-
RiskReduction_Value
-
SWAG_Id
-
SWAG_Value
-
TimeCriticality_Id
-
TimeCriticality_Value
-
CostofDelay
-
WSJF
-
ValueArea_Id
-
ValueArea_Value
-
EpicPoints
-
RemainingPoints
-
PlanType_Objective_Id
-
PlanType_Objective_Value
-
Lead
-
Lead_Value
-
Metric_Id
-
Metric_Value
-
CurrentNumber
-
TargetNumber
-
CurrentMetric
-
Status_Id
-
Status_Value
-
AssociatedObjectives
-
AssociatedObjectives_Value
-
RequestedBy
-
RequestedBy_Value
-
Product_Id
-
Product_Value
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedPrograms_Value
-
NoofInProgressTasks
-
NoofNotStartedTasks
-
Insights_Compliance
-
Insights_Problems
-
Insights_Warnings
-
NoofLateTasks
-
ApprovalStatus_Id
-
ApprovalStatus_Value
-
AssociatedResults
-
AssociatedResults_Value
-
ProjectCount
-
Count
-
DefaultTaskType_Id
-
DefaultTaskType_Value
-
BudgetTrend
-
ComplianceTrend
-
ActiveIssuesTrend
-
ActiveChangesTrend
-
StateTrend
-
PlanBudget
-
MetricTrend
-
CurrentMetricTrend
-
DefaultTaskMode_Id
-
DefaultTaskMode_Value
-
Summary_Status
-
Summary_Complete
-
Summary_EstimatedCost
-
Summary_EstimatedRevenue
-
Summary_State
-
Summary_TimesheetHours
-
Summary_Priority
-
Summary_TaskStatus
-
Summary_StatusNotes
-
Summary_RemainingEffort
-
Summary_ActualCost
-
Summary_RemainingCost
-
Summary_ActualRevenue
-
Summary_RemainingRevenue
-
Summary_Points
-
Summary_Description
-
Summary_Impact
-
Summary_Category
-
Summary_RiskStage
-
Summary_Mitigation
-
Summary_CostImpact
-
Summary_TopicArea
-
Summary_DecisionDate
-
Summary_DecisionImpact
-
Summary_DecisionMakers
-
Summary_ShowinReports
-
Summary_MSPWBS
-
Summary_Contingency
-
Summary_Resolution
-
Summary_Exposure
-
Summary_Probability
-
Summary_Risk
-
Summary_ItemType
-
Summary_BusinessValue
-
Summary_BaselinePercentDone
-
Summary_BaselineEndDate
-
Summary_BaselineEffort
-
Summary_BaselineStartDate
-
Summary_BaselineRemainingEffort
-
Summary_ChargeType
-
Summary_Team
-
Summary_FixedCost
-
Summary_FixedRevenue
-
Summary_StartDate
-
Summary_EndDate
-
Summary_Effort
-
Summary_Duration
-
Summary_PercentDone
-
Summary_taskorder
-
Summary_WBS
-
% Done
-
JiraProjectNames_Id
-
JiraProjectNames_Value
-
OverallHealthTrend
-
PlanType_EnterpriseArchitecture_Id
-
PlanType_EnterpriseArchitecture_Value
-
AssociatedApplications
-
AssociatedApplications_Value
-
AssociatedCapabilities
-
AssociatedCapabilities_Value
-
AssociatedProducts
-
AssociatedProducts_Value
-
ValueProposition
-
Solutions
-
SolutionContext
-
PeopleandLocations
-
CustomerSegments
-
Channels
-
CustomerRelationships
-
ARTsandSuppliers
-
ValueStreamRoles
-
Vision
-
Mission
-
Strengths
-
Weaknesses
-
Opportunity
-
Threats
-
AssociatedValueStream
-
AssociatedValueStream_Value
-
StatusTrend
-
AssociatedInitiatives
-
AssociatedInitiatives_Value
-
Summary_Rate
-
FunctionalFit_Id
-
FunctionalFit_Value
-
Summary_WorkItemType
-
Summary_Synch
-
Summary_LastBaselineDate
Available Fields:
-
Id
-
Name
-
Created
-
Modified
-
Creator
-
Editor
-
Folder
-
ParentPlanId
-
ProcessStep
-
ProcessStepStart
-
ProcessStepIndex
-
Archived
-
PlanType
-
PlanId
-
PortfolioPriority
-
Summary_Milestone
-
State_Id
-
State_Value
-
Priority_Id
-
Priority_Value
-
Budget
-
TimesheetHours
-
TimesheetType_Id
-
TimesheetType_Value
-
TimesheetChargeLevel_Id
-
TimesheetChargeLevel_Value
-
EstimatedStart
-
EstimatedEnd
-
ExecutiveSponsor
-
ExecutiveSponsor_Value
-
Manager
-
Manager_Value
-
Stage_Id
-
Stage_Value
-
ProjectType_Id
-
ProjectType_Value
-
BusinessUnit_Id
-
BusinessUnit_Value
-
Forecast
-
RemainingBudget
-
BudgetVariance
-
Benefits
-
ROI
-
FundingAvailable
-
FundingSource_Id
-
FundingSource_Value
-
CommittedEffort
-
ScheduledEffort
-
RemainingEffort
-
EffortVariance
-
OverallHealth_Id
-
Overall
-
ScheduleHealth_Id
-
ScheduleHealth_Value
-
FinancialHealth_Id
-
FinancialHealth_Value
-
EffortHealth_Id
-
EffortHealth_Value
-
IssueHealth_Id
-
IssueHealth_Value
-
NeedsStaffing
-
StrategicAlignment_Id
-
StrategicAlignment_Value
-
LowerCost_Id
-
LowerCost_Value
-
ImproveEmployeeRetention_Id
-
ImproveEmployeeRetention_Value
-
Risk_Id
-
Risk_Value
-
PrioritizationScore
-
Actuals
-
PowerAppID
-
Goals_Id
-
Goals_Value
-
Description
-
BusinessCase
-
ValueStatement
-
Accomplishments
-
PlannedActivities
-
AdditionalComments
-
PlanType_EnterpriseProject_Id
-
PlanType_EnterpriseProject_Value
-
PlanType_Program_Id
-
PlanType_Program_Value
-
ProgramBudget
-
RemainingBudgetAllocation
-
TeamProjectsAreas_Id
-
TeamProjectsAreas_Value
-
ActiveRisks
-
ActiveIssues
-
ActiveChanges
-
TasksinProgress
-
TasksAtRisks
-
TasksOffTrack
-
ofBacklogTasks
-
ofFeatures
-
ofUserStories
-
BacklogPoints
-
BusinessValue_Id
-
BusinessValue_Value
-
RiskReduction_Id
-
RiskReduction_Value
-
SWAG_Id
-
SWAG_Value
-
TimeCriticality_Id
-
TimeCriticality_Value
-
CostofDelay
-
WSJF
-
ValueArea_Id
-
ValueArea_Value
-
EpicPoints
-
RemainingPoints
-
PlanType_Objective_Id
-
PlanType_Objective_Value
-
Lead
-
Lead_Value
-
Metric_Id
-
Metric_Value
-
CurrentNumber
-
TargetNumber
-
CurrentMetric
-
Status_Id
-
Status_Value
-
AssociatedObjectives
-
AssociatedObjectives_Value
-
RequestedBy
-
RequestedBy_Value
-
Product_Id
-
Product_Value
-
AssociatedPortfolio_Id
-
AssociatedPortfolio_Value
-
AssociatedPrograms
-
AssociatedPrograms_Value
-
NoofInProgressTasks
-
NoofNotStartedTasks
-
Insights_Compliance
-
Insights_Problems
-
Insights_Warnings
-
NoofLateTasks
-
ApprovalStatus_Id
-
ApprovalStatus_Value
-
AssociatedResults
-
AssociatedResults_Value
-
ProjectCount
-
Count
-
DefaultTaskType_Id
-
DefaultTaskType_Value
-
BudgetTrend
-
ComplianceTrend
-
ActiveIssuesTrend
-
ActiveChangesTrend
-
StateTrend
-
PlanBudget
-
MetricTrend
-
CurrentMetricTrend
-
DefaultTaskMode_Id
-
DefaultTaskMode_Value
-
Summary_Status
-
Summary_Complete
-
Summary_EstimatedCost
-
Summary_EstimatedRevenue
-
Summary_State
-
Summary_TimesheetHours
-
Summary_Priority
-
Summary_TaskStatus
-
Summary_StatusNotes
-
Summary_RemainingEffort
-
Summary_ActualCost
-
Summary_RemainingCost
-
Summary_ActualRevenue
-
Summary_RemainingRevenue
-
Summary_Points
-
Summary_Description
-
Summary_Impact
-
Summary_Category
-
Summary_RiskStage
-
Summary_Mitigation
-
Summary_CostImpact
-
Summary_TopicArea
-
Summary_DecisionDate
-
Summary_DecisionImpact
-
Summary_DecisionMakers
-
Summary_ShowinReports
-
Summary_MSPWBS
-
Summary_Contingency
-
Summary_Resolution
-
Summary_Exposure
-
Summary_Probability
-
Summary_Risk
-
Summary_ItemType
-
Summary_BusinessValue
-
Summary_BaselinePercentDone
-
Summary_BaselineEndDate
-
Summary_BaselineEffort
-
Summary_BaselineStartDate
-
Summary_BaselineRemainingEffort
-
Summary_ChargeType
-
Summary_Team
-
Summary_FixedCost
-
Summary_FixedRevenue
-
Summary_StartDate
-
Summary_EndDate
-
Summary_Effort
-
Summary_Duration
-
Summary_PercentDone
-
Summary_taskorder
-
Summary_WBS
-
ROI %
-
EffortHealthNumberValue
-
FinancialHealthNumberValue
-
IssueHealthNumberValue
-
ScheduleHealthNumberValue
-
OverallHealthNumberValue
-
JiraProjectNames_Id
-
JiraProjectNames_Value
-
OverallHealthTrend
-
PlanType_EnterpriseArchitecture_Id
-
PlanType_EnterpriseArchitecture_Value
-
AssociatedApplications
-
AssociatedApplications_Value
-
AssociatedCapabilities
-
AssociatedCapabilities_Value
-
AssociatedProducts
-
AssociatedProducts_Value
-
ValueProposition
-
Solutions
-
SolutionContext
-
PeopleandLocations
-
CustomerSegments
-
Channels
-
CustomerRelationships
-
ARTsandSuppliers
-
ValueStreamRoles
-
Vision
-
Mission
-
Strengths
-
Weaknesses
-
Opportunity
-
Threats
-
AssociatedValueStream
-
AssociatedValueStream_Value
-
StatusTrend
-
AssociatedInitiatives
-
AssociatedInitiatives_Value
-
Summary_Rate
-
FunctionalFit_Id
-
FunctionalFit_Value
-
Summary_WorkItemType
-
Summary_Synch
-
Summary_LastBaselineDate