Results for “igs_uc_com_schsites”

23 results




Overview
Explore in AI Chat

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

Overview

IGS_UC_COM_SCHSITES is a legacy table within the Oracle E-Business Suite IGS (Student System) product family, now classified as Obsolete. It stores the master list of school sites associated with the UCAS (Universities and Colleges Admissions Service) integration, and is designed to synchronize with the UCAS external view known as cvSchool. In the context of EBS 12.1.1 and 12.2.2, this object represents an inbound staging and reference table used during the transfer of UCAS school and site data into the institution's student system database.

The table is owned by the IGS schema and carries eighteen documented columns. Its primary key, IGS_UC_COM_SCHSITES_PK, is a composite of SCHOOL and SITECODE, and the unique index IGS_UC_COM_SCHSITES_U1 mirrors these same columns. Under the heuristic Data Vault classification mined from the foreign key structure, this object is described as satellite-leaning. This suggests it is best modeled as a descriptive satellite attached to a parent hub (IGS_UC_COM_SCH), holding attribute detail keyed by the natural business identifiers SCHOOL and SITECODE rather than acting as an independent hub or a pure link table.

Note that the ETRM metadata explicitly states this object is "Not implemented in this database," indicating that in the evaluated 12.1.1 installation the table was absent from the physical schema despite its documentation. This is consistent with its obsolete status and with the phased retirement of UCAS-related IGS components.

Key Information Stored

The most significant columns fall into three groups: identifiers, address detail, and audit/control fields.

  • SCHOOL — Part of the composite primary key; identifies the parent school record, joining to IGS_UC_COM_SCH.
  • SITECODE — The second component of the composite primary key; distinguishes individual sites within a school.
  • DATETIMESTAMP — Capture timestamp associated with the UCAS synchronization event.
  • ADDRESS1 through ADDRESS4 — Structured address lines for the site location.
  • POSTCODE — Postal code for geographic and mailing purposes.
  • MAILSORT — Mail sorting code used for bulk correspondence routing.
  • TOWN_KEY and COUNTY_KEY — Foreign-key-style references to town and county reference data.
  • COUNTRY_CODE — Country identifier for the site address.
  • IMPORTED — Flag indicating whether the record was loaded through the UCAS import process.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking record provenance and modification history.

The surrogate identity of the row is effectively expressed through the composite business key (SCHOOL, SITECODE), enforced by IGS_UC_COM_SCHSITES_PK and reinforced by the unique index IGS_UC_COM_SCHSITES_U1. No single-column surrogate identifier is documented.

Common Use Cases and Queries

Typical usage centers on UCAS data reconciliation, admissions reporting, and reference data validation. A frequent query retrieves all sites for a given school:

  • SELECT school, sitecode, address1, postcode FROM igs_uc_com_schsites WHERE school = :school_id;
  • Reporting on unimported records: SELECT * FROM igs_uc_com_schsites WHERE imported = 'N';
  • Audit tracking via last_update_date and last_updated_by to monitor recent synchronization activity.
  • Joining to IGS_UC_COM_SCH to resolve parent school names for admissions correspondence.

Because the table synchronizes with the UCAS cvSchool view, it is commonly used as a staging point before data is promoted into operational student records.

Related Objects

  • IGS_UC_COM_SCH — Parent school table; joined via IGS_UC_COM_SCHSITES.SCHOOL.
  • IGS_UC_COM_SCSICNTS — References this table on (SCHOOL, SITECODE); holds related site content records.
  • UCAS view cvSchool — External synchronization source for this table.
  • IGS_UC_COM_SCHSITES_PK / _U1 — Primary key and unique index enforcing the (SCHOOL, SITECODE) business key.

Together these objects form the UCAS school-site integration cluster within the obsolete IGS Student System module.