Results for “igs_ps_course”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_COURSE is a core reference table within the Oracle EBS Student System (IGS) product family. It represents the academic programs — both award-bearing (such as degrees, diplomas, and certificates) and non-award programs — that a higher-education institution offers. In the IGS functional model, this table acts as the master catalogue of programs against which applications, admissions, enrollments, fee assessments, progression rules, and graduation records are aligned.

It is important to note that the ETRM metadata marks IGS - Student System as Obsolete, and this specific table is flagged as "Not implemented in this database" in the documented 12.1.1 environment. The Student System was a legacy Oracle product line largely superseded by the Oracle Student Cloud and external student information systems; therefore, IGS_PS_COURSE is most commonly encountered in historical schemas, upgrade assessments, or data-migration efforts rather than in active 12.2.2 deployments. However, the documentation remains relevant for institutions maintaining or archiving IGS data.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as hub-leaning. This is a modeling suggestion only: the table behaves as a business hub keyed on a stable business identifier (COURSE_CD), with no attempt in the documented schema to model descriptive attributes as satellites. Given the documented six columns, no meaningful satellite content exists in the exposed layer.

Key Information Stored

The documented physical schema at 12.1.1 contains only six columns, and the primary key is IGS_PS_COURSE_PK, defined on COURSE_CD. Notable columns include:

• COURSE_CD — The program code. This is the single documented business key and is also the column referenced by every downstream foreign key. It is both the primary key column and the sole unique-index candidate (IGS_PS_COURSE_U1).
• CREATED_BY — Standard EBS WHO column recording the user who inserted the row.
• CREATION_DATE — Standard EBS WHO column recording the insertion timestamp.
• LAST_UPDATED_BY — Standard EBS WHO column recording the last modifying user.
• LAST_UPDATE_DATE — Standard EBS WHO column recording the last modification timestamp.
• LAST_UPDATE_LOGIN — Standard EBS WHO column capturing the login session of the last modification.

Because the data model in the ETRM excerpt exposes only COURSE_CD and the WHO audit columns, descriptive attributes such as program title, award type, or effective dates are not present at this layer. The surrogate-versus-business-key distinction is effectively collapsed: COURSE_CD serves simultaneously as the primary key and the business identifier.

Common Use Cases and Queries

Typical usage centers on validating, joining, and reporting program references.

• Validating that applications reference valid programs: SELECT c.course_cd FROM igs_ps_course c JOIN igs_ad_ps_appl_all a ON a.nominated_course_cd = c.course_cd;
• Fee trigger analysis joining IGS_PS_FEE_TRG on COURSE_CD to confirm which programs incur assessments.
• Version and progression reporting via IGS_PS_VER_ALL.COURSE_CD to trace program versions.
• Graduation and awards analysis via IGF_AW_COA_RATE_DET.PROGRAM_CD and IGF_AP_FA_ANT_DATA.PROGRAM_CD.
• Admissions configuration review through IGS_DA_CNFG_REQ_TYP.WIF_PROGRAM_CODE and IGS_DA_REQ_WIF.PROGRAM_CODE.

Related Objects

Numerous child tables reference COURSE_CD (or an equivalently named program code column) as a foreign key to IGS_PS_COURSE. The most significant include:

• IGS_AD_PS_APPL_INST_ALL — join on COURSE_CD; application instance details.
• IGS_AD_PS_APPL_ALL — join on NOMINATED_COURSE_CD; applicant program nominations.
• IGS_PS_VER_ALL — join on COURSE_CD; program version records.
• IGS_PS_FEE_TRG — join on COURSE_CD; fee trigger definitions.
• IGS_FI_FEE_AS_ALL — join on COURSE_CD; fee assessments.
• IGF_AW_COA_RATE_DET — join on PROGRAM_CD; awards rate detail.
• IGS_PR_STDNT_PR_PS — join on COURSE_CD; student program progression.
• IGS_PE_COURSE_EXCL — join on COURSE_CD; program exclusions.