Results for “hr_location_extra_info”

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

Overview

HR_LOCATION_EXTRA_INFO is a Human Resources (PER) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores user-defined, flexfield-style extra information that is attached to a location record in Oracle HRMS. Locations defined in HR_LOCATIONS_ALL cover standard attributes such as address, telephone, and shipping details; HR_LOCATION_EXTRA_INFO provides the extensible "overflow" area that captures additional attributes a customer has configured through Descriptive Flexfields and the HR location information types framework.

The table is owned by the HR schema and is documented as VALID in the ETRM 12.2.2 physical schema, with 65 columns. Its purpose is descriptive: each row represents one occurrence of an extra information type applied to one location. In Data Vault terminology, the mined foreign-key structure suggests classifying HR_LOCATION_EXTRA_INFO as a link object, since it primarily connects a location (HR_LOCATIONS_ALL) with its information type (HR_LOCATION_INFO_TYPES) and carries the descriptive flexfield payload. It is not a standalone hub, because its identity depends on those business references, and the vast majority of its columns are attribute columns (LEI_INFORMATION1–30 and LEI_ATTRIBUTE1–20) rather than natural business keys.

Key Information Stored

The principal columns of this table are:

• LOCATION_EXTRA_INFO_ID — Surrogate primary key, defined by the unique index HR_LOCATION_EXTRA_INFO_PK. This is the only documented unique/business-key candidate; the remaining columns form no formal unique constraint.
• LOCATION_ID — Foreign key to HR_LOCATIONS_ALL. Identifies the location to which the extra information belongs.
• INFORMATION_TYPE — Foreign key to HR_LOCATION_INFO_TYPES. Selects which configured information type (for example, a descriptive flexfield structure) the record represents.
• LEI_INFORMATION_CATEGORY and LEI_INFORMATION1 through LEI_INFORMATION30 — The context and value portions of the descriptive flexfield segments.
• LEI_ATTRIBUTE_CATEGORY and LEI_ATTRIBUTE1 through LEI_ATTRIBUTE20 — The attribute (context/value) flexfield columns that hold additional customer-defined values.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/ADF framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program bookkeeping columns populated when records are loaded or updated through batch processes.

The LEI_ prefix denotes "Location Extra Information." The numbering and column layout mirror the Oracle Descriptive Flexfield convention, but only those columns that appear in the documented metadata should be treated as authoritative.

Common Use Cases and Queries

Typical usage involves retrieving the extra location attributes for a given location or filtering locations by a specific flexfield value. A query joining the three core tables is common:

• Reporting location details for HR or Payroll extracts.
• Parameterizing forms that conditionally display fields based on LEI_INFORMATION_CATEGORY.
• Validating that a location has the required extra information type before a business process proceeds.
• Auditing concurrent-program uploads using REQUEST_ID and PROGRAM_ID.

A representative SQL pattern is:

SELECT l.location_id, l.location_code, t.information_type,
       e.lei_information1, e.lei_information2
  FROM hr.hr_locations_all       l,
       hr.hr_location_extra_info e,
       hr.hr_location_info_types t
 WHERE e.location_id        = l.location_id
   AND e.information_type   = t.information_type
   AND l.location_id        = :p_location_id;

Related Objects

The following objects are the most significant dependencies, based on the documented foreign-key relationships and the surrounding HR location schema:

• HR_LOCATIONS_ALL — Parent entity; joined via LOCATION_ID. Provides the location's standard attributes.
• HR_LOCATION_INFO_TYPES — Joined via INFORMATION_TYPE; defines which extra information structures are valid for locations.
• HR_LOCATION_EXTRA_INFO_PK — The unique index enforcing the surrogate primary key on LOCATION_EXTRA_INFO_ID.
• HR_LOCATIONS_ALL_F_VL / HR_LOCATIONS_ALL_TL — Reporting views and translations for location data commonly queried alongside this table.
• PER_LOCATION_EXTRA_INFO_API and related location APIs — Business-layer entry points that insert, update, and delete rows in this table.
• FND_DESCR_FLEX_COL_USAGE / FND_DESCR_FLEX_CONTEXTS — Flexfield metadata tables that describe the LEI_INFORMATION and LEI_ATTRIBUTE columns.
• HR_LOCATION_INFO_TYPES_TL — Translated names for information types used in reports.

Any join to this table should observe the LOCATION_ID and INFORMATION_TYPE foreign keys, since both are mandatory references in the documented schema and there is no unique constraint beyond HR_LOCATION_EXTRA_INFO_PK.