Search Results igs_ad_intak_trg_typ




Overview
Explore in AI Chat

Overview

The IGS_AD_INTAK_TRG_TYP table is a core reference table within the Oracle E-Business Suite Student System (IGS) module. It functions as a master list for categorizing different types of intake targets. These targets represent planned enrollment figures that an educational institution may establish at various organizational levels—such as the institution itself, a specific faculty, a program, or a program entry point—for a defined submission period. The table's primary role is to provide a standardized set of intake target types, ensuring data integrity and consistency across the complex admissions and enrollment planning processes in EBS releases 12.1.1 and 12.2.2. It acts as a parent entity, with its key referenced by numerous transactional tables that store the actual target figures and associated financial data.

Key Information Stored

While the provided metadata does not list all columns, the structure centers on the primary key, INTAKE_TARGET_TYPE. This column stores the unique code or identifier for a specific category of intake target. Based on standard EBS design patterns for such reference tables, it likely includes descriptive columns such as a meaningful name (e.g., TARGET_TYPE_NAME), an effective start and end date for the validity of the type, and columns for who created and last updated the record. The table's description indicates its purpose is to "describe" these targets, implying it holds the definitional attributes for each target type used throughout the system.

Common Use Cases and Queries

This table is primarily used in two contexts: setup and reporting. During system configuration, administrators populate this table with the institution's specific intake target categories (e.g., "Government Funded," "International," "Scholarship"). In operational and analytical scenarios, it is joined to transactional data to categorize and report on enrollment targets. A common query would involve joining this table to the IGS_AD_SBMINTAK_TRGT table to retrieve all defined targets of a specific type for a submission period. For example, a report analyzing "International" intake targets across different programs would use a SQL pattern similar to: SELECT tgt.*, typ.TARGET_TYPE_NAME FROM IGS_AD_SBMINTAK_TRGT tgt, IGS_AD_INTAK_TRG_TYP typ WHERE tgt.INTAKE_TARGET_TYPE = typ.INTAKE_TARGET_TYPE AND typ.INTAKE_TARGET_TYPE = 'INTERNATIONAL';

Related Objects

The IGS_AD_INTAK_TRG_TYP table is a central reference point, as evidenced by its multiple foreign key relationships. The following tables reference its primary key, INTAKE_TARGET_TYPE, to categorize their respective data:

All joins to this reference table would typically use the syntax: `[Related_Table].INTAKE_TARGET_TYPE = IGS_AD_INTAK_TRG_TYP.INTAKE_TARGET_TYPE`.