Search Results received_dt

Overview

The IGS_AS_SPL_CONS_APPL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Student Administration module. It serves as the transactional repository for recording applications for special consideration made by students regarding their academic assessments. The table's primary role is to formally document each occurrence where a student seeks an adjustment or concession due to extenuating circumstances, such as medical issues or personal hardship, that may have impacted their ability to complete an assessment item. By maintaining this record, the institution can manage, track, and make decisions on these applications in a structured and auditable manner, linking the request to the specific student, unit attempt, and assessment.

Key Information Stored

The table stores a comprehensive set of identifiers and attributes for each application. The primary key uniquely identifies an application through a combination of the student (PERSON_ID), their enrolled program (COURSE_CD), the unit offering (UOO_ID), the specific assessment item (ASS_ID), and key dates (CREATION_DT, RECEIVED_DT). Critical descriptive columns include SPCL_CONSIDERATION_CAT, which classifies the basis of the application (e.g., "Medical"), and SOUGHT_OUTCOME, which captures the specific result the student is requesting. The SPCL_CONSIDERATION_OUTCOME column records the institution's final decision on the application. Other columns like UNIT_CD, CAL_TYPE, and CI_SEQUENCE_NUMBER provide the full academic context of the unit attempt in question.

Common Use Cases and Queries

A primary use case is generating reports on special consideration application volumes by category or outcome for administrative review. Another is querying the status of applications for a specific student or assessment item. For instance, to find all pending applications for a particular unit, a query might join to the outcome lookup table to filter for null or provisional outcomes. A common reporting pattern involves aggregating data by the SOUGHT_OUTCOME column to analyze trends in the types of concessions students are requesting. Support staff may also run queries to identify applications received after a specified date (RECEIVED_DT) that require processing. Sample SQL often includes joins to the foreign key reference tables (IGS_AS_SPCL_CONS_CAT, IGS_AS_SPCL_CONS_OUT) to retrieve the descriptive meaning of the stored codes.

Related Objects

The table maintains defined integrity relationships with several key objects in the IGS schema, as documented in its foreign key constraints:

• IGS_AS_SPCL_CONS_CAT: The SPCL_CONSIDERATION_CAT column references this table to validate the application category code.
• IGS_AS_SPCL_CONS_OUT (Two Relationships): Both the SOUGHT_OUTCOME and the SPCL_CONSIDERATION_OUTCOME columns reference this lookup table to validate codes for the requested and final outcomes, respectively.
• IGS_AS_SU_ATMPT_ITM: The PERSON_ID column, as part of the table's identifying context, references a student unit attempt item, linking the application to the specific academic enrollment record.

These relationships ensure data consistency and enable meaningful joins for reporting and application processing workflows.