Search Results igs_ad_sbm_aou_fndtt_pk

Overview

The IGS_AD_SBM_AOU_FNDTT table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designed for managing government or regulatory reporting related to student admissions. Its primary function is to store submission period targets, which are typically the planned or allocated intake figures for specific academic organizational units, broken down by funding source and target type for a given reporting cycle. This table plays a critical role in enabling institutions to plan, track, and report on student intake against established targets, ensuring compliance with external funding and reporting requirements in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's composite primary key defines the granularity of the target data it holds. Each record is uniquely identified by the combination of the submission year (SUBMISSION_YR) and number (SUBMISSION_NUMBER), the academic organizational unit code (ORG_UNIT_CD) and its start date (OU_START_DT), the FUNDING_SOURCE, and the INTAKE_TARGET_TYPE. This structure allows an institution to define multiple targets for the same organizational unit within a submission period, differentiated by how the student is funded (e.g., government-funded, self-funded) and the type of target (e.g., domestic, international). The table likely contains additional columns to store the actual target numeric values and related control information, though the specific column list beyond the key fields is not detailed in the provided metadata.

Common Use Cases and Queries

This table is central to submission-related reporting and validation processes. A common use case involves generating summary reports of planned intake for a specific submission period to review against actual application numbers. Administrators may also query this table to validate data before finalizing a government submission. A typical analytical query would join this table with its referenced lookup tables to produce a readable report.

Sample Query Pattern:
SELECT sbm.SUBMISSION_YR, sbm.ORG_UNIT_CD, fs.FUNDING_SOURCE_NAME, itt.TARGET_TYPE_NAME, sbm.TARGET_NUMBER
FROM IGS_AD_SBM_AOU_FNDTT sbm,
IGS_FI_FUND_SRC_ALL fs,
IGS_AD_INTAK_TRG_TYP itt
WHERE sbm.FUNDING_SOURCE = fs.FUNDING_SOURCE
AND sbm.INTAKE_TARGET_TYPE = itt.INTAKE_TARGET_TYPE
AND sbm.SUBMISSION_YR = :p_sub_yr
AND sbm.SUBMISSION_NUMBER = :p_sub_num;


Related Objects

The integrity and meaning of the data in IGS_AD_SBM_AOU_FNDTT are enforced and defined through its relationships with other key tables in the Student System, as documented by its foreign key constraints.

• IGS_ST_GVT_SPSHT_CTL_ALL: This table controls the government spreadsheet submission cycle. The foreign key from SUBMISSION_YR and SUBMISSION_NUMBER ensures that every target record is associated with a valid, defined submission period.
• IGS_FI_FUND_SRC_ALL: This table holds valid funding sources. The foreign key on FUNDING_SOURCE ensures that the target is linked to an established financial source within the system.
• IGS_AD_INTAK_TRG_TYP: This lookup table defines the types of intake targets (e.g., "Planned," "Approved," "Maximum"). The foreign key on INTAKE_TARGET_TYPE categorizes the nature of the target figure stored.

The table's primary key, IGS_AD_SBM_AOU_FNDTT_PK, is also likely referenced by other child tables or views that store more detailed data related to these high-level targets.