Results for “t4a_box18”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PAY_CA_EOY_T4A_REG_V view is a Canadian Payroll end-of-year (EOY) reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the T4A regulatory reporting data set that is archived at the conclusion of a Canadian payroll year. T4A slips are issued for pension, retirement, annuity, and other supplementary income amounts, and this view surfaces the employee and reporting attributes required to generate or reprint the T4A regulatory form.
The view does not store persistent T4A data in its own right. Instead, it reconstructs archived EOY values on demand by calling the PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE function for each reporting attribute, using the archive context identifier held in FF_ARCHIVE_ITEMS.CONTEXT1 as the lookup key. This design decouples the physical archive from the reporting interface: the underlying archive can retain values in a generic name/value structure, while the view presents them as a typed, denormalised row. It is consumed primarily by Canadian EOY reports and concurrent programs that require employee identification, address, and T4A box amounts for a given payroll action and organization.
Underlying Base Objects
The documented referenced objects are FF_ARCHIVE_ITEMS (SYNONYM), PAY_ASSIGNMENT_ACTIONS (SYNONYM), PAY_PAYROLL_ACTIONS (SYNONYM), and the PAY_CA_ARCHIVE_UTILS (PACKAGE). FF_ARCHIVE_ITEMS is the pivotal object: its CONTEXT1 column supplies the archive identifier passed to every GET_ARCHIVE_VALUE call, effectively acting as the join key between the archive store and the reporting attributes. The view therefore depends on archive records having been written for the relevant EOY process.
PAY_ASSIGNMENT_ACTIONS supplies BUSINESS_GROUP_ID and PAYROLL_ACTION_ID context, tying each archived T4A row to the payroll action that produced it. PAY_PAYROLL_ACTIONS contributes the TAX_UNIT_ID, associating the record with the applicable Canadian tax unit. These relationships allow consumers to filter archived T4A data by payroll run, business group, or tax unit without navigating the archive structure directly. The PAY_CA_ARCHIVE_UTILS package is the functional dependency through which all attribute values are retrieved.
Key Columns
The view exposes several groups of columns. Employee identification columns include CAEOY_EMPLOYEE_SIN (Social Insurance Number), CAEOY_EMPLOYEE_NUMBER, CAEOY_EMPLOYEE_LAST_NAME, CAEOY_EMPLOYEE_FIRST_NAME, and CAEOY_EMPLOYEE_INITIAL — the latter being the specific attribute associated with the search term "caeoy_employee_initial". Mailing information is provided through CAEOY_EMPLOYEE_ADDRESS_LINE1 through LINE3, CAEOY_EMPLOYEE_CITY, CAEOY_EMPLOYEE_PROVINCE, CAEOY_EMPLOYEE_COUNTRY, and CAEOY_EMPLOYEE_POSTAL_CODE.
- CAEOY_T4A_ORGANIZATION_ID and CAEOY_T4A_LOCATION_ID — identify the reporting organization and location for the slip.
- CAEOY_PERSON_ID — the person identifier linking to core HR records.
- BUSINESS_GROUP_ID, TAX_UNIT_ID, PAYROLL_ACTION_ID, CONTEXT1 — structural keys for scoping the archived record.
- T4A_BOX16 (from CAEOY_T4A_BOX16_PER_GRE_YTD) and T4A_BOX18 (from CAEOY_T4A_BOX18_PER_GRE_YTD) — year-to-date pension and lump-sum box amounts.
Common Use Cases and Queries
Typical usage includes validating archived T4A data after year-end close, reconciling box amounts against payroll balances, and extracting data for slip reissue. A basic query selecting the primary identification columns is shown below:
SELECT CAEOY_EMPLOYEE_NUMBER, CAEOY_EMPLOYEE_LAST_NAME, CAEOY_EMPLOYEE_FIRST_NAME, CAEOY_EMPLOYEE_INITIAL, CAEOY_EMPLOYEE_PROVINCE, T4A_BOX16, T4A_BOX18 FROM APPS.PAY_CA_EOY_T4A_REG_V WHERE PAYROLL_ACTION_ID = :p_action_id ORDER BY CAEOY_EMPLOYEE_LAST_NAME;
Because each column is computed via a function call, filtering on structural columns such as PAYROLL_ACTION_ID, TAX_UNIT_ID, or BUSINESS_GROUP_ID is preferable for performance, and results should be joined to PER_ALL_PEOPLE_F on CAEOY_PERSON_ID when additional assignment detail is required.
-
View: PAY_CA_EOY_T4A_REG_V 12.2.2
APPS.PAY_CA_EOY_T4A_REG_V·↳ FF_ARCHIVE_ITEMS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_CA_ARCHIVE_UTILS·Explore PAY module →
-
View: PAY_CA_EOY_T4A_REG_V 12.1.1
APPS.PAY_CA_EOY_T4A_REG_V·↳ FF_ARCHIVE_ITEMS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_CA_ARCHIVE_UTILS·Explore PAY module →
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.