Results for “pa_lowest_tasks_it”

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

Overview

PA_LOWEST_TASKS_IT is a reporting table in the Oracle Projects (PA) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. As its name and description indicate, the table stores lowest-level task information for reporting purposes. In the Oracle Projects task hierarchy, tasks can be nested at multiple levels beneath a project; this table isolates the leaf-level (lowest) tasks so that reporting tools and concurrent programs can query them without traversing the full hierarchy each time. The "_IT" suffix denotes an interface/reporting table rather than a transactional base table, and it is populated by Projects reporting processes.

From a Data Vault modeling perspective, the mined FK structure suggests a standalone classification — the table has no inbound foreign keys referencing it and only one outbound reference (TOP_TASK_ID to PA_TOP_TASKS_IT). Heuristically this behaves most like a satellite or reporting denormalization rather than a hub or link, since it carries descriptive attributes tied to a single business key.

Key Information Stored

The documented 12.2.2 physical schema contains 27 columns. The most significant include:

• TASK_ID — the surrogate primary key, also the sole business-key candidate via unique index PA_LOWEST_TASKS_IT_U1.
• TOP_TASK_ID — foreign key to PA_TOP_TASKS_IT, linking each lowest task to its top-level task ancestor.
• TASK_NUMBER and TASK_NAME — human-readable business identifiers for the task.
• CARRYING_OUT_ORGANIZATION_ID — the organization responsible for executing the task.
• SERVICE_TYPE_CODE — classifies the task's service type.
• STATUS_CODE — the current lifecycle status of the task.
• DESCRIPTION — free-text description of the task.
• USER_COL1 through USER_COL10 — ten extensibility (DDF-style) attribute columns for client-specific reporting data.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard Oracle WHO columns for auditing.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program audit columns identifying the process that populated the row.

Common Use Cases and Queries

This table is primarily consumed by Oracle Projects reporting. Typical patterns include joining lowest tasks to their top-level parent, filtering by organization or status, and driving spend or effort reports at the leaf level.

• List active lowest tasks for a top task:
  SELECT l.task_number, l.task_name, l.status_code FROM pa_lowest_tasks_it l WHERE l.top_task_id = :top_task_id AND l.status_code = 'ACTIVE';
• Aggregate tasks by carrying organization:
  SELECT carrying_out_organization_id, COUNT(*) FROM pa_lowest_tasks_it GROUP BY carrying_out_organization_id;
• Audit last refresh of the reporting snapshot:
  SELECT MAX(last_update_date), MAX(request_id) FROM pa_lowest_tasks_it;
• Use USER_COL1–USER_COL10 for client-specific report bucketing where standard columns are insufficient.

Because it is a reporting table, it should generally be treated as read-only by custom code; underlying task changes are reflected after the relevant Projects reporting program runs.

Related Objects

• PA_TOP_TASKS_IT — parent by TOP_TASK_ID; holds top-level task information.
• PA_TASKS — the transactional task definition table from which lowest tasks derive.
• PA_PROJECTS_ALL — project header data joining the task to its project.
• PA_PROJECT_TASKS — full task hierarchy for reconciling leaf versus parent tasks.
• PA_TASK_ASSIGNMENTS — resource assignments at the task level.
• PA_EXPENDITURES_ALL / PA_COST_DISTRIBUTIONS — transactional facts reported by lowest task.
• Projects reporting concurrent programs that populate PA_LOWEST_TASKS_IT and PA_TOP_TASKS_IT.