Results for “igs_ps_dscp_hist”

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

Overview

IGS_PS_DSCP_HIST is an Oracle E-Business Suite (EBS) view owned by the APPS schema and delivered as part of the IGS — Student System product family (the Student Records / Academic Structures components of Oracle Student System, formerly Oracle Student System / OSS). The object carries a status of VALID and is exposed in both 12.1.1 and 12.2.2 with identical view text, since the student system data model was not materially reworked between those releases.

The view presents historical, date-tracked records for discipline groups — the coded classifications used to group academic disciplines for funding, government reporting, and fee/statutory categorisation purposes. Its defining characteristic is that it is an org-striped (_ALL base table) view: it filters the underlying history table by the operating unit (ORG_ID) derived from the session context, rather than returning all rows. Functionally, IGS_PS_DSCP_HIST therefore acts as the reporting and integration surface through which discipline group history is queried for a single operating unit, while the base table holds all organisational units in one physical structure.

Underlying Base Objects

The view is defined over a single documented base object, IGS_PS_DSCP_HIST_ALL. The view text selects every column of that table and applies the standard multi-org (MO) security predicate:

• ROW_ID is generated from TAB.ROWID to provide a unique row identifier.
• The WHERE clause compares the row's ORG_ID against the value parsed from USERENV('CLIENT_INFO'), the mechanism Oracle applications use to convey the current operating unit in a multi-org enabled session.
• When CLIENT_INFO is blank, DECODE returns NULL and NVL substitutes -99, so rows with a null or sentinel ORG_ID are returned; otherwise a positive operating unit id is matched exactly.

No other base objects are documented for this view. The companion _ALL table, not the view, is the authoritative repository; the view adds only operating-unit filtering and a ROW_ID projection. Because the view is not a synonym for a table with constraints, no declarative primary key exists on it — ROW_ID is the practical key.

Key Columns

• DISCIPLINE_GROUP_CD — the business key of the discipline group, combined with HIST_START_DT and ORG_ID to identify a historical version.
• HIST_START_DT / HIST_END_DT — the effective date range of the record; HIST_END_DT is typically null or a high date for the current version.
• HIST_WHO — the user or process that made the historical change.
• DESCRIPTION — the descriptive text of the discipline group.
• FUNDING_INDEX_1, FUNDING_INDEX_2, FUNDING_INDEX_3 — funding classification values carried per version.
• GOVT_DISCIPLINE_GROUP_CD — the corresponding government reporting code.
• CLOSED_IND — indicates whether the discipline group is closed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ORG_ID — the operating unit to which the historical row belongs.
• ROW_ID — the physical row identifier.

Common Use Cases and Queries

Typical uses include point-in-time reporting of funding or government discipline classification, audit/inquiry screens showing what changed and when, and integrations that extract historical discipline group data for a specific operating unit. Because the view applies MO security automatically, a session must initialise CLIENT_INFO (via FND_GLOBAL or the standard multi-org initialisation) or the query returns only the -99 org rows.

Sample query — current versions of active discipline groups for the session's operating unit:

SELECT discipline_group_cd, description, govt_discipline_group_cd,
funding_index_1, funding_index_2, funding_index_3,
hist_start_dt, hist_end_dt, org_id
FROM igs_ps_dscp_hist
WHERE NVL(closed_ind,'N') = 'N'
ORDER BY discipline_group_cd, hist_start_dt;

Sample query — full change history for one discipline group:

SELECT discipline_group_cd, hist_start_dt, hist_end_dt, hist_who,
description, last_updated_by, last_update_date
FROM igs_ps_dscp_hist
WHERE discipline_group_cd = :discipline_group_cd
ORDER BY hist_start_dt DESC;

For an organisation-wide, unbounded extraction, query the underlying IGS_PS_DSCP_HIST_ALL table directly rather than the view.