Search Results flsa_status




Overview
Explore in AI Chat

Overview

APPS.HR_USJOB_LOV_V is a reporting and list-of-values view in Oracle E-Business Suite that exposes job definitions for United States business groups together with their derived Fair Labor Standards Act (FLSA) exemption status. The view resolves the FLSA designation stored on the job record into its user-facing lookup meaning, so that a single query returns the job identifier, translated job name, business group, effective dates, and the human-readable FLSA status. Because the view joins the translated job name table and applies the session language through USERENV('LANG'), it returns job names in the language of the connected user, making it suitable for both Oracle Forms list-of-values windows and ad hoc reporting against the HR schema.

The object is owned by APPS and is documented in ETRM metadata for release 12.2.2, with the same definition carried forward from 12.1.1. It is a lightweight, read-only view intended strictly for query access; it exposes no DML surface and holds no data of its own. Its naming and column set make it particularly relevant to users searching on the term FLSA_STATUS, since that column is the distinguishing feature of this view relative to more generic job views.

Underlying Base Objects

The ETRM metadata records four referenced base objects: HR_API (PACKAGE), HR_LOOKUPS (VIEW), PER_JOBS (SYNONYM), and PER_JOBS_TL (SYNONYM). The view text confirms how three of these participate:

  • PER_JOBS — supplies the core job rows, including JOB_ID, BUSINESS_GROUP_ID, DATE_FROM, DATE_TO, and the Job Information flexfield segment JOB_INFORMATION3 that carries the FLSA code.
  • PER_JOBS_TL — supplies the translated job name (NAME) and is joined to PER_JOBS on JOB_ID with the language filter applied.
  • HR_LOOKUPS — supplies the lookup meaning that converts the stored FLSA code into readable text; the join uses the outer-join operator (+) on both LOOKUP_CODE and LOOKUP_TYPE, so jobs without a matching lookup still appear with a null FLSA status.
  • HR_API — referenced as a package supporting the HR foundation, providing the API layer through which jobs and lookups are maintained.

Key Columns

  • JOB_ID — Primary identifier of the job definition; the join key between PER_JOBS and PER_JOBS_TL.
  • JOB_NAME — Translated job name sourced from PER_JOBS_TL.NAME, restricted to the session language.
  • BUSINESS_GROUP_ID — The business group that owns the job, used to scope results to a US legislative context.
  • DATE_FROM / DATE_TO — Effective date range of the job record, enabling date-effective filtering.
  • FLSA_STATUS — The lookup meaning (HLC.MEANING) resolved from JOB_INFORMATION3 against lookup type US_EXEMPT_NON_EXEMPT. This column expresses whether the job is exempt or non-exempt under FLSA rules.

Common Use Cases and Queries

Typical uses include populating list-of-values fields in HR forms, validating FLSA designation during job creation or update, and reporting exempt versus non-exempt headcount by business group. A common query lists all jobs for a business group with their FLSA status:

  • SELECT job_id, job_name, flsa_status, date_from, date_to FROM apps.hr_usjob_lov_v WHERE business_group_id = :p_bg_id ORDER BY job_name;

To isolate only exempt jobs, filter on the resolved meaning:

  • SELECT job_id, job_name, flsa_status FROM apps.hr_usjob_lov_v WHERE flsa_status = 'Exempt';

Rows returning a null FLSA_STATUS indicate job records whose JOB_INFORMATION3 value has no corresponding US_EXEMPT_NON_EXEMPT lookup, which is useful for data-quality audits. All queries must account for the session-language filter applied within the view.