Search Results mws_zip_code

Overview

APPS.HR_WORKSITE_V is a supplementary Oracle EBS view owned by the APPS schema and registered under FND Design Data as PER.HR_WORKSITE_V. It exposes worksite-level information used primarily to satisfy Multi-State Withholding (MWS) tax reporting requirements, including the data elements required for SUI (State Unemployment Insurance) account numbers and magnetic media (magtape) reporting. As documented, the view is classified as a "supplementary view used to simplify forms coding," and its metadata carries the standard Oracle warning that querying or altering data through it is not recommended because its definition may change dramatically in subsequent minor or major releases.

In practice, HR_WORKSITE_V functions as a flattened projection of worksite organization, location, and address attributes, presenting them under the MWS_ prefix. It bridges HR organization model data (organization units, organization information, and locations) with payroll tax reporting logic used by the MWS magtape reporting process. It is not a base table and holds no data of its own.

Underlying Base Objects

The view's dependency chain, as documented in the ETRM metadata, is as follows:

• HR_ORGANIZATION_UNITS (VIEW) — supplies the worksite organization definition and the primary worksite organization identifier.
• HR_ORGANIZATION_INFORMATION (SYNONYM) — supplies contextual organization attributes referenced by the worksite logic.
• HR_LOCATIONS (VIEW) — supplies the address components: address lines, city, state, and zip code.
• HR_GENERAL (PACKAGE) — provides general HR utility functions used in resolving display values and security.
• HR_SECURITY (PACKAGE) — applies HR security predicates so that only authorized organization/location rows are returned to the calling session.

The view is referenced by PAY_MWS_MAGTAPE_REPORTING, confirming its role in the payroll Multi-State Withholding magtape reporting pipeline.

Key Columns

• MWS_TAX_UNIT_ID (NUMBER) — identifier of the tax unit associated with the worksite; the primary correlation key to payroll tax setups.
• MWS_BUSINESS_GROUP_ID (NUMBER) — the business group to which the worksite belongs.
• MWS_PRIMARY_WORKSITE_ORG_ID (NUMBER) — the organization ID of the primary worksite organization.
• MWS_SUI_ACCOUNT_NO (VARCHAR2) — the state unemployment insurance account number used in SUI reporting.
• MWS_REPORTING_UNIT_NO (VARCHAR2) — the reporting unit number filed with the tax authority.
• MWS_TRADE_NAME / MWS_WORKSITE_DESCRIPTION (VARCHAR2) — the operating (trade) name and descriptive label of the worksite.
• MWS_ADDRESS_LINE_1/2/3, MWS_CITY, MWS_STATE, MWS_ZIP_CODE (VARCHAR2) — the full mailing address of the worksite, sourced from HR_LOCATIONS. MWS_ZIP_CODE is the column most commonly referenced in user searches for this view.

Common Use Cases and Queries

Typical uses include validating the worksite and address used on MWS magtape submissions, reconciling SUI account numbers to state filings, and troubleshooting ZIP code or state mismatches on reported worksites.

Sample query returning worksite details, including the MWS_ZIP_CODE column:

• SELECT mws_tax_unit_id, mws_primary_worksite_org_id, mws_trade_name, mws_city, mws_state, mws_zip_code FROM apps.hr_worksite_v WHERE mws_zip_code = '&zip';
• SELECT mws_sui_account_no, mws_reporting_unit_no, mws_state FROM apps.hr_worksite_v WHERE mws_business_group_id = :bg_id;
• SELECT mws_primary_worksite_org_id, mws_address_line_1, mws_city, mws_state, mws_zip_code FROM apps.hr_worksite_v ORDER BY mws_state, mws_city;

Because HR_SECURITY is in the dependency chain, results are filtered by the HR security profile of the connected user. Given the documented volatility warning, custom code should select only the needed MWS_ columns and avoid depending on a stable column list across releases.