Search Results pa_projects_all

Overview

PER_JOB_GROUPS is a Human Resources (PER) table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It holds job group information, providing a classification layer above individual jobs. According to the documented description, each job is a member of a job group, and a job group can optionally reside within a business group. This structure allows organizations to cluster related jobs—such as by function, grade band, or bargaining unit—so that downstream modules can reference the grouping rather than enumerating individual jobs.

In Data Vault modeling terms, the metadata's heuristic classification places PER_JOB_GROUPS as a hub. This is a reasonable suggestion: the table carries a single-column surrogate primary key, a small number of descriptive attributes, and is referenced by many downstream tables rather than acting as a transactional link or type-2 satellite. Job groups function as a stable business concept that other subject areas point to.

Key Information Stored

The table contains thirteen documented columns. The most significant are:

• JOB_GROUP_ID — the surrogate primary key (PER_JOB_GROUPS_PK). This is the value carried by every foreign key in dependent tables.
• INTERNAL_NAME and BUSINESS_GROUP_ID — together forming the unique business key (PER_JOB_GROUPS_UK1). INTERNAL_NAME is the system-facing identifier, while BUSINESS_GROUP_ID ties the row to an operating unit defined in HR_ALL_ORGANIZATION_UNITS.
• DISPLAYED_NAME — the user-visible label shown in forms and list of values.
• LEGISLATION_CODE — the legislative context that governs the group, important for global or multi-country implementations.
• ID_FLEX_NUM — links the row to the descriptive flexfield definition, enabling installation-specific attributes.
• MASTER_FLAG — indicates the master record in a global, multi-org (Business Group) configuration.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates via the Oracle Application Object Library.
• Standard WHO/audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

The distinction between JOB_GROUP_ID (surrogate key) and the INTERNAL_NAME/BUSINESS_GROUP_ID pair (business-key candidate) is important for integration: external systems should ideally resolve to the surrogate key at load time.

Common Use Cases and Queries

Typical reporting queries resolve the group behind a job, or list all jobs within a group:

• Joining PER_JOBS to PER_JOB_GROUPS on JOB_GROUP_ID to report job-to-group mappings.
• Joining PER_ROLES to PER_JOB_GROUPS to associate roles with job groups for security or eligibility rules.
• Filtering by BUSINESS_GROUP_ID to produce business-group-specific lists of job groups for an operating unit.
• Joining to PA_PROJECTS_ALL on BILL_JOB_GROUP_ID or COST_JOB_GROUP_ID to determine which job groups drive project billing and costing.
• Joining to PA_PROJECT_TYPES_ALL to determine default billing/costing job groups by project type.

A representative query:

SELECT jg.job_group_id, jg.internal_name, jg.displayed_name, jg.business_group_id FROM per_job_groups jg WHERE jg.business_group_id = :p_bg ORDER BY jg.internal_name;

Because the object is a hub, most reporting joins start from this table and fan out to dependent facts.

Related Objects

The most significant objects that reference PER_JOB_GROUPS through documented foreign keys are:

• PER_JOBS — references PER_JOB_GROUPS via PER_JOBS.JOB_GROUP_ID; the primary parent-child relationship.
• PER_ROLES — references PER_JOB_GROUPS via PER_ROLES.JOB_GROUP_ID.
• PA_PROJECTS_ALL — references the table through both PA_PROJECTS_ALL.BILL_JOB_GROUP_ID and PA_PROJECTS_ALL.COST_JOB_GROUP_ID, linking Projects billing and costing to job groups.
• PA_PROJECT_TYPES_ALL — references the table via BILL_JOB_GROUP_ID and COST_JOB_GROUP_ID to set project-type defaults.
• PA_PROJECT_ASSIGNMENTS — references PER_JOB_GROUPS through PA_PROJECT_ASSIGNMENTS.FCST_JOB_GROUP_ID.
• PA_RBS_VERSIONS_B and PA_RESOURCE_LISTS_ALL_BG — reference JOB_GROUP_ID for resource list and rate schedule definitions.
• AP_POL_HEADERS — references PER_JOB_GROUPS via AP_POL_HEADERS.JOB_GROUP_ID.
• HR_ALL_ORGANIZATION_UNITS — the parent organization unit referenced by PER_JOB_GROUPS.BUSINESS_GROUP_ID.

Together these relationships position PER_JOB_GROUPS as a shared reference hub across Human Resources, Projects, Payables, and Benefits.