Search Results us_postal_code




Overview
Explore in AI Chat

Overview

IGS_SV_EV_CRT_USADDR_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 view owned by the APPS schema and defined in the IGS – Student System product. It presents United States address information for newly created Exchange Visitor (EV) students. The view is part of the Student System's visa and SEVIS-related data model, supporting downstream processes that require clean, US-specific address data for exchange visitor records. Because the view restricts its result set to a particular address type and a null activity site, it functions as a purpose-built projection rather than a general-purpose address view. In ETRM the object is documented as VALID, and no referenced base objects are separately catalogued, although the view text identifies its single source explicitly.

Underlying Base Objects

The view is defined over exactly one base table: IGS_SV_ADDRESSES (aliased UADD). No other tables, joins, or synonyms are documented in the ETRM metadata. The definition applies two filters to the base table. First, it restricts rows to ADDRESS_TYPE = 'U', isolating the US address record from any other address types a student may hold. Second, it requires ACTIVITY_SITE_CD IS NULL, excluding addresses tied to a specific activity site. The view renames columns to a US-prefixed convention as they are projected, so that consumers receive an unambiguous US address shape. Because there are no documented joins, the view is a straightforward single-table projection and does not perform aggregation or computed expressions.

Key Columns

Common Use Cases and Queries

Typical uses include generating exchange visitor address extracts, validating that a US address exists for a person before SEVIS submission, and reconciling batch-loaded addresses. A simple lookup by person returns the US address and routing code:

SELECT person_id,
       us_address_line1,
       us_city,
       us_state,
       us_postal_code,
       us_postal_routing_code
FROM   apps.igs_sv_ev_crt_usaddr_v
WHERE  person_id = :p_person_id;

To list all exchange visitor addresses created under a given batch:

SELECT person_id,
       us_postal_code,
       us_postal_routing_code
FROM   apps.igs_sv_ev_crt_usaddr_v
WHERE  batch_id = :p_batch_id
ORDER  BY person_id;

A completeness check for missing postal routing codes:

SELECT person_id, us_postal_code
FROM   apps.igs_sv_ev_crt_usaddr_v
WHERE  us_postal_routing_code IS NULL;

Because the view filters to ADDRESS_TYPE = 'U' and ACTIVITY_SITE_CD IS NULL, queries against it need not repeat those predicates, and results are inherently scoped to US addresses for new Exchange Visitor students.