Search Results igs_ps_type_pk

Overview

The IGS_PS_TYPE_ALL table is a core reference entity within the Oracle E-Business Suite Student System (IGS), which is now marked as obsolete. It serves as the master repository for defining and managing an institution's internal classification of academic program types. Its primary role is to establish a controlled vocabulary for categorizing courses or programs (e.g., Undergraduate Degree, Graduate Certificate, Doctoral Program) that is used across the student lifecycle. Crucially, this internal set is broader than the official government (DEET) reporting classifications. The table facilitates mapping between the university's own program types and the standardized government equivalents required for statutory reporting, acting as a critical translation layer between institutional data and external compliance requirements.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships define its core structure. The central column is COURSE_TYPE, which serves as the unique identifier (Primary Key: IGS_PS_TYPE_PK) for each program type record. Other significant columns, inferred from foreign key relationships, include COURSE_TYPE_GROUP_CD, which links a program type to a logical grouping via the IGS_PS_TYPE_GRP table, and GOVT_COURSE_TYPE, which stores the code for the corresponding government (DEET) course type as defined in the IGS_PS_GOVT_TYPE table. This structure allows the table to store the program type code, its descriptive name, its categorization within the university, and its mandated external reporting equivalent.

Common Use Cases and Queries

This table is primarily referenced in configuration, validation, and reporting scenarios. A common administrative use case is setting up or maintaining the valid program types available when creating a new course version (IGS_PS_VER_ALL). For reporting, a typical query would join program details to their internal and government classifications to generate compliance-ready extracts. For instance, to list all active courses with their internal and government types, a query might pattern:

• SELECT pt.course_type, pt.description, gt.govt_course_type, pv.version_number FROM igs_ps_type_all pt JOIN igs_ps_ver_all pv ON pt.course_type = pv.course_type JOIN igs_ps_govt_type gt ON pt.govt_course_type = gt.govt_course_type WHERE pv.status = 'ACTIVE';

It is also heavily used as a validation reference table in processes related to admissions categories, assessment rules, fee triggers, and financial aid packaging, ensuring data integrity across modules.

Related Objects

The IGS_PS_TYPE_ALL table has extensive relationships across the Student System and into Financial Aid, indicating its foundational role. Key documented foreign key relationships include:

• IGS_PS_VER_ALL: Links via COURSE_TYPE to define the type of each course version.
• IGS_PS_TYPE_GRP: Links via COURSE_TYPE_GROUP_CD to categorize program types.
• IGS_PS_GOVT_TYPE: Links via GOVT_COURSE_TYPE for government reporting mapping.
• IGS_AD_CAT_PS_TYPE: References COURSE_TYPE to restrict program types by admissions category.
• IGS_AS_COURSE_TYPE_ALL: References COURSE_TYPE for assessment rules.
• IGF_AP_FA_ANT_DATA & IGF_AW_COA_RATE_DET: Linked via PROGRAM_TYPE for financial aid anticipation and award calculations.
• IGS_PS_UNIT_LVL_ALL: References COURSE_TYPE to define allowable unit levels for a program type.
• IGS_EN_UNITSETPSTYPE: References COURSE_TYPE to control enrollment in unit sets.