Search Results igs_ad_sbmao_fn_amtt




Overview
Explore in AI Chat

Overview

The IGS_AD_SBMAO_FN_AMTT table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a detailed repository for submission period academic organizational unit targets. Specifically, it stores granular targets related to student intake, segmented by key institutional dimensions such as organizational unit, funding source, and attendance mode. This table is critical for managing and reporting on institutional planning and government submissions, particularly in higher education contexts where funding and reporting are tied to specific enrollment targets. Its role is to provide the foundational data structure for tracking planned versus actual intake figures against defined submission periods and organizational hierarchies.

Key Information Stored

The table's structure is defined by a composite primary key that ensures uniqueness for each target record. The key columns, which also represent the main dimensions for analysis, are SUBMISSION_YR and SUBMISSION_NUMBER (linking to the submission control), ORG_UNIT_CD and OU_START_DT (identifying the academic organizational unit), FUNDING_SOURCE, ATTENDANCE_MODE, and INTAKE_TARGET_TYPE. While the provided metadata focuses on these key identifiers, the table typically contains additional numeric columns (not explicitly listed but implied by the table's purpose) to store the actual target amounts or counts for the specified combination. The foreign key constraints enforce data integrity by ensuring valid codes are used from related setup tables.

Common Use Cases and Queries

This table is central to institutional reporting and planning processes. A primary use case is generating reports for government funding bodies that require breakdowns of planned student intake by faculty, funding type (e.g., government-subsidized, full-fee), and study mode (e.g., full-time, part-time). Administrators use this data to monitor target achievement and perform variance analysis. Common SQL queries involve joining this table with its referenced setup tables to translate codes into meaningful descriptions for reports.

For example, a query to list all targets for a specific submission period might follow this pattern:

  • SELECT sbm.submission_yr, sbm.submission_number, ou.org_unit_cd, fs.funding_source, am.attendance_mode, sbm.target_amount FROM igs_ad_sbmao_fn_amtt sbm JOIN igs_fi_fund_src_all fs ON sbm.funding_source = fs.funding_source JOIN igs_en_atd_mode_all am ON sbm.attendance_mode = am.attendance_mode WHERE sbm.submission_yr = '2024';

Related Objects

The IGS_AD_SBMAO_FN_AMTT table maintains strict referential integrity with several key setup and control tables in the Student System, as documented by its foreign keys. The primary key is enforced by the IGS_AD_SBMAO_FN_AMTT_PK index. The table references the following objects directly:

These relationships are essential for maintaining consistent code values across the module and for enabling comprehensive reporting that includes descriptive information from the parent tables.