Search Results igs_as_course_type_all_pk

Overview

The IGS_AS_COURSE_TYPE_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a junction table that defines the relationship between assessment items and the types of academic courses to which they are applicable. Its primary role is to support the precise allocation of assessment items to students by linking a specific assessment to one or more course types. This ensures that assessment rules and items are correctly associated with the appropriate academic programs during enrollment and grading processes. As an "ALL" table, it is designed to support the multi-organization architecture of Oracle EBS, allowing data to be partitioned by operating unit.

Key Information Stored

The table's structure is focused on establishing the link between an assessment item and a course type. The two critical columns are the foreign keys that form the table's composite primary key. The ASS_ID column stores the unique identifier for an assessment item, linking directly to the IGS_AS_ASSESSMNT_ITM_ALL table. The COURSE_TYPE column stores the code for a specific type of academic program or course, linking to the IGS_PS_TYPE_ALL table. Together, these columns enforce a rule that a given assessment item can be associated with a particular course type only once. The table may also contain standard WHO columns (e.g., CREATED_BY, CREATION_DATE) for auditing, though these are not detailed in the provided metadata.

Common Use Cases and Queries

A primary use case is validating and determining which assessment items are relevant for a student enrolled in a specific course type. This is critical during processes like gradebook setup, final grade calculation, and the generation of assessment schedules. System administrators may query this table to audit or maintain assessment-to-course mappings. A typical reporting query would join this table to the assessment item and course type descriptions to produce a human-readable list.

• Sample Query: SELECT ict.course_type, iai.ass_title FROM igs_as_course_type_all ict JOIN igs_as_assessmnt_itm_all iai ON ict.ass_id = iai.ass_id WHERE iai.ass_status = 'ACTIVE';
• Administrative Use: Identifying all course types associated with a specific assessment item for troubleshooting allocation issues.
• Configuration Use: When defining a new assessment item, this table is populated to specify the target course types.

Related Objects

The IGS_AS_COURSE_TYPE_ALL table sits at the intersection of two key master data entities in the Student System, as defined by its documented foreign key relationships.

• IGS_AS_ASSESSMNT_ITM_ALL: This is the parent table for assessment item definitions. The relationship is maintained via the ASS_ID column. An assessment item record must exist before it can be linked to a course type here.
• IGS_PS_TYPE_ALL: This is the parent table for course or program type definitions. The relationship is maintained via the COURSE_TYPE column. A valid course type code must exist before it can be associated with an assessment item.

The table's primary key constraint, IGS_AS_COURSE_TYPE_ALL_PK, ensures data integrity for these relationships. Any application logic or API that creates or manages assessment allocations will interact with this table to establish or query these critical links.