Search Results igs_uc_crse_keywrds




Overview
Explore in AI Chat

Overview

The IGS_UC_CRSE_KEYWRDS table is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, specifically in the now-obsolete Student System (IGS) module. Its primary function is to manage the association of descriptive keywords with specific courses during the Universities and Colleges Admissions Service (UCAS) admission cycle in the UK. The table acts as a synchronization point, holding data that aligns with the external UCAS view named 'uvCourseKeyword'. This design facilitates the exchange of course-related keyword information between the institution's internal EBS system and the central UCAS service, which is critical for accurate course cataloging and applicant search functionality. Notably, the provided metadata indicates this table was "Not implemented in this database," suggesting it may have been part of a defined data model that was not deployed in all instances.

Key Information Stored

The table stores the linkage between a course offering and its assigned keywords. Key columns include a unique identifier, CRSE_KEYWORD_ID, which serves as the primary key. The table's structure enforces a unique combination of PREFERENCE, INSTITUTE, UCAS_PROGRAM_CODE, OPTION_CODE, SYSTEM_CODE, and UCAS_CAMPUS through the IGS_UC_CRSE_KEYWRDS_U1 unique key. This composite key, along with the foreign key column KEYWORD, defines the core relationships. The KEYWORD column holds the actual keyword value, which references a controlled list in the IGS_UC_REF_KEYWORDS table. The other columns in the unique key—SYSTEM_CODE, UCAS_PROGRAM_CODE, INSTITUTE, and UCAS_CAMPUS—collectively identify the specific course detail record in the IGS_UC_CRSE_DETS table to which the keyword is attached. The PREFERENCE column likely indicates the ranking or order of importance for multiple keywords associated with a single course.

Common Use Cases and Queries

The primary use case revolves around UCAS integration, specifically extracting or receiving keyword data for course marketing and discovery. A typical operational query would retrieve all keywords for a specific UCAS course code to validate data before synchronization. For reporting, institutions might analyze keyword frequency to understand course portfolio trends. Common SQL patterns include joining to the related course details and reference tables for a complete dataset.

  • Retrieve Keywords for a Course: SELECT k.keyword FROM igs_uc_crse_keywrds k, igs_uc_crse_dets c WHERE k.system_code = c.system_code AND k.ucas_program_code = c.ucas_program_code AND c.internal_program_code = '<value>';
  • Validate Keyword References: SELECT k.* FROM igs_uc_crse_keywrds k WHERE NOT EXISTS (SELECT 'x' FROM igs_uc_ref_keywords r WHERE r.keyword = k.keyword);

Related Objects

The IGS_UC_CRSE_KEYWRDS table has defined foreign key relationships with two core tables in the UCAS data model, as documented in the ETRM metadata.

  • IGS_UC_CRSE_DETS: This table holds the core details of courses within the UCAS cycle. The relationship is established through multiple columns in IGS_UC_CRSE_KEYWRDS (SYSTEM_CODE, UCAS_PROGRAM_CODE, INSTITUTE, UCAS_CAMPUS) referencing corresponding columns in IGS_UC_CRSE_DETS. This ensures every keyword record is tied to a valid course offering.
  • IGS_UC_REF_KEYWORDS: This is a reference (lookup) table containing the master list of valid keyword values. The KEYWORD column in IGS_UC_CRSE_KEYWRDS is a foreign key to this table, enforcing data integrity and consistency in the keywords assigned to courses.