Search Results igs_ps_dscp




Overview
Explore in AI Chat

Overview

IGS_PS_DSCP is a reporting view within the Oracle E-Business Suite IGS – Student System product family. The IGS module, now designated as obsolete in the ETRM documentation set, provided the underlying data model for academic and student administration, including program structures, discipline classifications, and funding groupings used by higher-education and government training institutions. The view IGS_PS_DSCP exposes discipline group definitions and their associated funding indices in a multi-tenant (multi-organization) aware format.

Functionally, the view acts as the organization-filtered projection of the IGS_PS_DSCP_ALL table. Its purpose is to present only those discipline group records that belong to the operating unit derived from the current session's client information, thereby insulating downstream reports, concurrent programs, and form-based queries from cross-organization data. This pattern — a secured (non-_ALL) view over an _ALL base table — is the standard Oracle Applications multi-org strategy and is applied consistently across the IGS schema.

Underlying Base Objects

The ETRM metadata records no additional referenced base objects; the view is defined solely over the table IGS_PS_DSCP_ALL, as confirmed by the view text:

  • IGS_PS_DSCP_ALL — the organization-partitioned base table holding discipline group and funding index records.
  • Row identity is established through TAB.ROWID AS ROW_ID, allowing the view to be used in updateable block contexts where Oracle Forms requires a physical row identifier.
  • Org filtering is performed with a decoded USERENV('CLIENT_INFO') expression, comparing the first ten bytes of the client information string against ORG_ID. A fallback value of -99 is used when the client information is empty, ensuring a deterministic (if non-matching) predicate.

The join condition is expressed without a conventional WHERE clause on a table alias chain; the NVL-wrapped equality effectively restricts rows to the current operating unit or to the sentinel value -99.

Key Columns

  • ROW_ID — the physical ROWID of the underlying IGS_PS_DSCP_ALL row; used for DML anchoring in Forms.
  • DISCIPLINE_GROUP_CD — the primary business key; identifies a discipline group classification.
  • DESCRIPTION — the human-readable name of the discipline group.
  • FUNDING_INDEX_1, FUNDING_INDEX_2, FUNDING_INDEX_3 — funding classification codes mapped to the discipline group, typically used for grant, subsidy, or cost-recovery reporting.
  • GOVT_DISCIPLINE_GROUP_CD — the corresponding government-defined discipline code, used for regulatory submissions.
  • CLOSED_IND — indicates whether the discipline group is retired and should be excluded from active reporting.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle Applications audit columns.
  • ORG_ID — the operating unit identifier used by the multi-org predicate.

Common Use Cases and Queries

Because the view is organization-secured, queries run from within an operating-unit context return only the relevant discipline groups. A typical listing query is:

  • SELECT discipline_group_cd, description, govt_discipline_group_cd FROM igs_ps_dscp WHERE closed_ind = 'N' ORDER BY discipline_group_cd; — enumerates active discipline groups for the current organization.
  • SELECT funding_index_1, COUNT(*) FROM igs_ps_dscp GROUP BY funding_index_1; — aggregates discipline groups by primary funding index for cost-analysis reporting.
  • Join the view to student program or enrollment tables on DISCIPLINE_GROUP_CD to enrich funding and reporting extracts.

Note that in the documented database (ETRM 12.2.2) this view is marked Not implemented; it should be treated as legacy metadata for historical or upgrade reference rather than as an actively supported object in current releases.