Results for “pension_provider_type”

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

Overview

The HR_DE_SOC_INS_ORG_INFO_V view is a German localization object delivered in the APPS schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the PER — Human Resources product family and, as its ETRM description states, "Holds information relating to German Insurance Providers." Specifically, it presents social insurance organization data — health (Krankenkassen) and pension (Rentenversicherung) providers — captured as descriptive organization information against German legal entities and business groups.

Functionally, the view is a filtered, translated projection of social insurance attributes rather than a standalone entity. It exposes the raw flexfield segments of the DE_SOCIAL_INSURANCE_INFO organization information context side-by-side with decoded, human-readable values produced by the HR_GENERAL.DECODE_LOOKUP API. This makes it useful for reporting, concurrent programs, extracts, and integrations that must resolve insurance provider classification codes into display text without embedding lookup logic. In ETRM the object is documented as VALID at 12.2.2, indicating it remains supported across the 12.1.1 to 12.2.2 upgrade path.

Underlying Base Objects

The ETRM metadata records two referenced base objects:

• HR_ORGANIZATION_INFORMATION (SYNONYM) — the primary data source. The view text selects ORG_INFORMATION_ID, ORGANIZATION_ID, the four descriptive ORG_INFORMATION1..4 segments, and OBJECT_VERSION_NUMBER from this synonym, restricting rows with WHERE ORG_INFORMATION_CONTEXT = 'DE_SOCIAL_INSURANCE_INFO'.
• HR_GENERAL (PACKAGE) — referenced indirectly through HR_GENERAL.DECODE_LOOKUP, which converts stored lookup codes into their meaning/description text at query time.

Because the context predicate is fixed, the view returns only the German social insurance rows of a much larger organization information table, effectively acting as a semantic slice over the common PER organization information model.

Key Columns

• ORG_INFORMATION_ID — primary identifier of the underlying organization information row.
• ORGANIZATION_ID — foreign key to the organization (legal entity or business group) that owns the insurance information.
• WEST_BETRIEBSNUMMER — mapped from ORG_INFORMATION1; the West German company/establishment number issued by the insurance provider.
• EAST_BETRIEBSNUMMER — mapped from ORG_INFORMATION2; the corresponding East German establishment number.
• HEALTH_PROVIDER_TYPE — mapped from ORG_INFORMATION3; the stored lookup code for the health insurance provider category. This is the column most directly associated with the search term health_provider_type.
• PENSION_PROVIDER_TYPE — mapped from ORG_INFORMATION4; the stored code for the pension provider category.
• D_PENSION_PROVIDER_TYPE — decoded value of PENSION_PROVIDER_TYPE via lookup type DE_PENSION_PROV_TYPE.
• D_HEALTH_PROVIDER_TYPE — decoded value of HEALTH_PROVIDER_TYPE via lookup type DE_HEALTH_PROV_TYPE; the preferred display column for reporting.
• OBJECT_VERSION_NUMBER — optimistic locking/versioning column for the row.

Common Use Cases and Queries

Typical uses include German statutory reporting, payroll and social insurance extracts, and validation reports that must confirm each organization has a valid health provider type. A representative query returns all providers for a given organization:

SELECT organization_id,
       west_betriebsnummer,
       east_betriebsnummer,
       health_provider_type,
       d_health_provider_type
  FROM apps.hr_de_soc_ins_org_info_v
 WHERE organization_id = :p_org_id;

To list decoded health provider classifications across the enterprise, developers reference the D_ column to avoid re-implementing lookup decoding:

SELECT organization_id,
       d_health_provider_type,
       d_pension_provider_type
  FROM apps.hr_de_soc_ins_org_info_v
 ORDER BY d_health_provider_type;

Because the view accepts the standard APPS security context, statutory extracts and BI Publisher data models can join it to HR_ALL_ORGANIZATION_UNITS for names. Note that decoded columns depend on live lookup values, so results reflect current lookup configuration at execution time.