Search Results igs_ps_ent_pt_ref_cd




Overview
Explore in AI Chat

Overview

The IGS_PS_ENT_PT_REF_CD table is a core data entity within the Oracle E-Business Suite Student System (IGS) module, specifically in releases 12.1.1 and 12.2.2. It serves as a junction table that manages standardized reference codes associated with specific program offering entry points. An entry point defines the precise combination of a program, its version, calendar, location, and attendance details for which a student can apply. This table enables the institution to attach official external or internal identifiers, such as Tertiary Admissions Centre (TAC) codes or Commonwealth Register of Institutions and Courses for Overseas Students (CRICOS) codes, to these defined entry points. Its primary role is to maintain a formal, auditable link between the academic offering structure and the reference codes required for reporting, compliance, and integration with external systems.

Key Information Stored

The table's composite primary key defines the unique combination of attributes required to identify a specific reference code for an entry point. The key consists of the program identifier (COURSE_CD, VERSION_NUMBER), the offering details (CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE), the type of reference code (REFERENCE_CD_TYPE), and a SEQUENCE_NUMBER to allow multiple codes of the same type. Crucially, the table stores the actual REFERENCE_CD value itself. Additional foreign key columns, such as COO_ID (Curriculum Offering Option ID) and UNIT_SET_CD with US_VERSION_NUMBER, provide linkages to more granular offering options and unit sets, extending the code association beyond the base entry point.

Common Use Cases and Queries

A primary use case is generating regulatory reports for government bodies, such as listing all active entry points with their assigned CRICOS codes for international student compliance. System interfaces for admission centers also query this table to validate application submissions against authorized TAC codes. Common SQL patterns involve joining the table to the program offering (IGS_PS_OFR_OPT_ALL) and reference code type (IGS_GE_REF_CD) tables. For example, to retrieve all reference codes for a specific program offering, a query would filter on COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE, then join to IGS_GE_REF_CD to get the description of the REFERENCE_CD_TYPE. Another typical query finds entry points missing a mandatory type of reference code by using an outer join and checking for NULL values in REFERENCE_CD.

Related Objects

The table maintains integral relationships with several other key entities in the Student System, as documented by its foreign key constraints:

  • IGS_PS_OFR_OPT_ALL: The fundamental relationship. The entry point attributes (COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE) and the COO_ID column reference this table, which defines the program offering option.
  • IGS_EN_UNIT_SET_ALL: The UNIT_SET_CD and US_VERSION_NUMBER columns reference this table, allowing reference codes to be associated with specific unit sets (majors, minors) within an offering.
  • IGS_GE_REF_CD: The REFERENCE_CD_TYPE and REFERENCE_CD columns reference this generic reference codes table, ensuring code values are validated against a controlled list of valid types and codes.