Search Results igs_ad_sbm_ps_fntrgt




Overview
Explore in AI Chat

Overview

The table IGS_AD_SBM_PS_FNTRGT is a data structure within the Oracle E-Business Suite (EBS) Student System (IGS), specifically noted as obsolete. Its primary function is to store detailed funding target information associated with program versions for specific submission periods. The table acts as a junction, linking a program version (course) and a funding source to various optional components—such as attendance mode, attendance type, location, and unit sets—for which enrollment or funding targets are defined. This data is critical for managing and reporting on government or institutional funding submissions, where targets must be broken down by specific academic and demographic criteria.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships that enforce data integrity. The primary key uniquely identifies a record through a combination of submission identifiers, program details, and a funding sequence: SUBMISSION_YR, SUBMISSION_NUMBER, COURSE_CD, CRV_VERSION_NUMBER, FUNDING_SOURCE, and SEQUENCE_NUMBER. Key columns include FUNDING_SOURCE, which links to the institution's valid funding sources, and optional component columns like ATTENDANCE_MODE, ATTENDANCE_TYPE, LOCATION_CD, and UNIT_SET_CD/US_VERSION_NUMBER. These optional columns allow for the definition of granular targets for specific student cohorts within the broader program and funding source context.

Common Use Cases and Queries

The primary use case for this table is the generation and management of funding submission reports, such as government statistical returns. Administrators would query this table to validate or report on the defined targets for a specific submission period. A typical query might join to related master tables to produce a readable report. For example:

  • Listing all funding targets for a specific submission: SELECT sft.submission_yr, sft.submission_number, sft.course_cd, fs.funding_source_name, sft.attendance_mode FROM igs_ad_sbm_ps_fntrgt sft JOIN igs_fi_fund_src_all fs ON sft.funding_source = fs.funding_source WHERE sft.submission_yr = :p_yr AND sft.submission_number = :p_num;
  • Identifying targets for a particular program and funding source to reconcile against actual enrollment data.
  • Due to its obsolete status, direct interaction may be limited to historical data analysis or supporting legacy processes during an upgrade or data migration.

Related Objects

IGS_AD_SBM_PS_FNTRGT is centrally connected to several master tables and one child table, forming a key part of the student funding data model. The documented foreign key relationships are as follows: