Results for “group_flag”

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

Overview

PA_RESOURCE_TYPES is a Projects (PA) module reference table that defines the categories of resources used throughout Oracle E-Business Suite. A "resource" in Oracle Projects is any person, organization, or non-labor asset whose time, effort, or cost is tracked against a project. PA_RESOURCE_TYPES establishes the allowable classifications for those resources, functioning as a controlled lookup that governs how resource records are validated, grouped, and reported. The table is owned by the PA schema and is flagged as VALID in the ETRM 12.2.2 metadata. Its documented primary key is PA_RESOURCE_TYPES_PK, defined on RESOURCE_TYPE_ID.

Based on the foreign key topology supplied in the metadata — in which PA_RESOURCE_TYPES is referenced by ten dependent tables and references none itself — the object exhibits a hub-leaning profile in a Data Vault model. As a modeling suggestion, it is best represented as a hub entity, with RESOURCE_TYPE_ID serving as the business key that anchors dependent satellite and link structures. This pattern reflects its role as a stable, slowly-changing classification source rather than a transactional or fact-bearing table.

Key Information Stored

The documented physical schema contains 17 columns. The most operationally significant are:

• RESOURCE_TYPE_ID — The surrogate primary key (PA_RESOURCE_TYPES_PK) that uniquely identifies each resource type and is propagated to all dependent tables as a foreign key.
• RESOURCE_CLASS_CODE — The high-level class to which the resource type belongs (for example, labor, non-labor, or organization), used to drive processing and validation logic.
• RESOURCE_TYPE_CODE — The business-facing short code for the resource type, commonly used in reports and interfaces.
• NAME and DESCRIPTION — The descriptive label and longer explanation displayed to users.
• TABLE_NAME and ACCESS_KEY — Identify the underlying source table and discriminator used when resolving actual resource records.
• SQL_TEXT — An optional query fragment used to constrain or dynamically derive the resource population for the type.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Date-effective range controls that determine when a resource type is available for assignment.
• GROUP_FLAG — Indicates whether the type represents a grouped or individual resource classification.
• ZD_EDITION_NAME — The editioning column introduced by EBS Online Patching; it participates with RESOURCE_TYPE_ID in the unique index PA_RESOURCE_TYPES_U1, the documented business-key candidate. Audit columns include CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include validating resource definitions, restricting resource availability on project assignments, and grouping resources for resource lists and distribution reporting. A frequent query pattern retrieves only currently active types:

• SELECT resource_type_id, resource_type_code, name
FROM pa_resource_types
WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE)
AND NVL(zd_edition_name, 'SET1') = 'SET1';
• Joining to PA_RESOURCES to list all resources and their classifications: pa_resources.resource_type_id = pa_resource_types.resource_type_id.
• Reporting resource-list composition via PA_RESOURCE_LIST_MEMBERS and PA_RESOURCE_LISTS_ALL_BG to identify grouped resource types.
• Reconciling distribution lists through PA_DIST_LIST_DENORM for cost and billing analysis.

Related Objects

The following dependent tables reference PA_RESOURCE_TYPES through RESOURCE_TYPE_ID and represent the most significant relationships:

• PA_RESOURCES — Master resource records; joins on RESOURCE_TYPE_ID.
• PA_PROJECT_PARTIES — Project team and party assignments.
• PA_PROJECT_PARTIES_AR — Archived party records.
• PA_RESOURCE_LIST_MEMBERS — Individual resources belonging to resource lists.
• PA_RESOURCE_LISTS_ALL_BG — Group resource definitions referencing GROUP_RESOURCE_TYPE_ID.
• PA_DIST_LIST_DENORM — Denormalized distribution list data used in costing and reporting.
• PA_RBS_ELEMENT_NAMES_B and PA_RBS_ELEMENT_MAP — Reporting and budgeting element mappings.
• AHL_RESOURCES and AHL_RT_OPER_RESOURCES — Oracle Complex Maintenance, Repair, and Overhaul resource references, demonstrating cross-module consumption of Projects resource types.