Search Results time_in_locality

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

• ROW_ID – ROWID pseudo-column identifying the underlying row.
• ASSIGNMENT_EXTRA_INFO_ID / ASSIGNMENT_ID – Keys linking the record to the assignment and its extra information entry.
• INFORMATION_TYPE – Identifies the category of assignment extra information.
• STATE_CODE / STATE_NAME / CITY_NAME – State and city identification for the locality.
• JURISDICTION_CODE – The taxing jurisdiction applicable to the employee.
• FILING_STATUS_CODE / FILING_STATUS – Withholding filing status code and its displayed description.
• WITHHOLDING_ALLOWANCES / ADDITIONAL_WA_RATE – Allowance count and additional withholding rate.
• LIT_ADDITIONAL_TAX / LIT_EXEMPT / LIT_OVERRIDE_RATE / LIT_OVERRIDE_AMOUNT – Local income tax additional, exemption, and override values.
• SD_EXEMPT / HT_EXEMPT – School district and hotel/other exemption indicators.
• SCHOOL_DISTRICT_CODE – School district identifier.
• ENABLED – Flag indicating whether the record is active.
• TIME_IN_LOCALITY – Numeric value representing the time (duration) the employee has been within the locality, used in local tax residency determination.

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.