Search Results entry_information1




Overview
Explore in AI Chat

Overview

HR_DE_SOCIAL_INSURANCE_INFO_V is an APPS-owned database view in the Oracle E-Business Suite PER (Human Resources) product module, defined over the Element Entry tables to expose German Social Insurance records. Its status is VALID in both ETRM 12.1.1 and 12.2.2. The view does not store data of its own; it is a reporting and integration access layer that decodes the delimited character strings captured in the ENTRY_INFORMATION1 through ENTRY_INFORMATION6 columns of the underlying element entries into discrete, human-readable attributes. Because the view is defined on the Element Entry base table rather than on a dedicated German social insurance table, it presents social insurance information exactly as it is stored by the German payroll localization via element entries.

The view is particularly relevant to the search term "entry_information1," since ENTRY_INFORMATION1 is the central source column from which the view derives its key codes: the contribution key, the health key, the pension key, the unemployment key, and the special care key.

Underlying Base Objects

The view is defined over the following documented base objects:

In each case, the localization stores multiple logical attributes inside a single delimited string, and the view decomposes that string positionally using SUBSTR.

Key Columns

Common Use Cases and Queries

The view supports German social insurance reporting, provider reconciliation, and payroll audits. A typical query joins the view to the element entry for a specific assignment or period:

  • Listing all social insurance records with decoded keys and provider names.
  • Validating that a contribution key correctly maps to the expected health, pension, and unemployment codes.
  • Reconciling contributions by provider organization.

Sample SQL:

SELECT element_entry_id, contribution_key, health_key_desc, pension_key_desc, unemployment_key_desc, special_care_key_desc, health_provider FROM apps.hr_de_social_insurance_info_v WHERE contribution_key = :p_key;

SELECT element_entry_id, occupation_key, job_key, profession_key FROM apps.hr_de_social_insurance_info_v ORDER BY element_entry_id;