Search Results igs_ge_ref_cd_type_all




Overview
Explore in AI Chat

Overview

The IGS_GE_REF_CD_TYPE_ALL table is a core reference data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a master repository for defining and categorizing the various types of reference codes that can be associated with academic offerings. Its primary role is to establish a controlled vocabulary of code types—such as TAC (Tertiary Admissions Centre), CRICOS (Commonwealth Register of Institutions and Courses for Overseas Students), and IVRS—which are then applied to course and unit offerings. This table provides the foundational structure that ensures consistency and validity in how external or institutional reference identifiers are linked to educational products across the system, enabling standardized reporting and regulatory compliance.

Key Information Stored

While the provided ETRM metadata does not list specific column names, the structure and purpose of the table can be inferred. The central piece of information stored is the reference code type itself, which serves as the table's primary key. This is likely stored in a column such as REFERENCE_CD_TYPE. The table would also contain descriptive columns to define each type, such as a meaningful name (e.g., DESCRIPTION) and potentially attributes controlling the code's format, validation rules, or status (e.g., ACTIVE_IND). As an "_ALL" table in the EBS architecture, it also contains the ORG_ID column to support multi-org functionality, allowing different business groups or operating units to maintain their own set of reference code types if required.

Common Use Cases and Queries

This table is primarily used in administrative and reporting contexts related to course and unit management. Common use cases include setting up new reference code types during system implementation, generating lists of valid code types for user interfaces, and auditing which code types are in use. For reporting, it is frequently joined to transactional tables to produce human-readable descriptions for code types. A typical query would retrieve all active reference code types for a specific operating unit:

  • SELECT reference_cd_type, description FROM igs_ge_ref_cd_type_all WHERE org_id = :p_org_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Another common pattern is to join this table to a transactional table like IGS_PS_REF_CD to resolve a code type for a specific course offering:

  • SELECT rct.description, rc.reference_cd FROM igs_ps_ref_cd rc, igs_ge_ref_cd_type_all rct WHERE rc.course_cd = :p_course_cd AND rc.reference_cd_type = rct.reference_cd_type AND rc.org_id = rct.org_id;

Related Objects

The IGS_GE_REF_CD_TYPE_ALL table is a key parent table, referenced by several transactional and historical tables via foreign key relationships. These relationships document where specific reference code type values are applied. The documented foreign keys are: