Search Results pay_ie_bik_accommodation_v




Overview
Explore in AI Chat

Overview

PAY_IE_BIK_ACCOMMODATION_V is an APPS-owned database view within the Oracle E-Business Suite Payroll (PAY) module, classified as VALID in the ETRM repository for releases 12.1.1 and 12.2.2. Its documented purpose is to support Irish (IE) statutory Benefit-in-Kind (BIK) reporting, specifically for delivery through Oracle Web ADI (Web Applications Desktop Integrator). The view consolidates employee, assignment, and benefit element entry data into a flattened, one-row-per-assignment structure suitable for export to spreadsheet-based reporting templates required by Irish Revenue.

The view is one of a family of Ireland-specific reporting views embedded in the payroll schema. Rather than storing data, it projects data drawn from payroll element entries and screen entry values associated with accommodation-related BIK element types. Each output row represents a single employee's employer-provided accommodation benefit for a reporting period, with the columns pivoted from the underlying flexfield-defined input values of the assignment's element entry.

Underlying Base Objects

The view is defined over a documented set of base objects spanning payroll, HR, and person/assignment entities:

Rows are aggregated using MAX() with DECODE pivoting against input value names such as 'RENTAL START DATE', 'RENTAL END DATE', 'ADDRESS ID', and 'LANDLORD ORGANIZATION ID'.

Key Columns

  • PPS_NO, SURNAME, FIRST_NAME: Employee identity fields, with the national identifier serving as the Irish PPS number.
  • ASSIGNMENT_NUMBER: Assignment identifier linking the benefit to a specific employment record.
  • BENEFIT_START_DATE / BENEFIT_END_DATE: Derived from the 'RENTAL START DATE' and 'RENTAL END DATE' screen entry values, representing the accommodation benefit period.
  • ADDRESS_LINE_1 through COUNTRY: Residence address components resolved via PAY_IE_BIK.GET_ADDRESS from the 'ADDRESS ID' input value.
  • LANDLORD_NAME and LANDLORD_ADDRESS_LINE_1 through 3: Landlord details resolved from HR_ORGANIZATION_UNITS and PAY_IE_BIK.GET_LANDLORD_ADDRESS using the 'LANDLORD ORGANIZATION ID' input value.

Common Use Cases and Queries

This view is typically consumed by Web ADI report layouts configured for Irish BIK accommodation reporting, or directly queried for reconciliation and audit purposes. A representative query follows:

  • SELECT pps_no, surname, first_name, assignment_number, benefit_start_date, benefit_end_date, address_line_1, town, post_code, landlord_name FROM apps.pay_ie_bik_accommodation_v;
  • Filter by assignment or person for a single-employee audit: WHERE assignment_number = :p_assignment;
  • Extract full landlord detail for a statutory return: SELECT assignment_number, landlord_name, landlord_address_line_1, landlord_address_line_2, landlord_address_line_3 FROM apps.pay_ie_bik_accommodation_v;

Because the view applies person security through HR_SECURITY, query results are restricted according to the responsibility under which the session runs. It is read-only and should not be modified; all underlying data originates from standard payroll element entry maintenance.