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:
- IGS_AS_SPL_CONS_APPL (SCAP) — the driving special consideration application table, supplying person, course, unit, assessment, calendar, outcome, and processing-day attributes.
- HZ_PARTIES (HP) — the trading community party, filtered by
PARTY_IDto yieldPARTY_NAMEandPARTY_NUMBER. - IGS_PS_VER_ALL (CRV) — course version, supplying the course title.
- IGS_PS_UNIT_VER_ALL (UV) — unit version, supplying the unit title.
- IGS_AS_ASSESSMNT_ITM_ALL (AI) — assessment item description.
- IGS_AS_SPCL_CONS_CAT (SPCC) — special consideration category.
- IGS_AS_SPCL_CONS_OUT (SPCO, SPCO1) — the outcome reference table, outer-joined twice for the sought outcome and the consideration outcome.
- IGS_CA_INST_ALL (CI) — calendar instance description.
- IGS_PS_UNIT_OFR_OPT_ALL (UOO) and IGS_AD_LOCATION_ALL (LOC) — unit offering option and location.
- IGS_EN_STDNT_PS_ATT_ALL (SPA) — student program attempt, joining person and course to the course version.
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
SYSDATEminusRECEIVED_DTagainstESTIMATED_PROCESSING_DAYS. - Pending outcome review: filter on
SPCL_CONSIDERATION_OUTCOMEbeing 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.
-
Describes occurrence of an application for special consideration.
APPS.IGSFV_AS_SPECIAL_CONSID_APPLS·↳ HZ_PARTIES·↳ IGS_AD_LOCATION_ALL·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
Describes an item a student might be assessed. All items are of a nominated type, as defined by the assessment type assigned. An assessment item can be either an examinable or non-examinable item. Examinable items may require scheduling dur
APPS.IGSFV_AS_ASSESSMENT_ITEMS·↳ IGS_AS_ASSESSMNT_ITM_ALL·↳ IGS_AS_ASSESSMNT_TYP·Explore IGS module →
-
Describes assessment items allocated to a unit version within nominated teaching calendar instance.
APPS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS·↳ IGS_AS_ASSESSMNT_ITM_ALL·↳ IGS_AS_GRD_SCHEMA·↳ IGS_AS_UNITASS_ITEM_ALL·Explore IGS module →
-
Describes an item a student might be assessed.
APPS.IGSBV_AS_ASSESSMENT_ITEMS·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
Describes occurrence of an application for special consideration.
APPS.IGSBV_AS_SPECIAL_CONSID_APPLS·↳ HZ_PARTIES·↳ IGS_AD_LOCATION_ALL·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
Describes occurrence of an application for special consideration.
Not implemented in this database·Explore IGS module →
-
Describes an item a student might be assessed. All items are of a nominated type, as defined by the assessment type assigned. An assessment item can be either an examinable or non-examinable item. Examinable items may require scheduling dur
Not implemented in this database·Explore IGS module →
-
Describes an item a student might be assessed.
Not implemented in this database·Explore IGS module →
-
Describes occurrence of an application for special consideration.
Not implemented in this database·Explore IGS module →
-
Describes assessment items allocated to a unit version within nominated teaching calendar instance.
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'.