Results for “received_dt”
9 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_AS_SPL_CONS_APPL is a transactional table in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe the occurrence of an application for special consideration — that is, a formal request made by a student for special consideration in relation to an assessment, and the outcome and processing status of that request. In the Oracle EBS 12.1.1 and 12.2.2 schemas, the table resides in the IGS schema and is reported with VALID status in the ETRM reference data.
From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests this object behaves as a link. It records an associative event that connects a student attempt item with special consideration categories and outcomes, rather than acting as a standalone hub of business concepts or a purely descriptive satellite. This classification is a modeling suggestion rather than an enforced construct within EBS itself.
Key Information Stored
The table contains 21 documented columns. The most significant include:
- PERSON_ID, COURSE_CD, UOO_ID, ASS_ID — identify the student, course, unit offering option, and assessment against which the special consideration application is raised.
- CREATION_DT and RECEIVED_DT — record when the application was created and when it was received.
- SPCL_CONSIDERATION_CAT — the category of special consideration requested, referencing IGS_AS_SPCL_CONS_CAT.
- SOUGHT_OUTCOME and SPCL_CONSIDERATION_OUTCOME — the outcome the student sought and the actual outcome determined, both referencing IGS_AS_SPCL_CONS_OUT.
- ESTIMATED_PROCESSING_DAYS and TRACKING_ID — administrative controls for tracking the application through its lifecycle.
- NOTIFIED_DATE — the date the student was notified of the outcome.
- COMMENTS — free-text notes attached to the application.
- UNIT_CD, CAL_TYPE, CI_SEQUENCE_NUMBER — context columns identifying the academic unit, calendar type, and sequence.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO audit columns.
The documented primary key is IGS_AS_SPL_CONS_APPL_PK, formed from PERSON_ID, COURSE_CD, UOO_ID, ASS_ID, CREATION_DT, and RECEIVED_DT. This six-column composite also serves as the unique business-key candidate; no separate surrogate key is documented.
Common Use Cases and Queries
Typical uses include monitoring open special consideration applications, reporting on outcomes by category, and reconciling applications against assessment attempts. A representative query joins the application table to its attempt item parent:
- SELECT a.PERSON_ID, a.COURSE_CD, a.ASS_ID, a.SPCL_CONSIDERATION_CAT, a.SPCL_CONSIDERATION_OUTCOME FROM IGS_AS_SPL_CONS_APPL a WHERE a.NOTIFIED_DATE IS NULL;
- Aggregate counts of applications grouped by SOUGHT_OUTCOME and SPCL_CONSIDERATION_OUTCOME for outcome reporting.
- Identify applications older than ESTIMATED_PROCESSING_DAYS without a NOTIFIED_DATE to flag overdue cases.
Related Objects
The table participates in the following documented relationships:
- IGS_AS_SU_ATMPT_ITM — parent attempt item, joined on PERSON_ID, COURSE_CD, UOO_ID, ASS_ID, CREATION_DT.
- IGS_AS_SPCL_CONS_CAT — joined on SPCL_CONSIDERATION_CAT.
- IGS_AS_SPCL_CONS_OUT — joined twice, on SOUGHT_OUTCOME and SPCL_CONSIDERATION_OUTCOME.
These FK relationships define the core parent and lookup dependencies that any extraction or reporting layer must preserve.
-
Describes occurrence of an application for special consideration
-
Table: IGS_AS_SPL_CONS_APPL 12.2.2
Describes occurrence of an application for special consideration
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.