Search Results caldendar_inst_sequence_number

Overview

The view APPS.IGSBV_AS_UNIT_ASSESSMENT_ITEMS belongs to the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe assessment items that have been allocated to a unit version within a nominated teaching calendar instance. In practical terms, the view consolidates the assessment structure of a taught unit — the individual assessment items, their weights, mandatory flags, grading schema, due and release dates, and examination scheduling attributes — alongside the teaching calendar instance under which that unit version is delivered.

The view is defined as a read-only projection (declared WITH READ ONLY) over a single base table, and it resolves several coded columns into their display meanings by referencing IGS_LOOKUP_VALUES. This makes it well suited to reporting and integration workloads where consumers require human-readable assessment metadata without joining to lookup tables themselves. Because it is a reporting-oriented view rather than a transaction entity, it exposes no DML surface; inserts and updates must be performed against the underlying base table.

Underlying Base Objects

The documented view text shows a single referenced base object: IGS_AS_UNITASS_ITEM_ALL, aliased as UAI. The ETRM metadata notes that no base objects are separately documented, so IGS_AS_UNITASS_ITEM_ALL is the authoritative source from the view definition itself. The view selects the assessment item attributes directly from this table and applies inline lookup resolution against IGS_LOOKUP_VALUES for three coded columns:

• MIDTERM_MANDATORY_TYPE_CODE resolved against lookup type IGS_AS_AI_MANDATORY_TYPES to return MEANING.
• FINAL_MANDATORY_TYPE_CODE resolved against lookup type IGS_AS_AI_MANDATORY_TYPES to return MEANING.
• DFLT_ITEM_IND (default item indicator) resolved against lookup type YES_NO to return MEANING.

The view therefore sits directly on the unit assessment item table, with no intermediate joins documented, and inherits the multi-org (_ALL) nature of its base table. Because the base is a _ALL table, row visibility is governed by the standard IGS/HR security and operating unit context of the calling session.

Key Columns

The view exposes columns that describe both the assessment item and its teaching calendar context. Notable columns include:

• UNIT_CODE, UNIT_VERSION_NUMBER — identify the unit and the specific version of the unit to which the assessment item is attached.
• CALENDAR_TYPE, CALDENDAR_INST_SEQUENCE_NUMBER, CALENDAR_START_DATE, CALENDAR_END_DATE — the teaching calendar instance; the CALENDAR_START_DATE (aliased from CI_START_DT) is the value users most commonly filter on when searching for assessment items delivered within a given teaching period.
• ASSESSMENT_ID, SEQUENCE_NUMBER, UNIT_ASSESSMENT_ITEM_ID, UNIT_ASSESSMENT_ITEM_GROUP_ID — identifiers linking the item to its assessment and grouping structure.
• MIDTERM_MNDRY_TYP_CD, MIDTERM_WEIGHT_QUANTITY, FINAL_MNDRY_TYP_CODE, FINAL_WEIGHT_QUANTITY — mandatory-type and weighting information for midterm and final components.
• GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER — the grading schema applied to the item.
• DUE_DATE, RELEASE_DATE, ACTION_DATE — scheduling and lifecycle dates for the item.
• EXAM_CALENDAR_TYPE, EXAM_CAL_INST_SEQUENCE_NUMBER — examination calendar instance details.
• LOGICAL_DELETE_DATE — indicates logical (soft) deletion; rows with a populated value should generally be excluded from active reporting.
• Standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

A frequent requirement is to list assessment items for a unit version within a specific teaching calendar instance. Filtering on CALENDAR_START_DATE is the typical entry point when a user searches by teaching period start:

• Assessment item listings for a unit version in a nominated calendar instance.
• Weight and mandatory-type reporting for midterm and final components.
• Examination scheduling extracts using the exam calendar columns.
• Due-date and release-date monitoring for assessment items.

Representative query:

SELECT unit_code, version_number, reference, description, calendar_start_date, calendar_end_date, midterm_weight_quantity, final_weight_quantity, due_date FROM apps.igsbv_as_unit_assessment_items WHERE unit_code = :unit_code AND calendar_type = :cal_type AND calendar_start_date >= :calendar_start_date AND logical_delete_date IS NULL ORDER BY unit_code, version_number, sequence_number;

Because the view performs the lookup resolution internally, users obtain mandatory-type and default-item meanings without additional joins, simplifying report and interface development against the IGS assessment structures.