Results for “qualification_recency”

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

Overview

IGS_PS_VER_V is a view within the Oracle E-Business Suite Student System (IGS) product family, which historically provided higher-education functionality for managing courses, programs, students, and academic structures. IGS is documented in the ETRM reference as Obsolete, meaning that the underlying schema components are no longer maintained or supported in current EBS releases, including 12.1.1 and 12.2.2. The view presents version-level course data, exposing the attributes that describe a specific version of a course offering as defined in the course versioning model. Its role in reporting and integration is to provide a flattened, query-friendly projection of the course version entity, allowing downstream reports, extracts, and interfaces to retrieve course version detail without needing to reconstruct joins across the base entities.

For Oracle EBS 12.1.1 and 12.2.2 environments, the view is of interest primarily as a compatibility and migration reference. Implementations that originated on earlier EBS releases or that have custom extensions referencing IGS_PS_VER_V must account for the fact that it is marked obsolete in the current documentation set. The ETRM entry for this view notes that it is "Not implemented in this database," which indicates that the object is not present in the reference environment from which the documentation was generated.

Underlying Base Objects

The documented ETRM metadata records no referenced base objects for IGS_PS_VER_V. The view text, however, references the table alias PV, which corresponds to the course version entity (IGS_PS_VER) in the IGS schema. Each row selected from PV is projected with an explicit ROWID aliased as ROW_ID, alongside the descriptive columns of the course version. Because the view is a simple selection over a single underlying entity, its relationship to the base object is one-to-one: one row in the base table yields one row in the view, with no aggregation or filtering applied in the documented view text.

The absence of documented base objects in ETRM reflects the obsolete status of the object rather than the absence of a physical source. Dependencies for this view are therefore best verified directly against the data dictionary in the target environment using ALL_DEPENDENCIES or ALL_VIEWS.

Key Columns

• COURSE_CD / VERSION_NUMBER — The course code and version number that together uniquely identify a course version.
• START_DT / END_DT / REVIEW_DT / EXPIRY_DT — Lifecycle dates governing when a version is active, under review, or expired.
• COURSE_STATUS — The current status of the course version.
• TITLE / SHORT_TITLE / ABBREVIATION — Descriptive naming attributes for reporting.
• COURSE_TOTAL_EFTSU — The Effective Full-Time Student Unit value, the column the user searched for; it expresses the course load weighting used in student load calculations.
• CONTACT_HOURS / CREDIT_POINTS_REQUIRED / GOVT_COURSE_LOAD / STD_ANNUAL_LOAD / ANNUAL_INSTRUCTION_TIME — Load and instruction measures.
• COURSE_TYPE / RESPONSIBLE_ORG_UNIT_CD / RESPONSIBLE_OU_START_DT — Ownership and classification attributes.
• STD_FT_COMPLETION_TIME / STD_PT_COMPLETION_TIME / MAX_INTRMSN_DURATION / NUM_OF_UNITS_BEFORE_INTRMSN — Duration and interruption rules.
• FINANCIAL_AID flags (STATE_/FEDERAL_/INSTITUTIONAL_FINANCIAL_AID) — Aid eligibility indicators.
• ATTRIBUTE_CATEGORY / ATTRIBUTE… — Descriptive flexfield support columns.

Common Use Cases and Queries

Typical usage centers on reporting course version load and status, particularly the EFTSU figure. A representative query is:

• SELECT course_cd, version_number, title, course_status, course_total_eftsu FROM igs_ps_ver_v WHERE course_status = 'ACTIVE';
• SELECT course_cd, version_number, contact_hours, credit_points_required, course_total_eftsu FROM igs_ps_ver_v WHERE start_dt >= TRUNC(SYSDATE);
• SELECT responsible_org_unit_cd, COUNT(*), SUM(course_total_eftsu) FROM igs_ps_ver_v GROUP BY responsible_org_unit_cd;

These patterns support curriculum load analysis, organizational reporting, and extract files for external student-record systems. Because the object is obsolete and not implemented in the documented 12.1.1/12.2.2 environment, any query must first confirm existence in the target database before being deployed in concurrent programs or interfaces.