Search Results igs_as_sc_atmpt_enr_pk

Overview

The table IGS_AS_SC_ATMPT_ENR is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a transactional repository for enrollment information that is either planned or has been completed for a specific student program attempt. Its primary role is to establish a formal link between a student's academic program and their associated enrollment activities within a given academic calendar instance. This table is critical for managing the student lifecycle, from enrollment planning and scheduling to the finalization of academic records, and serves as a foundational element for processes related to assessment, progression, and reporting.

Key Information Stored

The table's structure centers on identifying the student, their program, the academic period, and the nature of the enrollment. The primary key uniquely identifies a record through a combination of four columns: PERSON_ID (the student), COURSE_CD (the academic program code), CAL_TYPE (the calendar type), and CI_SEQUENCE_NUMBER (the sequence number for the calendar instance). A critical column is ENROLMENT_CAT, which categorizes the type of enrollment, likely referencing a lookup or code table. While the provided metadata does not list all columns, the foreign key relationships imply the storage of data that connects to the student's program attempt (IGS_EN_STDNT_PS_ATT_ALL), the academic calendar (IGS_CA_INST_ALL), and the enrollment category (IGS_EN_ENROLMENT_CAT).

Common Use Cases and Queries

This table is central to queries that analyze student enrollment patterns, load, and status. Common use cases include generating enrollment verification reports, calculating tuition fees based on enrolled units, auditing student progression against program requirements, and supporting administrative scheduling. A typical query pattern involves joining to student personal, program, and calendar tables to produce a comprehensive enrollment roster. For example, a report to list all enrollments for a specific academic period might use SQL similar to:

• SELECT enr.*, ps_att.version_number, inst.start_dt FROM igs_as_sc_atmpt_enr enr JOIN igs_en_stdnt_ps_att_all ps_att ON enr.person_id = ps_att.person_id AND enr.course_cd = ps_att.course_cd JOIN igs_ca_inst_all inst ON enr.cal_type = inst.cal_type AND enr.ci_sequence_number = inst.sequence_number WHERE enr.cal_type = 'SEMESTER' AND enr.ci_sequence_number = 202401;

Related Objects

The table maintains defined foreign key relationships with several other core IGS tables, ensuring referential integrity. These documented relationships are:

• IGS_EN_STDNT_PS_ATT_ALL: Links to the student's program attempt record. Join columns are PERSON_ID and COURSE_CD.
• IGS_CA_INST_ALL: Links to the academic calendar instance. Join columns are CAL_TYPE and CI_SEQUENCE_NUMBER.
• IGS_EN_ENROLMENT_CAT: Links to the enrollment category definition. Join column is ENROLMENT_CAT.

These relationships indicate that IGS_AS_SC_ATMPT_ENR is a child table, dependent on master data from student programs, calendars, and enrollment categories. Its primary key IGS_AS_SC_ATMPT_ENR_PK is likely referenced by other transactional tables in the assessment and enrollment modules.