Results for “unconf_sua”
3 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.IGS_EN_SS_SCHEDULE_DISP_V is a Student System (SS) self-service display view within the Oracle E-Business Suite higher education data model. It exposes a consolidated, denormalized rowset combining a student's course attempt context (person, program, version) with derived term, attendance mode, location, and eligibility attributes. The view is principally consumed by the Student Self-Service schedule and enrolment pages, which render a student's confirmed and unconfirmed enrolment activity for a given teaching period. Because it wraps several PL/SQL API calls (IGS_EN_SPA_TERMS_API, Igs_En_Elgbl_Program, Igs_En_Prc_Load, Igs_Ss_Enr_Details), it presents business logic results rather than raw column data, making it suitable for direct page rendering and lightweight reporting rather than bulk extraction.
Underlying Base Objects
The ETRM metadata documents no explicit base objects for this view; the derivation is instead visible through the defining query text. The principal driving object is sca, an alias over the student course attempt record (a Student Course Attempt / IGS_EN_STUDENT_CRS_ATT-style source) supplying person_id, course_cd, and version_number. Programme version data is joined through pv (programme version), returning course_type as the career. Calendar context is supplied by ci1 (the term), cir (calendar instance relationship, resolving sub- and super-calendar hierarchies), and ci2 (the academic period description). The unconf_sua flag is derived from a correlated subquery against IGS_EN_SU_ATTEMPT joined to IGS_CA_LOAD_TO_TEACH_V, which maps the load calendar instance to its corresponding teaching instance.
Key Columns
PERSON_ID,PROGRAM_CD,VERSION_NUMBER— identify the student and the programme version under which the attempt is held.CAREER— the programme type (e.g. undergraduate, postgraduate) drawn from programme version data.UNCONF_SUA— returns 'Y' or 'N'; 'Y' indicates the student holds at least one student unit attempt with statusUNCONFIRMwhose calendar instance maps to the term's teaching instance. This is the column referenced by the "unconf_sua" search term.TERM_DESCRIPTION,START_DT,ACADEMIC_DESCRIPTION— term and super-calendar descriptors supporting schedule display.- API-derived attendance columns —
GET_SPAT_ATT_TYPE(_DESC),GET_SPAT_ATT_MODE(_DESC),GET_SPAT_LOCATION(_DESC)— return coded and described attendance type, mode, and location for the student's programme attempt term. - Credit point and institution columns —
GET_APPLIED_MIN_CP,GET_APPLIED_MAX_CP,ENRP_GET_INST_ATTENDANCE,ENRP_GET_INST_CP— expose applied minimum/maximum credit points and institutional attendance/credit values. - Primary and secondary programme titles —
GET_PRI_PRG_TITLE,GET_SEC_PRG_TITLE. SUB_CAL_TYPE/SUB_CI_SEQUENCE_NUMBERandSUP_CAL_TYPE/SUP_CI_SEQUENCE_NUMBER— the sub- and super-calendar instance keys for the term.
Common Use Cases and Queries
The view is typically queried per student for schedule display. A representative query filtering to unconfirmed unit attempts is:
SELECT person_id, program_cd, career, term_description, unconf_sua FROM apps.igs_en_ss_schedule_disp_v WHERE person_id = :p_person AND unconf_sua = 'Y';- Term-level reporting:
SELECT program_cd, academic_description, start_dt, get_spat_att_mode_desc FROM apps.igs_en_ss_schedule_disp_v WHERE person_id = :p_person ORDER BY start_dt; - Confirming attendance mode and location for a schedule: select the
_DESCattendance columns alongsideTERM_DESCRIPTION.
Because the view invokes multiple API functions per row, queries should remain narrowly filtered by PERSON_ID to avoid performance degradation. For set-based reporting, materialising the results into a table is preferable to repeatedly calling the view.
-
This view shows all the program attempts with additional details like applicable min/max cp, year of program unit set etc. used to display in schedule page.
Not implemented in this database·Explore IGS module →
-
This view shows all the program attempts with additional details like applicable min/max cp, year of program unit set etc. used to display in schedule page.
APPS.IGS_EN_SS_SCHEDULE_DISP_V·↳ IGS_CA_INST·↳ IGS_CA_INST_REL·↳ IGS_CA_LOAD_TO_TEACH_V·Explore IGS module →