Excel Add-In for Oracle Fusion Cloud Financials

Build 25.0.9434

ProjectsTasks

The Task resource includes the attributes that are used to store values while creating or updating project tasks. Tasks are units of project work assigned or performed as part of the duties of a resource. Tasks can be a portion of project work to be performed within a defined period by a specific resource or multiple resources.

Columns

Name Type Description
ProjectsProjectId [KEY] Long Unique identifier of the project.
ActualQuantity Decimal Actual effort spent on the project task.
AllowCrossChargeTransactionsFlag Bool Indicates if the task can accept charges from other business units.
BaselineAllocation Decimal Original planned allocation of the task in the primary work plan baseline.
BaselineDuration Decimal Original planned duration of the task in the primary work plan baseline.
BaselineFinishDate Date Original planned finish date of the task in the primary work plan baseline.
BaselineStartDate Date Original planned start date of the task in the primary work plan baseline.
BaselineQuantity Decimal Original planned effort of the task in the primary work plan baseline.
BillableFlag Bool Indicates transactions charged to that task can be billed to customers.
BurdenSchedule String Name of the burden schedule associated with the task. A burden schedule is a set of burden multipliers that is maintained for use across projects. Also referred to as a standard burden schedule.
ChargeableFlag Bool Chargeable task checkbox indicator
CapitalizableFlag Bool Specifies if the project task is capitalizable. A value of true means that the task is capitalizable and a value of false means that the task is not capitalizable. The default value is false for a summary task belonging to a noncapital project. The default value is true for a summary task belonging to a capital project. For a subtask belonging to a capital project, the default value is the corresponding value of the parent task.
ConstraintDate Date The date when a task must start or complete based on the constraint type for the task.
ConstraintType String The type of scheduling constraint applied on the task.
CriticalFlag Bool A task that must be completed on schedule or it will impact the finish date of the entire project.
CrossChargeLaborFlag Bool Indicates that the task will allow processing of cross-charge transactions between business units for labor costs.
CrossChargeNonLaborFlag Bool Indicates that the task will allow processing of cross-charge transactions between business units for nonlabor costs.
ReceiveIntercompanyAndInterprojectInvoicesFlag Bool Indicates if the task can receive invoices from other projects and organizations. A value of true means that the task can be included on intercompany and interproject invoices and a value of false means that the task cannot be included on intercompany and interproject invoices. The default value is false.
ServiceType String Specifies an activity assigned to the project task for tracking purposes. You can enter a value either for this attribute or Service Type Code but not both while creating or updating a project task. A list of valid values is defined in the lookup type PJF_SERVICE_TYPE. The default value is derived from the project to which the task belongs.
ServiceTypeCode String Code that specifies an activity assigned to the project task for tracking purposes. You can enter a value either for this attribute or Service Type but not both while creating or updating a project task. A list of valid values is defined in the lookup type PJF_SERVICE_TYPE. The default value is derived from the project to which the task belongs.
WorkType String Name of the classification of the work associated with the project task. Use work types to categorize and group tasks for processing purposes. You can enter a value for either this attribute or Work Type ID but not both while creating a project task. The work type must be active within the planned task dates. The default value is derived from the project type or the project to which the task belongs.
WorkTypeId Long Name of the classification of the work associated with the project task. Use work types to categorize and group tasks for processing purposes. You can enter a value for either this attribute or Work Type ID but not both while creating a project task. The work type must be active within the planned task dates. The default value is derived from the project type or the project to which the task belongs.
CurrentFinishDate Date The date when the task is estimated to end.
CurrentStartDate Date The date when the task is estimated to start.
CurrentQuantity Decimal Total estimated effort on the task at completion.
ElementType String Title for the exposed attribute for element type task attributes in OTBI.
ExecutionDisplaySequence Long The order in which the task is displayed in the project.
ExternalParentTaskId String Unique identifier of the parent project task that is created in the third-party application.
ExternalTaskId String Unique identifier of the project task that is created in the third-party application.
LowestLevelTask String Indicates the task is at the lowest level.
ManualSchedule String The schedule mode where you need to schedule the task manually and can't update it automatically using the scheduling process.
MilestoneFlag Bool Indicates the project milestone during which the task must be completed.
ParentTaskId Long Identifier of the parent task of the task.
ProgressStatusCode String The status of work completed on the task or milestone. Valid values for the status of a task or nonbillable milestone are NOT_STARTED, IN_PROGRESS, COMPLETED. Valid values for the status of a billable milestone are NOT_STARTED, IN_PROGRESS, REJECTED, SUBMITTED, COMPLETED.
RemainingQuantity Decimal Effort remaining on the project task.
RequirementCode String The unique code corresponding to a requirement.
RequirementName String The name of the requirement.
Sprint String The sprint in which the task was completed or is estimated to be completed. You can configure the valid values during application set up.
TaskActualFinishDate Date The actual finish date for the task as opposed to a planned finish date for the task.
TaskActualStartDate Date The date that work commenced on a task as opposed to the planned start date for the task.
TaskCode01Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode02Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode03Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode04Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode05Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode06Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode07Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode08Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode09Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode10Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode11Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode12Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode13Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode14Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode15Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode16Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode17Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode18Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode19Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode20Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode21Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode22Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode23Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode24Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode25Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode26Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode27Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode28Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode29Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode30Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode31Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode32Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode33Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode34Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode35Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode36Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode37Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode38Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode39Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskCode40Id Long Task code defined during implementation that provides a list of values to capture additional information for a project task.
TaskDescription String Text description of the project task that is being created.
TaskDuration Decimal Length of time within which the project task is scheduled to be completed.
TaskFinishDate Date Scheduled end date of the project task.
TaskId Long Unique identifier of the project task.
SourceApplication String The external application from which the task is imported.
SourceReference String Identifier of the task in the external system where it was originally entered.
TaskLevel Int Indicates level of the task in the WBS.
TaskManagerEmail String Email of the person who is assigned as task manager to the task.
TaskManagerName String The resource who manages the task.
TaskManagerPersonId Long Unique identifier of the person who leads the project task and who has the authority and responsibility for meeting the task objectives.
TaskName String The name of the task. A task is subdivision of project work. Each project can have a set of top tasks and a hierarchy of subtasks below each top task.
TaskNumber String The number of a task.
TaskNumberAttr01 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr02 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr03 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr04 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr05 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr06 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr07 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr08 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr09 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskNumberAttr10 Decimal Task code defined during implementation that provides the ability to capture a numeric value as additional information for a project task.
TaskOrganizationId Long Unique identifier of the task organization.
TaskOrganizationName String The name of the task organization.
TaskPercentComplete Decimal Percentage of work completed for an object or task.
TaskPhysicalPercentComplete Decimal The amount of physical work achieved on a task.
TaskPriority Decimal Indicates the importance of a project task based on a predefined scale.
TaskQuantity Decimal Measure of the effort required to complete the project task.
TaskResourceAllocationPercent Decimal Percentage of hours that a resource is allocated to the project task for a specified duration
TaskSequence Long Position of the project task in a hierarchical arrangement.
TaskStartDate Date Scheduled start date of the project task.
TaskTextAttr01 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr02 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr03 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr04 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr05 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr06 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr07 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr08 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr09 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr10 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr11 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr12 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr13 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr14 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr15 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr16 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr17 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr18 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr19 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TaskTextAttr20 String Task code defined during implementation that provides free-form text entry to capture additional information for a project task.
TransactionCompletionDate Date Transaction finish date of a task.
TransactionStartDate Date Transaction start date of a task.
TopTaskId Long Identifier of the top task to which the task rolls up. If the task is a top task, the identifier of the top task is same as the identifier of the task.
TransactionControlFlag Bool Type of transaction controls, inclusive or exclusive, defined for the selected task. A value of true means inclusive and a value of false means exclusive.
ActiveDate Date activedate
ClassCategory String classcategory
Finder String finder
FinishDate Date finishdate
OwningOrganizationName String owningorganizationname
PartyName String partyname
PersonId Long personid
PersonName String personname
ProjectId Long projectid
ProjectName String projectname
ProjectRole String projectrole
ProjectStatus String projectstatus
SearchAttribute String searchattribute
SourceApplicationCode String sourceapplicationcode
SourceProjectReference String sourceprojectreference
StartDate Date startdate

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