Results for “abbreviation_code”

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

Overview

IGSFV_UC_CONDITION_DETAILS is a read-only view owned by the APPS schema in Oracle E-Business Suite, belonging to the IGS (Student System) product family. It presents the full set of condition details that together constitute an offer extended to an applicant within the Universities and Colleges admissions functionality. In Oracle EBS reporting and integration terms, the view provides a denormalized, human-readable projection of the underlying admissions condition data, joining condition detail records to their parent offer conditions and resolving coded values into descriptive text.

The view is defined with a WITH READ ONLY clause, confirming that it is intended strictly for query, reporting, and integration consumption rather than for DML. It is valid in both the 12.1.1 and 12.2.2 releases of the E-Business Suite.

Underlying Base Objects

The view is defined over four base objects within the IGS schema, joined as follows:

• IGS_UC_COND_DETAILS (alias CO) — the driving condition detail table holding the individual conditions that make up the offer.
• IGS_UC_OFFER_CONDS (alias FT1) — the parent offer condition record, joined on CONDITION_CATEGORY and CONDITION_NAME.
• IGS_UC_REF_OFF_ABRV (alias FT2) — the offer abbreviation reference table, outer-joined on ABBREVIATION = ABBREV_CODE (+).
• IGS_UC_REF_CODES (alias FT3) — the general reference codes table, outer-joined on SUBJECT = CODE (+) with the restricting predicate CODE_TYPE (+) = 'SB'.

The inner joins to IGS_UC_OFFER_CONDS ensure that only condition details with a valid parent offer condition are returned, while the outer joins to the two reference tables tolerate missing abbreviation or subject lookups.

Key Columns

• CONDITION_CATEGORY / CONDITION_NAME / CONDITION_LINE — the identifying keys of the condition and its line-level detail.
• ABBREVIATION_CODE / ABBREVIATION_TEXT — the condition abbreviation code and its resolved descriptive text from the abbreviation reference table.
• GRADE_MARK / POINTS — the grade and tariff points associated with the condition.
• SUBJECT_CODE / SUBJECT_TEXT — the subject code and its resolved description from code type 'SB'.
• CONDITION_TEXT — the free-text narrative of the condition.
• STATUS / _LA:STATUS_DESC — the condition status and its lookup meaning, the latter resolved against the IGS_UC_COND_STATUS lookup type via the standard _LA: descriptive flexfield mechanism.
• MARVIN_CODE / SUMMARY_OF_CONDITIONS / DECISION — decision-support attributes carried from the offer condition record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

The view is typically used to report on the composition of admissions offers, to drive applicant-facing correspondence, and to feed decision-status reconciliation into downstream systems.

A representative query listing offer conditions with resolved status for a given condition category:

SELECT CONDITION_CATEGORY,
       CONDITION_NAME,
       ABBREVIATION_CODE,
       ABBREVIATION_TEXT,
       SUBJECT_TEXT,
       GRADE_MARK,
       POINTS,
       STATUS,
       _LA:STATUS_DESC,
       DECISION
  FROM APPS.IGSFV_UC_CONDITION_DETAILS
 WHERE CONDITION_CATEGORY = :p_category
 ORDER BY CONDITION_NAME, CONDITION_LINE;

Because the view already resolves abbreviation, subject, and status lookups, it eliminates the need for application-side decoding and is well suited to BI Publisher reports, concurrent-program extracts, and interface staging. As the view is read-only, all maintenance must be performed against the underlying base tables.