Results for “course_group_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_PS_GRP_TYPE table is a reference (lookup) entity within the Oracle E-Business Suite Student System (IGS) product family. It defines the available types of program groups that can be established on the system, for example Equivalents, available double programs, and common entrance requirements. Rather than storing individual group memberships, this table provides the controlled vocabulary — the classification values — that govern how program groups are categorized. It is owned by the IGS schema and carries a VALID status in both the 12.1.1 and 12.2.2 releases.

From a data-modeling perspective, the metadata classifies IGS_PS_GRP_TYPE as hub-leaning. In Data Vault terms, this suggests treating it as a hub entity: its primary key holds a stable, unique business key around which downstream links and satellites would be organized. In practice the table functions as a relatively static code table, and referencing rows in IGS_PS_GRP_ALL act as dependent structures tied back to this hub.

Key Information Stored

The table is documented with nine physical columns. The most operationally significant are outlined below.

• COURSE_GROUP_TYPE — the primary key column (defined by constraint IGS_PS_GRP_TYPE_PK) and also the single business-key candidate, mirrored by the unique index IGS_PS_GRP_TYPE_U1. It holds the code that uniquely identifies each program group type.
• DESCRIPTION — the human-readable label describing the group type, such as "Equivalents" or "Common Entrance Requirements."
• S_COURSE_GROUP_TYPE — a secondary or system-defined attribute associated with the course group type, conventionally used to hold an alternate or translated code value in Student System configurations.
• CLOSED_IND — an indicator flagging whether the group type is closed and therefore unavailable for new assignments.
• CREATED_BY, CREATION_DATE — audit columns capturing who created the row and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns recording the most recent modification, its author, timestamp, and session login identifier.

Because the primary key and the unique index both cover COURSE_GROUP_TYPE, that single column serves simultaneously as the surrogate-style identifier and as the natural business key for this entity.

Common Use Cases and Queries

Typical usage centers on validating, reporting, and joining group-type codes against the program group data that references them. In reporting, the table is joined to IGS_PS_GRP_ALL to resolve descriptive text for grouped program structures.

• Retrieve all active group types: SELECT COURSE_GROUP_TYPE, DESCRIPTION FROM IGS.IGS_PS_GRP_TYPE WHERE CLOSED_IND = 'N';
• Resolve descriptions for groups: SELECT a.COURSE_GROUP_TYPE, t.DESCRIPTION FROM IGS.IGS_PS_GRP_ALL a JOIN IGS.IGS_PS_GRP_TYPE t ON a.COURSE_GROUP_TYPE = t.COURSE_GROUP_TYPE;
• Identify orphaned or unclassified groups lacking a valid type definition.
• Feed validation logic and value sets in concurrent programs or OAF-based Student System pages.

Related Objects

The documented foreign-key relationship links this entity to the program group table, with dependent reference tables and views following the same join column.

• IGS_PS_GRP_ALL — the principal dependent table; its COURSE_GROUP_TYPE column is a foreign key to IGS_PS_GRP_TYPE.COURSE_GROUP_TYPE.
• IGS_PS_GRP_TYPE_PK — the primary key constraint enforcing uniqueness of COURSE_GROUP_TYPE.
• IGS_PS_GRP_TYPE_U1 — the unique index on COURSE_GROUP_TYPE supporting business-key integrity.
• Student System views and concurrent processes that surface or validate program group types.
• Program group membership and versioning objects that ultimately depend on IGS_PS_GRP_ALL and therefore transitively on this type definition.