Results for “org_unit_wlst_id”
27 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_EN_ORUN_WLST_PRI is a transactional configuration table within the IGS (Student System) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the priority rules by which students are ranked on an organization unit waitlist for a given unit attempt. Each row associates a waitlist definition (at the organization unit level) with a priority number and a priority value, producing the ordered ranking logic applied when the system determines which waitlisted student is offered a seat next. The highest priority rule is evaluated first.
The table resides in the IGS schema and is documented as VALID. From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning: it carries descriptive priority attributes that hang off a parent waitlist entity (IGS_EN_OR_UNIT_WLST_ALL) and is itself referenced by a profile/detail table (IGS_EN_ORUN_WLST_PRF). This classification is heuristic and intended as a modeling suggestion rather than a mandated design.
Key Information Stored
The documented physical schema for Release 12.1.1 contains nine columns. The most significant are:
- ORG_UNIT_WLST_PRI_ID — the surrogate primary key, enforced by IGS_EN_ORUN_WLST_PRI_PK and also carried by the unique index IGS_EN_ORUN_WLST_PRI_U1. In this schema the surrogate key and the documented business-key candidate coincide.
- ORG_UNIT_WLST_ID — the foreign key to IGS_EN_OR_UNIT_WLST_ALL, anchoring the priority rule to a specific organization unit waitlist definition.
- PRIORITY_NUMBER — the ordinal position of the rule, establishing the evaluation sequence (highest priority applied first).
- PRIORITY_VALUE — the value or criterion against which student ranking is compared for the corresponding priority number.
- CREATED_BY, CREATION_DATE — standard WHO audit columns recording the creating user and timestamp.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the most recent modification user, timestamp, and login session.
Together, ORG_UNIT_WLST_ID, PRIORITY_NUMBER, and PRIORITY_VALUE constitute the operative business content: the parent context, the ranking order, and the ranking criterion.
Common Use Cases and Queries
Typical use cases include auditing waitlist ranking configuration, reproducing the order in which students were promoted from a waitlist, and validating that priority numbers are unique and contiguous within each waitlist. A representative query retrieves the ordered rules for a waitlist:
- SELECT p.org_unit_wlst_pri_id, p.priority_number, p.priority_value FROM igs.igs_en_orun_wlst_pri p WHERE p.org_unit_wlst_id = :waitlist_id ORDER BY p.priority_number;
- Join to the parent waitlist table to report rules by organization unit: SELECT w.org_unit_wlst_id, p.priority_number, p.priority_value FROM igs.igs_en_orun_wlst_pri p, igs.igs_en_or_unit_wlst_all w WHERE p.org_unit_wlst_id = w.org_unit_wlst_id ORDER BY w.org_unit_wlst_id, p.priority_number;
- Detect duplicate or missing priority numbers per waitlist using GROUP BY ORG_UNIT_WLST_ID, PRIORITY_NUMBER with a HAVING COUNT(*) > 1 filter.
Reporting extensions commonly join to IGS_EN_ORUN_WLST_PRF to expose the profile attributes governed by each priority rule.
Related Objects
The documented relationships center on two IGS tables:
- IGS_EN_OR_UNIT_WLST_ALL — parent waitlist definition; joined via ORG_UNIT_WLST_PRI.ORG_UNIT_WLST_ID = IGS_EN_OR_UNIT_WLST_ALL.ORG_UNIT_WLST_ID.
- IGS_EN_ORUN_WLST_PRF — referencing table; joined via IGS_EN_ORUN_WLST_PRF.ORG_UNIT_WLST_PRI_ID = IGS_EN_ORUN_WLST_PRI.ORG_UNIT_WLST_PRI_ID.
Surrounding IGS Student System objects — organization unit waitlist and unit attempt entities — supply the broader context in which these priority rules are consumed during waitlist processing. Access to the table is ordinarily governed through the IGS schema and its associated application responsibilities.
-
This entity describes the organization unit waitlist priority based on which the students are ranked for the unit attempt. The highest priority is applied first.
-
This entity describes the fields required to set organization unit waitlist.
-
View incorporating wait list priorities that have to be considered in allotting a unit to waitlisted students.
APPS.IGS_EN_OR_UNIT_WLST_PRI_V·↳ IGS_EN_ORUN_WLST_PRI·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View: IGS_EN_OR_UNIT_WLST_V 12.1.1
This view incorporates the unit wait list priorities and unit wait list preferences.
APPS.IGS_EN_OR_UNIT_WLST_V·↳ HZ_PARTIES·↳ IGS_CA_TYPE·↳ IGS_EN_OR_UNIT_WLST·Explore IGS module →
-
View: IGS_EN_OR_UNIT_WLST 12.1.1
This view describes the various organization unit wait list options.
APPS.IGS_EN_OR_UNIT_WLST·↳ IGS_EN_OR_UNIT_WLST_ALL·Explore IGS module →
-
View incorporating wait list priorities that have to be considered in allotting a unit to waitlisted students.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_OR_UNIT_WLST 12.2.2
This view describes the various organization unit wait list options.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_OR_UNIT_WLST_V 12.2.2
This view incorporates the unit wait list priorities and unit wait list preferences.
Not implemented in this database·Explore IGS module →
-
This entity describes the fields required to set organization unit waitlist.
Not implemented in this database·Explore IGS module →
-
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'.