Search Results igs_ss_su_selection_pk

Overview

IGS_SS_SU_SELECTION_ALL is a core transactional table in the Oracle EBS Student System (IGS) product family. It stores Student Unit Selections — the record of a student's enrollment or attempt against a specific unit offering within an academic period. In the Oracle EBS 12.1.1 and 12.2.2 data models, this table is the operational backbone that links a person (student) to an academic unit offering, capturing enrollment date, class grouping, grading schema, and attempt status. Downstream processes such as assessment, progression, and graduation depend on records held here.

The table is owned by the IGS schema and is documented as VALID in ETRM. It carries 21 physical columns. Consistent with Oracle EBS multi-org design, it includes ORG_ID, which scopes records to an operating unit where applicable. Heuristic Data Vault classification mined from the foreign-key structure identifies this object as standalone; a modeling suggestion would therefore treat it as an independent satellite or transactional fact rather than a pure link table, though its business meaning (student to unit association) is inherently associative in nature.

Key Information Stored

The documented metadata identifies two key definitions: the surrogate primary key constraint IGS_SS_SU_SELECTION_PK on USEC_SU_SELECTION_ID, and a unique constraint IGS_SS_SU_SELECTION_UK spanning PERSON_ID and UOO_ID. The latter is the clearest business-key candidate: it guarantees that a given student holds at most one selection record per unit offering occurrence.

• USEC_SU_SELECTION_ID — surrogate primary key; system-generated identifier used by all referential children.
• PERSON_ID — the student party identifier; joins to the person/party model.
• UOO_ID — unit offering option identifier; identifies the specific offering instance being selected.
• UNIT_CD — the academic unit (subject) code.
• VERSION_NUMBER — version of the unit, supporting curriculum versioning.
• CAL_TYPE — calendar type (for example, standard academic year versus other calendar models).
• CI_SEQUENCE_NUMBER — calendar instance sequence, identifying the teaching period.
• LOCATION_CD — delivery or attendance location.
• UNIT_CLASS — classification of the unit.
• COURSE_CD and CALL_NUMBER — the parent course and its offering call number.
• ENROLLED_DT — date the student enrolled.
• ENROLLED_CP — enrolled credit points for the selection.
• GRADING_SCHEMA_CD — grading scheme applied to the attempt.
• UNIT_ATTEMPT_STATUS — status of the attempt (for example, enrolled, completed, withdrawn).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit and concurrency columns.

Common Use Cases and Queries

Typical reporting scenarios include student enrollment listings per teaching period, credit-point load calculations, and attempt-status tracking. A common query filters by student and calendar context:

• Enrollment roster: SELECT PERSON_ID, UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, UNIT_ATTEMPT_STATUS FROM IGS.IGS_SS_SU_SELECTION_ALL WHERE CAL_TYPE = :cal AND CI_SEQUENCE_NUMBER = :seq.
• Student unit history: filter by PERSON_ID and order by ENROLLED_DT to reconstruct a study transcript.
• Credit load: SELECT PERSON_ID, SUM(ENROLLED_CP) FROM IGS.IGS_SS_SU_SELECTION_ALL WHERE UNIT_ATTEMPT_STATUS = 'ENROLLED' GROUP BY PERSON_ID.
• Duplicate prevention: because of IGS_SS_SU_SELECTION_UK, a uniqueness check on PERSON_ID plus UOO_ID validates prospective inserts.

Related Objects

The ETRM metadata marks this object as standalone with no mined foreign-key children, so related-object guidance draws on the Student System model and its documented key columns.

• IGS_SS_STUDENT_UNITS — the student unit record that the selection typically maps to; joined via PERSON_ID and unit/version attributes.
• Unit offering tables — the entity keyed by UOO_ID (unit offering option), the parent of each selection.
• Person/party tables — joined on PERSON_ID to resolve student identity.
• Calendar instance tables — joined on CAL_TYPE and CI_SEQUENCE_NUMBER to resolve the teaching period.
• Course offering tables — joined on COURSE_CD and CALL_NUMBER for course-level reporting.
• Grading schema reference tables — joined on GRADING_SCHEMA_CD.
• Student System APIs — IGS enrollment and assessment PL/SQL APIs that insert, update, or query selections during processing.