Search Results departure_reason

Overview

APPS.PAY_HK_IR56_EMPLOYEE_V is a reporting view in the Oracle E-Business Suite (EBS) Applications schema, delivered in release 12.1.1 and 12.2.2 under FND Design Data PAY.PAY_HK_IR56_EMPLOYEE_V. Its purpose is to consolidate the employee-level data required for the Hong Kong Inland Revenue Department (IRD) employer's returns — specifically the IR56 series of forms used to report remuneration, commencement, cessation, and departure of employees. The view gathers personal particulars, tax identifiers, spouse details, employment capacity, and departure information into a single denormalized row per employee or assignment, so that the corresponding Oracle Payroll processes and concurrent programs can render statutory IR56 output without joining numerous PER and PAY tables at runtime.

The object is documented as Oracle Internal Use Only: Oracle Corporation does not support direct data access except from standard Oracle Applications programs. Consequently, the view is intended as a supporting component of the seeded Hong Kong payroll statutory reporting logic rather than as a public API for customer-developed queries.

Underlying Base Objects

The documented referenced objects span several EBS product families. Employee and person data derive from PER_PEOPLE_F, HR_PERSON_NAME (package), PER_ASSIGNMENTS_F, PER_ASSIGNMENT_EXTRA_INFO, PER_ADDRESSES, PER_PERIODS_OF_SERVICE, PAY_HK_IR56_SPOUSE_DETAILS_V, and the HR_LOOKUPS view for code translations. Organization, employer, and location data come from HR_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS, and HR_SOFT_CODING_KEYFLEX. Helper packages HR_API, HR_GENERAL, HR_SECURITY, and FND_NUMBER supply formatting, secured-list filtering, and numeric translation; FND_TERRITORIES_VL resolves country/territory descriptions used in departure reporting. Because HR_SECURITY participates in the definition, the view is subject to standard EBS security profiles, and any query executed outside the payroll reporting programs may return a filtered row set.

Key Columns

The view exposes a broad statutory attribute set. Identification columns include PERSON_ID and ASSIGNMENT_ID (the join keys to PER_PEOPLE_F and PER_ASSIGNMENTS_F), EMPLOYEE_TAX_FILE_NO, HK_ID_CARD_NO, and PASSPORT_NUMBER. Person naming is provided through FULL_NAME, LAST_NAME, and MAIDEN_NAME — the latter being the specific column referenced in searches related to this view, populated for employees whose IR56 declaration must show a former name. Spouse particulars are exposed through SPOUSE_NAME, SPOUSE_HK_ID_CARD_NO, and SPOUSE_PASSPORT_NUMBER, sourced via PAY_HK_IR56_SPOUSE_DETAILS_V.

Employer-side attributes include EMPLOYER_RETURN_FILE_NO, EMPLOYER_RETURN_LAST_8, EMPLOYER_NAME, EMPLOYER_ADDRESS, LEGAL_EMPLOYER_ID, and PRINCIPAL_EMPLOYER_NAME. Employment and departure columns include DESIGNATION, DESIGNATION_NAME, CAPACITY_EMPLOYED, SERVICE_DATE_START, SERVICE_TERMINATION_DATE, EMPLOYMENT_PERIOD, EXPECTED_CESSATION_DATE, LEAVING_REASON, DEPARTURE_DATE, DEPARTURE_REASON, DEPARTURE_REASON_SELECT, RETURN_TO_HK, PROBABLE_RETURN_DATE, COUNTRY_RETURNING_TO, SECONDED_TO, and MONIES_HELD_SECTION52 with its amount and no-hold reason. Address data is carried in RESIDENTIAL_ADDRESS, CORRESPONDENCE_ADDRESS, FUTURE_CORRESPONDENCE_ADDRESS, and NEW_EMPLOYER_NAME_ADDRESS. SERVICE_TAX_REPORTING_YEAR, FINAL_PROCESS_DATE, SEX, and MARITAL_STATUS complete the key set.

Common Use Cases and Queries

Typical usage is limited to verification and troubleshooting of IR56 output. A basic lookup by employee name or maiden name helps confirm that the view resolves the expected values:

• SELECT person_id, assignment_id, full_name, maiden_name, hk_id_card_no, employee_tax_file_no FROM apps.pay_hk_ir56_employee_v WHERE UPPER(maiden_name) LIKE UPPER(:p_name);
• SELECT assignment_id, designation, service_date_start, service_termination_date, departure_date, leaving_reason FROM apps.pay_hk_ir56_employee_v WHERE service_tax_reporting_year = :p_year;
• SELECT person_id, spouse_name, spouse_hk_id_card_no FROM apps.pay_hk_ir56_employee_v WHERE marital_status = 1;

Because the view is marked internal use only, these statements should be treated as diagnostic rather than as a supported integration interface. For production IR56 extraction, the standard Hong Kong Payroll statutory concurrent programs should be used, ensuring that HR_SECURITY filtering and IRD layout formatting are applied consistently.