Search Results igs_ps_degrees_u1

Overview

The IGS_PS_DEGREES table is a core reference data table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (formerly Oracle Campus Solutions) module. Owned by the IGS schema, its primary function is to serve as the master repository for all academic degrees offered by an educational institution. It defines the valid degree codes and their descriptions that can be assigned to academic programs, plans, and student records, ensuring data integrity and standardization across the student lifecycle. Its role is foundational, as the DEGREE_CD acts as a key foreign key in numerous transactional and setup tables throughout the system.

Key Information Stored

The table stores essential attributes for each degree definition. The most critical column is DEGREE_CD (VARCHAR2(10)), which serves as the unique identifier and primary key for a degree, enforced by the unique index IGS_PS_DEGREES_U1. The DESCRIPTION (VARCHAR2(80)) column holds the institution-defined name for the degree. The CLOSED_IND flag controls the active status of a degree record, preventing its selection in new configurations when set. The PROGRAM_TYPE (VARCHAR2(10)) associates the degree with a broader academic program classification. Standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit trails for all changes.

Common Use Cases and Queries

This table is central to setup, reporting, and data validation. Common use cases include populating list of values (LOVs) during the configuration of academic offerings, validating degree codes during student program enrollment, and generating institutional degree catalogs. A fundamental query to retrieve all active degrees is:

• SELECT DEGREE_CD, DESCRIPTION, PROGRAM_TYPE FROM IGS.IGS_PS_DEGREES WHERE CLOSED_IND = 'N' ORDER BY DEGREE_CD;

For integration or data migration purposes, a full extract following the documented structure is typical:

• SELECT DEGREE_CD, DESCRIPTION, CLOSED_IND, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_TYPE FROM IGS.IGS_PS_DEGREES;

Reporting often involves joining this table to student program or course catalog tables to translate degree codes into meaningful descriptions.

Related Objects

As a reference table, IGS_PS_DEGREES is primarily a referenced object rather than one that references others. The provided dependency information confirms that IGS_PS_DEGREES does not reference other database objects but is itself referenced by the APPS synonym of the same name (IGS_PS_DEGREES). This synonym allows other modules and applications within the EBS instance to access the table seamlessly. In practice, transactional tables storing student academic records, such as those related to program enrollments, plans, and conferred awards, will likely contain a foreign key to the DEGREE_CD column in this table to maintain referential integrity.