Search Results cp_attempted

Overview

The view IGS_AD_TUNDT_INT is a critical interface object within the Oracle E-Business Suite (EBS) Student System (IGS), specifically for versions 12.1.1 and 12.2.2. It serves as a staging and validation point for detailed unit (or course) data being processed during admissions or academic term setup. The view is built upon the underlying table IGS_AD_TUNDT_INT_ALL, which is a multi-organization (Multi-Org) enabled table designed to hold interface records for unit details. Its primary role is to facilitate the batch import and error-checking of unit-level academic information, such as grades and credit points, before this data is formally posted to the core student records. The "INT" suffix commonly denotes an interface table or view, indicating its function in the data conversion and migration workflows of the EBS Student System.

Key Information Stored

The view exposes columns essential for tracking unit performance and managing the interface process. Key data elements include identifiers like UNIT_DETAILS_ID, INTERFACE_TERM_UNITDTLS_ID, and INTERFACE_TERM_DTLS_ID, which link these unit details to broader term records. Academic information is captured through UNIT, UNIT_NAME, UNIT_DIFFICULTY, CP_ATTEMPTED (Credit Points Attempted), CP_EARNED, GRADE, and UNIT_GRADE_POINTS. The interface control and status are managed by columns such as STATUS, ERROR_CODE, and MATCH_IND, which indicate processing success, failure reasons, and duplicate record matching. Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID) and the ORG_ID for multi-org partitioning are also present.

Common Use Cases and Queries

This view is predominantly used in scenarios involving the bulk loading of student academic history or term enrollment details from external systems. A typical use case is verifying records pending import or identifying errors for correction. Common SQL queries include extracting records with a specific status for review or joining with related interface tables to validate data integrity before submission to the core system.

• Reviewing pending interface records: SELECT unit_name, grade, status, error_code FROM igs_ad_tundt_int WHERE status = 'ERROR' AND org_id = :p_org_id;
• Validating unit details for a specific term interface batch: SELECT unit, unit_name, cp_attempted, cp_earned FROM igs_ad_tundt_int WHERE interface_term_dtls_id = :p_term_id AND match_ind = 'N';

Related Objects

Based on the column structure, IGS_AD_TUNDT_INT is intrinsically related to other interface and core tables within the Student System. The primary relationship is with its source table, IGS_AD_TUNDT_INT_ALL. The columns INTERFACE_TERM_DTLS_ID and DUP_TERM_UNITDTLS_ID suggest foreign key relationships to a parent term details interface table, likely named IGS_AD_TRM_INT_ALL or similar. The UNIT column may reference a core unit definition table, such as IGS_PS_UNIT_VER. The view is part of a larger data flow where processed records are ultimately moved to production tables storing finalized student unit attempts and grades.