Search Results postal_routing_code

Overview

IGS.IGS_SV_ADDRESSES is a transactional table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments that stores address information for foreign students and exchange visitors. It is a component of the Student and Exchange Visitor Information System (SEVIS) integration delivered within the Oracle Student System, supporting regulatory reporting requirements administered under the IGS schema. The table holds three distinct address record types — US addresses, Foreign addresses, and Site of Activity addresses — as identified by the ADDRESS_TYPE column. Each row is scoped to a specific processing batch, a person, and a party site, allowing the same individual to carry multiple address records across different SEVIS processing runs.

The heuristic Data Vault classification mined from the foreign key structure is standalone, suggesting this table is best modeled as an independent satellite or a standalone entity rather than as a hub or link. Its composite primary key — BATCH_ID, PERSON_ID, and PARTY_SITE_ID — reinforces that the table is fundamentally a detail-level record attached to persons and party sites, not a shared relationship construct between multiple hubs.

Key Information Stored

The primary key IGS_SV_ADDRESSES_PK is composed of three columns: BATCH_ID, PERSON_ID, and PARTY_SITE_ID. BATCH_ID identifies the run of the SEVIS process that generated the row, PERSON_ID identifies the student or exchange visitor, and PARTY_SITE_ID references the specific address record held on the party site. These three columns also form the unique index IGS_SV_ADDRESSES_U1, making them the documented business-key candidates in addition to being the surrogate primary key.

The most significant descriptive columns include:

• ADDRESS_TYPE — distinguishes the record as a Foreign, US, or Site of Activity address.
• ADDRESS_LINE1, ADDRESS_LINE2 — the first and second lines of the student's address.
• CITY, STATE, PROVINCE — locality information for the address.
• POSTAL_CODE — the postal code for the address, and POSTAL_ROUTING_CODE — the postal routing code, which is the element most commonly targeted by users querying this table.
• COUNTRY_CODE — the country associated with the address.
• STDNT_VALID_FLAG — indicates whether the student record is valid.
• PRINT_FORM — a flag indicating whether the SEVIS form is to be printed.
• ACTION_TYPE — used for Exchange Visitors site of activity addresses, with values such as R (Remove site) and A (Add site).
• ACTIVITY_SITE_CD, PRIMARY_FLAG, REMARKS — additional attributes associated with the address record and its site.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Who columns capturing audit metadata.

Common Use Cases and Queries

This table is typically queried during SEVIS batch reconciliation, address verification, and regulatory reporting. A common pattern retrieves all addresses for a person within a given batch:

• SELECT ADDRESS_TYPE, POSTAL_CODE, POSTAL_ROUTING_CODE FROM IGS_SV_ADDRESSES WHERE PERSON_ID = :p AND BATCH_ID = :b;
• Determining which forms are pending print: SELECT PERSON_ID, PARTY_SITE_ID FROM IGS_SV_ADDRESSES WHERE PRINT_FORM = 'Y';
• Identifying address changes for exchange visitors using ACTION_TYPE: SELECT ACTION_TYPE, ACTIVITY_SITE_CD FROM IGS_SV_ADDRESSES WHERE ACTION_TYPE IN ('A','R');

Reporting teams frequently join this table to person and party-site structures to produce address census reports for international student offices.

Related Objects

The following objects are most significant in relation to IGS_SV_ADDRESSES. Joins are expressed on the documented key columns:

• IGS_SV_ADDRESSES_U1 / IGS_SV_ADDRESSES_PK — unique indexes enforcing (BATCH_ID, PERSON_ID, PARTY_SITE_ID).
• IGS_SV_ADDRESSES_N1 — non-unique index on (PERSON_ID, PARTY_SITE_ID) supporting person-level lookups.
• Person / party-site base tables — referenced via PERSON_ID and PARTY_SITE_ID to resolve identity and site details.
• SEVIS batch processing objects — related through BATCH_ID to the run that produced the address records.
• Student System SEVIS reporting views — which combine ADDRESS_TYPE, POSTAL_CODE, and POSTAL_ROUTING_CODE for regulatory submissions.