Search Results activity_site_cd




Overview
Explore in AI Chat

Overview

IGS_SV_EV_CRT_USADDR_V is a reporting and integration view in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment. It belongs to the IGS product family, which supports the Student Systems / Student Information (recruiting, admissions, and student records) functionality. The view presents a filtered, denormalized projection of address data, specifically US-format addresses associated with batch and person identifiers. Its name indicates its purpose in the student systems event and address processing path: it exposes addresses used when creating or validating US address records during event-driven processing.

The view serves as a stable read interface between the base address data and downstream reporting or integration activities. It does not introduce new data; instead it isolates rows from the base address table that satisfy two conditions, making it a convenient source for concurrent programs, reports, and interface extracts that must ignore non-US or activity-site-linked addresses.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over a single base object: IGS_SV_ADDRESSES, aliased as UADD. No other referenced base objects are documented for this view. The definitions of the exposed columns are derived from the following columns of IGS_SV_ADDRESSES: BATCH_ID, PERSON_ID, ADDRESS_LINE1, ADDRESS_LINE2, CITY, STATE, POSTAL_CODE, and POSTAL_ROUTING_CODE. The view additionally constrains the source rows using the ACTIVITY_SITE_CD and ADDRESS_TYPE columns of the same table.

Because there is only one base table, the view performs no joins. It is a simple horizontal and vertical projection: horizontal in that it filters rows, and vertical in that it renames selected columns with a US_ prefix for clarity.

Key Columns

  • BATCH_ID — Identifier of the batch with which the address record is associated, used to group records for processing or reconciliation.
  • PERSON_ID — Identifier of the person (student, applicant, or recruit) to whom the address belongs.
  • US_ADDRESS_LINE1 — First line of the US-format address, sourced from ADDRESS_LINE1.
  • US_ADDRESS_LINE2 — Second line of the address, sourced from ADDRESS_LINE2.
  • US_CITY — City name, sourced from CITY.
  • US_STATE — US state code, sourced from STATE.
  • US_POSTAL_CODE — US ZIP code, sourced from POSTAL_CODE.
  • US_POSTAL_ROUTING_CODE — Supplemental postal routing code (e.g., ZIP+4 extension), sourced from POSTAL_ROUTING_CODE.

The filtering columns ACTIVITY_SITE_CD and ADDRESS_TYPE are not projected by the view. The predicate ACTIVITY_SITE_CD IS NULL limits the result set to addresses not tied to an activity site, while ADDRESS_TYPE = 'U' restricts the result to US-format addresses. This is the meaning most relevant to the user search term "activity_site_cd": in this view the column is used only as a filter and does not appear in the output.

Common Use Cases and Queries

Typical uses include extracting US addresses for a batch, validating address completeness for a set of persons, and feeding interface programs that require domestic addresses only.

Example: retrieve all US addresses for a given batch.

SELECT batch_id, person_id, us_address_line1, us_address_line2, us_city, us_state, us_postal_code FROM apps.igs_sv_ev_crt_usaddr_v WHERE batch_id = :p_batch_id;

Example: retrieve the address for a specific person.

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

Because the view already enforces ACTIVITY_SITE_CD IS NULL and ADDRESS_TYPE = 'U', queries against it return only US addresses that are not activity-site-linked, simplifying downstream logic and ensuring consistent filtering across reports and integrations.