Tableau Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ProjectPrograms

The Project Programs resource is used to manage project programs and the program hierarchical structure. A program is a collection of projects that are managed as a group to coordinate, monitor and implement a corporate strategy.

Columns

Name Type Description
AssessmentCode String The code that represents the program owner's ongoing assessment for the likelihood that the program will meet the program objectives. Examples for assessments are On track and At risk. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_ASSESSMENT. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
AssessmentMeaning String The program owner's ongoing assessment for the likelihood that the program will meet the program objectives. Examples for assessments are On track and At risk. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_ASSESSMENT. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
FinishDate Date The date when the program is finished. The value is for informational purposes only.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.
LineOfBusinessCode String The code that represents the line of business name for the set of products and services that are managed by the program. Examples for line of business names are Product development and All lines of business. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_BUSINESS. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
LineOfBusinessMeaning String The line of business name for the set of products and services that are managed by the program. Examples for line of business names are Product development and All lines of business. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_BUSINESS. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
ParentProgramId Long The unique identifier of the parent program. A program without a parent is the root node in the hierarchy structure.
ParentProgramNumber String The unique number of the parent program. A program without a parent is the root node in the hierarchy structure.
PriorityCode String The code that represents the priority for the program. Examples for priority are High, Medium, and Low. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_PRIORITY. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
PriorityMeaning String The priority for the program. Examples for priority are High, Medium, and Low. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_PRIORITY. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
ProgramDescription String The description of the program.
ProjectProgramId [KEY] Long The unique identifier of the program.
ProgramName String The unique name of the program. A value is required to create a program.
ProgramNumber String The unique number of the program. The default value is the unique identifier of the program.
ProgramObjective String The objective of the program.
ProgramStatusName String The status of the program. Examples for status are Draft and Active. A value is required to create a program. Review and update the program status list of values using the Setup and Maintenance work area and the Manage Project Statuses task.
ProgramSystemStatusCode String The code that represents the system status defined for the program status. Values are DRAFT, SUBMITTED, ACTIVE, PENDING_CLOSE, and CLOSED. Review and update the program status list of values using the Setup and Maintenance work area and the Manage Project Statuses task.
PublicFlag Bool Indicates whether the program hierarchy can be viewed by all. If true, then programs in the hierarchy can be viewed by all. If false, then only the persons assigned as stakeholders directly or inherited from a parent or grandparent program can view their programs. The value is defined for the root node of the hierarchy. The default value is false.
RegionCode String The code that represents the geographic or divisional region that's covered by the program. Examples for region names are North America and All regions. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_REGION. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
RegionMeaning String The geographic or divisional region that's covered by the program. Examples for region names are North America and All regions. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_REGION. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
StartDate Date The date on which the program starts. The value is for informational purposes only.
StrategyCode String The code that represents the strategic plan of actions and policies that are targeted by the program. An example for strategy is Innovation. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_STRATEGY. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
StrategyMeaning String The strategic plan of actions and policies that are targeted by the program. An example strategy is Innovation. A list of accepted values is defined in the lookup type ORA_PROJECT_PROGRAM_STRATEGY. Review and update the list of values using the Setup and Maintenance work area and the Manage Standard Lookups task.
TreeStructureId Long The unique identifier of the program hierarchy structure.
OwningOrganizationName String The name of the owning organization. The value is for informational purposes only. Review and update organizations classified as owning organizations using the Setup and Maintenance work area and the task Manage Project Organization Classifications.
OwningOrganizationId Long The unique identifier of the owning organization.
ProgramBudget Decimal The budgeted amount allotted to the program.
ProgramBudgetCurrency String The currency of the budgeted amount allotted to the program.
Finder String finder
PersonId Long personid
ProjectId Long projectid

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