Search Results national_identifier




Overview
Explore in AI Chat

Overview

PER_ES_TAX_SS_EMP_V is an APPS-owned database view within the Oracle E-Business Suite Human Resources (PER) product module. It is documented as being used in the Social Security and Tax Forms for Spain, presenting a small set of employee attributes required by Spanish statutory reporting, including social security filings and tax documentation. The view is registered in the ETRM repository with a status of VALID and is available in both Oracle EBS 12.1.1 and 12.2.2 environments.

The view is a session-driven, single-row-per-person projection. Rather than exposing the full breadth of person or assignment data, it surfaces only the attributes needed by the Spanish legislative reports: the employee's full name, age at the session effective date, sex and its decoded meaning, national identifier, assignment identifiers, and a derived disability degree. Because the view is defined over both people and assignment records and joined to the current FND session, it returns the assignment-level view of the person as of the effective date of the active session.

Underlying Base Objects

The view is defined over the following documented objects:

The joins are person-to-assignment on PERSON_ID, with both the person and assignment rows filtered by the effective date of the current session. The FND_SESSIONS row is effectively a driver table restricting the query to the context of the calling session.

Key Columns

  • FULL_NAME — the concatenated or formatted full name of the person from PER_ALL_PEOPLE_F.
  • AGE — computed as FLOOR(MONTHS_BETWEEN(session effective date, DATE_OF_BIRTH)/12), yielding completed years at the session effective date.
  • SEX — the stored lookup code for the person's sex.
  • SEX_MEANING — the decoded meaning of the sex code, resolved via HR_GENERAL.DECODE_LOOKUP('SEX', SEX).
  • NATIONAL_IDENTIFIER — the national identifier stored on the person record. This is the column most commonly sought by users searching on "national_identifier"; in the Spanish context it corresponds to the documento nacional de identidad or equivalent tax identity value used on social security and tax forms.
  • ASSIGNMENT_ID — the surrogate identifier of the person's assignment.
  • ASSIGNMENT_NUMBER — the user-visible assignment number.
  • DISABILITY_DEGREE — the disability degree derived by HR_ES_UTILITY for the person at the effective date.

Common Use Cases and Queries

The view is typically consumed by Spanish social security and tax form generation, and by ad hoc reporting where a compact employee snapshot including the national identifier is required. Because it depends on the session's effective date, it should be queried within a session context that supplies a meaningful EFFECTIVE_DATE; outside such a context, age and date tracking resolve against the session defaults.

A simple retrieval for a known assignment might be written as:

  • SELECT full_name, age, sex_meaning, national_identifier FROM per_es_tax_ss_emp_v;
  • SELECT national_identifier, assignment_number, disability_degree FROM per_es_tax_ss_emp_v;
  • SELECT full_name, age FROM per_es_tax_ss_emp_v WHERE sex = 'M';

Report developers integrating Spanish statutory outputs frequently join the view back to PER_ALL_ASSIGNMENTS_F or PER_ALL_PEOPLE_F on ASSIGNMENT_ID or PERSON_ID when additional attributes beyond those exposed are needed. As with all EBS date-tracked constructs, callers should remain aware that the values returned reflect the effective date bound through FND_SESSIONS rather than the current system date.