Search Results fee_ass_ind




Overview
Explore in AI Chat

Overview

IGS_AD_ADM_UNIT_STAT_V is a database view belonging to the IGS – Student System product family in Oracle E-Business Suite (documented across 12.1.1 and 12.2.2). It exposes administrative unit status records together with their corresponding lookup meanings. In the Oracle Student System data model, an "administrative unit status" describes the state of a student's attempt within an administrative unit — for example a progression, enrollment, or registration status applied to a unit attempt.

The ETRM documentation flags this product as Obsolete and records the object as Not implemented in this database. This means the view is not deployed in the database against which the ETRM metadata was generated, and no owner or referenced base objects are formally documented. It should therefore be regarded as a legacy or historical object from earlier Student System releases rather than an actively supported reporting interface. Where it does exist, its role is to provide a denormalized, inquiry-friendly projection of status rows enriched with lookup descriptions, typically consumed by forms, reports, or integration extracts.

Underlying Base Objects

Per the documented view text, IGS_AD_ADM_UNIT_STAT_V is defined over two objects:

  • IGS_AD_ADM_UNIT_STAT (aliased AUS) — the primary base table holding administrative unit status rows, including descriptive attributes, indicator flags, and standard WHO columns.
  • IGS_LOOKUPS_VIEW (aliased LKUPS) — the lookup view supplying the human-readable MEANING and the FEE_ASS_IND flag.

The join is an inner equi-join on LKUPS.LOOKUP_CODE = AUS.UNIT_ATTEMPT_STATUS with the filter LKUPS.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'. Consequently, only rows whose unit attempt status value has a matching, active lookup entry of that type are returned. The ETRM metadata lists no owner and no formally documented base objects, so the referential details above derive solely from the embedded view text.

Key Columns

  • ROW_ID — unique identifier of the administrative unit status record; the primary join key for downstream references.
  • ADMINISTRATIVE_UNIT_STATUS — the administrative status value assigned to the unit attempt.
  • UNIT_ATTEMPT_STATUS — the status code driving the lookup join.
  • DESCRIPTION — free-text description held on the base record itself.
  • SHOW_ON_OFFIC_NTFCTN_IND — indicator controlling whether the status is surfaced on official notification output.
  • EFFECTIVE_PROGRESSION_IND — the column most directly relevant to the search term; it flags whether the status counts as an effective progression for the student. Reporting frequently filters on this flag to isolate progression-bearing statuses from administrative or transitional ones.
  • EFFECTIVE_TIME_ELAPSED_IND — flag indicating whether the status contributes to effective time elapsed calculations.
  • CLOSED_IND — indicates whether the status is closed.
  • MEANING — the lookup display value resolved from IGS_LOOKUPS_VIEW.
  • FEE_ASS_IND — fee assessment indicator carried on the lookup definition.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO audit columns.

Common Use Cases and Queries

Typical uses include listing all valid unit attempt statuses with their meanings, driving validation lists, and identifying statuses that represent effective progression for student records or integration extracts. A representative query is:

SELECT ROW_ID, UNIT_ATTEMPT_STATUS, MEANING, EFFECTIVE_PROGRESSION_IND, CLOSED_IND FROM IGS_AD_ADM_UNIT_STAT_V WHERE EFFECTIVE_PROGRESSION_IND = 'Y';

Because the object is documented as obsolete and not implemented, SQL against this view should be validated against the target environment before use in reports, and any production dependency should be migrated to a supported Student System object where one exists.