Search Results designation_name




Overview
Explore in AI Chat

Overview

APPS.HR_HK_LEGAL_EMPLOYER_V is a Hong Kong localization view owned by the APPS schema and registered under FND Design Data as PER.HR_HK_LEGAL_EMPLOYER_V. It exposes legal employer information for Hong Kong-based organizations registered in Oracle Human Resources, presenting organization unit attributes, addresses, and the statutory designation associated with each legal employer record. The view is internal in nature: Oracle Corporation does not support direct data access through this object except from standard Oracle Applications programs. Its status is VALID in both Oracle E-Business Suite 12.1.1 and 12.2.2.

Functionally, the view serves as a reporting and integration layer for Hong Kong statutory reporting, most notably the Employer's Return and related IR56 family of XML outputs. The presence of the DESIGNATION_NAME column, which carries a 150-character designation label, enables downstream reports to resolve the legal employer's signatory or representative designation without querying multiple HR base entities directly. The view is consumed by the concurrent program package PER_PERHKCEL_XMLP_PKG, confirming its role in XML Publisher-based Hong Kong statutory extracts.

Underlying Base Objects

The view is defined over the following documented objects:

Because HR_LOCATIONS is itself a view and HR_GENERAL is a package called at query time, the object is a non-trivial construct whose performance depends on the underlying HR security and date-tracking logic.

Key Columns

  • GRE_ID (NUMBER, 15) — system-generated primary key for the legal employer record.
  • BUSINESS_GROUP_ID (NUMBER) — the business group owning the record; essential for multi-organization filtering.
  • NAME (VARCHAR2, 240) — the legal employer or organization unit name.
  • DESIGNATION_NAME (VARCHAR2, 150) — the designation title associated with the employer; this is the column surfaced by the user search "designation_name" and is central to Hong Kong statutory report headers.
  • DESIGNATION (VARCHAR2, 150) — the underlying designation code or alternate rendering.
  • GRE_IDENTIFIER (VARCHAR2, 150) — the business identifier of the legal employer, typically the registration or reference number.
  • DATE_FROM / DATE_TO (DATE) — effective dating boundaries governing record validity.
  • TYPE (VARCHAR2, 30) — the classification of the legal employer.
  • INTERNAL_ADDRESS_LINE (VARCHAR2, 80) and COMMENTS (LONG) — supplementary address and free-text fields.
  • LOCATION_ID, ADDRESS_LINE1–3, TOWN_OR_CITY, COUNTRY — address details resolved from HR_LOCATIONS.

Common Use Cases and Queries

The view is primarily queried by Hong Kong statutory reporting packages and by localization extensions that need a legal employer's designation and address. A representative query is:

  • SELECT gre_id, name, designation_name, gre_identifier, address_line1, town_or_city, country FROM apps.hr_hk_legal_employer_v WHERE business_group_id = :p_bg_id AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to, TRUNC(SYSDATE));
  • SELECT designation_name FROM apps.hr_hk_legal_employer_v WHERE gre_id = :p_gre_id; — resolves the signatory designation for a single employer.

Typical scenarios include generating Hong Kong Employer's Returns, validating legal employer setup before running IR56B/E/F extracts, and integrating employer designation data into third-party payroll or filing systems. Because the object is flagged as Oracle Internal Use Only, customers should access it only through supported concurrent programs such as those in PER_PERHKCEL_XMLP_PKG rather than building custom code against it.