Results for “application_date”

50+ results




Overview
Explore in AI Chat

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

Overview

APPS.PAY_KR_FW_TAX_BREAK_V is a reporting and integration view in Oracle E-Business Suite (validated on 12.1.1 and 12.2.2) owned by the APPS schema and associated with the Payroll (PAY) product family. It presents the Foreign Worker (FW) tax break information maintained for Korean payroll processing. Specifically, the view exposes the assignment-level extra information record whose INFORMATION_TYPE is KR_YEA_FW_TAX_BREAK_INFO, denormalizing the generic key-flexible AEI_INFORMATION1 through AEI_INFORMATION6 attributes of PER_ASSIGNMENT_EXTRA_INFO into named, semantically meaningful columns such as IMMIGRATION_PURPOSE, CONTRACT_DATE, EXPIRY_DATE, STAX_APPLICABLE_FLAG, APPLICATION_DATE, and SUBMISSION_DATE.

Its principal role is to shield downstream consumers—BI Publisher reports, extracts, payroll interfaces, and statutory Korean year-end adjustment (YEA) reporting—from the underlying generic structure of the extra information table. Because the descriptive attributes are stored as positional character values, the view applies the FND_DATE package to convert the stored canonical date strings into proper date values, giving consumers directly usable DATE columns.

Underlying Base Objects

The view is defined over the synonym PER_ASSIGNMENT_EXTRA_INFO (aliased AEI) and calls the FND_DATE package. PER_ASSIGNMENT_EXTRA_INFO is the assignment-level extension table in Oracle HRMS that stores non-standard, customer- or localization-defined attributes keyed by ASSIGNMENT_ID, INFORMATION_TYPE, and a category. The filter INFORMATION_TYPE = 'KR_YEA_FW_TAX_BREAK_INFO' restricts the result set to a single Korean localization information type, so the view behaves as a targeted slice of that table rather than a general-purpose assignment information view.

Because the source attributes are stored positionally, the column mapping is fixed: AEI_INFORMATION1 becomes IMMIGRATION_PURPOSE, AEI_INFORMATION2 becomes CONTRACT_DATE, AEI_INFORMATION3 becomes EXPIRY_DATE, AEI_INFORMATION4 becomes STAX_APPLICABLE_FLAG, AEI_INFORMATION5 becomes APPLICATION_DATE, and AEI_INFORMATION6 becomes SUBMISSION_DATE. Each of the date columns is wrapped in FND_DATE.CANONICAL_TO_DATE to render the stored canonical strings as Oracle dates.

Key Columns

  • ROW_ID – the ROWID of the underlying extra information row, useful for direct row identification.
  • ASSIGNMENT_EXTRA_INFO_ID – primary key of the source extra information record.
  • ASSIGNMENT_ID – the assignment to which the foreign worker tax break information belongs; the primary join key to payroll and HR assignment data.
  • INFORMATION_TYPE – always KR_YEA_FW_TAX_BREAK_INFO given the view's filter.
  • AEI_INFORMATION_CATEGORY – the category under which the extra information is held.
  • OBJECT_VERSION_NUMBER – optimistic locking version for the source row.
  • IMMIGRATION_PURPOSE – purpose of immigration (from AEI_INFORMATION1).
  • CONTRACT_DATE – date of the contract.
  • EXPIRY_DATE – expiry date of the relevant document or tax break period.
  • STAX_APPLICABLE_FLAG – flag indicating whether the special tax treatment applies.
  • APPLICATION_DATE – date the application was filed.
  • SUBMISSION_DATE – date the documentation or application was submitted; a commonly queried date for compliance and reporting fits.

Common Use Cases and Queries

This view is typically joined to assignment and person tables to produce Korean foreign worker tax break reports and to validate submission and expiry dates against a reporting period.

  • Listing all tax break records for an assignment, including submission and expiry dates.
  • Filtering by a date range on SUBMISSION_DATE or EXPIRY_DATE for statutory filing or compliance extracts.
  • Identifying records where the special tax flag is set (STAX_APPLICABLE_FLAG) for downstream payroll processing.

Sample queries:

  • SELECT assignment_id, information_type, immigration_purpose, contract_date, expiry_date, stax_applicable_flag, application_date, submission_date FROM apps.pay_kr_fw_tax_break_v ORDER BY submission_date DESC;
  • SELECT assignment_id, submission_date, expiry_date FROM apps.pay_kr_fw_tax_break_v WHERE assignment_id = :p_assignment_id;
  • SELECT assignment_id, immigration_purpose, submission_date FROM apps.pay_kr_fw_tax_break_v WHERE submission_date BETWEEN :p_from AND :p_to

Because the view performs only row filtering and date conversion, it can be queried directly without additional tuning; for large extracts, an index on the underlying ASSIGNMENT_ID and information type columns supports efficient access.