Results for “cumulative_total_mileage”

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

Overview

The view APPS.PAY_IE_BIK_COMPANY_VEHICLES_V is a payroll reporting object shipped with the Oracle E-Business Suite Payroll (PAY) product. It exposes data relating to Irish Benefit-in-Kind (BIK) company vehicle reporting, consolidating employee, assignment, payroll run, and vehicle registry information into a single denormalised result set suitable for statutory and internal reporting. The object is documented as a VIEW owned by the APPS schema with a status of VALID, and is available in both Oracle EBS 12.1.1 and 12.2.2. Its functional purpose is to present, per payroll action and assignment, the details of a company vehicle provided to an employee, the associated business and total mileage figures, and the calculated BIK parameters required for Irish Revenue reporting obligations.

Because it is a view rather than a table, it does not store data; it derives its output dynamically from the underlying payroll and HR tables at query time, reflecting the state of payroll processing at the moment of execution.

Underlying Base Objects

The view is defined over a substantial join of payroll, HR, and vehicle registry objects. The documented referenced base objects include:

• Payroll run objects: PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_PAYROLL_ACTIONS, PAY_PAYROLLS_F, PAY_ASSIGNMENT_ACTIONS.
• Element and input objects: PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F.
• HR person and assignment objects: PER_PEOPLE_F, PER_ASSIGNMENTS_F.
• Vehicle registry objects: PQP_VEHICLE_REPOSITORY_F (vehicle master data such as list price and registration) and PQP_VEHICLE_ALLOCATIONS_F (allocation of a vehicle to an assignment, with effective dates).
• Supporting packages: PAY_IE_BIK (used to retrieve cumulative mileage balance values), HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY.

The view joins these objects on person, assignment, payroll action, payroll, and consolidation set identifiers, and filters payroll actions to specific action types ('R', 'Q', 'V', 'B', 'I'), ensuring only relevant run results are surfaced. Calls to PAY_IE_BIK.GET_BALANCE_VALUES resolve cumulative business and total mileage balances at the assignment action level.

Key Columns

• PPS_NO – The employee's national identifier (PPS number) from PER_PEOPLE_F.
• SURNAME / FIRST_NAME – Employee name components.
• ASSIGNMENT_NUMBER, ASSIGNMENT_ID – Identifiers for the assignment.
• DATE_VEHICLE_PROVIDED / DATE_VEHICLE_RETURNED – Effective start and end dates of the vehicle allocation.
• ORIG_MARKET_VALUE_OF_VEHICLE – Original market value (list price) of the vehicle.
• VEHICLE_REGISTRATION_NUMBER – The registration number of the vehicle.
• CALCULATION_METHOD – The BIK calculation method input value.
• CUMULATIVE_BUSINESS_MILEAGE – Cumulative business mileage balance retrieved via PAY_IE_BIK.GET_BALANCE_VALUES.
• DECLARED_BUSINESS_MILEAGE – Declared annual business mileage input value.
• CUMULATIVE_TOTAL_MILEAGE – Cumulative total mileage balance.
• ASSIGNMENT_SET_ID, PAYROLL_ID, CONSOLIDATION_SET_ID – Contextual identifiers for the payroll run.

Common Use Cases and Queries

This view is typically used for Irish BIK reporting, audit reconciliation of vehicle benefits, and data extraction for statutory submissions. A representative query retrieving vehicle BIK details for a payroll period is:

• SELECT pps_no, surname, first_name, vehicle_registration_number, orig_market_value_of_vehicle, cumulative_business_mileage, cumulative_total_mileage FROM apps.pay_ie_bik_company_vehicles_v WHERE payroll_id = :p_payroll_id;
• Filter by assignment_id to inspect a single employee's vehicle benefit position.
• Aggregate mileage columns across a consolidation set to reconcile declared versus cumulative mileage for the period.

Because the view applies HR security and business group joins, results are inherently constrained to the querying user's authorised data set, which should be considered when designing extraction or integration processes.