Search Results igs_en_stdnt_ps_att_all

Overview

The table IGS_EN_STDNT_PS_ATT_ALL is a core data entity within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It serves as the definitive record of a student's attempt to study a specific academic program or course offered by the institution. This table is central to the student lifecycle, tracking enrollment, progression, and completion statuses. As an "ALL" table, it is designed to store data for multiple business groups or operating units, supporting the multi-org architecture of Oracle EBS. Its comprehensive foreign key relationships integrate it with critical modules including Admissions, Curriculum, Finance, and Assessments, making it a pivotal hub for student academic data.

Key Information Stored

The table's primary key uniquely identifies a student's course attempt through the combination of PERSON_ID and COURSE_CD. Beyond these identifiers, the table stores vital academic and administrative details. Key columns include VERSION_NUMBER for the course version, CAL_TYPE and LOCATION_CD for the offering calendar and site, and ATTENDANCE_MODE and ATTENDANCE_TYPE (with derived counterparts) to define the study pattern. Critical status and date columns track the student's progression, such as COMMENCEMENT_DT, DISCONTINUED_DT, and DISCONTINUATION_REASON_CD. The table also holds financial and administrative references like FEE_CAT, FUNDING_SOURCE, COO_ID (Course Offering Option), and links to the admission application via ADM_ADMISSION_APPL_NUMBER and related fields.

Common Use Cases and Queries

This table is fundamental for reporting and processes related to student enrollment, academic standing, and institutional reporting. Common use cases include generating enrollment verification reports, tracking student progression and attrition rates, and interfacing data with financial aid or billing systems. A typical query might retrieve all active student attempts for a given course and version. For example:

• SELECT person_id, course_cd, version_number, commencement_dt, derived_att_mode FROM igs_en_stdnt_ps_att_all WHERE course_cd = 'BSC-CS' AND discontinued_dt IS NULL;

Another critical pattern involves joining to related tables to analyze discontinuation reasons or to validate admission application data against the actual enrolled attempt, supporting audit and compliance reporting.

Related Objects

The table maintains extensive foreign key relationships, integrating deeply with the Student System and adjacent modules. Key documented relationships include:

• IGS_PS_VER_ALL: Validates the COURSE_CD and VERSION_NUMBER combination for the program structure.
• IGS_PS_OFR_OPT_ALL: Linked via COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE to define the specific offering option, and separately via COO_ID.
• IGS_AD_PS_APPL_ALL / IGS_AD_PS_APPL_INST_ALL: Ties the student attempt back to its source admission application using PERSON_ID, ADM_ADMISSION_APPL_NUMBER, ADM_NOMINATED_COURSE_CD, and ADM_SEQUENCE_NUMBER.
• IGS_EN_ATD_MODE_ALL & IGS_EN_ATD_TYPE_ALL: Validate the derived attendance mode (DERIVED_ATT_MODE) and type (DERIVED_ATT_TYPE).
• IGS_EN_DCNT_REASONCD_ALL: Validates the DISCONTINUATION_REASON_CD.
• IGS_FI_FEE_CAT_ALL & IGS_FI_FUND_SRC_ALL: Validate the FEE_CAT and FUNDING_SOURCE codes for financial processing.
• IGS_CA_INST_ALL: Validates the catalog calendar (CATALOG_CAL_TYPE, CATALOG_SEQ_NUM).
• IGS_AS_ANON_ID_PS & IGS_AS_ANON_ID_US: Support assessment anonymization processes linked to the student's program attempt.