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:
- PROGRESSION_RULE_CAT — the progression rule category that identifies the rule context being overridden.
- PRA_SEQUENCE_NUMBER — sequence number qualifying the progression rule override instance.
- PRO_SEQUENCE_NUMBER — sequence number identifying the specific rule override record.
- UNIT_SET_CD — the unit set code that the student will be failed from, drawn from the enterprise unit set definitions.
- US_VERSION_NUMBER — the version of the referenced unit set, ensuring the correct effective definition is applied.
- ORG_ID — the operating unit that owns the row, enabling multi-org (multi-institution) data security.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns capturing row audit history.
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, andPRO_SEQUENCE_NUMBER; the progression rule override definition. - IGS_EN_UNIT_SET_ALL — referenced via
UNIT_SET_CDandUS_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.
-
This table contains unit sets from which the student will be failed as a result of the related rule being failed.
-
This table contains unit sets from which the student will be failed as a result of the related rule being failed.
Not implemented in this database·Explore IGS module →
-
View: IGS_PR_OU_UNIT_SET 12.1.1
APPS.IGS_PR_OU_UNIT_SET·↳ IGS_PR_OU_UNIT_SET_ALL·Explore IGS module →
-
View: IGS_PR_OU_UNIT_SET 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_PR_RU_OU_ALL 12.2.2
This table describes the outcomes applicable to failure of the related progression rule in the way described by the attributes of the outcome. A given rule may have multiple outcomes for any given failure type if required.
Not implemented in this database·Explore IGS module →
-
Table: IGS_EN_UNIT_SET_ALL 12.2.2
This field describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules which govern its completion via the Rules Sub-system.
Not implemented in this database·Explore IGS module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.