Search Results unemployment_key_code

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:

• PAY_ELEMENT_ENTRIES_F (SYNONYM) — the primary Element Entry table supplying the ROWID, OBJECT_VERSION_NUMBER, ELEMENT_ENTRY_ID, and the ENTRY_INFORMATION1 through ENTRY_INFORMATION6 columns.
• HR_GENERAL (PACKAGE) — used for the DECODE_LOOKUP calls that translate single-character key codes into descriptive text.
• HR_DE_GENERAL (PACKAGE) — used for GET_ORG_NAME to resolve the numeric organization identifiers held in ENTRY_INFORMATION2 through ENTRY_INFORMATION5 into provider names.
• PER_DE_ELE_API (PACKAGE) — the German element API associated with this data.
• FND_SESSIONS (SYNONYM) — the standard Oracle EBS session context object.

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

• CONTRIBUTION_KEY — SUBSTR(ENTRY_INFORMATION1, 1, 4), the four-character composite key.
• HEALTH_KEY_CODE / HEALTH_KEY_DESC — the first character of ENTRY_INFORMATION1 and its decoded description from DE_HEALTH_KEY.
• PENSION_KEY_CODE / PENSION_KEY_DESC — the second character, decoded from DE_PENSION_KEY.
• UNEMPLOYMENT_KEY_CODE / UNEMPLOYMENT_KEY_DESC — the third character, decoded from DE_UNEMPLOYMENT_KEY.
• SPECIAL_CARE_KEY_CODE / SPECIAL_CARE_KEY_DESC — the fourth character, decoded from DE_SPECIAL_CARE_KEY.
• HEALTH_PROVIDER, PENSION_PROVIDER, UNEMPLOYMENT_PROVIDER, SPECIAL_CARE_PROVIDER — provider names resolved from ENTRY_INFORMATION2 through ENTRY_INFORMATION5.
• OCCUPATION_KEY, JOB_KEY_CODE, JOB_KEY, PROFESSION_KEY_CODE, PROFESSION_KEY, EDUCATION_KEY_CODE — decoded from ENTRY_INFORMATION6.

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;