Search Results us_lit_filing_status




Overview
Explore in AI Chat

Overview

APPS.PAY_EMP_LOCAL_TAX_V1 is a supplementary database view owned by the APPS schema and registered as a valid object in Oracle E-Business Suite 12.1.1 and 12.2.2. Its FND Design Data reference is PAY.PAY_EMP_LOCAL_TAX_V1, and it is classified as a view type explicitly described as a supplementary view used to simplify forms coding. Oracle documents a standing caution that querying or altering data through this view is not recommended, since its definition may change dramatically across minor or major releases. The view consolidates employee-level local tax information — state, jurisdiction, withholding, exemption, and locality residency data — into a single flattened record that forms can consume without issuing complex joins directly against the underlying payroll and HR tables.

Because the view exposes TIME_IN_LOCALITY alongside jurisdiction, city, and school district attributes, it is frequently encountered when developers or analysts investigate local tax residency and locality duration reporting. This makes it a plausible target for the search term "time_in_locality," even though the view is designed primarily as a form-support construct rather than a public reporting interface.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects: FND_NUMBER (PACKAGE), HR_API (PACKAGE), HR_LOOKUPS (VIEW), PAY_STATE_RULES (SYNONYM), and PER_ASSIGNMENT_EXTRA_INFO (SYNONYM). The dependency list also includes FND_GLOBAL.

PER_ASSIGNMENT_EXTRA_INFO is the principal source of the employee assignment-level local tax details, supplying the assignment extra information identifier, information type, and the various locality and exemption attributes. HR_LOOKUPS is used to resolve lookup codes into descriptive values such as filing status and state or jurisdiction names, while PAY_STATE_RULES supplies state-specific rule context. FND_NUMBER and HR_API are utility packages invoked by the view's defining logic, and FND_GLOBAL provides session context such as the effective user and date. The synonym PAY_EMP_LOCAL_TAX_V1 is exposed publicly and is referenced by APPS.PAY_US_EMP_TAX_RULES_PKG, confirming that the view participates in US employee tax rule processing.

Key Columns

Common Use Cases and Queries

Typical uses include verifying locality residency, reviewing local income tax exemptions and overrides, and debugging US payroll local tax rule processing. A representative query filtering on the searched attribute:

  • SELECT assignment_id, state_code, city_name, jurisdiction_code, time_in_locality, lit_exempt, enabled FROM apps.pay_emp_local_tax_v1 WHERE time_in_locality IS NOT NULL;
  • SELECT assignment_id, state_code, filing_status, withholding_allowances, lit_override_rate FROM apps.pay_emp_local_tax_v1 WHERE assignment_id = :p_assignment_id;

Analysts should treat results as informational and prefer documented public APIs where read-consistency across releases is required.