Results for “enrolled_dt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AS_SC_ATMPT_ENR is a transactional table in the Oracle E-Business Suite Student System (IGS) module. It records the enrollment record that is either planned to occur or has already occurred in relation to a student's program attempt. In the Oracle Student System data model, an enrollment represents the linkage between a person (student) and a course offering within a calendar instance, and this table captures that linkage along with associated processing and administrative dates.

From a Data Vault modeling perspective, the metadata's heuristic classification identifies this object as a link. This is consistent with the fact that its primary key is composed entirely of foreign-key columns (PERSON_ID, COURSE_CD, CAL_TYPE, CI_SEQUENCE_NUMBER), each pointing to a different parent entity. In Data Vault terms, this table resolves the many-to-many relationship between students and course instances, with the remaining non-key columns acting as descriptive attributes.

Key Information Stored

The table contains 18 documented columns. The most significant are grouped below.

• PERSON_ID — Identifier for the student involved in the enrollment; part of the primary key and references IGS_EN_STDNT_PS_ATT_ALL.
• COURSE_CD — The course code identifying the course in which the student is enrolled.
• CAL_TYPE — The calendar type identifying the academic calendar in which the enrollment occurs.
• CI_SEQUENCE_NUMBER — Sequence number identifying the specific calendar instance; together with CAL_TYPE this references IGS_CA_INST_ALL.
• ENROLMENT_CAT — The enrollment category, referencing IGS_EN_ENROLMENT_CAT, used to classify the nature of the enrollment.
• ENROLLED_DT — Date on which the enrollment occurred.
• ENR_FORM_DUE_DT, ENR_FORM_RECEIVED_DT, ENR_PCKG_PROD_DT — Administrative dates tracking enrollment form deadlines, form receipt, and enrollment package production.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Attributes linking the enrollment to the associated program application and program.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID — Standard Oracle WHO audit columns capturing creation and last-update metadata.

Because the surrogate primary key is not a single sequence-generated identifier, the table relies on a composite business key. The metadata documents both the primary key IGS_AS_SC_ATMPT_ENR_PK and the unique index IGS_AS_SC_ATMPT_ENR_U1, both defined on the same four columns: PERSON_ID, COURSE_CD, CAL_TYPE, and CI_SEQUENCE_NUMBER. This confirms that the enrollment is uniquely identified by the combination of student, course, calendar type, and calendar instance sequence.

Common Use Cases and Queries

This table is central to enrollment reporting and to identifying which students are enrolled in which course instances for a given academic period. Typical scenarios include producing enrollment rosters, tracking outstanding enrollment forms, reconciling enrollments against applications, and auditing changes to enrollment records.

A representative query joining the enrollment to its calendar instance and student record may be written as:

• SELECT e.PERSON_ID, e.COURSE_CD, e.CAL_TYPE, e.CI_SEQUENCE_NUMBER, e.ENROLLED_DT FROM IGS_AS_SC_ATMPT_ENR e WHERE e.CAL_TYPE = :cal_type;
• Joining to IGS_CA_INST_ALL on CAL_TYPE and CI_SEQUENCE_NUMBER retrieves calendar instance details.
• Joining to IGS_EN_STDNT_PS_ATT_ALL on PERSON_ID and COURSE_CD provides the student program attempt context.
• Filtering on ENR_FORM_DUE_DT versus ENR_FORM_RECEIVED_DT identifies overdue enrollment forms.

Because REQUEST_ID and the audit columns are present, the table can also be used for concurrent program reconciliation and change tracking.

Related Objects

The following objects are referenced by or closely related to IGS_AS_SC_ATMPT_ENR, based on documented foreign keys.

• IGS_CA_INST_ALL — Referenced via CAL_TYPE and CI_SEQUENCE_NUMBER; supplies calendar instance information.
• IGS_EN_ENROLMENT_CAT — Referenced via ENROLMENT_CAT; defines the enrollment category.
• IGS_EN_STDNT_PS_ATT_ALL — Referenced via PERSON_ID and COURSE_CD; provides the student program attempt record.
• IGS_AS_SC_ATMPT_ENR_PK — The primary key constraint enforcing uniqueness of the composite key.
• IGS_AS_SC_ATMPT_ENR_U1 — The unique index implementing the business key on the same four columns.

Additional views or APIs exposed by the Student System may reference this table indirectly through the parent tables above, but those listed represent the most significant documented dependencies.