Search Results primary_program_type




Overview
Explore in AI Chat

Overview

IGS_EN_STDNT_PS_ATT_SV is an Oracle E-Business Suite seed data view owned by the APPS schema. It exposes student program attempt and attendance records from the Higher Education / Student System product family, and is part of the IGS (Integrated Graduate/Student Systems) schema lineage inherited from the historical Student Systems product. In Oracle EBS 12.1.1 and 12.2.2 this object functions as a read-only reporting and integration surface over the student program attempt entity, presenting a denormalized row set suitable for concurrent programs, OBIEE/XML Publisher extracts, and inbound/outbound interface mappings.

The _SV suffix conventionally denotes a "seed view," indicating that the object is shipped as seed data and is not intended for direct DML by customers. Because the view selects ROWID as ROW_ID and exposes ORG_ID, it is multi-org aware and can be joined to operating unit contexts, though student records are typically filtered by business unit through the institution's own security model.

Underlying Base Objects

The view is defined over a single base table, IGS_EN_STDNT_PS_ATT_ALL. The _ALL suffix confirms the table is partitioned by operating unit (ORG_ID) and holds all organization rows; the view consequently exposes the complete data set without an ORG_ID predicate. The ETRM metadata lists no additional referenced base objects, and the view text is a straightforward column projection with no joins, unions, or scalar subqueries. All filtering, decoding, and derivation must therefore be supplied by the querying application.

Key Columns

Common Use Cases and Queries

Typical scenarios include identifying each student's primary program attempt for enrolment reporting, auditing attendance-mode distributions, and extracting lifecycle data into a data warehouse. A representative query filtering on the searched column is:

  • SELECT person_id, course_cd, version_number, primary_program_type, primary_prog_type_source FROM apps.igs_en_stdnt_ps_att_sv WHERE primary_program_type = 'PRIMARY' AND org_id = :org_id;
  • SELECT course_cd, attendance_mode, COUNT(*) FROM apps.igs_en_stdnt_ps_att_sv WHERE commencement_dt >= :from_date GROUP BY course_cd, attendance_mode;
  • SELECT person_id, key_program, derived_completion_yr FROM apps.igs_en_stdnt_ps_att_sv WHERE future_dated_trans_flag = 'Y';

Because the view performs no filtering, queries should always constrain ORG_ID, PERSON_ID, or a date range to avoid full-table scans against IGS_EN_STDNT_PS_ATT_ALL.