Results for “unit_name”

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

Overview

The view IGS_AD_TERM_UNITDTLS_V belongs to the IGS (Student System) product family in Oracle E-Business Suite. It exposes term-level unit detail records for an academic term, combining enrollment unit data with a decoded description of the unit difficulty level. The _V suffix denotes a view rather than a base table, and the object is documented as obsolete and not implemented in the current release's database. The view is a reporting and integration convenience layer: by joining the base unit details table to the code classes table, it removes the need for downstream reports, extracts, or interfaces to resolve the difficulty code themselves. It is relevant to the user term "deg_aud_detail_id" because the view projects the DEG_AUD_DETAIL_ID column, separating the audit-related detail sequence from the primary unit detail sequence and thereby allowing degree audit records to be traced through term unit detail data.

Underlying Base Objects

Per the ETRM metadata, no base objects are separately documented, but the view text identifies its two source objects directly. The driving table is IGS_AD_TERM_UNITDTLS, aliased TU, which holds the unit-level detail rows for a given term. The lookup table is IGS_AD_CODE_CLASSES, aliased CC1, which supplies the decoded difficulty description. The join is CC1.CODE_ID = TU.UNIT_DIFFICULTY (+), an outer join keyed on the unit difficulty code. Because the lookup side is outer-joined, a unit detail row is preserved even when its difficulty code has no matching code class entry, in which case UNIT_DIFFICULTY_DESC returns null. The view selects TU.ROWID as ROW_ID, which gives callers a pseudo-column handle to the underlying base row for direct row addressing. No filter or restriction clause appears on the base tables, so the view returns all term unit detail rows available in the base table.

Key Columns

• ROW_ID — the base table ROWID, useful for updating or deleting the source row directly.
• UNIT_DETAILS_ID — primary identifier for the unit detail record.
• TERM_DETAILS_ID — the parent term detail record to which the unit belongs.
• UNIT and UNIT_NAME — the unit code and its descriptive name.
• UNIT_DIFFICULTY — the raw difficulty code value.
• UNIT_DIFFICULTY_DESC — the decoded difficulty name from IGS_AD_CODE_CLASSES.
• CP_ATTEMPTED and CP_EARNED — credit points attempted and earned for the unit.
• GRADE and UNIT_GRADE_POINTS — the achieved grade and its numeric grade point value.
• DEG_AUD_DETAIL_ID — the degree audit detail identifier, linking the term unit detail to a degree audit record.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically used to report earned credit and grade outcomes by unit within a term, or to reconcile term unit details against degree audit records. A representative query listing unit outcomes for a term:

• SELECT unit, unit_name, unit_difficulty_desc, cp_attempted, cp_earned, grade, unit_grade_points
• FROM igs_ad_term_unitdtls_v
• WHERE term_details_id = :term_id
• ORDER BY unit;

To trace degree audit linkage, restrict or project DEG_AUD_DETAIL_ID:

• SELECT unit_details_id, term_details_id, unit, grade, deg_aud_detail_id
• FROM igs_ad_term_unitdtls_v
• WHERE deg_aud_detail_id IS NOT NULL
• AND unit_details_id = :unit_detail_id;

Because the object is documented as obsolete in ETRM 12.2.2 and not implemented in the database, any reference should be validated against the target environment before use; equivalent data may reside in successor tables within the IGS schema.