Results for “per_job_groups_uk1”

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

Overview

HR.PER_JOB_GROUPS is a foundational Human Resources table within Oracle E-Business Suite that defines the grouping construct used to organize records held in PER_JOBS. A job group provides the container within which individual jobs are created, secured, and reported, and it determines the key flexfield structure that all jobs belonging to that group must use. Every job group exists within a business group, except when the HR: Cross Business Group Profile profile option is set to N, in which case a job group may carry a NULL business group and is treated as a Global Job Group. Jobs defined in global job groups are visible system-wide.

The table is significant because Oracle HRMS requires that every HR-related job be defined inside a "Default HR Job Group," which is created automatically when a business group is created. The table is stored in the APPS_TS_TX_DATA tablespace with a primary key of PER_JOB_GROUPS_PK and a unique business key of PER_JOB_GROUPS_UK1. From a Data Vault modeling perspective, the mined relationship structure suggests classifying PER_JOB_GROUPS as a hub, since it holds a stable surrogate-keyed business entity referenced by numerous dependent tables.

Key Information Stored

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

• JOB_GROUP_ID — the system-generated surrogate primary key (PER_JOB_GROUPS_PK).
• BUSINESS_GROUP_ID — foreign key to the business group in HR_ALL_ORGANIZATION_UNITS; NULL permits a Global Job Group.
• INTERNAL_NAME — the internal name of the job group. Together with BUSINESS_GROUP_ID, it forms the unique business key (PER_JOB_GROUPS_UK1). It cannot be updated after creation.
• DISPLAYED_NAME — the name rendered on forms and reports; unlike INTERNAL_NAME, it is user-updatable.
• LEGISLATION_CODE — the legislation to which the job group applies.
• ID_FLEX_NUM — identifies the key flexfield structure that jobs within the group must use.
• MASTER_FLAG — designates the master/default job group.
• OBJECT_VERSION_NUMBER — optimistic locking control column used by the OAF/ADF framework.
• Standard WHO audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

The surrogate key JOB_GROUP_ID should not be confused with the business-key pair INTERNAL_NAME + BUSINESS_GROUP_ID, which enforces uniqueness at the business level.

Common Use Cases and Queries

Typical scenarios include validating that a job group exists before creating jobs, listing all active job groups within a business group, and driving jobs-related reporting and security. A common query joins the table to the business group:

• Retrieve all job groups for a business group: SELECT job_group_id, internal_name, displayed_name FROM per_job_groups WHERE business_group_id = :p_bg_id;
• Count jobs per group: join to PER_JOBS on JOB_GROUP_ID.
• Reporting job group usage across project costing and billing, joining to PA_PROJECTS_ALL via COST_JOB_GROUP_ID or BILL_JOB_GROUP_ID.
• Identifying the Default HR Job Group through MASTER_FLAG and legislation filters.

Related Objects

The table participates in a hub-and-spoke relationship structure. It references HR_ALL_ORGANIZATION_UNITS through BUSINESS_GROUP_ID, and is referenced by many downstream tables, including:

• PER_JOBS.JOB_GROUP_ID — the primary child table, linking each job to its group.
• PER_ROLES.JOB_GROUP_ID — binds roles to job groups.
• PA_PROJECTS_ALL via COST_JOB_GROUP_ID and BILL_JOB_GROUP_ID — drives project costing and billing rates.
• PA_PROJECT_ASSIGNMENTS.FCST_JOB_GROUP_ID, PA_PROJECT_TYPES_ALL, PA_BILL_RATES_ALL, and PA_STD_BILL_RATE_SCHEDULES_ALL — project and rate configuration.
• AP_POL_HEADERS.JOB_GROUP_ID, BEN_ELIG_SUPPL_ROLE_PRTE_F.JOB_GROUP_ID, and PQH_DE_WRKPLC_VLDTN_VERS.JOB_GROUP_ID — payables policies, benefits eligibility, and public-sector validation.

The PER_JOB_GROUPS_FK1 index on BUSINESS_GROUP_ID supports efficient lookups of all job groups belonging to a single business group, which is the most frequent access path.