Search Results au_termination_type

Overview

APPS.PAY_AU_TERM_EMP_ASG_V is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that consolidates Australian employee termination information across the assignment, person, and period-of-service entities. Its primary purpose is to surface terminated employee records for Australian business groups, joining the assignment record to the individual's period of service and translating the termination reason code into a meaningful description. The view is restricted to Australian legislation via a filter on the business group's legislation_code, making it a jurisdiction-specific reporting object rather than a general-purpose HR view. It is typically used for statutory end-of-employment reporting, termination trend analysis, and downstream payroll or legislative extracts. A specific point of interest is the au_termination_type lookup, which the view resolves through the hr_lookups object so that consumers see the descriptive termination reason rather than a raw code.

Underlying Base Objects

The view is defined as a six-table join. The documented referenced base objects include FND_SESSIONS, HR_API, HR_GENERAL, HR_LOOKUPS, HR_PERSON_NAME, HR_PERSON_TYPE_USAGE_INFO, HR_SECURITY, PER_ASSIGNMENTS_F, PER_BUSINESS_GROUPS, PER_PEOPLE_V, and PER_PERIODS_OF_SERVICE_V. In the view text, ASS aliases PER_ASSIGNMENTS_F, PER aliases PER_PEOPLE_V, SERV aliases PER_PERIODS_OF_SERVICE_V, BUS aliases PER_BUSINESS_GROUPS, and HR1 aliases HR_LOOKUPS. The HR_API, HR_GENERAL, HR_PERSON_NAME, HR_PERSON_TYPE_USAGE_INFO, and HR_SECURITY packages are referenced indirectly because the derived person and period-of-service views (PER_PEOPLE_V and PER_PERIODS_OF_SERVICE_V) depend on them for datetracked security and name resolution logic. FND_SESSIONS supplies the current session context used to enforce datetrack (effective-dating) visibility.

Key Columns

• assignment_id, assignment_number — the assignment identifier and its user-facing number.
• person_id, employee_number, full_name, date_of_birth, original_date_of_hire — personal and employment identity details.
• period_of_service_id, date_start, actual_termination_date — the period-of-service record and its start/termination dates.
• business_group_id, payroll_id — the organizational and payroll context.
• meaning — the decoded value of the AU_TERMINATION_TYPE lookup, obtained by joining hr_lookups.lookup_code to serv.pds_information1 where lookup_type = 'AU_TERMINATION_TYPE' and enabled_flag = 'Y'.

The outer join on HR_LOOKUPS ensures records with an unmapped or disabled termination type are not lost from the result set.

Common Use Cases and Queries

Typical uses include reconciliation of terminated Australian employees against legislative reporting, termination-type distribution analysis, and validation of period-of-service data before statutory submissions.

SELECT full_name,
       employee_number,
       payroll_id,
       date_start,
       actual_termination_date,
       au_termination_type_meaning
FROM   apps.pay_au_term_emp_asg_v;

To break down terminations by reason within a payroll:

SELECT au_termination_type_meaning, COUNT(*)
FROM   apps.pay_au_term_emp_asg_v
WHERE  payroll_id = :p_payroll_id
GROUP  BY au_termination_type_meaning;

Because the view is session- and datetrack-aware, callers should query it as the APPS user (or a user with the correct business group security profile) to ensure FND_SESSIONS supplies the proper effective date and the AU legislation filter is satisfied.