Search Results hr_location_info_types_pk




Overview
Explore in AI Chat

Overview

The HR_LOCATION_INFO_TYPES table is a core reference table within the Oracle E-Business Suite Human Resources (PER) module. It functions as a master list defining the types of supplementary or contextual information that can be associated with a physical location. In Oracle EBS, a location is a fundamental entity representing a place of work, office, or site. This table enables the system to support flexible, user-defined attributes for locations beyond the standard address fields. Its primary role is to govern and validate the kinds of extra information that can be stored, ensuring data integrity and consistency across the application when capturing location-specific details such as facility codes, security protocols, or regional identifiers.

Key Information Stored

The table's structure is designed to manage a controlled list of information types. The most critical column is INFORMATION_TYPE, which serves as the table's primary key. This column stores the unique code or name identifying a specific category of extra information, for example, 'SITE_MANAGER', 'FLOOR_PLAN_REF', or 'BUILDING_CODE'. While the provided ETRM metadata does not list additional columns, such reference tables typically include supporting columns like ENABLED_FLAG (to activate or deactivate a type) and possibly descriptive fields. The integrity of this master data is enforced by the primary key constraint HR_LOCATION_INFO_TYPES_PK on the INFORMATION_TYPE column.

Common Use Cases and Queries

The primary use case is the administration and utilization of location extra information. System administrators query this table to review or maintain the list of available information types before configuring them in the application. A common reporting need is to join this table with the detail table to produce readable reports. For instance, to list all locations along with a specific type of extra information, a query would join through the HR_LOCATION_EXTRA_INFO table.

  • Listing All Active Information Types: SELECT information_type FROM hr_location_info_types WHERE enabled_flag = 'Y' ORDER BY 1;
  • Reporting Location Extra Information: SELECT hl.location_code, hl_t.info_type_name, hlei.information_value FROM hr_locations hl, hr_location_extra_info hlei, hr_location_info_types hlit WHERE hl.location_id = hlei.location_id AND hlei.information_type = hlit.information_type;

Related Objects

The HR_LOCATION_INFO_TYPES table has a direct and essential relationship with the HR_LOCATION_EXTRA_INFO table. As documented in the foreign key, HR_LOCATION_EXTRA_INFO.INFORMATION_TYPE references HR_LOCATION_INFO_TYPES.INFORMATION_TYPE. This means every record in the detail table (HR_LOCATION_EXTRA_INFO) must have an INFORMATION_TYPE that exists in this master table. This object is central to the location data model and is indirectly referenced by any forms, APIs, or reports that capture or display location extra information, such as the Location form (HR_LOCATIONS) and potentially the HR_LOCATIONS_API.