Search Results igs_ad_sbmps_fn_ittt

Overview

The table IGS_AD_SBMPS_FN_ITTT is a core data structure within the Oracle E-Business Suite's Student System (IGS) module. It serves a critical function in managing student admissions and funding planning. Specifically, this table stores detailed intake target types and their associated numerical targets for a specific funding source, linked to a program version within a defined submission period. It acts as a child table, providing granular breakdowns of the broader funding targets established at the submission level. Its role is essential for institutions to plan, track, and report on enrollment targets across different student categories and funding streams, supporting compliance and strategic resource allocation.

Key Information Stored

The table's composite primary key defines its unique granularity and consists of seven columns: SUBMISSION_YR, SUBMISSION_NUMBER, COURSE_CD, CRV_VERSION_NUMBER, FUNDING_SOURCE, SEQUENCE_NUMBER, and INTAKE_TARGET_TYPE. This structure ties each target record to a specific submission year and number, a precise course code and version, a particular funding source, and a sequence identifier from its parent table. The most significant data column is INTAKE_TARGET_TYPE, which holds a code classifying the type of intake target (e.g., domestic, international, specific equity group). This column is validated via a foreign key to the IGS_AD_INTAK_TRG_TYP table. The table itself is designed to store the associated target figure for each combination, though the exact column name for the target value is implied by the context of the foreign key relationship to IGS_AD_SBM_PS_FNTRGT.

Common Use Cases and Queries

This table is central to reporting and operational processes related to admissions targets. A common use case is generating detailed reports that break down total program funding targets by intake category for audit or planning purposes. Administrators may query this table to validate that targets for all required intake types have been defined for a submission or to analyze historical target allocations. A typical SQL query would join this table to its parent funding target table and the intake target type description table. For example:

• SELECT sft.submission_yr, sft.course_cd, itt.intake_target_type, itt_desc.description FROM igs_ad_sbmps_fn_ittt itt JOIN igs_ad_sbm_ps_fntrgt sft ON itt.submission_yr = sft.submission_yr AND itt.submission_number = sft.submission_number AND itt.course_cd = sft.course_cd AND itt.crv_version_number = sft.crv_version_number AND itt.funding_source = sft.funding_source AND itt.sequence_number = sft.sequence_number JOIN igs_ad_intak_trg_typ itt_desc ON itt.intake_target_type = itt_desc.intake_target_type WHERE sft.submission_yr = '2024';

Related Objects

The IGS_AD_SBMPS_FN_ITTT table maintains defined foreign key relationships with two primary tables, establishing its place in the data model.

• IGS_AD_SBM_PS_FNTRGT (Submission Period Program Version Funding Source Target): This is the direct parent table. The foreign key links on the columns SUBMISSION_YR, SUBMISSION_NUMBER, COURSE_CD, CRV_VERSION_NUMBER, FUNDING_SOURCE, and SEQUENCE_NUMBER. This relationship ensures every intake target detail is associated with a valid higher-level funding target record.
• IGS_AD_INTAK_TRG_TYP (Intake Target Type): This is a reference table for valid intake target type codes. The foreign key on the INTAKE_TARGET_TYPE column ensures data integrity by restricting entries to predefined, meaningful categories.