• Updated

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.

Stable Tables

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.

Activities

Description: The Activities table contains data on all Activities related to work items in the Work Planner.

Available Fields:

  • Id

  • WorkPlaId

  • TaskId

  • Name

  • State

  • AssignedTo

Assignments

Description: The Assignments table holds data on all of the the resources who are assigned to each work item in the environment.

Association

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.

Available Fields:

  • AssociationId

  • Field

  • PlanId

  • RelatedId

Capacity

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

Capacity (ResourceID)

->

Resources (UserID)

Capacity (Date)

->

Date Dimension (Date)

Available Fields:

  • ResourceId

  • Date

  • Capacity

  • Units

Costs

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

Cost (Date)

->

Date Dimension (Date)

Cost (WorkPlanId)

->

Plans (Id)

Available Fields:

  • Id

  • TpId

  • CostTypeId

  • CostType

  • ParentCostCategoryId

  • CostCategory

  • WorkPlanId

  • Date

  • Cost

  • DetailRow

  • ExternalId

  • IsLeaf

  • Cost_USD

  • Cost_CAD

  • Cost_AUD

  • ExpenseType

  • ExpenseType_Id

  • Description

ModelerModel

Description: The ModelerModel table contains all of the information for a Model created in the Portfolio Modeler.

Best Practices, Tips, and Tricks:

Available Fields:

  • Id

  • Name

  • Description

  • ParentId

  • Created

  • CreatedBy

  • Modified

  • ModifiedBy

  • NumberOfScenarios

ModelerScenario

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

ModelerScenatio (UserId)

->

Resources (UserId)

Available Fields:

  • Id

  • Name

  • UserId

  • ParentModelId

  • Personal

  • TotalPlans

  • TotalCheckedPlans

  • TotalBenefits

  • TargetBenefits

  • TotalBudget

  • TargetBudget

  • TotalForecast

  • TargetForecast

ModelerScenarioPlan

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

ModelerScenarioPlan (id)

->

Plans (Id)

ModelerScenarioPlan (Name)

->

Plan_Project (Name)

ModelerScenarioPlan (Name)

->

Plan_Project_Epic (Name)

Available Fields:

  • Id

  • ParentScenarioId

  • ParentScenarioName

  • Name

  • Checked

  • Priority

PlanDependency

Description: The PlanDependency table contains data on all of the dependencies between plans (i.e.predecessors and successors).

Available Fields:

  • DependencyId

  • FromPlan

  • ToPlan

  • Type

  • Description

PlanInsights

Description: The PlanInsights table holds data on all plan-level Insights in your OnePlan environment.

Available Fields:

  • Id

  • WorkPlanId

  • Plan

  • InsightId

  • Level

  • IsCompliance

  • ResultText

  • Details

Plans

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

Plans (Id)

<->

Plan_Project_Epic (Id)

Plans (ProgramId)

<->

Plan_Program (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

  • 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

Plan Process Steps

Description: The Plan Process Steps table contains data on when a plan transitions through a step.

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

Process Steps

Description: The Process Steps table contains data on process step stages and flows.

Best Practices, Tips, and Tricks: Each row represents a unique process step.

Available Fields:

  • Step ID

  • Step Name

  • Order

  • Plan Type ID

  • Plan Type Name

Resources

Description: The Resources table contains data on all of the resources in your OnePlan environment.

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

ResPlan

Description: The ResPlan table contains data for all resource plans in your OnePlan environment.

Out of the Box Links to Other Tables

From: Table (Column)

Relationship Direction

To: Table (Column)

ResPlan (Date)

->

Date Dimension (Date)

ResPlan (ResourceId)

->

Resources (UserId))

ResPlan (WorkPlanId)

<->

Plans (Id)

Available Fields:

  • Id

  • CostTypeId

  • CostType

  • WorkPlanId

  • Date

  • Hours

  • ResourceId

  • ResourceName

  • State

  • ProjectManagerStatus

  • ResourceManagerStatus

  • Notes

ResPlanLog

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.

Available Fields:

  • Id

  • ResPlanId

  • PostDate

  • Status

  • ResourceId

  • Message

StatusReports

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

StatusReports (Report_WorkPlanId)

->

Plans (Id)

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

Tasks

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

Tasks (PlanId)

->

Plans (Id)

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

Teams

Description: The Teams table contains data from the Shared With forms for all plans in your OnePlan environment.

Available Fields:

  • PlanId

  • UserId

  • Name

  • Level

  • Inherited

TimeOff

Description: The TimeOff table holds data related to time off requests that are created and tracked in your OnePlan environment.

Available Fields:

  • Id

  • UserId

  • ResourceName

  • TimeOffCategoty

  • Start

  • End

  • HoursPerDay

  • Notes

  • Status

  • Approver

  • ApproverName

  • DateApproved

TimesheetAudit

