Search Results igs_ps_govt_type




Overview
Explore in AI Chat

Overview

The IGS_PS_GOVT_TYPE table is a core reference entity within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for government-defined classifications of academic programs. Its primary role is to provide a standardized set of program types, such as "Bachelor Degree," "Associate Degree," or "Diploma," as mandated or recognized by a governmental education authority. This table is essential for ensuring institutional reporting compliance, aligning internal academic structures with external regulatory frameworks, and facilitating accurate data exchange with government bodies. It acts as a key lookup table that links the institution's internal program definitions to the official, externally recognized categories.

Key Information Stored

The table's structure is designed to store a controlled list of government program types. While the full column list is not detailed in the provided metadata, the primary key column is explicitly documented. The central column is GOVT_COURSE_TYPE, which is the table's primary key. This column stores the unique code representing a specific government program classification. The table likely contains additional descriptive columns, such as a description field (e.g., GOVT_COURSE_TYPE_DESC) to provide the full name of the type, and potentially columns for effective dating, active/inactive status, and other control attributes common to EBS reference tables. The integrity of the GOVT_COURSE_TYPE code is enforced by the primary key constraint IGS_PS_GOVT_TYPE_PK.

Common Use Cases and Queries

This table is primarily used in regulatory reporting, data validation, and program setup. A common operational use case is during the creation or maintenance of an academic program (IGS_PS_TYPE), where a user must select the appropriate government classification from a list populated by this table. For reporting, it is frequently joined to program tables to categorize enrollment, completion, or funding data according to government standards. A typical query would involve joining IGS_PS_GOVT_TYPE to the program definition table to generate a report for a statutory body.

  • Sample Query: To list all active academic programs with their corresponding government type description, a SQL statement would join via the documented foreign key: SELECT t.COURSE_CD, t.VERSION_NUMBER, g.GOVT_COURSE_TYPE, g.DESCRIPTION FROM IGS_PS_TYPE_ALL t, IGS_PS_GOVT_TYPE g WHERE t.GOVT_COURSE_TYPE = g.GOVT_COURSE_TYPE;
  • Validation: The table is used to constrain LOV values in forms, ensuring that only valid government types can be assigned to a program.

Related Objects

The IGS_PS_GOVT_TYPE table has a direct and critical relationship with the core academic program entity. As documented in the provided foreign key metadata:

  • IGS_PS_TYPE_ALL: This table stores the detailed definitions of all academic programs (courses). It contains a column named GOVT_COURSE_TYPE, which is a foreign key (FK) referencing the primary key (GOVT_COURSE_TYPE) of the IGS_PS_GOVT_TYPE table. This relationship enforces that every program record must have a government type that exists in the master IGS_PS_GOVT_TYPE lookup table. The join condition for any query involving these two entities is IGS_PS_TYPE_ALL.GOVT_COURSE_TYPE = IGS_PS_GOVT_TYPE.GOVT_COURSE_TYPE.

This relationship is fundamental, making IGS_PS_GOVT_TYPE a parent table to IGS_PS_TYPE_ALL for the government classification attribute.