Results for “pay_in_asg_elements_v”

50+ results




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

Overview

PAY_IN_ASG_ELEMENTS_V is an Oracle E-Business Suite (EBS) view owned by the APPS schema within the PAY (Payroll) product family. It exists in both 12.1.1 and 12.2.2 and is flagged VALID in the ETRM repository. The view presents assignment-level payroll element results in a form suited to payslip, statutory, and localization reporting, specifically the Oracle Payroll "IN" (India) legislation. It consolidates data from payroll actions, assignment actions, run results, run result values, element type definitions, input values, and element classifications into a single denormalized row set. The suffix _V denotes a view rather than a base table; the object is read-only in that it does not carry its own storage, but the underlying joins are materialized at query time from the base entities listed below.

Underlying Base Objects

The view is defined over the following documented base objects: PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_INPUT_VALUES_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, PAY_ELEMENT_CLASSIFICATIONS, PAY_ACTION_INTERLOCKS, and the PAY_IN_PAYSLIP_UTILS package. The driving tables are PAY_PAYROLL_ACTIONS (filtered to ACTION_TYPE in 'R','Q' and ACTION_STATUS = 'C') and PAY_ASSIGNMENT_ACTIONS. Run result data is supplied through PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES, while element definitions come from PAY_ELEMENT_TYPES_F joined to its translation table PAY_ELEMENT_TYPES_F_TL (LANGUAGE = USERENV('LANG')). Classification names are resolved via PAY_ELEMENT_CLASSIFICATIONS, restricted to the India legislation (LEGISLATION_CODE = 'IN'). Input values are sourced from PAY_INPUT_VALUES_F where the input NAME = 'PAY VALUE'. The PAY_IN_PAYSLIP_UTILS package supplies the GET_EXCHANGE_RATE function used to populate the exchange rate column.

Key Columns

  • ROW_ID — ROWID of the underlying element type row; useful as a unique surrogate identifier in queries.
  • ASSIGNMENT_ACTION_ID — Identifier linking the row to a specific assignment action.
  • CLASSIFICATION_NAME — Normalized element classification. The DECODE maps PRE TAX DEDUCTIONS, TAX DEDUCTIONS, INVOLUNTARY DEDUCTIONS, and VOLUNTARY DEDUCTIONS to 'DEDUCTIONS'; ALLOWANCES to 'EARNINGS'; ADVANCES to 'ADVANCES'; and retains FRINGE BENEFITS, PAID MONETARY PERQUISITE, and other values.
  • ELEMENT_REPORTING_NAME — Reporting name from PAY_ELEMENT_TYPES_F_TL, falling back to ELEMENT_NAME via NVL.
  • PROCESSING_PRIORITY — Priority sequence from the element type, controlling processing order.
  • AMOUNT — Summed result value, populated only where the input value UOM begins with 'M' (monetary).
  • FOREIGN_CURRENCY_CODE — Derived from the element's INPUT_CURRENCY_CODE, with the value 'INR' suppressed to NULL. This is the column most frequently referenced by users searching for foreign_currency_code.
  • EXCHANGE_RATE — Computed through PAY_IN_PAYSLIP_UTILS.GET_EXCHANGE_RATE using input currency, output currency, payroll action effective date, and business group.

Common Use Cases and Queries

Typical applications include India statutory payslip and return preparation, reconciliation of element results by classification, and identification of foreign-currency element entries requiring rate conversion. A representative query follows:

  • SELECT assignment_action_id, element_reporting_name, classification_name, amount, foreign_currency_code, exchange_rate FROM apps.pay_in_asg_elements_v WHERE foreign_currency_code IS NOT NULL;
  • SELECT classification_name, SUM(amount) FROM apps.pay_in_asg_elements_v GROUP BY classification_name;
  • SELECT element_reporting_name, foreign_currency_code, exchange_rate, amount FROM apps.pay_in_asg_elements_v WHERE exchange_rate <> 1 ORDER BY element_reporting_name;

Because the view filters to ACTION_TYPE in 'R','Q', ACTION_STATUS = 'C', LEGISLATION_CODE = 'IN', and input NAME = 'PAY VALUE', it returns only completed, India-legislated payroll run and quick-pay results. Queries should therefore be scoped to a specific payroll action or assignment action to avoid scanning the full history of completed runs. The foreign currency filtering behavior (suppressing 'INR') makes the view particularly convenient for isolating non-functional currency amounts in India payroll reporting.