Search Results emp_status




Overview
Explore in AI Chat

Overview

APPS.JTF_RS_EMP_DTLS_VL is a reporting and integration view within the Oracle E-Business Suite resource management schema. It presents a flattened, human-readable projection of employee-level resource records sourced from the broader resource extensions layer of the CRM/Resource Manager foundation. The suffix "VL" indicates that the object is a validated, translatable view, meaning display values for certain derived attributes are resolved through the translation framework while the underlying identifiers remain intact.

In Oracle EBS 12.1.1 and 12.2.2 the view is owned by the APPS schema and is primarily consumed by modules such as Field Service, TeleService, Service Request, iSupport, and resource scheduling components. It serves as the canonical read-only source for employee resource details, providing denormalised access to identities, contact information, organisational assignments, cost attributes, and job context without requiring the caller to join the numerous underlying resource and HR tables directly. The view is not a table-backed entity and holds no data of its own; every row is derived at query time.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the only referenced base object is JTF_RS_RESOURCE_EXTNS_VL, itself a validated view over the resource extensions entity. JTF_RS_EMP_DTLS_VL selects a defined column list from that parent view and applies a single restrictive predicate: rsc.category = 'EMPLOYEE'. This filter is the defining characteristic of the view, ensuring that only resource records classified as employees are returned, excluding other resource categories such as teams, groups, or non-employee resources.

Because the parent JTF_RS_RESOURCE_EXTNS_VL consolidates data that ultimately originates in resource, party, and HR person structures, the view inherits that lineage. Column-level aliasing in the defining query renames parent attributes to business-friendly names, for example SOURCE_FIRST_NAME becomes FIRST_NAME and SOURCE_CATEGORY becomes EMP_CATEGORY.

Key Columns

Common Use Cases and Queries

The view is typically used to populate resource pickers, resolve employee contact details on service requests, and drive scheduling or dispatch logic. A common query retrieves active employees within a business group:

  • SELECT resource_id, employee_number, full_name, emp_category, email FROM apps.jtf_rs_emp_dtls_vl WHERE org_id = :p_org_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND NVL(effective_end_date, TRUNC(SYSDATE));
  • SELECT full_name, job_title, manager_name FROM apps.jtf_rs_emp_dtls_vl WHERE emp_status = 'ACTIVE';
  • SELECT resource_id, cost_per_hr, cost_center FROM apps.jtf_rs_emp_dtls_vl WHERE emp_category = :p_category;

Because the view is read-only and always filtered to employees, it should be used for reporting and integration rather than for transactional updates, which must target the underlying resource tables.