Results for “hist_start_dt”

50+ results




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

Overview

IGS_PS_UNT_DSCP_HIST_V is a valid APPS-owned database view within the IGS (Student System) product family of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Its documented purpose is to merge unit discipline history records with the current unit discipline details, allowing the full set of attribute values to be queried across time up to the present day. Each row returned represents a complete set of column values valid over a defined time period.

In institutional terms, a "unit" is a course or module within the student system, and "discipline" refers to the academic discipline grouping to which a unit's teaching or funding is attributed. The percentage column records how much of a unit is apportioned to a given discipline group. Because this apportionment can change over time, the Student System maintains history rows rather than only the current value. This view is therefore the reporting and integration access point that presents a continuous, time-sliced picture of discipline apportionment without requiring callers to reconcile history and current tables themselves.

The view is read-only and is intended for enquiry, reporting, and downstream integration rather than for maintenance. It exposes standard Oracle EBS audit columns alongside the functional attributes.

Underlying Base Objects

The view text is defined over three documented sources:

  • IGS_PS_UNT_DSCP_HIST (aliased UDH1/UDH2) — the historical unit discipline apportionment records, holding effective-dated percentage changes.
  • IGS_PS_UNIT_DSCP (aliased UD1/UD2) — the current unit discipline details, holding the values in force today.
  • IGS_PS_UNIT_VER (aliased UV) — the unit version header, used to validate and constrain the unit and version combination in the historical branch.

Although the ETRM metadata lists no referenced base objects explicitly, the view definition itself confirms these three tables. The structure is a UNION ALL of two branches. The first branch joins history to current and to the unit version, using an outer join on the current table so that history rows continue to appear even when no matching current detail exists; the percentage is resolved as the historical value, falling back to a custom hook function, and then to the current value. The second branch selects from the current table alone, again outer-joined to history, and uses MAX(HIST_END_DT) aggregated by unit, version, discipline group and audit attributes to synthesise an open-ended "today" entry with a null end date.

Key Columns

  • UNIT_CD — the code identifying the unit (course). Part of the composite key.
  • VERSION_NUMBER — the unit version, allowing different versions of a unit to be maintained independently.
  • DISCIPLINE_GROUP_CD — the discipline group to which the unit is attributed for this record.
  • HIST_START_DT — the date from which this set of values is effective.
  • HIST_END_DT — the date on which this set of values ceases to be effective; null for the current, open-ended entry.
  • HIST_WHO — the user or process that made the historical change.
  • PERCENTAGE — the proportion of the unit attributed to the discipline group, resolved through the documented fallback chain.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle audit columns describing who created and last modified the row.

Common Use Cases and Queries

Typical uses include reporting the discipline split of a unit at a point in time, reconciling historical changes to discipline apportionment, and extracting a time-sliced feed for data warehousing or regulatory reporting. Because the view can return multiple rows per unit, version and discipline group, queries should always filter by date range and aggregate or order appropriately.

Current discipline apportionment for a unit:

  • SELECT unit_cd, version_number, discipline_group_cd, percentage FROM igs_ps_unt_dscp_hist_v WHERE unit_cd = :unit_cd AND hist_end_dt IS NULL;

Discipline apportionment as at a given date:

  • SELECT unit_cd, version_number, discipline_group_cd, percentage FROM igs_ps_unt_dscp_hist_v WHERE unit_cd = :unit_cd AND :as_of_date BETWEEN hist_start_dt AND NVL(hist_end_dt, :as_of_date);

Full audit trail of all changes for a unit and discipline group:

  • SELECT unit_cd, version_number, discipline_group_cd, hist_start_dt, hist_end_dt, hist_who, percentage FROM igs_ps_unt_dscp_hist_v WHERE unit_cd = :unit_cd AND discipline_group_cd = :discipline_group_cd ORDER BY hist_start_dt;

As with all APPS views in the Student System, queries should observe the standard multi-org and security context of the calling responsibility, and results should be treated as read-only reference data.