Search Results mws_zip_code

Overview

APPS.HR_WORKSITE_V is a database view owned by the APPS schema and delivered with the PER (Human Resources) product module in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata classifies it with a status of VALID and describes its purpose succinctly as "used to support user interface." In practice this view exists to feed Oracle HRMS forms and related UI components that need to present a flattened, denormalized picture of a worksite organization together with its filing characteristics and mailing address.

The object the user searched for, ORG_INFORMATION2, is material to this view because the view text relies on it repeatedly. It is used both as a classification flag (values of 'Y' in HR_ORGANIZATION_INFORMATION describe whether a given organization qualifies as an HR_ESTAB establishment or an HR_LEGAL legal entity) and as the SUI account number in the 'WORKSITE FILING' context. The view therefore functions as a bridge between organization classification data and location address data, which is why it surfaces in tax and regulatory reporting discussions.

Underlying Base Objects

The documented base objects behind the view are HR_GENERAL (PACKAGE), HR_LOCATIONS (VIEW), HR_ORGANIZATION_INFORMATION (SYNONYM), HR_ORGANIZATION_UNITS (VIEW), and HR_SECURITY (PACKAGE). Because HR_LOCATIONS and HR_ORGANIZATION_UNITS are themselves views, HR_WORKSITE_V is layered over the HRMS date-tracked security model rather than raw base tables, and HR_SECURITY enforces row-level access according to the security profile of the querying user.

The SELECT statement joins HR_ORGANIZATION_INFORMATION twice under the aliases HOI1 and HOI2, HR_LOCATIONS under HRL, and HR_ORGANIZATION_UNITS twice under HOU and HOU2. HOI2 filters on ORG_INFORMATION_CONTEXT = 'WORKSITE FILING' and ORG_INFORMATION1 = 'Y'. HOI1 filters on ORG_INFORMATION_CONTEXT = 'STATE TAX RULES', and the two are linked by matching the first ten characters of their ORG_INFORMATION2 values. Two EXISTS subqueries further require that the worksite organization carry the 'CLASS' context values HR_ESTAB and HR_LEGAL with ORG_INFORMATION2 = 'Y'.

Key Columns

• MWS_TAX_UNIT_ID — the organization identifier of the state tax rule unit (HOI1.ORGANIZATION_ID).
• MWS_BUSINESS_GROUP_ID — the business group owning the worksite organization.
• MWS_PRIMARY_WORKSITE_ORG_ID — the worksite organization identifier (HOI2.ORGANIZATION_ID).
• MWS_SUI_ACCOUNT_NO — the state unemployment insurance account number, sourced from ORG_INFORMATION2 in the worksite filing context.
• MWS_REPORTING_UNIT_NO, MWS_TRADE_NAME, MWS_WORKSITE_DESCRIPTION — ORG_INFORMATION3, 4 and 5 respectively, carrying reporting and descriptive details.
• MWS_COMMENT_CODE1, MWS_COMMENT_CODE2, MWS_COMMENTS — ORG_INFORMATION6, 7 and 8, holding coded and free-text comments.
• MWS_ADDRESS_LINE_1..3, MWS_CITY, MWS_STATE, MWS_ZIP_CODE — mailing address attributes drawn from HR_LOCATIONS, with MWS_STATE resolved by a DECODE that selects REGION_2 for US-style locations and REGION_1 for Canadian-style locations.

Common Use Cases and Queries

Typical uses include validating that every active establishment has a worksite filing record, reconciling SUI account numbers, and populating state tax registration reports. A representative query lists all worksites for a business group:

• SELECT mws_primary_worksite_org_id, mws_sui_account_no, mws_city, mws_state, mws_zip_code FROM apps.hr_worksite_v WHERE mws_business_group_id = :p_bg_id;
• SELECT mws_sui_account_no, mws_reporting_unit_no, mws_trade_name FROM apps.hr_worksite_v WHERE mws_state = 'CA';

Because HR_SECURITY governs access, results depend on the session's security profile.