Search Results igs_ps_pat_study_unt




Overview
Explore in AI Chat

Overview

The IGS_PS_PAT_STUDY_UNT table is a core data object within the Oracle E-Business Suite Student System (IGS) module for releases 12.1.1 and 12.2.2. It functions as a detailed component of the academic structure by defining the specific units (subjects) that constitute a pattern of study for a given period. A pattern of study period is a sub-component of a program's overall study pattern, which outlines the planned sequence of academic workload. This table is therefore essential for modeling curriculum requirements, enabling the system to track and manage the precise units a student is expected or permitted to undertake during a specific phase of their academic program.

Key Information Stored

The table stores the mapping between a unit and its containing study pattern period. Its composite primary key precisely identifies a single unit's placement within the broader academic structure. The key columns are COURSE_CD and VERSION_NUMBER (identifying the program), CAL_TYPE (the calendar type for the period), POS_SEQUENCE_NUMBER (identifying the pattern of study), POSP_SEQUENCE_NUMBER (identifying the period within that pattern), and SEQUENCE_NUMBER (uniquely identifying the unit record within that period). Critical descriptive columns include UNIT_CD, which holds the code of the specific academic unit, and UNIT_CLASS, which defines the class or type of that unit (e.g., lecture, lab). The UNIT_LOCATION_CD column specifies the intended delivery location for the unit.

Common Use Cases and Queries

This table is central to curriculum planning, enrollment validation, and academic advising reports. Administrators use it to verify that a student's enrolled units align with their program's prescribed study pattern. A common reporting need is to list all units within a specific study pattern period for audit or planning purposes. A typical query would join to parent tables to retrieve meaningful descriptions.

  • Sample Query: Retrieving unit details for a specific program and pattern.
    SELECT unt.unit_cd, unt.unit_class, loc.location_name
    FROM igs_ps_pat_study_unt unt,
         igs_ad_location_all loc
    WHERE unt.course_cd = 'BSC001'
      AND unt.version_number = 1
      AND unt.cal_type = 'SEMESTER'
      AND unt.pos_sequence_number = 1
      AND unt.unit_location_cd = loc.location_cd(+);

Related Objects

The IGS_PS_PAT_STUDY_UNT table maintains defined foreign key relationships with several other core entities in the Student System, ensuring referential integrity for curriculum data.

  • IGS_PS_PAT_STUDY_PRD: This is the direct parent table. The foreign key on (COURSE_CD, VERSION_NUMBER, CAL_TYPE, POS_SEQUENCE_NUMBER, POSP_SEQUENCE_NUMBER) links a unit record to its specific containing study pattern period.
  • IGS_PS_UNIT: The foreign key on UNIT_CD validates that the unit specified in the pattern is a valid, defined unit in the system's catalog.
  • IGS_AS_UNIT_CLASS_ALL: The foreign key on UNIT_CLASS ensures the unit class code is valid.
  • IGS_AD_LOCATION_ALL: The foreign key on UNIT_LOCATION_CD links to the institutional locations where the unit may be delivered.