Results for “caeoy_ei_exempt”

10 results




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

Overview

APPS.PAY_CA_EOY_REGISTER_V is an Oracle E-Business Suite view that presents end-of-year (EOY) Canadian payroll register information in a form suitable for T4 and related year-end reporting. It is defined in the APPS schema and is primarily consumed by Oracle Payroll year-end processing and reporting logic. The view does not store data itself; instead, it reconstructs historical EOY values by calling the PAY_CA_ARCHIVE_UTILS package, which retrieves values that were captured and archived at the time the payroll action was run. This archive-based architecture is significant because Canadian year-end reporting requires values as they existed at a specific point in time, independent of later changes to employee or assignment data.

The view is relevant in both Oracle EBS 12.1.1 and 12.2.2, where the underlying archive tables and package retain the same structure. Users searching for "jurisdiction_code" encounter this view because jurisdiction is a key archive item context. In the view text, jurisdiction code is passed as a parameter to get_archive_value for items such as CAEOY_CPP_QPP_EXEMPT, CAEOY_EI_EXEMPT, CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD, and CAEOY_FED_WITHHELD_PER_JD_GRE_YTD, reflecting that several EOY amounts and exemptions are stored per jurisdiction.

Underlying Base Objects

According to the documented metadata, the view is defined over the following base objects and program units:

  • FF_ARCHIVE_ITEMS (synonym) — archive item definitions identifying each EOY data element.
  • FF_ARCHIVE_ITEM_CONTEXTS (synonym) — contexts, such as jurisdiction code, under which archive items are stored.
  • FF_CONTEXTS (synonym) — context definitions used to resolve archive contexts.
  • PAY_ASSIGNMENT_ACTIONS (synonym) — assignment-level action rows that link the payroll action to the assignment.
  • PAY_PAYROLL_ACTIONS (synonym) — payroll action header information, supplying business group, payroll action, and tax unit references.
  • PAY_CA_ARCHIVE_UTILS (package) — the archive utility package that returns the archived EOY value for a given action context, item, and context combination.

The view joins archive item and context information (FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_CONTEXTS) with payroll action data (PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS) and invokes PAY_CA_ARCHIVE_UTILS.get_archive_value to materialize the stored EOY values. The columns fai.context1 and fac.context drive the archive lookup keys, with jurisdiction code acting as an additional named context.

Key Columns

Common Use Cases and Queries

This view supports year-end validation, T4 slip generation, and audit of archived Canadian payroll values. A typical query selects archived EOY data for a specific payroll action, and jurisdiction code is frequently included to isolate federal or provincial figures.

  • Retrieve EOY employee and jurisdiction data for a payroll action:

SELECT payroll_action_id, tax_unit_id, caeoy_employee_sin, caeoy_cpp_qpp_exempt, caeoy_ei_exempt, caeoy_gross_earnings_per_jd_gre_ytd FROM apps.pay_ca_eoy_register_v WHERE payroll_action_id = :p_action_id;

  • Filter archived records by jurisdiction context for federal withholding analysis:

SELECT caeoy_person_id, fac_context AS jurisdiction_code, caeoy_fed_withheld_per_jd_gre_ytd FROM apps.pay_ca_eoy_register_v WHERE payroll_action_id = :p_action_id AND fac_context = :p_jurisdiction_code;

  • Reconcile archived gross earnings per jurisdiction against T4 totals, grouping by business_group_id and tax_unit_id to confirm completeness before submission.