Search Results igs_ps_course

Overview

The IGS_PS_COURSE table is a core master data table within the Oracle E-Business Suite Student System (IGS). It serves as the definitive repository for all programs offered by an educational institution. As indicated by its description, it comprehensively covers both award programs (e.g., degrees, diplomas, certificates) and non-award programs (e.g., short courses, professional development). This table is foundational to the academic structure, acting as the parent entity for program versions (IGS_PS_VER) and being referenced extensively across the student lifecycle—from admissions and enrollment to financial aid and program completion. Its primary key, COURSE_CD, is a unique identifier that propagates throughout the application to maintain data integrity.

Key Information Stored

While the provided metadata does not list specific columns, the table's role and foreign key relationships imply it stores critical attributes defining an academic program. The central column is COURSE_CD, the unique program code. Other typical columns would include the program's official title, a descriptive name, its academic level (e.g., undergraduate, graduate), an award type, an operational status (active, inactive), and administrative control fields like creation date and who created it. The table essentially holds the static, high-level definition of a program, distinct from its time-bound versions which manage details like effective dates, fees, and admission rules.

Common Use Cases and Queries

This table is central to numerous operational and reporting functions. Common use cases include maintaining the institution's program catalog, configuring admission requirements, setting up fee structures, and processing financial aid awards based on program of study. For reporting, it is frequently joined to child tables to analyze program enrollment, completion rates, and applicant demographics. A fundamental query pattern involves joining IGS_PS_COURSE with IGS_PS_VER_ALL to get a complete program definition.

• Listing Active Programs: SELECT course_cd, title FROM igs_ps_course WHERE status = 'ACTIVE';
• Program Details with Current Version: SELECT c.course_cd, c.title, v.version_name, v.start_dt FROM igs_ps_course c, igs_ps_ver_all v WHERE c.course_cd = v.course_cd AND v.version_status = 'ACTIVE';
• Admissions Reporting: Queries often join IGS_PS_COURSE with IGS_AD_PS_APPL_ALL to report on applications by nominated program.

Related Objects

The extensive foreign key relationships documented highlight IGS_PS_COURSE's integration across modules. Key related objects include:

• IGS_PS_VER_ALL: The most direct child table, storing historical and current versions of each program.
• Admissions Tables (IGS_AD_PS_APPL_ALL, IGS_AD_PS_APPL_INST_ALL): Reference the program for which a student has applied.
• Financial Aid Tables (IGF_AP_FA_ANT_DATA, IGF_AW_COA_RATE_DET): Link financial aid packages and cost-of-attendance rates to a specific program.
• Financials Tables (IGS_FI_FEE_AS_ALL, IGS_PS_FEE_TRG): Associate fee assessments and triggers with a program code.
• Disability Accommodations (IGS_DA_REQ_WIF, IGS_DA_REQ_STDNTS): Use the program code within the Disability Accommodations module.
• Progression Rules (IGS_PR_STDNT_PR_PS): Tracks a student's progression within a specific program.