Results for “per_job_groups_v”

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

Overview

The PER_JOB_GROUPS_V view is an APPS-owned, VALID database object within the PER – Human Resources product of Oracle E-Business Suite 12.1.1 / 12.2.2. Its documented purpose is to retrieve Job Group and associated flexfield information. A Job Group is a Human Resources construct that bundles one or more jobs under a single structure so that legislative or reporting rules—such as EEO categories or statutory groupings—can be applied consistently to a set of jobs. This view joins the transactional Job Group definition to its owning business group organization name and to the Key Flexfield structure registered for the 'JOB' flexfield code, exposing both descriptive attributes and flexfield metadata in one row per Job Group.

In reporting and integration contexts the view functions as a denormalized read layer sitting on top of PER_JOB_GROUPS. It is typically used by concurrent programs, BI Publisher reports, OAF pages, and third-party extracts that require not only the internal and displayed Job Group names, but also the human-readable flexfield structure name and the master flag state that governs whether the record is a master or an override.

Underlying Base Objects

The view text is defined over three documented base objects:

• PER_JOB_GROUPS (SYNONYM) — the primary base object, aliased as JGR. It supplies the Job Group's identity, naming, flexfield number, master flag, and audit columns.
• HR_ALL_ORGANIZATION_UNITS (SYNONYM) — aliased as ORG. It supplies BUSINESS_GROUP_NAME via ORG.NAME. The join is outer-joined (JGR.BUSINESS_GROUP_ID = ORG.ORGANIZATION_ID (+)), so Job Groups without a matching organization unit are still returned.
• FND_ID_FLEX_STRUCTURES_VL (VIEW) — aliased as FND. It supplies ID_FLEX_STRUCTURE_NAME and is joined on ID_FLEX_NUM, constrained to ID_FLEX_CODE = 'JOB'. Because this is a non-outer join, only Job Groups tied to a valid JOB flexfield structure are returned.

Each row represents one Job Group. The ROWID of the base PER_JOB_GROUPS row is exposed as ROW_ID.

Key Columns

• ROW_ID — Row identifier derived from JGR.ROWID; useful for row-level addressing.
• JOB_GROUP_ID, BUSINESS_GROUP_ID — Primary key and the business group (organization) that owns the Job Group.
• BUSINESS_GROUP_NAME — Display name of the owning organization unit, sourced from HR_ALL_ORGANIZATION_UNITS.NAME.
• LEGISLATION_CODE — Statutory legislation under which the Job Group is defined.
• INTERNAL_NAME, DISPLAYED_NAME — Internal and user-facing names of the Job Group.
• ID_FLEX_NUM, ID_FLEX_STRUCTURE_NAME — The Job flexfield structure number and its translatable name, enabling the same Job Group semantics to be mapped to a flexfield structure.
• MASTER_FLAG — Flag indicating whether the Job Group definition is the master record or a local override. This is especially relevant to absent searches on master_flag.
• OBJECT_VERSION_NUMBER — Optimistic locking version used by the date-tracked/ORM layer.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns for change tracking and provenance.

Common Use Cases and Queries

Typical uses include listing Job Groups by business group, locating the flexfield structure applied to a Job Group, and filtering by MASTER_FLAG to distinguish master records from overrides. The following sample filters on the searched term:

• By master flag: SELECT job_group_id, internal_name, displayed_name, id_flex_structure_name FROM per_job_groups_v WHERE master_flag = 'Y' AND business_group_id = :p_bg_id;
• By legislation: SELECT job_group_id, displayed_name, legislation_code FROM per_job_groups_v WHERE legislation_code = 'US';
• With flexfield context: SELECT jg.internal_name, jg.id_flex_structure_name, jg.business_group_name FROM per_job_groups_v jg WHERE jg.id_flex_num = :p_flex_num ORDER BY 1;

Because the flexfield join is non-outer, queries that must return Job Groups lacking a registered JOB structure should be written against PER_JOB_GROUPS directly rather than this view.