Results for “estimated_processing_days”

11 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:

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.