Results for “de_tax_status”

8 results




Overview
Explore in AI Chat

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

Overview

APPS.HR_DE_TAX_INFORMATION_V is a German localization view delivered with Oracle E-Business Suite 12.1.1 and 12.2.2. It presents German tax card data entered against employee element entries in Oracle Payroll and HRMS, exposing cryptic ENTRY_INFORMATIONn flexfield segments from PAY_ELEMENT_ENTRIES_F as named, human-readable columns. The view is defined in the APPS schema and is intended primarily for reporting, extract generation, and downstream integration — for example feeding German payroll tax routines, ELStAM-style submissions, or custom tax-card reports. Because it translates code values into descriptive text through lookup decoding, it is best treated as a reporting view rather than as a transactional interface for updating tax information.

Underlying Base Objects

The view is defined over a single transactional synonym, PAY_ELEMENT_ENTRIES_F, which supplies the row identifier, object version number, element entry identifier, and the ENTRY_INFORMATION1 through ENTRY_INFORMATION25 segments. Supporting objects supply derived or decoded values:

  • PAY_ELEMENT_ENTRIES_F — the base element entry rows for German tax information entries.
  • FND_DATE (package) — converts the stored date segment into a canonical date via fnd_date.canonical_to_date.
  • HR_DE_GENERAL (package) — supplies get_TAX_OFFICE_details, which resolves the tax office numeric identifier into a code and description.
  • HR_GENERAL (package) — supplies DECODE_LOOKUP, translating coded segments into lookup meaning.
  • FND_SESSIONS (synonym) — the standard session context object referenced by the view metadata.

Key Columns

The view exposes identity columns (ROW_ID, OBJECT_VERSION_NUMBER, ELEMENT_ENTRY_ID) alongside the following business attributes:

  • TAX_CARD_NUMBER, TAX_YEAR, ISSUE_DATE, CARD_ISSUER, TAX_CARD_LOCATION — core tax card identification and issuance data.
  • tax office code and description — derived from ENTRY_INFORMATION20 through HR_DE_GENERAL.get_TAX_OFFICE_details.
  • Tax_status_code / Tax_Status — coded via lookup DE_TAX_STATUS.
  • Tax_table_code / Tax_Table — coded via lookup DE_TAX_TABLE.
  • Tax_class_code / Tax_Class — coded via lookup DE_TAX_CLASS (the object matching the search term “de_tax_class”). The code column holds the stored value and the descriptive column holds the decoded lookup meaning.
  • Church tax and contribution flags — yearly_church_tax_flag, max_church_tax_flag, chamber_contribution, pensioners_tax_flag, all decoded through the YES_NO lookup, together with yearly_income_tax_flag.
  • Tax-free income and dependants — no_of_children, yearly_tax_free_income, monthly_tax_free_income, additional_year_taxable_income.

Common Use Cases and Queries

Typical usage includes auditing tax class assignments, validating tax office mappings, and building German payroll extracts.

  • Tax class audit: SELECT element_entry_id, tax_card_number, tax_year, tax_class_code, tax_class FROM apps.hr_de_tax_information_v ORDER BY tax_year, tax_class_code;
  • Church tax reporting: filter on yearly_church_tax_flag = 'Yes' and group by tax office description.
  • Extract generation: join ELEMENT_ENTRY_ID back to PAY_ELEMENT_ENTRIES_F and PAY_PAYROLL_ACTIONS to select tax data for a payroll period.
  • Lookup validation: compare Tax_Class and Tax_class_code to confirm DE_TAX_CLASS lookup definitions are complete.