Results for “unit_grade”

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

Overview

IGS_AS_PROGUGAI_ADI_V is a WebADI (Web Applications Desktop Integrator) integration view within the Oracle E-Business Suite Student System (IGS) product family. Its name reflects its composite purpose: it consolidates Assessment (AS), Progression, Unit Grade (UG), and Assessment Item (AI) data into a single denormalized projection intended for bulk upload and download operations through WebADI templates. In releases 12.1.1 and 12.2.2 the view is documented as part of the obsolete IGS module set, and the ETRM metadata explicitly states that it is not implemented in this database. Consequently, it should be treated as a reference artifact rather than an active runtime object in a standard 12.2.2 installation.

The view's role within reporting and integration is to expose student progression and grading records in a flattened, spreadsheet-friendly structure. WebADI relies on such views to map uploaded rows back to base entities using surrogate and business keys, so the projection deliberately mixes key identifiers (person, course, calendar instance, unit set) with descriptive attributes and placeholder NULL columns reserved for the assessment and unit grade legs of the integration.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view SQL itself draws from nine sources joined on person, course, and calendar keys. The principal entities are:

• HZ_PARTIES (HP) — supplies the person number and concatenated person name.
• IGS_EN_STDNT_PS_ATT_SV (SPA) — the student program attempt view, filtered to COURSE_ATTEMPT_STATUS values of ENROLLED or INACTIVE.
• IGS_PS_VER_ALL (PV) — course version data providing course code, type, and responsible organizational unit.
• IGS_AS_SU_SETATMPT (SUSA) — unit set attempt rows, restricted to open attempts (END_DT and RQRMNTS_COMPLETE_DT null, SELECTION_DT populated).
• IGS_CA_INST_ALL (CI) and IGS_CA_TYPE (CT) — calendar instance and type information for the program.
• IGS_HE_EN_SUSA (HES) — outer-joined year-of-program grade and mark values.
• IGS_AS_ANON_ID_PS (AIP) — outer-joined anonymous identifier, the column that most commonly prompts searches for this view.

All joins are equijoins on PARTY_ID, PERSON_ID, COURSE_CD, and VERSION_NUMBER, with the HES and AIP joins expressed as outer joins using the Oracle (+) syntax.

Key Columns

• PERSON_NUMBER, PERSON_NAME — student identification derived from HZ_PARTIES.
• ANONYMOUS_ID — the anonymized assessment identifier sourced from IGS_AS_ANON_ID_PS; used where marking must be blind.
• COURSE_CD, COURSE_TYPE, RESPONSIBLE_ORG_UNIT_CD — program context from the course version.
• UNIT_SET_CD — the unit set attempt being processed.
• PRG_ALTERNATE_CD, PRG_CAL_TYPE, PRG_CI_SEQUENCE_NUMBER — calendar instance keys for the program attempt.
• YOP_GRADE, YOP_MARK — year-of-program outcomes from IGS_HE_EN_SUSA.
• RECORD_TYPE — hardcoded to 'PRG', marking each row as a progression record.
• The remaining columns (UNIT_CD, UNIT_GRADE, ASSESSMENT_ID, AI_MARK, AI_GRADE, and similar) are emitted as literal dashes or NULLs, serving as typed placeholders for the unit-grade and assessment-item legs.

Common Use Cases and Queries

Because the view is not implemented, practical queries generally require the underlying tables or a locally recreated equivalent. A representative WebADI-style extraction would resemble:

• SELECT person_number, anonymous_id, course_cd, unit_set_cd FROM igs_as_progugai_adi_v WHERE record_type = 'PRG';
• Filtering by anonymous_id IS NOT NULL to isolate students requiring anonymized assessment handling.
• Joining back to IGS_AS_SU_SETATMPT on PERSON_ID, COURSE_CD, and UNIT_SET_CD to enrich the flattened rows.
• Using COURSE_CD and PRG_CI_SEQUENCE_NUMBER as upload keys in WebADI mapping definitions.

Administrators should verify object existence in their specific instance before referencing the view, as the ETRM record confirms it is absent from the documented 12.2.2 schema.