Results for “sv_f_addr”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_SV_EDT_FADDR_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, documented in the ETRM 12.2.2 repository. It belongs to the Student Systems (IGS) product family and serves the Student Visa / SEVIS address processing area associated with the "SV_F_ADDR" tag code. The view exposes foreign (non-U.S.) address records that have been staged for edit processing and are marked with a SEND administrative action, providing a pre-joined, denormalized result set for downstream extracts, interfaces, and concurrent programs.

Users searching on the term "sv_f_addr" are typically attempting to locate the object that resolves a batch's foreign address payload. The IGS_SV_EDT_FADDR_V view answers exactly that requirement: it isolates the F-type address row per person within a batch and labels each output column with the FN_ prefix, signalling a "foreign address" context to any consumer.

Underlying Base Objects

The view is defined over two documented base tables:

• IGS_SV_ADDRESSES — aliased as FGN; supplies the address detail rows, filtered by ADDRESS_TYPE = 'F'.
• IGS_SV_BTCH_SUMMARY — aliased as FADDRSUMM; supplies the batch control and administrative action context.

The join is established on the composite key of BATCH_ID and PERSON_ID, ensuring that each foreign address row is correlated to the correct batch summary row for the same individual. The view is therefore a two-table equi-join with no outer join, meaning that address rows lacking a corresponding batch summary row will not appear in the result set.

Key Columns

The projection of the view is deliberately narrow, containing eight columns. The first two carry the correlation keys, and the remaining six carry the address payload. Each payload column is aliased with the FN_ (foreign) prefix, which distinguishes this view from its domestic-address counterparts.

• BATCH_ID — the processing batch identifier; the grouping key for extract and reconciliation logic.
• PERSON_ID — the internal person identifier, used to link back to the person record.
• FN_ADDRESS_LINE1 and FN_ADDRESS_LINE2 — the street address lines as staged.
• FN_CITY — the city or locality.
• FN_PROVINCE — the province, state, or regional designation.
• FN_POSTAL_CODE — the postal or ZIP equivalent for the foreign address.
• FN_CNTRY_CODE — the country code, essential for routing and validating international mail.

Note that ACTIVITY_SITE_CD is referenced in the predicate but not projected; its role is purely restrictive.

Filter Predicates

The view applies four restrictive conditions that together define its semantics:

• FGN.ADDRESS_TYPE = 'F' — restrict to foreign address records.
• FADDRSUMM.TAG_CODE = 'SV_F_ADDR' — restrict to the SEVIS foreign-address tag.
• FADDRSUMM.ADM_ACTION_CODE = 'SEND' — restrict to rows flagged for outbound transmission.
• FGN.ACTIVITY_SITE_CD IS NULL — exclude rows associated with an activity site, limiting output to the batch-level address record.

Common Use Cases and Queries

The view is typically queried by batch to retrieve all foreign addresses destined for transmission, or by person to inspect a single individual's staged foreign address. A representative query follows:

SELECT batch_id, person_id, fn_address_line1, fn_city, fn_province, fn_postal_code, fn_cntry_code FROM apps.igs_sv_edt_faddr_v WHERE batch_id = :p_batch_id ORDER BY person_id;

A second common pattern joins the view back to person or batch tables to enrich the extract with names and status values. Because the view already filters on ADM_ACTION_CODE = 'SEND', it should not be used as a general-purpose address source; queries that require addresses in other action states must be written directly against IGS_SV_ADDRESSES.