Search Results pydate_value




Overview
Explore in AI Chat

Overview

The APPS.PAY_CA_FED_EE_V view is a payroll balance inquiry object within the Oracle E-Business Suite (EBS) Payroll (PAY) module, exposed under the APPS schema. It presents Canadian federal employee-level balance information for a given assignment action, resolving balance set, balance type, and payroll action context into a single denormalized result set. The view is defined over a hybrid of payroll transactional tables and PL/SQL package calls, which means it does not simply project stored columns but dynamically computes balance values at query time.

Its primary role is to support payroll reporting, legislative balance validation, and downstream integration where an administrator or report requires the full set of period-based balance values (current, run, pay-date, month-to-date, quarter-to-date, period-to-date, and related) for a Canadian federal employee within a specific assignment action. Because the balance values are derived through the PAY_CA_BALANCE_PKG API, the view reflects the same calculation logic used by the payroll engine, ensuring consistency between reported balances and processed results.

Underlying Base Objects

The metadata for ETRM 12.2.2 documents the following referenced base objects, all implemented as APPS-owned synonyms:

The view therefore joins assignment actions to payroll actions and balance set definitions, then delegates all balance computation to the Canadian balance packages. This architecture keeps the view thin while centralizing calculation logic in reusable PL/SQL.

Key Columns

  • ASSIGNMENT_ID, ASSIGNMENT_ACTION_ID, ACTION_STATUS — identify the employee assignment and the action being evaluated.
  • TAX_UNIT_ID — the tax unit context for the balance, relevant to Canadian federal reporting.
  • PAYROLL_ACTION_ID, ACTION_TYPE, EFFECTIVE_DATE — payroll run context and effective date.
  • BASE_BALANCE_NAME — the underlying balance set identifier used in calculations.
  • BALANCE_NAME, REPORTING_NAME, BASE_REPORTING_NAME — user-facing labels for the balance and its base balance.
  • BUSINESS_GROUP_ID, LEGISLATION_CODE — organizational and legislative scoping.
  • CURRENT_VALUE, RUN_VALUE, PYDATE_VALUE, MONTH_VALUE, QTD_VALUE, PTD_VALUE — the computed balance amounts for the current context, run-to-date, pay-date, month-to-date, quarter-to-date, and period-to-date respectively.

The MONTH_VALUE column, matching the user search term, returns the month-to-date balance computed by PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE with the 'MONTH' selector.

Common Use Cases and Queries

Typical uses include reconciling Canadian federal employee balances for a specific payroll action, producing month-to-date vs. quarter-to-date comparisons, and validating that legislative balances align with expected reporting names.

  • Auditing all period values for an assignment action.
  • Filtering by LEGISLATION_CODE to isolate Canadian federal balances.
  • Comparing MONTH_VALUE against QTD_VALUE for period analysis.

A representative query retrieving month-to-date values for a specific assignment is:

SELECT assignment_id, tax_unit_id, balance_name, reporting_name, month_value, qtd_value, ptd_value FROM apps.pay_ca_fed_ee_v WHERE assignment_action_id = :p_assignment_action_id AND legislation_code = 'CA';

Because the value columns are function-derived, queries should pass bind parameters where possible, and callers should be aware that performance depends on the underlying balance package execution for each row returned.