Results for “igs_pr_ou_unit_set_all”

24 results




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

Overview

The IGS_PR_OU_UNIT_SET_ALL table is a transactional definition table within the IGS (Student System) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the association between progression rule overrides and the unit sets from which a student will be failed when the related rule is evaluated as failed. In practical terms, it answers the question: "If this progression rule fails, which unit set (and version) does the student fail?" This is a core configuration element of academic progression and standing logic used by institutions running Oracle Student System.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is a link. The table does not model a business entity with its own descriptive attributes; instead it resolves a many-to-many relationship between progression rule override definitions and unit set definitions. It therefore acts as an associative (junction) table with a composite primary key formed from its foreign key columns.

Key Information Stored

The table contains 11 documented columns. The most significant are:

The surrogate/business identifier is the composite primary key IGS_PR_OU_UNIT_SET_PK, defined over (PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, PRO_SEQUENCE_NUMBER, UNIT_SET_CD, US_VERSION_NUMBER). The unique index IGS_PR_OU_UNIT_SET_ALL_U1 mirrors this same column set, confirming it as the definitive business-key candidate. There is no single surrogate sequence column; the key is entirely natural and composite.

Common Use Cases and Queries

Typical use cases include progression rule configuration validation, impact analysis before changing unit set versions, and reporting on which unit sets are flagged for failure under specific rules.

  • Find all unit sets failed by a given rule override:
    SELECT unit_set_cd, us_version_number
    FROM   igs_pr_ou_unit_set_all
    WHERE  progression_rule_cat  = :cat
    AND    pra_sequence_number   = :pra_seq
    AND    pro_sequence_number   = :pro_seq
    AND    org_id                = :org_id;
  • Confirm the primary key lookup path used by the application when resolving a failed outcome.
  • Audit recently changed configuration using the WHO columns, e.g. filtering on last_update_date.

Related Objects

The foreign key structure identifies the primary parents and children of this table:

  • IGS_PR_RU_OU_ALL — referenced via PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and PRO_SEQUENCE_NUMBER; the progression rule override definition.
  • IGS_EN_UNIT_SET_ALL — referenced via UNIT_SET_CD and US_VERSION_NUMBER; the enterprise unit set definition and version.

Because it is a link table, queries should generally join to both parents to resolve descriptive context (rule names on one side, unit set titles and versions on the other). The ORG_ID column means any reporting query should be scoped by operating unit to respect multi-org security. Combined with the unique index and composite primary key, these relationships define the table's complete documented role in the IGS schema.