Results for “igs_da_xml_course_v”

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

Overview

The view APPS.IGS_DA_XML_COURSE_V is a reporting and integration object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It is a component of the Student System's data extraction and XML publishing infrastructure, designed to support the generation of XML payloads consumed by external systems, government reporting bodies, and inter-institutional data exchanges. The view is documented as mapping to the CourseType XML element, which is a child of the CourseInstitution element, indicating its role in hierarchical XML output structures.

The view assembles student unit attempt (SUA) information for a local institution, encompassing both the institution's own units and units in which the student is currently enrolled. Enrolled units may be selectively excluded through the EIP (Enterprise Integration Platform) Control feature code, giving implementers configurable control over the scope of extracted data. This conditional filtering behaviour reflects the view's purpose as a flexible, configuration-driven extraction source rather than a fixed transactional report.

Underlying Base Objects

The view is defined over a set of joined tables and supporting views. The documented join structure includes the following base and supporting objects:

• IGS_EN_STDNT_PS_ATT — the student program attempt table, providing the person and course context.
• IGS_PS_VER_ALL — the course version table, supplying course version attributes.
• IGS_CA_TEACH_TO_LOAD_V — a teaching load view contributing the LOAD_ALTERNATE_CODE attribute.
• IGS_EN_SU_ATTEMPT_ALL — the student unit attempt table, the principal source of unit-level attempt records.
• IGS_PS_UNIT_VER_ALL — the unit version table, joined on unit code and version.
• IGS_PE_HZ_PARTIES and HZ_PARTIES — party records supplying the party number.
• IGS_DA_RQST — the data extraction request table supplying the batch identifier.
• IGS_DA_REQ_FTRS — the extraction request features table, correlated in a subquery to apply the EIP feature-code filtering on unit attempt status.

Rather than storing data, the view derives nearly all of its meaningful output values through calls to the IGS_DA_XML_PKG package and the IGS_SS_ENR_DETAILS package, which compute abbreviation numbers, titles, credit points, grades, and result types at query time.

Key Columns

The columns exposed by the view are largely function-derived and carry the following meanings:

• GET_COURSE_ABBR_NUM(...,'A') and GET_COURSE_ABBR_NUM(...,'N') — the abbreviated and numeric representations of the unit/course identifier.
• IGS_SS_ENR_DETAILS.GET_TITLE(...) — the descriptive title of the unit attempt.
• LOAD_ALTERNATE_CODE — an alternate load code sourced from the teaching load view.
• GET_SUA_ATTEMPTED_CP — credit points attempted for the unit attempt.
• GET_SUA_EARNED_CP — credit points earned.
• GET_SUA_GPA_CP and GET_SUA_GPA_QP — GPA credit points and quality points.
• GET_SUA_GRADE — the grade achieved.
• GET_SUA_RESULT_TYPE — the result type classification.
• GET_UNIT_REPEATABLE — indicates whether the unit may be repeated.
• BATCH_ID, PERSON_ID, PARTY_NUMBER, UNIT_CD — identifiers linking the row to the extraction batch, student, party, and unit respectively.

Common Use Cases and Queries

The view is typically invoked by the XML extraction process rather than directly by end users. A representative query retrieves unit attempt details for a given extraction batch:

• SELECT person_id, party_number, unit_cd, get_sua_grade FROM igs_da_xml_course_v WHERE batch_id = :p_batch_id;
• Analysts may join the view to IGS_DA_RQST to reconcile extraction output against the originating request, or filter by unit code to isolate results for a single course.

Because the view relies on package functions, performance tuning should focus on the underlying join predicates and the batch identifier filter.