Results for “assessment_item_description”

16 results




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

Overview

The view IGSFV_AS_SPECIAL_CONSID_APPLS belongs to the IGS – Student System product family within Oracle E-Business Suite. The ETRM metadata classifies this product as Obsolete, meaning the surrounding Student System functionality is no longer actively shipped in Oracle EBS 12.1.1 or 12.2.2 environments. The view's documented purpose is to describe the occurrence of an application for special consideration — that is, a student's formal request that adverse circumstances (illness, bereavement, or similar) be taken into account when an assessment outcome is determined.

Functionally, the view presents a denormalized, read-only reporting surface that joins the special consideration application record to the parties, course, unit, assessment item, calendar, location, and outcome reference data required to render the application meaningful to an administrative user. Its role in reporting and integration is to expose a single flattened row per application, suited to operational inquiry screens, extracts, and downstream reporting rather than to transactional processing. The view is defined WITH READ ONLY, confirming it is a query construct only and cannot be used for DML.

Underlying Base Objects

Although the ETRM "Referenced base objects" field records none explicitly, the embedded view text identifies the following base tables and their aliases, all in the IGS and HZ schemas:

Most joins are inner joins; only the category and outcome lookups are outer-joined, so an application without a category or outcome is still returned. This structure makes the view a pure reporting projection over the assessment and student records.

Key Columns

The column list aligns closely with the SCAP base columns, with lookup descriptions substituted for codes, including PROGRAM_CODE, PROGRAM_TITLE, UNIT_CODE, UNIT_TITLE, CALENDAR_TYPE, CALENDAR_DESCRIPTION, LOCATION_CODE, LOCATION_DESCRIPTION, and ASSESSMENT_ITEM_DESCRIPTION. Operational columns include CREATION_DT and RECEIVED_DT, NOTIFIED_DATE, TRACKING_ID, and COMMENTS.

Of particular relevance to the search term estimated_processing_days, the view exposes SCAP.ESTIMATED_PROCESSING_DAYS. This column carries the anticipated number of days required to process the application, used in service-level monitoring and in advising students of expected turnaround. It is a numeric staff-entered value on the underlying application record. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and the identifying keys (PERSON_ID, UOO_ID, ASS_ID) are also present for drill-down and integration.

Common Use Cases and Queries

Typical usage is operational: reviewing open special consideration applications, tracking ageing against the estimated processing window, and extracting data for student case-management reporting.

  • Applications exceeding their estimate: compare SYSDATE minus RECEIVED_DT against ESTIMATED_PROCESSING_DAYS.
  • Pending outcome review: filter on SPCL_CONSIDERATION_OUTCOME being null.
  • Reporting extracts: select person, program, unit, and assessment detail for a given calendar or faculty.

Illustrative query:

SELECT PERSON_NAME, PERSON_NUMBER, PROGRAM_CODE,
       UNIT_CODE, ESTIMATED_PROCESSING_DAYS,
       RECEIVED_DT
FROM   IGSFV_AS_SPECIAL_CONSID_APPLS
WHERE  RECEIVED_DT >= SYSDATE - 90
ORDER  BY RECEIVED_DT;

As this view belongs to an obsolete product, deployments should confirm availability against their EBS patch level before relying on it.