Results for “acad_alternate_code”

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

Overview

The IGS_PR_SUA_INQ_V view is a reporting and inquiry object within the Oracle E-Business Suite IGS — Student System product (the Student Records / Student Administration module lineage). It is owned by the APPS schema and resides in a VALID state, indicating that the compiled definition is present and usable at runtime. The view presents Student Unit Attempt (SUA) data — the enrolment record that links a person (student) to a specific unit offering, calendar instance, and teaching period. Its principal design purpose is to denormalise the SUA record and enrich it with derived attributes such as academic and calendar period alternate codes, credit point values, EFTSL calculations, and achievable outcomes, so that inquiry screens, concurrent reports, and integration extracts can consume a single flattened row per unit attempt.

Because the view invokes several stored PL/SQL functions in its projection, it behaves as a computational layer rather than a simple join. This is characteristic of IGS inquiry views (the _INQ_V suffix denotes an inquiry view) intended to support online enquiry forms and reporting where the derivation logic is centralised in the database rather than replicated in each consumer.

Underlying Base Objects

The view text confirms that IGS_PR_SUA_INQ_V is defined over the Student Unit Attempt base table (aliased SUA in the projection), logically joined to:

• Unit Version (UV) — supplies unit and version titles, short titles, credit point defaults, and the repeatable indicator.
• Unit Class (UC) — supplies the delivery mode (unit mode) for the attempt.
• Student Course Attempt (SCA) — supplies the parent course attempt version used by derived calculations.
• A credit-point source (CPS) — provides enrolled and achievable credit point overrides where present.
• A student unit outcome/grading object (SFOV) — contributes the mark and grading schema/version attributes near the end of the projection.

In addition, the view depends on IGS PL/SQL APIs, notably IGS_EN_GEN_014 (enrolment utilities such as ENRS_GET_ACAD_ALT_CD and ENRS_CLC_SUA_EFTSUT), IGS_CA_GEN_001 (calendar utilities such as CALP_GET_ALT_CD), and IGS_IN_GEN_001 (INQP_GET_SUA_ACHVD for achievable credit point calculation). The documented ETRM metadata lists no explicit base object dependencies, so the relationships above are inferred directly from the view text.

Key Columns

• PERSON_ID — the student identifier, the primary join key to person records.
• COURSE_CD, UNIT_CD, VERSION_NUMBER — identify the course, unit, and unit version of the attempt.
• CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and calendar instance defining the teaching period.
• CI_START_DT, CI_END_DT — the calendar instance start and end dates for the attempt.
• UNI T_ATTEMPT_STATUS, ADMINISTRATIVE_UNIT_STATUS — the enrolment and administrative state of the attempt.
• ENROLLED_DT, DISCONTINUED_DT, RULE_WAIVED_DT — lifecycle dates for the enrolment.
• LOCATION_CD, UNIT_CLASS, UNIT_MODE — where and how the unit is delivered.
• Enrolled and Achievable Credit Points — resolved through the NVL chain combining attempt overrides, class-schedule points, and unit-version defaults.
• EFTSL value — computed via ENRS_CLC_SUA_EFTSUT, respecting the override columns.
• MARK and grading schema columns — the achieved outcome and translated grading schema/version.
• NO_ASSESSMENT_IND, OVERRIDE_CREDIT_REASON, EXAM_LOCATION_CD — additional administrative flags and details.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view supports inquiry of a student's unit attempts with derived credit and outcome data, and is suitable for reporting and extract routines.

• List all attempts for a student in a period:

SELECT person_id, unit_cd, version_number, cal_type, ci_sequence_number,
       unit_attempt_status, enrolled_dt
FROM   apps.igs_pr_sua_inq_v
WHERE  person_id = :p_person_id
AND    cal_type  = :p_cal_type;

• Report enrolled versus achievable credit points for active attempts:

SELECT person_id, unit_cd, version_number,
       enrolled_credit_points, achievable_credit_points
FROM   apps.igs_pr_sua_inq_v
WHERE  unit_attempt_status = 'ENROLLED'
AND    ci_end_dt >= TRUNC(SYSDATE);

• Extract EFTSL and outcomes for a course attempt, filtering on the parent course and calendar instance for reconciliation or statutory reporting.

Because the projection calls PL/SQL functions per row, queries should be filtered tightly (by person, course, or calendar) to control execution cost.