Search Results igs_ps_degrees_pk

Overview

The IGS_PS_DEGREES table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. It functions as the master repository for all academic degree definitions offered by an educational institution. This table is foundational to the academic program structure, as it formally catalogs each distinct degree—such as Bachelor of Science or Master of Arts—that students can pursue. Its primary role is to establish a standardized reference for degrees across the student lifecycle, enabling accurate program planning, student enrollment tracking, credential awarding, and historical reporting. The table's validity in both EBS 12.1.1 and 12.2.2 confirms its critical and stable role in the application architecture.

Key Information Stored

The table's central attribute is the DEGREE_CD column, which serves as the unique identifier (Primary Key: IGS_PS_DEGREES_PK) for each degree record. This code is the key reference used throughout the system. A critical relational column is PROGRAM_TYPE, which is a foreign key to the IGS_PS_TYPE_ALL table. This link classifies the degree within the institution's broader program type hierarchy (e.g., Undergraduate, Graduate, Certificate). While the provided metadata does not list all columns, typical attributes for such a table would include a descriptive name (DEGREE_NAME), an official title (AWARD_TITLE), an effective date (START_DT), an inactive date (END_DT), and status controls (CLOSED_IND). These elements collectively define the degree's identity and operational status.

Common Use Cases and Queries

This table is central to numerous functional and reporting processes. Administrators use it to maintain the catalog of available degrees. It is queried when setting up new academic programs or student plans of study. Common reporting needs include generating lists of all active degrees, analyzing degree offerings by program type, or validating data for degree conferral. Sample SQL patterns include fetching basic degree information and joining with related tables for enriched reporting.

• Listing Active Degrees: SELECT degree_cd, degree_name FROM igs_ps_degrees WHERE SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE) ORDER BY degree_cd;
• Joining with Program Type: SELECT d.degree_cd, d.degree_name, t.program_type FROM igs_ps_degrees d, igs_ps_type_all t WHERE d.program_type = t.program_type;

Related Objects

The IGS_PS_DEGREES table has defined relationships with several other key entities in the Student System, as indicated by its foreign key constraints. The IGS_PS_TYPE_ALL table is a parent, providing the valid program type for each degree. The IGS_PS_FACLTY_DEGRS table is a child, detailing which faculties or departments are associated with the offering of each degree. Another significant child table is IGS_AD_HZ_ACAD_HIST, where the DEGREE_ATTEMPTED column references IGS_PS_DEGREES to record the degree a student pursued in their academic history. These relationships underscore the table's integral position in linking degree definitions to organizational structures and individual student academic records.