Results for “caeoy_employee_postal_code”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAY_CA_EOY_T4A_REG_V is a reporting view in the Oracle E-Business Suite Canadian payroll (Payroll Canada) module associated with Year-End (EOY) processing. Its name indicates that it presents the registered (REG) T4A data set that is captured and archived during the Canadian end-of-year run. The view is not a transactional object; rather it is a read-only projection that surfaces archived, frozen year-end values so that regulatory slips and related reporting can be produced reproducibly after the payroll year is closed.
The view is defined entirely in terms of the archive framework rather than over live assignment or person data. Almost every employee-level and slip-level attribute is retrieved through calls to the PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE function, passing the archive context identifier (fai.context1) and a named archive key such as CAEOY_EMPLOYEE_SIN or CAEOY_EMPLOYEE_CITY. This design decouples the reporting view from the underlying payroll tables, allowing the historical state of the data to be reconstructed exactly as it existed at the time the year-end archive was taken.
Underlying Base Objects
Per the documented ETRM metadata for 12.2.2, the view references the following objects:
- FF_ARCHIVE_ITEMS (synonym) — the archive framework table that stores the archived key/value pairs. The column fai.context1 supplies the archive context passed to GET_ARCHIVE_VALUE.
- PAY_ASSIGNMENT_ACTIONS (synonym) — the assignment-level action rows that link a payroll action to the assignment being processed; aliased as paa and providing payroll_action_id and tax_unit_id.
- PAY_PAYROLL_ACTIONS (synonym) — the payroll action header; aliased as ppa and providing business_group_id and payroll_action_id.
- PAY_CA_ARCHIVE_UTILS (package) — the PL/SQL package whose GET_ARCHIVE_VALUE function materializes each named CAEOY_* archive value.
The joins bind the archive context (fai.context1) to the assignment action and payroll action so that each row represents one archived year-end record for one assignment within one payroll action and business group.
Key Columns
- CAEOY_EMPLOYEE_SIN, CAEOY_EMPLOYEE_NUMBER — archived Social Insurance Number and employee number.
- CAEOY_EMPLOYEE_LAST_NAME, CAEOY_EMPLOYEE_FIRST_NAME, CAEOY_EMPLOYEE_INITIAL — archived name components.
- CAEOY_EMPLOYEE_ADDRESS_LINE1/2/3, CAEOY_EMPLOYEE_CITY, CAEOY_EMPLOYEE_PROVINCE, CAEOY_EMPLOYEE_COUNTRY, CAEOY_EMPLOYEE_POSTAL_CODE — archived mailing address, including the CAEOY_EMPLOYEE_CITY attribute surfaced directly as a view column.
- CAEOY_T4A_ORGANIZATION_ID, CAEOY_T4A_LOCATION_ID — archived employer organization and location identifiers (aliased from CAEOY_T4_* keys).
- CAEOY_PERSON_ID — archived person identifier.
- BUSINESS_GROUP_ID, TAX_UNIT_ID, PAYROLL_ACTION_ID, CONTEXT1 — operational keys from the payroll action and assignment action, plus the archive context.
- T4A_BOX16, T4A_BOX18, T4A_BOX20 — archived T4A box amounts (per-GRE year-to-date pension, other, and related income values).
Common Use Cases and Queries
Typical uses include T4A slip generation, reconciliation of archived year-end values, and audit queries that reproduce the exact city, address, or box amounts reported in a prior year. A simple query retrieving employee city and box amounts for a given payroll action:
SELECT caey_employee_number, caey_employee_city, t4a_box16, t4a_box18 FROM apps.pay_ca_eoy_t4a_reg_v WHERE payroll_action_id = :p_action_id;SELECT business_group_id, COUNT(*) FROM apps.pay_ca_eoy_t4a_reg_v GROUP BY business_group_id;SELECT caey_person_id, caey_employee_city, caey_employee_postal_code FROM apps.pay_ca_eoy_t4a_reg_v WHERE caey_employee_province = 'ON';
-
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 →
-
View: PAY_CA_EOY_REGISTER_V 12.1.1
APPS.PAY_CA_EOY_REGISTER_V·↳ FF_ARCHIVE_ITEMS·↳ FF_ARCHIVE_ITEM_CONTEXTS·↳ FF_CONTEXTS·Explore PAY module →
-
View: PAY_CA_EOY_RL1_REG_V 12.1.1
APPS.PAY_CA_EOY_RL1_REG_V·↳ FF_ARCHIVE_ITEMS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_CA_ARCHIVE_UTILS·Explore PAY module →
-
View: PAY_CA_EOY_REGISTER_V 12.2.2
APPS.PAY_CA_EOY_REGISTER_V·↳ FF_ARCHIVE_ITEMS·↳ FF_ARCHIVE_ITEM_CONTEXTS·↳ FF_CONTEXTS·Explore PAY module →
-
View: PAY_CA_EOY_RL1_REG_V 12.2.2
APPS.PAY_CA_EOY_RL1_REG_V·↳ FF_ARCHIVE_ITEMS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_CA_ARCHIVE_UTILS·Explore PAY module →