Results for “term_record_id”

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

Overview

IGS_EN_SPA_TERMS_V is a reporting and integration view in the Oracle E-Business Suite Student System (IGS) product, owned by the APPS schema and registered with a VALID status. Its description, "Student Program Attempts Term View," reflects its purpose: it consolidates a student's program attempt records with the term calendar instance, program version, and class standing information into a single denormalized result set. Rather than forcing report developers and integration interfaces to join the underlying transactional tables themselves, the view presents a ready-to-query projection of the IGS_EN_SPA_TERMS base table enriched with descriptive attributes. This makes it a convenient access point for both concurrent-program reports and inbound/outbound interface logic that must resolve a student's term-level enrollment context.

Underlying Base Objects

The view is defined over four base objects: IGS_EN_SPA_TERMS (aliased SPAT), the core student program attempts term table that supplies the driving rows; IGS_CA_INST (CI), the calendar instance table joined on TERM_CAL_TYPE and TERM_SEQUENCE_NUMBER; IGS_PS_VER (CV), the program version table joined on PROGRAM_CD and PROGRAM_VERSION; and IGS_PR_CLASS_STD (PRCS), the class standing reference table. All joins are equi-joins except the class standing join, which uses the outer-join operator (+) on PRCS.IGS_PR_CLASS_STD_ID against SPAT.CLASS_STANDING_ID. This outer join is significant because it means program attempt rows are preserved even when no valid class standing reference exists, and CLASS_STANDING may therefore return null.

Key Columns

The view exposes the ROWID of the base record plus a wide set of identifying and descriptive columns. TERM_RECORD_ID is the primary identifier of the term record, while PERSON_ID identifies the student. PROGRAM_CD and PROGRAM_VERSION define the program attempt, and CAREER (derived from CV.COURSE_TYPE) indicates the career level. Term context is captured by ACAD_CAL_TYPE, TERM_CAL_TYPE, TERM_SEQUENCE_NUMBER, and DESCRIPTION_TERM. The columns most relevant to the user's search term are CLASS_STANDING_ID (the foreign key to IGS_PR_CLASS_STD) and CLASS_STANDING (the resolved description from that reference table). Additional attributes include KEY_PROGRAM_FLAG, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, FEE_CAT, PLAN_SHT_STATUS, and the standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE. Twenty attribute columns (ATTRIBUTE_CATEGORY through ATTRIBUTE20) provide extensibility.

Common Use Cases and Queries

A frequent requirement is resolving class standing for a student's term records, since CLASS_STANDING_ID is often the searched identifier. The following query returns program attempt term rows with their resolved class standing:

• SELECT person_id, program_cd, term_cal_type, term_sequence_number, class_standing_id, class_standing FROM igs_en_spa_terms_v WHERE person_id = :person_id;
• SELECT program_cd, career, description_term, class_standing FROM igs_en_spa_terms_v WHERE class_standing_id = :class_standing_id;
• SELECT term_cal_type, term_sequence_number, COUNT(*) FROM igs_en_spa_terms_v GROUP BY term_cal_type, term_sequence_number;

Because the class standing join is outer, queries filtering on CLASS_STANDING must account for null values where CLASS_STANDING_ID is populated but no matching reference row exists. The view is equally suited to integration extracts that populate external student information systems with term-level program data, or to concurrent programs producing enrollment and standing reports.