Search Results elo_description

Overview

APPS.IGS_EN_SU_ATTEMPT_H is a reporting and integration view within the Oracle E-Business Suite Student Information/Student Systems product family (the IGS schema prefix denotes Student Records and related Higher Education entities). It exposes the historical, versioned record of student unit attempts — that is, the record of a student's registration against a specific unit (module) offering, together with its lifecycle attributes, outcome controls, and administrative status. Because the object is a "_H" (history) view, it presents the historized rows maintained for audit and temporal tracking rather than only the current active attempt.

The view plays a supporting role in operational reporting, extracts, and integrations: it allows external consumers, concurrent programs, or custom reports to read attempt history through a secure, organization-filtered interface without directly accessing the underlying _ALL table. The organization filter is enforced through the standard Multi-Org mechanism using USERENV('CLIENT_INFO'), restricting returned rows to the operating unit context of the session unless that context is unset.

Underlying Base Objects

Although the ETRM metadata records no separately documented referenced base objects, the view definition itself identifies its source explicitly: the view selects from IGS_EN_SU_ATTEMPT_H_ALL, the multi-org ( "_ALL") history table for student unit attempts. The view is therefore a thin projection over that table, reproducing its columns one-for-one while adding the organization security predicate and, implicitly, the ROWID exposed as ROW_ID.

The WHERE clause applies the standard client-info organization filter:

• It parses USERENV('CLIENT_INFO'), taking the first ten bytes (or NULL when the first byte is a space) and converting to a number.
• It compares NVL(ORG_ID, ... -99) against the session value, also defaulting to -99, so rows with a null ORG_ID and sessions without a set org context both resolve to the same comparison value.

No joins, aggregations, or derivations are performed; the view is effectively a secured synonym-style wrapper over IGS_EN_SU_ATTEMPT_H_ALL.

Key Columns

The projected columns describe a student's attempt at a unit across versions and time. Significant columns include:

• ROW_ID — the ROWID of the underlying row, useful for unique identification and direct row access.
• ORG_ID — the operating unit, driving the Multi-Org filter.
• PERSON_ID — the student (person) identifier.
• COURSE_CD, UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER — the course, unit, version, calendar type, and calendar instance sequence defining the attempt.
• HIST_START_DT, HIST_END_DT, HIST_WHO — history/effective-dating columns recording when the version became effective, when it ended, and who made the change.
• UNIT_ATTEMPT_STATUS, ADMINISTRATIVE_UNIT_STATUS, AUS_DESCRIPTION — the student's attempt status and the administrative status with its description.
• ENROLLED_DT, DISCONTINUED_DT, RULE_WAIVED_DT, RULE_WAIVED_PERSON_ID — enrollment and discontinuation dates plus rule-waiver data.
• ELO_DESCRIPTION — the description associated with the ELO (Element of Learning / learning outcome) context, the column the user searched for; it carries the descriptive text for the linked learning element.
• SUP_UNIT_CD, SUP_VERSION_NUMBER, ALTERNATIVE_TITLE — supplementary unit references and alternate title.
• OVERRIDE_ENROLLED_CP, OVERRIDE_EFTSU, OVERRIDE_ACHIEVABLE_CP, OVERRIDE_OUTCOME_DUE_DT, OVERRIDE_CREDIT_REASON — credit-point, EFTSU, achievable credit, outcome-due-date and credit-reason overrides.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• Other attributes — DCNT_REASON_CD, GRADING_SCHEMA_CODE, ENR_METHOD_TYPE, DEG_AUD_DETAIL_ID, UOO_ID, CORE_INDICATOR_CODE.

Common Use Cases and Queries

Typical uses include point-in-time reporting of a student's unit attempt history, reconciliation of enrollment credits via the OVERRIDE_* columns, and integration extracts that require the ELO_DESCRIPTION and administrative status text. A representative query retrieving current attempt history for a person is:

• SELECT person_id, course_cd, unit_cd, version_number, cal_type, unit_attempt_status, administrative_unit_status, elo_description, enrolled_dt FROM apps.igs_en_su_attempt_h WHERE person_id = :person_id ORDER BY hist_start_dt DESC;
• SELECT unit_cd, ci_sequence_number, override_enrolled_cp, override_achievable_cp FROM apps.igs_en_su_attempt_h WHERE person_id = :person_id AND cal_type = :cal_type;
• SELECT COUNT(*) FROM apps.igs_en_su_attempt_h WHERE org_id = :org_id AND unit_attempt_status = :status;

Because the view enforces the org filter automatically, reports should be run with the appropriate operating unit context set; otherwise the client-info comparison resolves to the -99 default and only rows with a matching null/decode value are returned. Performance is generally equivalent to querying the base history table directly.