Results for “pa_proj_progress_attr”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_PROJ_PROGRESS_ATTR is a Projects (PA) module table that stores progress setup related information for structures. It defines the progress configuration applied to a project structure, governing how physical and financial progress is captured, weighted, and rolled up across project elements. Each row represents a progress setup record tied to a specific object (such as a project element) within a project, and to a structure type and object type that determine the scope of the configuration.

The table resides in the PA schema and is wholly owned by Oracle EBS. In version 12.2.2 the documented physical schema contains 19 columns. Based on the foreign key structure provided in the metadata, a Data Vault classification heuristic suggests treating PA_PROJ_PROGRESS_ATTR as a link entity: it associates a project (PROJECT_ID) with a project element (OBJECT_ID) and a billing cycle (PROGRESS_CYCLE_ID), capturing the relationships that bind progress configuration together. The attributes carried on the row can be modeled as link-level or dependent attributes in a Data Vault design.

Key Information Stored

The primary key of the table is PA_PROJ_PROGRESS_ATTR_PK, defined on the surrogate column PROJ_PROGRESS_ATTR_ID. A second unique index, PA_PROJ_PROGRESS_ATTR_U1, also covers PROJ_PROGRESS_ATTR_ID. The business-key candidate is captured by PA_PROJ_PROGRESS_ATTR_U2, a composite unique index on (PROJECT_ID, OBJECT_ID, OBJECT_TYPE, STRUCTURE_TYPE), which enforces that one progress setup record exists per project, object, object type, and structure type combination.

The most significant columns include:

• PROJ_PROGRESS_ATTR_ID — surrogate primary key and unique identifier for the progress setup row.
• PROJECT_ID — the project to which the progress setup applies; part of the business-key unique index.
• OBJECT_ID — the referenced object, foreign key to PA_PROJ_ELEMENTS; identifies the project element whose progress is configured.
• OBJECT_TYPE and STRUCTURE_TYPE — qualify the scope and structure context of the setup; both participate in the business-key unique index.
• PROGRESS_CYCLE_ID — foreign key to PA_BILLING_CYCLES, defining the progress measurement or billing cycle.
• WQ_ENABLE_FLAG — controls whether work quantity progress entry is enabled.
• REMAIN_EFFORT_ENABLE_FLAG — controls whether remaining-effort-based progress is enabled.
• PERCENT_COMP_ENABLE_FLAG — controls whether percent-complete progress entry is enabled.
• ALLOW_COLLAB_PROG_ENTRY — indicates whether collaborative progress entry is permitted.
• ALLOW_PHY_PRCNT_CMP_OVERRIDES — indicates whether physical percent-complete overrides are allowed.
• NEXT_PROGRESS_UPDATE_DATE — the next scheduled progress update date.
• TASK_WEIGHT_BASIS_CODE — the weighting basis applied to tasks for progress rollup.
• RECORD_VERSION_NUMBER — optimistic locking / concurrency control version.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting scenarios include retrieving the progress configuration for a given project, determining which progress methods are enabled, and identifying the progress cycle and update schedule.

• Progress setup by project: SELECT * FROM PA.PA_PROJ_PROGRESS_ATTR WHERE PROJECT_ID = :project_id;
• Enabled progress methods: SELECT PROJECT_ID, OBJECT_ID, WQ_ENABLE_FLAG, REMAIN_EFFORT_ENABLE_FLAG, PERCENT_COMP_ENABLE_FLAG FROM PA.PA_PROJ_PROGRESS_ATTR WHERE PROJECT_ID = :project_id;
• Join to project elements for structure detail: SELECT a.PROJECT_ID, a.OBJECT_ID, e.* FROM PA.PA_PROJ_PROGRESS_ATTR a, PA.PA_PROJ_ELEMENTS e WHERE a.OBJECT_ID = e.PROJ_ELEMENT_ID AND a.PROJECT_ID = :project_id;
• Join to billing cycles to display the cycle: SELECT a.PROJECT_ID, a.PROGRESS_CYCLE_ID, b.* FROM PA.PA_PROJ_PROGRESS_ATTR a, PA.PA_BILLING_CYCLES b WHERE a.PROGRESS_CYCLE_ID = b.CYCLE_ID;
• Upcoming progress updates: SELECT PROJECT_ID, OBJECT_ID, NEXT_PROGRESS_UPDATE_DATE FROM PA.PA_PROJ_PROGRESS_ATTR WHERE NEXT_PROGRESS_UPDATE_DATE > SYSDATE ORDER BY NEXT_PROGRESS_UPDATE_DATE;

Related Objects

The following objects are significant to PA_PROJ_PROGRESS_ATTR based on the documented relationships:

• PA_PROJ_ELEMENTS — referenced through PA_PROJ_PROGRESS_ATTR.OBJECT_ID; supplies project element detail for the progress setup.
• PA_BILLING_CYCLES — referenced through PA_PROJ_PROGRESS_ATTR.PROGRESS_CYCLE_ID; defines the progress/billing cycle.
• PA_PROJ_PROGRESS_ATTR_PK — the primary key constraint on PROJ_PROGRESS_ATTR_ID.
• PA_PROJ_PROGRESS_ATTR_U1 — unique index on PROJ_PROGRESS_ATTR_ID.
• PA_PROJ_PROGRESS_ATTR_U2 — composite unique index on (PROJECT_ID, OBJECT_ID, OBJECT_TYPE, STRUCTURE_TYPE).
• PA_PROJECTS_ALL — the project master referenced conceptually through PROJECT_ID.