Results for “per_job_info_types_pk”

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

Overview

PER_JOB_INFO_TYPES is a Human Resources (PER) module table in the HR schema that defines the types of extra information that may be held against a job. It functions as a reference or lookup table within the Oracle E-Business Suite, providing the valid categories of supplementary job attributes that can be captured through the descriptive flexfield and extra information framework. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the configuration of job-related supplementary data, ensuring that only predefined information types are associated with job records during HR administration, recruitment, and workforce analytics.

From a dimensional modeling perspective, the mined Data Vault classification for this object is hub-leaning. This heuristic suggests that PER_JOB_INFO_TYPES behaves primarily as a hub entity, holding a stable business key (INFORMATION_TYPE) with relatively low volatility and descriptive attributes attached. Rather than a transactional link, it anchors the definition of information types around which job extra information records are organized.

Key Information Stored

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

• INFORMATION_TYPE — the primary business identifier for each information type; part of the PER_JOB_INFO_TYPES_PK unique index alongside ZD_EDITION_NAME.
• DESCRIPTION — the user-facing name or explanation of the information type, displayed in setup and entry forms.
• ACTIVE_INACTIVE_FLAG — controls whether the information type is available for selection.
• MULTIPLE_OCCURENCES_FLAG — governs whether more than one value of this type can be attached to a single job.
• LEGISLATION_CODE — localizes the information type to a specific country or legislative context.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrency and concurrent-program tracking columns.
• ZD_EDITION_NAME — the editioning column used in 12.2 online patching to support multiple editions of the same row.

The surrogate-level identifier is INFORMATION_TYPE within PER_JOB_INFO_TYPES_PK, which combines INFORMATION_TYPE and ZD_EDITION_NAME as the documented unique index; this composite nature reflects the editioning model in 12.2.2.

Common Use Cases and Queries

Typical reporting and configuration scenarios include listing all active information types for a legislation, confirming which allow multiple occurrences, and joining to the actual job extra information values. A representative query follows:

• SELECT information_type, description FROM per_job_info_types WHERE active_inactive_flag = 'Y' AND legislation_code = :leg_code;
• SELECT ji.information_type, ji.description FROM per_job_info_types ji JOIN per_job_extra_info jei ON jei.information_type = ji.information_type WHERE jei.job_id = :job_id;

These patterns support HR setup validation, data migration audits, and dashboards showing which supplementary attributes are configured per enterprise or country.

Related Objects

The most significant dependent object is PER_JOB_EXTRA_INFO, whose INFORMATION_TYPE column has a foreign key referencing PER_JOB_INFO_TYPES. This relationship confirms the hub role of PER_JOB_INFO_TYPES, with PER_JOB_EXTRA_INFO acting as the transactional satellite holding actual values. Related supporting objects include the standard PER descriptive flexfield structures, PER_JOB_DEFINITION and PER_ALL_POSITIONS used alongside jobs in HR setup, and the concurrent program metadata referenced by REQUEST_ID, PROGRAM_APPLICATION_ID, and PROGRAM_ID. Together these objects form the job supplementary information framework within Oracle EBS Human Resources.