Search Results igs_ad_sbm_ps_fntrgt

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:

Referenced Master Tables (Parent):
- IGS_ST_GVT_SPSHT_CTL_ALL via SUBMISSION_YR, SUBMISSION_NUMBER (controls the submission period).
- IGS_PS_VER_ALL via COURSE_CD, CRV_VERSION_NUMBER (defines the program version).
- IGS_FI_FUND_SRC_ALL via FUNDING_SOURCE (defines the funding source).
- IGS_EN_ATD_MODE_ALL via ATTENDANCE_MODE.
- IGS_EN_ATD_TYPE_ALL via ATTENDANCE_TYPE.
- IGS_AD_LOCATION_ALL via LOCATION_CD.
- IGS_EN_UNIT_SET_ALL via UNIT_SET_CD, US_VERSION_NUMBER.
Referencing Table (Child):
- IGS_AD_SBMPS_FN_ITTT references this table's primary key columns, suggesting it holds more granular itemized target or transaction data linked to each high-level funding target record.

Table: IGS_AD_SBM_PS_FNTRGT 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_AD_SBM_PS_FNTRGT, object_name:IGS_AD_SBM_PS_FNTRGT, status:VALID, product: IGS - Student System , description: Holds program version funding source and optional components that have one or more targets for a submission period , implementation_dba_data: IGS.IGS_AD_SBM_PS_FNTRGT ,
Table: IGS_ST_GVT_SPSHT_CTL_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_ST_GVT_SPSHT_CTL_ALL, object_name:IGS_ST_GVT_SPSHT_CTL_ALL, status:VALID, product: IGS - Student System , description: This entity describes the characteristics of each government submission and is used to control the various snapshot and extract processes. There is a version for each government submission. Example 1995 submission 1. , implementation_dba_data: IGS.IGS_ST_GVT_SPSHT_CTL_ALL ,
Table: IGS_AD_SBMPS_FN_ITTT 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_AD_SBMPS_FN_ITTT, object_name:IGS_AD_SBMPS_FN_ITTT, status:VALID, product: IGS - Student System , description: Holds intake target types and associated targets for submission period program version funding source. , implementation_dba_data: IGS.IGS_AD_SBMPS_FN_ITTT ,
Table: IGS_FI_FUND_SRC_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_FI_FUND_SRC_ALL, object_name:IGS_FI_FUND_SRC_ALL, status:VALID, product: IGS - Student System , description: This entity describes the university set of funding sources. , implementation_dba_data: IGS.IGS_FI_FUND_SRC_ALL ,
Table: IGS_EN_ATD_TYPE_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_EN_ATD_TYPE_ALL, object_name:IGS_EN_ATD_TYPE_ALL, status:VALID, product: IGS - Student System , description: Describes available university program attendance types , implementation_dba_data: IGS.IGS_EN_ATD_TYPE_ALL ,
Table: IGS_EN_ATD_MODE_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_EN_ATD_MODE_ALL, object_name:IGS_EN_ATD_MODE_ALL, status:VALID, product: IGS - Student System , description: Describes available university program attendance modes , implementation_dba_data: IGS.IGS_EN_ATD_MODE_ALL ,
Table: IGS_AD_LOCATION_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_AD_LOCATION_ALL, object_name:IGS_AD_LOCATION_ALL, status:VALID, product: IGS - Student System , description: Describes available geographic locations at which programs and units may be offered or taught , implementation_dba_data: IGS.IGS_AD_LOCATION_ALL ,
Table: IGS_EN_UNIT_SET_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_EN_UNIT_SET_ALL, object_name:IGS_EN_UNIT_SET_ALL, status:VALID, product: IGS - Student System , description: This field describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules which govern its completion via the Rules Sub-system. , implementation_dba_data: IGS.IGS_EN_UNIT_SET_ALL ,
Table: IGS_PS_VER_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PS_VER_ALL, object_name:IGS_PS_VER_ALL, status:VALID, product: IGS - Student System , description: This entity describes the versions of programs which are offered by the university, covering both award and non-award programs. , implementation_dba_data: IGS.IGS_PS_VER_ALL ,