Results for “de_tax”

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

Overview

APPS.HR_DE_TAX_EXEMPTIONS_V is a reporting view in Oracle E-Business Suite that exposes German tax exemption data stored as element entry information in Oracle Payroll. The view presents records from PAY_ELEMENT_ENTRIES_F where ENTRY_INFORMATION_CATEGORY equals 'DE_TAX EXEMPTIONS' and ENTRY_TYPE equals 'E'. Rather than requiring callers to parse the five generic ENTRY_INFORMATIONn descriptor columns and to apply the effective-dating rules manually, the view projects them into named columns such as Form_Number, Issue_Date, Valid_From, Valid_To, and Tax_Free_Remuneration.

The view is session-aware. It joins PAY_ELEMENT_ENTRIES_F to FND_SESSIONS using USERENV('SESSIONID'), and it restricts rows to the calendar year of the session effective date, requiring the element entry's effective start date to fall on or after January 1 of that year and its effective end date to fall on or before December 31. This makes the view useful for legislative reporting and for integration interfaces that need the exemption certificate in force for the current session year, without exposing historical or out-of-period rows.

Underlying Base Objects

The ETRM metadata documents three referenced objects. PAY_ELEMENT_ENTRIES_F (synonym) is the primary source and supplies the element entry identifier, assignment, effective dates, object version number, and the five ENTRY_INFORMATIONn columns. FND_SESSIONS (synonym) supplies the session effective date used for the year-boundary filter and is joined on SESSION_ID equal to USERENV('SESSIONID'). FND_DATE (package) provides the CANONICAL_TO_DATE conversion used to translate ENTRY_INFORMATION3 and ENTRY_INFORMATION4 from stored canonical strings into true DATE values. The view selects PEE.ROWID as ROW_ID and PEE.OBJECT_VERSION_NUMBER, preserving the identity and concurrency attributes of the underlying row.

Key Columns

• ROW_ID — the ROWID of the PAY_ELEMENT_ENTRIES_F row, useful for direct row identification.
• OBJECT_VERSION_NUMBER — optimistic locking attribute carried from the base table.
• ELEMENT_ENTRY_ID — primary identifier of the element entry record.
• FORM_NUMBER — first 30 characters of ENTRY_INFORMATION1, the exemption certificate form number.
• ISSUE_DATE — first 30 characters of ENTRY_INFORMATION2, the certificate issue date.
• VALID_FROM — FND_DATE.CANONICAL_TO_DATE of ENTRY_INFORMATION3, the exemption validity start date.
• VALID_TO — FND_DATE.CANONICAL_TO_DATE of ENTRY_INFORMATION4, the exemption validity end date. This is the column surfaced when users search on "entry_information4".
• TAX_FREE_REMUNERATION — first 30 characters of ENTRY_INFORMATION5, the tax-free remuneration amount.
• ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — the assignment and effective dating of the element entry.

Common Use Cases and Queries

Typical consumers include German payroll reporting, third-party tax interfaces, and custom concurrent programs that need certificate data for the active session year.

List exemptions with validity dates for a given assignment:

SELECT assignment_id, form_number, issue_date,
       valid_from, valid_to, tax_free_remuneration
FROM   apps.hr_de_tax_exemptions_v
WHERE  assignment_id = :p_assignment_id;

Identify certificates expiring during the current session year:

SELECT element_entry_id, assignment_id, form_number, valid_to
FROM   apps.hr_de_tax_exemptions_v
WHERE  valid_to BETWEEN TRUNC(SYSDATE,'YYYY') AND TRUNC(SYSDATE,'YYYY')+364;

Because the view is already bounded to the session year and filters ENTRY_TYPE = 'E', queries against it are concise and require no additional date-boundary logic. Cross-checking against PAY_ELEMENT_ENTRIES_F is advisable when historical years are needed, since the view intentionally excludes rows outside the session effective date's calendar year.