Results for “us_state”

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

Overview

The view IGS_SV_CRT_STDT_USADDR_V belongs to the IGS — Student System product family within Oracle E-Business Suite, a module that Oracle has since classified as obsolete. Its documented purpose is narrow and functional: it fetches United States address information associated with newly created Non-Immigrant students. In the ETRM 12.2.2 metadata the object carries no documented owner and no explicitly recorded referenced base objects, and implementation notes state it is "Not implemented in this database." That combination indicates the view is a legacy or seeded definition whose value today is primarily documentary and diagnostic rather than operational. Where the view does exist in a customer instance, it serves reporting and integration scenarios that need a consolidated, flattened projection of the US mailing address of a student within a given batch process, joined to the batch summary that flags the address as ready for transmission.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects, the published view text defines a two-table equijoin:

• IGS_SV_ADDRESSES (aliased UADD) — the address detail source. Filters restrict to rows where ACTIVITY_SITE_CD IS NULL and ADDRESS_TYPE = 'U', isolating the US address record.
• IGS_SV_BTCH_SUMMARY (aliased ADDRSUMM) — the batch summary that qualifies whether the address should be extracted, constrained by TAG_CODE = 'SV_US_ADDR' and ADM_ACTION_CODE = 'SEND'.

The join is a four-part correlation: PERSON_ID, BATCH_ID, and PARTY_SITE_ID on the address side matched to OWNER_TABLE_IDENTIFIER on the batch summary side. The batch summary therefore acts as a gate, ensuring only addresses selected for the US-address send action are exposed.

Key Columns

The view exposes eight columns, renaming the address attributes to make their US-address context explicit:

• BATCH_ID — identifier of the batch process under which the address was captured; a primary correlating key to the batch summary.
• PERSON_ID — the student (person) identifier to whom the address belongs.
• US_ADDRESS_LINE1 and US_ADDRESS_LINE2 — the first and second street address lines.
• US_CITY, US_STATE, US_POSTAL_CODE — the city, state, and ZIP code components of the US address.
• US_POSTAL_ROUTING_CODE — the postal routing (ZIP+4 style) code completing the delivery point.

The US_ prefixes distinguish these attributes from other address types (for example, foreign or home addresses) stored in the same underlying address table.

Common Use Cases and Queries

The view is typically used where a process or report must retrieve the confirmed US address of newly created Non-Immigrant students for a batch that has been flagged with the SEND administrative action. A representative query retrieving addresses for a specific batch follows:

• Filter by BATCH_ID to scope output to one processing run.
• Filter by PERSON_ID to retrieve a single student's address.
• Select all columns when producing a mailing or interface extract.

Example:

SELECT batch_id, person_id, us_address_line1, us_address_line2, us_city, us_state, us_postal_code, us_postal_routing_code FROM igs_sv_crt_stdt_usaddr_v WHERE batch_id = :p_batch_id ORDER BY person_id;

Because the object is documented as obsolete and not implemented, consultants should verify its presence in the target 12.1.1 or 12.2.2 instance before relying on it, and confirm whether the underlying IGS_SV_ADDRESSES and IGS_SV_BTCH_SUMMARY tables are still populated by the active student processes.