Description: The TimesheetAudit table contains data that is captured when timesheet approvals are turned on. It tracks when things like approvals and rejections happen.

Available Fields:

  • AuditId

  • TimesheetId

  • TimesheetLineId

  • Action

  • UserOfAction

  • UserIdOfAction

  • DateOfAction

  • Message

  • IsApp

Timesheets

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:

From: Table (Column)

Relationship Direction

To: Table (Column)

Timesheet (EntryDate)

->

Date Dimension (Date)

Timesheet (TaskId)

->

Tasks (Id)

Timesheets (UserId)

->

Resources (UserId)

Available Fields:

  • PeriodIndex

  • PeriodName

  • PeriodStart

  • PeriodEnd

  • UserId

  • TimesheetId

  • PlanId

  • TaskId

  • Submitted

  • TimeApproved

  • PlanApproved

  • ModifiedBy

  • Modified

  • EntryDate

  • Hours

  • Line_Notes

  • Class

  • Billable

  • Day_Notes

  • ChargeType

Variable Tables

As you customize OnePlan to meet the needs of your organization, new tables will be created in the OData feed.

Plan_[PlanType]

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.

Plan_Applications

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_StartDate
  • Summary_EndDate
  • Summary_Effort
  • Summary_Duration
  • Summary_PercentDone
  • Summary_taskorder
  • Summary_WBS
  • NotStartedIssues
  • InvestmentHorizon_Id
  • InvestmentHorizon_Value
  • Today
  • PlanType_Space_Id
  • PlanType_Space_Value
  • PlanType_Challenge_Id
  • PlanType_Challenge_Value
  • AssociatedIdeas
  • AssociatedIdeas_Value
  • AssociatedSpace_Id
  • AssociatedSpace_Value
  • AssociatedChallenge_Id
  • AssociatedChallenge_Value
  • Summary_Facility

Plan_Capabilities

Out of the Box Links to Other Tables:

From: Table (Column)

Relationship Direction

To: Table (Column)

Plan_Capabilities (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
  • 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_StartDate
  • Summary_EndDate
  • Summary_Effort
  • Summary_Duration
  • Summary_PercentDone
  • Summary_taskorder
  • Summary_WBS
  • NotStartedIssues
  • InvestmentHorizon_Id
  • InvestmentHorizon_Value
  • Today
  • PlanType_Space_Id
  • PlanType_Space_Value
  • PlanType_Challenge_Id
  • PlanType_Challenge_Value
  • AssociatedIdeas
  • AssociatedIdeas_Value
  • AssociatedSpace_Id
  • AssociatedSpace_Value
  • AssociatedChallenge_Id
  • AssociatedChallenge_Value
  • Summary_Facility

Plan_Enterprise Architecture

Out of the Box Links to Other Tables:

From: Table (Column)

Relationship Direction

To: Table (Column)

Plan_Enterprise Architecture (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
  • 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_StartDate
  • Summary_EndDate
  • Summary_Effort
  • Summary_Duration
  • Summary_PercentDone
  • Summary_taskorder
  • Summary_WBS
  • NotStartedIssues
  • InvestmentHorizon_Id
  • InvestmentHorizon_Value
  • Today
  • PlanType_Space_Id
  • PlanType_Space_Value
  • PlanType_Challenge_Id
  • PlanType_Challenge_Value
  • AssociatedIdeas
  • AssociatedIdeas_Value
  • AssociatedSpace_Id
  • AssociatedSpace_Value
  • AssociatedChallenge_Id
  • AssociatedChallenge_Value
  • Summary_Facility

Plan_Epic

Out of the Box Links to Other Tables:

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

Plan_Idea

Out of the Box Links to Other Tables:

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

Plan_KeyResult

Out of the Box Links to Other Tables:

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

Plan_Objective

Out of the Box Links to Other Tables: 

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

Plan_Portfolio

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

Plan_Program

Out of the Box Links to Other Tables:

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

Plan_Project

Out of the Box Links to Other Tables:

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

Plan_Project_Epic

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

Plan_Value Stream

Out of the Box Links to Other Tables:

From: Table (Column)

Relationship Direction

To: Table (Column)

Plan_Value Stream (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
  • 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_StartDate
  • Summary_EndDate
  • Summary_Effort
  • Summary_Duration
  • Summary_PercentDone
  • Summary_taskorder
  • Summary_WBS
  • NotStartedIssues
  • InvestmentHorizon_Id
  • InvestmentHorizon_Value
  • Today
  • PlanType_Space_Id
  • PlanType_Space_Value
  • PlanType_Challenge_Id
  • PlanType_Challenge_Value
  • AssociatedIdeas
  • AssociatedIdeas_Value
  • AssociatedSpace_Id
  • AssociatedSpace_Value
  • AssociatedChallenge_Id
  • AssociatedChallenge_Value
  • Summary_Facility

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request