Search Results de_job_key

Overview

APPS.HR_DE_SOCIAL_INSURANCE_INFO_V is a German localizations (DE) reporting view within Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It presents decoded social insurance attributes stored against element entries for German employees — statutory health, pension, unemployment, and special care (Pflege) contributions, along with the associated insurance carrier organizations and the classification keys required for German social insurance reporting (for example, the DEUEV and Jahresmeldung processes).

The view is a reporting and integration artifact rather than a transactional entity. It flattens and decodes a set of concatenated "entry information" segments held on the element entry record into discrete, human-readable attributes, so that downstream reports, extracts, and interfaces do not have to reproduce the substring and lookup logic themselves. It is typically consumed by payroll reporting, statutory notification extracts, and localization support queries. Users searching for "de_special_care_key" arrive here because the view exposes the special care key in both coded and decoded form (special_care_key_code and special_care_key_desc).

Underlying Base Objects

The documented base objects referenced by the view are:

• PAY_ELEMENT_ENTRIES_F (SYNONYM) — the element entry table holding the ENTRY_INFORMATIONn segments that the view decodes. This is the primary driving object; PEE.ROWID is exposed as ROW_ID and PEE.OBJECT_VERSION_NUMBER is carried through.
• HR_GENERAL (PACKAGE) — supplies DECODE_LOOKUP, used to translate single-character and short codes into descriptive text against the German lookup types DE_HEALTH_KEY, DE_PENSION_KEY, DE_UNEMPLOYMENT_KEY, DE_SPECIAL_CARE_KEY, DE_JOB_KEY, DE_PROFESSION_KEY, DE_EDUCATION_KEY, and DE_PEOPLE_GROUP_KEY.
• HR_DE_GENERAL (PACKAGE) — supplies GET_ORG_NAME, used to resolve organization identifiers to organization names for each insurance provider.
• FND_SESSIONS (SYNONYM) — referenced as part of the view's supporting metadata context.
• PER_DE_ELE_API (PACKAGE) — the German element API package associated with this localization area.

The view does not persist data of its own; every column is derived at query time from PAY_ELEMENT_ENTRIES_F and the two HR packages.

Key Columns

• contribution_key — Substr(ENTRY_INFORMATION1,1,4), the four-character composite German contribution key.
• health_key_code / health_key_desc — character 1 of ENTRY_INFORMATION1, decoded via DE_HEALTH_KEY.
• pension_key_code / pension_key_desc — character 2, decoded via DE_PENSION_KEY.
• unemployment_key_code / unemployment_key_desc — character 3, decoded via DE_UNEMPLOYMENT_KEY.
• special_care_key_code / special_care_key_desc — character 4, decoded via DE_SPECIAL_CARE_KEY. This is the column pair relevant to the search term "de_special_care_key".
• health_org_id / health_provider, pension_org_id / pension_provider, unemployment_org_id / unemployment_provider, special_care_org_id / special_care_provider — numeric values parsed from ENTRY_INFORMATION2 through ENTRY_INFORMATION5, resolved to names by HR_DE_GENERAL.GET_ORG_NAME.
• occupation_key, job_key_code / job_key, profession_key_code / profession_key, education_key_code / education_key — derived from ENTRY_INFORMATION6 and decoded against DE_JOB_KEY, DE_PROFESSION_KEY, and DE_EDUCATION_KEY.
• people_class_key / people_class_desc — from ENTRY_INFORMATION7, decoded via DE_PEOPLE_GROUP_KEY.
• ROW_ID, OBJECT_VERSION_NUMBER — passthrough identifiers from the element entry row.

Common Use Cases and Queries

Typical uses include auditing German social insurance assignments, validating carrier organization IDs, and building statutory extracts. To isolate the special care attributes:

• SELECT element_entry_id, special_care_key_code, special_care_key_desc, special_care_provider FROM apps.hr_de_social_insurance_info_v;
• SELECT * FROM apps.hr_de_social_insurance_info_v WHERE special_care_key_code IS NOT NULL;
• SELECT health_provider, pension_provider, COUNT(*) FROM apps.hr_de_social_insurance_info_v GROUP BY health_provider, pension_provider;
• SELECT element_entry_id, contribution_key, job_key, profession_key FROM apps.hr_de_social_insurance_info_v WHERE contribution_key = '1111';

Because decoding relies on HR_GENERAL.DECODE_LOOKUP, output reflects the current lookup values; queries should therefore be run against the intended business group and date context to obtain correct historical descriptions.