Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ProjectProgressTaskProgressResourceProgress

The Project Progress resource is used to capture draft progress, view draft and published progress, update draft progress, and publish progress for a project enabled for financial management.

Columns

Name Type Description
ProjectId Long Unique identifier of the project.
ProjectName String Name assigned to the project.
ProjectNumber String Alphanumeric identifier of the project.
SourceApplicationCode String The third-party application from which the project originated.
SourceApplicationReference String The identifier of the project in the external application where it was originally created.
TaskId Long Unique identifier of the task.
TaskName String Name assigned to the task.
TaskNumber String Alphanumeric identifier of the task.
ProgressAsOfDate Date Date through which progress is captured for the project.
ProgressAsOfPeriod String Period through which progress is captured for the project.
ActualsAmountsThroughPeriod String Period through which actual amounts are summarized for project progress.
ActualAmountsDate Date Date on which actual amounts are most recently summarized.
PublicationStatus String Status of the current project progress. The status can either be Draft or Published.
CurrentActualAmountsPeriod String Period through which actual amounts are most recently summarized.
CurrentActualAmountsDate Date Date on which actual amounts are most recently summarized.
PlanningStartDate Date Scheduled start date of the task.
PlanningEndDate Date Scheduled end date of the task.
BaselineStartDate Date Planned start date of the task in the baseline project plan. Used to compare the deviation of the current task start from the original planned start date.
BaselineFinishDate Date Planned end date of the task in the baseline project plan. Used to compare the deviation of the current task end from the original planned end date.
ProjectCurrency String The currency code for the project. It is a three-letter ISO code associated with a currency.
ProjectRawActualCost Decimal Actual amount paid or actual amount incurred for the task in project currency.
ProjectBurdenedActualCost Decimal Cost that is actually charged to the task in project currency. Burdened cost is the sum of raw cost and the overhead.
ProjectLedgerCurrency String The currency code used for accounting and reporting in the project ledger. It is a three-letter ISO code associated with a currency.
ProjectLedgerRawActualCost Decimal Actual amount paid or actual amount incurred for the task in project ledger currency.
ProjectLedgerBurdenedActualCost Decimal Cost that is actually charged to the task in project ledger currency. Burdened cost is the sum of raw cost and the overhead.
ResourceId Long Identifier of the ?resource breakdown structure element ?used to create the financial plan resource assignment.
ResourceName String Name or alias of the resource included in the planning resource breakdown structure that is used to create the financial plan resource assignment.
UnitOfMeasure String Unit of work that measures the quantity of effort for which the resource is planned for on the financial plan resource assignment.
ResourceClass String Grouping of predefined resource types to which the resource in the financial plan resource assignment belongs. ?A list of valid values are Labor, Equipment, Material Items, and Financial Resources.
ResourceAssignmentFromDate Date The date that is planned on the financial plan for a resource to begin their assignment on a project task.
ResourceAssignmentToDate Date The date that is planned on the financial plan for a resource to finish their assignment on a project task.
EstimatedStartDate Date An estimated start date collected during progress entry and usually defaulted to the resource assignments planned start date.
EstimatedFinishDate Date An estimated finish date collected during progress entry and usually defaulted to the resource assignments planned to date.
ActualStartDate Date Actual start date collected during progress entry.
ActualFinishDate Date Actual finish date collected during progress entry.
EstimatetoCompleteQuantity Decimal Estimate to complete in quantity.
EstimatetoCompleteCostinProjectCurrency Decimal Estimate to complete burdened cost in project currency.
EstimateatCompletionQuantity Decimal Estimate at completion quantity.
EstimateatCompletionCostinProjectCurrency Decimal Estimate at completion burdened cost in project currency.
Unplanned String Unplanned project cost included on the project.
BaselinedPlannedEffort Decimal Baselined planned effort from the financial project plan.
BaselinedPlannedQuantity Decimal Baselined planned quantity from the financial project plan.
BaselinedPlannedCost Decimal Baseline planned burdened cost from the project plan
CurrentPlannedEffort Decimal Current planned effort from the financial project plan.
CurrentPlannedQuantity Decimal Current planned quantity from the financial project plan.
CurrentPlannedCost Decimal Current planned burdened cost from the project plan
Finder String finder
SourceProjectReference String sourceprojectreference

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454