Results for “igs_uc_com_sch”

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

Overview

The IGS_UC_COM_SCH table is a legacy Oracle E-Business Suite data object belonging to the IGS (Student System) product family, a module documented as obsolete within the ETRM reference set. The table stores the master list of all schools known to UCAS (the Universities and Colleges Admissions Service), and it is designed to synchronize with the external UCAS view cvSchool. In this respect the table functions as a staging and reference repository for secondary-school and college data that flows between the institution's student system and the UCAS admissions clearing network.

The ETRM metadata records that the object is not implemented in the current database, meaning it exists as a documentation artifact rather than an active runtime table in a supported 12.1.1 or 12.2.2 environment. Its presence in the metadata is therefore chiefly of interest to upgrade, conversion, and legacy-migration consultants auditing historical IGS customizations. The heuristic Data Vault classification supplied in the metadata is satellite-leaning, indicating that the table primarily holds descriptive attributes of a single business entity (the school), identified by a natural key, rather than acting as a hub or a link. This classification is offered as a modeling suggestion only, derived from the foreign-key structure.

Key Information Stored

The table comprises 24 documented columns. The primary key, IGS_UC_COM_SCH_PK, is defined on the SCHOOL column, which also appears as a unique-business-key candidate via the IGS_UC_COM_SCH_U1 index. The most significant columns include the following.

• SCHOOL — The surrogate/business identifier for each school record; serves as both the primary key and the unique-indexed business key.
• SCHOOL_NAME — The descriptive name of the school as recognized by UCAS.
• NAME_CHANGE_DATE — Effective date of any change to the school's official name.
• FORMER_NAME — A prior or alternative school name retained for historical reconciliation.
• NCN — The National College Number assigned to the institution.
• DFEE_CODE — The Department for Education and Employment code for the establishment.
• COUNTRY — Foreign key to IGS_UC_REF_APR, referencing the country of the school.
• LEA — Local Education Authority code governing the school.
• UCAS_STATUS — The current status of the school within the UCAS dataset.
• ESTAB_GROUP and SCHOOL_TYPE — Classification attributes describing the establishment grouping and type.
• NUMBER_ON_ROLL, NUMBER_IN_5_FORM, NUMBER_IN_6_FORM, NUMBER_TO_HE — Statistical enrolment counts, including the number progressing to higher education.
• DATETIMESTAMP and STATS_DATE — Synchronization and statistics reference dates.
• IMPORTED — Flag indicating whether the record has been imported into the local system.

Common Use Cases and Queries

Because the object is obsolete and not implemented, practical usage is largely confined to migration verification, historical data extraction, and reporting on legacy UCAS feeds. A typical query filters active schools by country and reports enrolment statistics.

A representative SQL pattern might be:

SELECT sch.school, sch.school_name, apr.description, sch.number_on_roll, sch.number_to_he FROM igs_uc_com_sch sch, igs_uc_ref_apr apr WHERE sch.country = apr.code AND sch.imported = 'Y';

Another common scenario validates synchronization completeness by comparing DATETIMESTAMP against the last successful UCAS load, or reconciles former names against current names during a data de-duplication exercise. Reporting uses include producing school-level progression-to-HE metrics keyed on LEA and SCHOOL_TYPE.

Related Objects

The foreign-key relationships documented for this table define its principal dependencies within the IGS schema.

• IGS_UC_REF_APR — Referenced by IGS_UC_COM_SCH.COUNTRY; provides the country lookup for each school.
• IGS_UC_COM_SCHSITES — Child table referencing IGS_UC_COM_SCH via the SCHOOL column, holding site-level details for each school.
• UCAS view cvSchool — The external synchronization source that populates and updates the school list.

Together these objects formed the UCAS school-management sub-model of the obsolete IGS Student System, and any retained customizations should be reviewed against current supported admissions integrations during upgrade planning.