Search Results igs_ad_sbmao_fn_cttt




Overview
Explore in AI Chat

Overview

The table IGS_AD_SBMAO_FN_CTTT is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as a central repository for managing and storing detailed intake targets at the academic organizational unit level, segmented by specific funding sources and course type groups for defined submission periods. Its primary role is to support the complex planning and reporting requirements associated with student admissions and government or institutional funding submissions. By linking targets to a submission control record, funding source, course type group, and target type, it enables institutions to model, track, and report on planned student intake against multiple dimensions as part of formalized submission cycles.

Key Information Stored

The table's composite primary key defines the granularity of the data it holds, consisting of seven columns that together form a unique record. The key columns are SUBMISSION_YR and SUBMISSION_NUMBER, which anchor the target to a specific submission period controlled by IGS_ST_GVT_SPSHT_CTL_ALL. The ORG_UNIT_CD and OU_START_DT identify the academic organizational unit. The FUNDING_SOURCE column links to IGS_FI_FUND_SRC_ALL, while COURSE_TYPE_GROUP_CD references IGS_PS_TYPE_GRP to categorize the courses. Finally, INTAKE_TARGET_TYPE references IGS_AD_INTAK_TRG_TYP to classify the nature of the target (e.g., planned, confirmed). Beyond these key columns, the table typically stores the actual target numeric values, creation dates, and last update information, which are standard for EBS tables.

Common Use Cases and Queries

This table is integral to admission planning and funding-related reporting. Common operational use cases include the setup and maintenance of annual intake targets for different faculties and funding bodies, and the generation of internal and statutory reports on planned versus actual admissions. A typical analytical query might involve joining this table with its referenced lookups to produce a detailed target summary report for a specific submission period.

Sample SQL Pattern:

SELECT t.submission_yr,
       t.submission_number,
       t.org_unit_cd,
       t.funding_source,
       tg.description AS course_type_group,
       t.intake_target_type,
       t.target_number -- (example non-key column)
FROM igs.igs_ad_sbmao_fn_cttt t,
     igs.igs_ps_type_grp tg,
     igs.igs_fi_fund_src_all fs
WHERE t.course_type_group_cd = tg.course_type_group_cd
  AND t.funding_source = fs.funding_source
  AND t.submission_yr = :p_sub_yr
  AND t.submission_number = :p_sub_num
ORDER BY t.org_unit_cd, t.funding_source;

Related Objects

The IGS_AD_SBMAO_FN_CTTT table maintains critical referential integrity through foreign key relationships with several master tables in the Student System. These documented relationships are essential for data validation and constructing accurate joins in reports and interfaces.

  • IGS_ST_GVT_SPSHT_CTL_ALL: Provides the controlling submission period via the SUBMISSION_YR and SUBMISSION_NUMBER columns.
  • IGS_FI_FUND_SRC_ALL: Validates the FUNDING_SOURCE code used to categorize the financial source of the intake target.
  • IGS_PS_TYPE_GRP: Validates the COURSE_TYPE_GROUP_CD, grouping related course types for target setting.
  • IGS_AD_INTAK_TRG_TYP: Validates the INTAKE_TARGET_TYPE, defining the classification of the target figure.
  • Table: IGS_AD_SBMAO_FN_CTTT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_SBMAO_FN_CTTT,  object_name:IGS_AD_SBMAO_FN_CTTT,  status:VALID,  product: IGS - Student System ,  description: Describes submission period academic organizational unit targets ,  implementation_dba_data: IGS.IGS_AD_SBMAO_FN_CTTT , 

  • 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_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_PS_TYPE_GRP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_TYPE_GRP,  object_name:IGS_PS_TYPE_GRP,  status:VALID,  product: IGS - Student System ,  description: This table describes a program grouping of program types relating to the way DEET funds (approved EFTSU) programs. E.g. Higher Degree by Research, Higher Degree by Coursework, Other Postgraduate. ,  implementation_dba_data: IGS.IGS_PS_TYPE_GRP , 

  • Table: IGS_AD_INTAK_TRG_TYP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_INTAK_TRG_TYP,  object_name:IGS_AD_INTAK_TRG_TYP,  status:VALID,  product: IGS - Student System ,  description: Describes intake targets that may be required by institution, faculty, program, and program entry points for a submission period ,  implementation_dba_data: IGS.IGS_AD_INTAK_TRG_TYP , 

  • View: IGS_AD_SBMAO_FN_CTTT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AD_SBMAO_FN_CTTT_V,  object_name:IGS_AD_SBMAO_FN_CTTT_V,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_AD_SBMAO_FN_CTTT_V ,