Search Results igs_ad_cat_ps_type_pk

Overview

The IGS_AD_CAT_PS_TYPE table is a core validation entity within the Oracle E-Business Suite Student System (IGS). It functions as a cross-reference or mapping table that defines the permissible relationships between admission categories and course types (program types). Its primary role is to enforce business rules during the setup of program offering options, ensuring that an admission category can only be assigned to a program offering if its course type is explicitly authorized in this table. This validation is critical for maintaining data integrity and enforcing consistent admission policies across the institution's academic offerings.

Key Information Stored

The table's structure is intentionally concise, serving as a junction for two key foreign keys. The primary data elements stored are the identifiers for the linked entities. The ADMISSION_CAT column stores the code for a specific admission category, which classifies applicants based on criteria like entry path (e.g., freshman, transfer, graduate). The COURSE_TYPE column stores the code for a specific course or program type (e.g., undergraduate degree, graduate certificate, doctoral program). Together, these two columns form the table's primary key (IGS_AD_CAT_PS_TYPE_PK), meaning each combination of admission category and course type is unique. This design prevents duplicate mappings and ensures precise validation rules.

Common Use Cases and Queries

The primary use case is the validation check performed when configuring or updating a program offering option. Before an admission category can be saved against an offering, the system will query this table to confirm the offering's course type is valid for that category. For reporting and administration, common queries include listing all authorized course types for a given admission category or identifying which admission categories are valid for a specific program type. A typical SQL pattern to retrieve all valid mappings would be:

• SELECT admission_cat, course_type FROM igs.igs_ad_cat_ps_type ORDER BY 1, 2;

To find valid course types for a specific admission category 'FRESHMAN':

• SELECT course_type FROM igs.igs_ad_cat_ps_type WHERE admission_cat = 'FRESHMAN';

Administrators may also use this table to audit or modify the institution's admission policy rules by inserting or deleting rows.

Related Objects

This table is centrally linked to two master tables via foreign key constraints, which enforce referential integrity. The ADMISSION_CAT column references the IGS_AD_CAT_ALL table, which is the master repository for all defined admission categories. The COURSE_TYPE column references the IGS_PS_TYPE_ALL table, the master table for academic program (course) types. These relationships ensure that mappings in IGS_AD_CAT_PS_TYPE can only be created for categories and course types that are already established in the system. The table is a prerequisite for the correct configuration of program offering options, which likely reference admission categories validated against it.