Results for “home_address3”

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

Overview

The view IGS_UC_IVGSTARA_2007_V belongs to the IGS (Student System) product family within Oracle E-Business Suite. As indicated by its name and ETRM classification, it is a cycle-specific view created for the UCAS 2007 admissions cycle, exposing applicant address and contact data supplied through the Universities and Colleges Admissions Service (UCAS) interface. The "IVGSTARA" component reflects the UCAS transaction/record type that carries applicant address details, while the "2007" token identifies the specific admissions cycle boundary. ETRM documents this object under the IGS - Student System (Obsolete) product designation, and the metadata explicitly states it is "Not implemented in this database." In Oracle EBS 12.1.1 and 12.2.2 environments, such cycle-stamped views were typically shipped as part of the UCAS inbound interface layer and were rendered obsolete once the corresponding cycle closed and the data was superseded by later cycle objects.

Underlying Base Objects

The ETRM metadata records no documented referenced base objects, but the view text itself provides the definitive dependency: the SELECT statement draws every column from a single source table, IGS_UC_G_IVGSTARA_2007. The "G" in the table name conventionally denotes a staging or inbound ("gateway") table into which UCAS-supplied records were loaded before validation and promotion into the core student/admissions tables. The view functions purely as a projection layer over that staging table, exposing a curated column list without joins, filters, aggregation, or transformation. Consequently, the view is only populated to the extent its underlying _2007 staging table is populated, and it inherits that table's cycle-specific lifecycle.

Key Columns

The view exposes nineteen columns, all passed through unchanged from the staging table:

• APPNO — The UCAS applicant number, the primary business key linking the record to an applicant.
• TIMESTAMP — The load/record timestamp used for change detection and reconciliation of inbound UCAS data.
• ADDRESSAREA, ADDRESS1–ADDRESS4, POSTCODE, MAILSORT — The term-time/contact postal address components, including the mail-sort code used for bulk correspondence.
• TELEPHONE, EMAIL, MOBILE — Contact channel data for the applicant (landline, email address, mobile number).
• HOME_ADDRESS1–HOME_ADDRESS4, HOMEPOSTCODE — The applicant's home/permanent address, kept separate from the term-time address.
• COUNTRYCODE, HOMECOUNTRYCODE — Country identifiers for the correspondence and home addresses respectively, supporting domicile and fee-status determination.

Common Use Cases and Queries

Because this view is cycle-specific and marked obsolete, its practical use in a live 12.1.1/12.2.2 instance is limited to migration, archival, or historical reconciliation work. Typical scenarios include verifying that 2007-cycle UCAS address records were loaded, extracting domicile information for historical fee assessment, or comparing legacy staging data against promoted student records.

A basic retrieval by applicant number:

• SELECT appno, address1, postcode, home_address1, homepostcode, countrycode, homecountrycode FROM igs_uc_ivgstara_2007_v WHERE appno = :applicant_number;

A reconciliation query identifying contactable applicants with a recorded email:

• SELECT appno, email, telephone, mobile FROM igs_uc_ivgstara_2007_v WHERE email IS NOT NULL;

A domicile-oriented extract:

• SELECT appno, homecountrycode, homepostcode FROM igs_uc_ivgstara_2007_v WHERE homecountrycode <> 'GB';

Administrators should confirm the object's existence before use, since ETRM reports it as not implemented in the documented database, and should prefer the current-cycle equivalent views for active UCAS processing.