Search Results element_inormation10

Overview

APPS.PAY_US_GTN_DEDUCT_V is a US localization view in the Oracle Payroll (PAY) schema. It exposes deduction and tax-balance related data used by the Oracle E-Business Suite "GTN" (Gross-to-Net) processing load, specifically the payroll run result extraction performed by the concurrent program object PAY_GTNLOD. The view is classified as Oracle Internal Use Only, meaning Oracle Corporation does not support direct customer access outside of standard Oracle Applications programs.

The view has a status of VALID and is registered in FND Design Data as PAY.PAY_US_GTN_DEDUCT_V. It presents a denormalized projection of assignment-level deduction activity, joining payroll action and run result context with balance, element, and reporting attributes. Because it carries the user-visible column ELEMENT_INORMATION10 — the concatenated "Element Information" descriptive flexfield segment — it is frequently encountered when customers search for that label while debugging deduction balances or payroll element detail.

Underlying Base Objects

Per documented metadata, the view is defined over the following APPS base objects:

• PAY_ASSIGNMENT_ACTIONS — supplies assignment action identifiers, action status, and effective dates.
• PAY_PAYROLL_ACTIONS — supplies payroll action context, action type, and payroll action ID.
• PAY_RUN_RESULTS — the transactional run results underlying the deduction amounts (RUN_VALUE).
• PAY_BALANCE_TYPES — provides balance name, balance type ID, and unit of measure.
• PAY_US_DEDUCTION_TYPES_V — the US deduction type view supplying element/classification detail, including the ELEMENT_INORMATION10 segment.
• PAY_US_BALANCE_VIEW_PKG — package used to derive balance view context.
• PAY_US_TAXBAL_VIEW_PKG — package used to derive tax-balance view context.

The view is referenced by APPS.PAY_GTNLOD, confirming its role as a source for the GTN load path rather than a standalone end-user reporting object.

Key Columns

Column names are notable for their spelling: ELEMENT_INORMATION10 (not "INFORMATION") is the actual metadata label, matching the reported user search term.

• ASSIGNMENT_ID, TAX_UNIT_ID, ASSIGNMENT_ACTION_ID, PAYROLL_ACTION_ID — assignment, tax unit, and action identifiers linking results to payroll processing.
• ACTION_STATUS, ACTION_TYPE, PROCESSING_PRIORITY — run/action state and element processing order.
• EFFECTIVE_DATE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — dated element and view effective ranges.
• ELEMENT_NAME, ELEMENT_TYPE_ID, CLASSIFICATION_NAME — the deduction element and its classification.
• ELEMENT_INORMATION10 — VARCHAR2(150) descriptive segment exposed for external consumers.
• REPORTING_NAME, REPORTING_NAME_ALT, BALANCE_NAME, BALANCE_TYPE_ID, BALANCE_UOM — balance reporting identity and units.
• VIEW_MODE (VARCHAR2(4000)), CALC_ALL_TIMETYPES, RUN_VALUE — balance view mode, calculation option, and the deduction/run amount.
• BUSINESS_GROUP_ID, LEGISLATION_CODE — legislative and business group scoping.

Common Use Cases and Queries

Typical usage is diagnosing deduction balances and element information for a US payroll run, or auditing GTN load output. A basic query:

SELECT assignment_id, element_name, element_inormation10, balance_name, run_value, effective_date FROM apps.pay_us_gtn_deduct_v WHERE payroll_action_id = :p_action_id;

The INFORMATION10 segment is often the target, for example filtering WHERE element_inormation10 = :p_value. Because the view is Internal Use Only, customers should prefer supported payroll balance or run result reports, restricting direct queries to non-production diagnostics.