Search Results igs_ad_sbmao_fn_uitt_pk

Overview

The table IGS_AD_SBMAO_FN_UITT is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the IGS (Student System) product family, which is documented as obsolete. Its core function is to describe academic organizational unit targets, likely in the context of government submissions, funding, and intake planning for educational institutions. The table's design, featuring a complex composite primary key and multiple foreign key relationships, indicates it serves as a detailed intersection table. It links key entities such as submission controls, organizational units, funding sources, and course levels to define specific intake targets. Notably, the provided metadata explicitly states it is "Not implemented in this database," suggesting it may represent a legacy or template structure not deployed in standard installations, which is a critical consideration for consultants and DBAs.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of seven columns that together uniquely identify a target record. These columns are SUBMISSION_YR and SUBMISSION_NUMBER, which link to a government spreadsheet control record; ORG_UNIT_CD and OU_START_DT, identifying the academic organizational unit; FUNDING_SOURCE; UNIT_INT_COURSE_LEVEL_CD, defining the unit or course level; and INTAKE_TARGET_TYPE. This combination allows the system to store granular targets—for example, the number of government-funded postgraduate students targeted for intake into a specific department for a given annual submission. The table acts as a child to the entities referenced by its foreign keys, storing the specific target values or related attributes in its non-key columns.

Common Use Cases and Queries

Given its role, primary use cases would revolve around reporting and data validation for institutional planning and compliance reporting. Analysts might query this table to aggregate intake targets by funding source or organizational unit, or to reconcile submitted targets against actual enrollment data. A typical reporting query would join this table to its parent tables to retrieve descriptive information. For instance:

• Retrieving Detailed Target Records: SELECT uitt.*, ctl.SUBMISSION_NAME, src.FUNDING_SOURCE_NAME FROM IGS_AD_SBMAO_FN_UITT uitt JOIN IGS_ST_GVT_SPSHT_CTL_ALL ctl ON uitt.SUBMISSION_YR = ctl.SUBMISSION_YR AND uitt.SUBMISSION_NUMBER = ctl.SUBMISSION_NUMBER JOIN IGS_FI_FUND_SRC_ALL src ON uitt.FUNDING_SOURCE = src.FUNDING_SOURCE WHERE uitt.ORG_UNIT_CD = :p_org_unit;
• Data Integrity Validation: Queries would be used to identify orphaned records where foreign key relationships are broken, which is especially pertinent if the table is not actively implemented or maintained.

Related Objects

The table IGS_AD_SBMAO_FN_UITT is centrally connected to several master tables in the Student System via foreign key constraints, as documented in the ETRM metadata. These relationships are fundamental to its integrity and meaning:

• IGS_ST_GVT_SPSHT_CTL_ALL: Linked via SUBMISSION_YR and SUBMISSION_NUMBER. This is the parent table controlling the government submission context.
• IGS_FI_FUND_SRC_ALL: Linked via FUNDING_SOURCE. This reference validates the financial source of the intake target.
• IGS_AD_INTAK_TRG_TYP: Linked via INTAKE_TARGET_TYPE. This defines the category or type of the intake target.
• IGS_PS_UNIT_INT_LVL: Linked via UNIT_INT_COURSE_LEVEL_CD. This reference table defines the academic level (e.g., undergraduate, postgraduate) of the unit or course associated with the target.

The table's primary key, IGS_AD_SBMAO_FN_UITT_PK, is referenced by these foreign keys. There is no metadata indicating other tables that have a foreign key pointing to this table, suggesting it is primarily a detail or transactional table.