Search Results igs_ps_type_grp




Overview
Explore in AI Chat

Overview

The IGS_PS_TYPE_GRP table is a core reference table within the Oracle E-Business Suite Student System (IGS). It defines logical groupings for different program (or course) types, primarily for funding and reporting purposes. Its central role is to categorize academic programs according to funding models, such as those defined by the Australian Department of Employment, Education, Training and Youth Affairs (DEET). By associating individual program types with a broader group, the system enables standardized financial analysis, government reporting, and the allocation of approved Equivalent Full-Time Student Unit (EFTSU) funding across related programs.

Key Information Stored

The table's primary function is to store a controlled list of program type group codes and their descriptions. The key column is COURSE_TYPE_GROUP_CD, which serves as the unique identifier for each funding category. A corresponding DESCRIPTION field would typically provide the full name of the group, such as "Higher Degree by Research" or "Other Postgraduate." While the explicit column list is not detailed in the provided metadata, the table's definition as a reference entity implies it contains standard audit and control columns (e.g., CREATION_DATE, LAST_UPDATE_DATE) in addition to the core code and description.

Common Use Cases and Queries

This table is essential for generating funding and statistical reports that aggregate data at the program type group level. Administrators use it to ensure program types are correctly categorized for compliance reporting. A common query involves joining this table to the program type master to list all categorized types.

  • Listing All Program Type Groups: SELECT course_type_group_cd, description FROM igs.igs_ps_type_grp ORDER BY 1;
  • Finding Programs in a Specific Funding Group: SELECT pt.course_cd, pt.version_number FROM igs.igs_ps_type_all pt JOIN igs.igs_ps_type_grp ptg ON pt.course_type_group_cd = ptg.course_type_group_cd WHERE ptg.course_type_group_cd = 'HDR';
  • Reporting EFTSU by Funding Category: This table would be joined through IGS_PS_TYPE_ALL to student enrollment and unit attempt tables to summarize total funded load by group.

Related Objects

The IGS_PS_TYPE_GRP table is a parent reference for several other key entities in the Student System, as defined by its foreign key relationships.

  • IGS_PS_TYPE_ALL: This is the primary child table. Each program type record can be linked to a funding group via the foreign key IGS_PS_TYPE_ALL.COURSE_TYPE_GROUP_CD referencing IGS_PS_TYPE_GRP.COURSE_TYPE_GROUP_CD.
  • IGS_AD_SBMAO_FN_CTTT: This table, related to admissions and funding, also references the program type group using the column IGS_AD_SBMAO_FN_CTTT.COURSE_TYPE_GROUP_CD. This indicates the group code is used in broader financial and admissions configuration contexts.

The primary key constraint IGS_PS_TYPE_GRP_PK on COURSE_TYPE_GROUP_CD enforces the integrity of these relationships.