Results for “igs_pr_ou_type”

50+ results




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

Overview

IGS_PR_OU_TYPE is a reporting view in the Oracle E-Business Suite IGS – Student System product family, sometimes labeled Obsolete in later ETRM documentation. The view exposes progression outcome type definitions as they pertain to an operating unit (OU), providing a security-filtered, organization-scoped projection of the underlying progression outcome configuration. In Oracle EBS 12.1.1 and 12.2.2, the view is not implemented in every database; the ETRM metadata states explicitly, "Not implemented in this database," indicating that it exists only where the Student System product (IGS) has been licensed and installed.

Its principal role is to present progression outcome types with operating-unit isolation, so that reports, concurrent programs, and integrations retrieve only the rows relevant to the caller's current operating unit context. Because the view embeds OU filtering directly in its WHERE clause, it eliminates the need for callers to replicate that logic.

Underlying Base Objects

The view is defined over a single documented base object: IGS_PR_OU_TYPE_ALL, an "_ALL" table that stores progression outcome type rows across all operating units. The view joins no additional tables; the ETRM "Documented view metadata" lists no referenced base objects beyond this source and records none as separately documented. The SELECT list maps each base-table column to a view column, and the WHERE clause performs OU restriction using the standard multi-org pattern: it reads the ten-character operating unit from USERENV('CLIENT_INFO'), converts it to a number, and compares it against TAB.ORG_ID. When no ORG_ID is present, the expression defaults to -99, and rows with NULL ORG_ID are matched via the nested NVL logic. This is the classic Oracle EBS "org_id-secured view" design.

Key Columns

  • ROW_ID – the base table ROWID, used for direct row addressing.
  • PROGRESSION_OUTCOME_TYPE – the primary identifier of the progression outcome type.
  • S_PROGRESSION_OUTCOME_TYPE – the short code or secondary identifier for the outcome type.
  • DESCRIPTION – the descriptive name of the outcome type.
  • ENCUMBRANCE_TYPE – the encumbrance classification associated with the outcome.
  • DFLT_RESTRICTED_ENROLMENT_CP – default restricted enrolment credit points. This is the field most closely associated with the search term "dflt_restricted_att_type," which is a sibling column.
  • DFLT_RESTRICTED_ATT_TYPE – the default restricted attendance type. This is the column matched by the user's search term "dflt_restricted_att_type," and it controls the default attendance restriction applied to a progression outcome.
  • POSITIVE_OUTCOME_IND – indicates whether the outcome is considered positive (Y/N).
  • CLOSED_IND – indicates whether the outcome type is closed to further use.
  • COMMENTS – free-text remarks on the outcome type.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard EBS audit columns.
  • ORG_ID – the operating unit that owns the row.

Common Use Cases and Queries

The view is typically queried to retrieve the default restricted attendance type alongside related defaults for a given progression outcome, respecting operating-unit security. A basic query might select the outcome identifier, description, and the two default restriction columns:

SELECT progression_outcome_type, description, dflt_restricted_att_type, dflt_restricted_enrolment_cp FROM igs_pr_ou_type WHERE closed_ind = 'N';

Because the view applies OU filtering automatically, callers running within an initialized multi-org session receive only their operating unit's rows; no additional ORG_ID predicate is required. Where a broader cross-OU dataset is needed, the base table IGS_PR_OU_TYPE_ALL should be queried directly instead. Typical consumers include progression and attendance setup reports, validation lookups during student progression entry, and integrations that need to resolve the default restricted attendance type for automated enrolment processing.