Results for “igs_ps_unt_inlv_hist”

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

Overview

IGS_PS_UNT_INLV_HIST is an Oracle E-Business Suite (EBS) view owned by the APPS schema and registered under the IGS – Student System product family. It is validated and available in both EBS 12.1.1 and 12.2.2. The view exposes historical, date-effective records for the "unit intra-course level" entity, which describes the intermediate level of study assigned to a teaching unit within a course (for example, intermediate, advanced, or honours placement of a unit). Unlike its transactional counterpart, this object is read-only and preserves prior versions of the base record across its history, making it the authoritative source for point-in-time reporting of unit intra-course level definitions.

Within the ETRM 12.2.2 metadata, the view is documented as a reporting and integration access layer rather than an editing surface. Because it applies Multi-Org (operating unit) security logic at runtime, consumers automatically see only the records associated with the operating unit in their current session context. This makes it suitable for concurrent programs, OBIEE/BI Publisher extracts, and interfaces that must respect ORG_ID partitioning without hard-coding organization filters.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for this view; however, the published view text shows it is defined exclusively over a single base table:

• IGS_PS_UNT_INLV_HIST_ALL — the _ALL history table holding all operating-unit rows, aliased as TAB.

The view selects every column of the _ALL table plus its ROWID (aliased ROW_ID) and appends a WHERE clause that restricts rows to the caller's operating unit. The predicate compares a padded substring of USERENV('CLIENT_INFO') against ORG_ID, substituting a default of -99 when no client information is present. Because it is a simple projection with a security filter and no joins, it carries no additional objects and inherits the underlying table's indexes and statistics.

Key Columns

• ROW_ID — the physical ROWID of the underlying history row; useful for row-level correlation and de-duplication.
• UNIT_INT_COURSE_LEVEL_CD — the code identifying the intra-course level applied to the unit.
• HIST_START_DT / HIST_END_DT — the effective start and end dates delimiting the validity period of this historical version.
• HIST_WHO — the user or process associated with the historical change.
• DESCRIPTION — free-text description of the level.
• WEFTSU_FACTOR — the weighting factor applied toward the Weighted Equivalent Full-Time Student Unit (WEFTSU) computation.
• CLOSED_IND — indicates whether the level is closed for new usage.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO-column audit attributes.
• ORG_ID — the operating unit to which the record belongs; drives Multi-Org security.

Common Use Cases and Queries

The view is typically used for auditing changes, reconstructing the state of a unit's intra-course level as of a past date, and extracting weighted-factor data for load reporting.

• Audit of historical changes to a unit's course level, ordered by effective date.
• As-of-date reporting: filtering HIST_START_DT <= :as_of AND (HIST_END_DT IS NULL OR HIST_END_DT >= :as_of).
• Extraction of WEFTSU_FACTOR values for statistical and funding returns.

Sample query:

SELECT unit_int_course_level_cd, hist_start_dt, hist_end_dt, weftsu_factor, closed_ind
FROM apps.igs_ps_unt_inlv_hist
WHERE TRUNC(SYSDATE) BETWEEN hist_start_dt AND NVL(hist_end_dt, TRUNC(SYSDATE))
ORDER BY unit_int_course_level_cd, hist_start_dt;