Search Results usec_su_selection_id




Overview
Explore in AI Chat

Overview

IGS_SS_SU_SELECTION is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the Student System (IGS) product family. It presents student unit selection records — the enrollments, attempts, or selections that link a person to a unit offering option within a teaching calendar. The view is a multi-org secured projection: it does not store data itself but exposes rows from an underlying _ALL table after applying an organization filter derived from the session's client information. Because it carries the APPS synonym and the standard WHO audit columns, it is intended for use in concurrent programs, OAF/Forms regions, BI Publisher reports, and ad hoc SQL executed by support and implementation staff.

Underlying Base Objects

The view is defined over a single base object, IGS_SS_SU_SELECTION_ALL. The view text selects every documented column from that table and then restricts the result set using a predicate on ORG_ID. The predicate compares ORG_ID (defaulted to -99 via NVL when null) against the organization identifier parsed from USERENV('CLIENT_INFO'). The decode logic inspects the first byte of CLIENT_INFO; if it is a space the expression evaluates to NULL, otherwise the first ten bytes are converted to a number. This is the standard Oracle multi-org "secure the view" pattern, so the same view returns only the selections relevant to the organization set in the current session. No other base tables or documented referenced objects are metadata-recorded, and the view performs no joins — all descriptive attributes must be resolved by joining to person, unit, course, and calendaring views separately.

Key Columns

Common Use Cases and Queries

The view is typically queried to list a student's unit selections for a period, to check attempt status and credit points, or to extract data for interfaces and data warehouses. Because the _ALL table sits behind a multi-org predicate, callers must ensure the correct operating unit context is set (for example through mo_global or by initializing CLIENT_INFO); otherwise a default organization of -99 is matched against null ORG_ID rows.

Retrieve all selections for a person:

  • SELECT usec_su_selection_id, unit_cd, version_number, cal_type, ci_sequence_number, unit_attempt_status FROM igs_ss_su_selection WHERE person_id = :p_person_id;

Filter by unit and calendar instance:

  • SELECT usec_su_selection_id, person_id, enrolled_dt, enrolled_cp FROM igs_ss_su_selection WHERE unit_cd = :p_unit_cd AND cal_type = :p_cal_type AND ci_sequence_number = :p_ci_seq;

Join to a person view to obtain names, and restrict to active attempts:

  • SELECT s.usec_su_selection_id, p.person_number, s.unit_cd, s.unit_attempt_status FROM igs_ss_su_selection s, igs_pe_person_v p WHERE s.person_id = p.person_id AND s.unit_attempt_status = 'ENROLLED';

When joining to the base _ALL table directly for performance or for cross-org extraction, bypass the secured view and filter ORG_ID explicitly.