Search Results per_position_info_types




Overview
Explore in AI Chat

Overview

The PER_POSITION_INFO_TYPES table is a foundational data dictionary object within the Oracle E-Business Suite Human Resources (PER) module, specifically for releases 12.1.1 and 12.2.2. It functions as a master reference table that defines the valid categories or types of descriptive flexfield (DFF) data that can be attached to a position. In essence, it stores the metadata for custom position attributes, enabling organizations to extend the standard position model to capture unique, business-specific information without modifying the core application code. Its role is to provide a controlled list of information types, ensuring data integrity and consistency for all position-related extra information stored in the system.

Key Information Stored

The table's primary purpose is to define the unique identifiers for these custom information types. Its most critical column is INFORMATION_TYPE, which serves as the table's primary key. This column stores the unique code or name that identifies a specific category of extra information, such as 'SECURITY_CLEARANCE', 'BUDGET_CODE', or 'PHYSICAL_LOCATION_DETAILS'. While the provided ETRM metadata does not list all columns, typical supporting columns in such reference tables would include a user-facing NAME, a DESCRIPTION, and system-controlled columns like CREATION_DATE, LAST_UPDATE_DATE, and ENABLED_FLAG to manage the lifecycle of the information type definition.

Common Use Cases and Queries

The primary use case is the administration and reporting of custom position attributes. System administrators query this table to review or audit the configured descriptive flexfield segments for positions. Common reporting scenarios involve joining this table to the child detail table to decode the INFORMATION_TYPE for meaningful reports. A fundamental query pattern is to list all active information types available for positions:

  • SELECT INFORMATION_TYPE, NAME FROM HR.PER_POSITION_INFO_TYPES WHERE ENABLED_FLAG = 'Y' ORDER BY NAME;

For analytical reporting, a typical join retrieves all extra information for a specific position or set of positions:

Related Objects

PER_POSITION_INFO_TYPES has a direct and critical parent-child relationship with the PER_POSITION_EXTRA_INFO table, as documented in the provided foreign key metadata. The PER_POSITION_EXTRA_INFO table stores the actual instance data (the values) for each position, and its INFORMATION_TYPE column is a foreign key referencing PER_POSITION_INFO_TYPES.INFORMATION_TYPE. This relationship ensures that every piece of extra information recorded against a position is of a valid, pre-defined type. This table is also intrinsically linked to the underlying descriptive flexfield structures (e.g., FND_DESCR_FLEX_COLUMN_USAGE) that define the specific prompts and validation for each INFORMATION_TYPE on the user interface.