Search Results igs_pe_src_types_uk

Overview

The IGS_PE_SRC_TYPES_ALL table is a core reference table within the Oracle E-Business Suite's Student System (IGS), which is noted as obsolete in the provided ETRM documentation. Its primary role is to serve as a master repository for all configured data source types within the student information system. A data source type is a classification that defines the origin or category of data entering the system, such as an online application, a manual data entry process, or an external system feed. This table provides a standardized list of valid source types, ensuring data integrity and consistency across various student-related transactional and interface processes. The '_ALL' suffix indicates it is a multi-organization enabled table, designed to store data specific to different operating units within a single installation.

Key Information Stored

Based on the provided metadata, the table's structure is defined by its primary keys and foreign key relationships. The two documented primary keys indicate the critical columns for uniquely identifying a record. The SOURCE_TYPE_ID column serves as the primary surrogate key (IGS_PE_SRC_TYPES_PK), a unique numeric identifier for each source type. The SOURCE_TYPE column is also defined as a unique key (IGS_PE_SRC_TYPES_UK and SRC_TYP), representing the actual code or short name for the source type. A third column, ADMISSION_CAT, is identified as a foreign key column referencing the IGS_AD_CAT_ALL table, linking source types to specific admission categories for further process control and validation.

Common Use Cases and Queries

This table is primarily used in setup, validation, and reporting scenarios. Administrators would query this table to view or maintain the list of valid source types available for configuration in other parts of the Student System. A common technical use case is to validate incoming interface data or to enrich transactional reports with source type descriptions. For instance, when processing application interface records, a validation routine would verify that the source type code on the incoming record exists in IGS_PE_SRC_TYPES_ALL. A typical reporting query might join this table to interface control or statistics tables to analyze data volume by source.

• Sample Query to List All Source Types: SELECT source_type_id, source_type FROM igs_pe_src_types_all WHERE NVL(end_date_active, SYSDATE) >= SYSDATE ORDER BY source_type;
• Validation in an Interface Program: The existence of a provided source type code would be checked via a SELECT statement against SOURCE_TYPE before processing interface records.

Related Objects

The ETRM metadata clearly outlines this table's central role in the data model through its foreign key relationships. It is referenced by several key interface and control tables in the Admissions (IGS_AD) and Recruiting (IGS_RC, IGR) modules.

• Referenced by this table (Outgoing FK): IGS_AD_CAT_ALL via the ADMISSION_CAT column.
• Referencing this table (Incoming FKs):
  • IGS_AD_SOURCE_CAT_ALL.SOURCE_TYPE_ID
  • IGS_AD_INTERFACE_CTL.SOURCE_TYPE_ID
  • IGS_AD_I_ENTRY_STATS.IMP_SOURCE_TYPE_ID
  • IGR_I_INQUIRY_TYPES.IMP_SOURCE_TYPE_ID
  • IGS_RC_I_ENT_STATS.IMP_SOURCE_TYPE_ID

These relationships demonstrate that IGS_PE_SRC_TYPES_ALL acts as a parent table for controlling and categorizing data within admissions source categories, interface control settings, and imported entry statistics for both admissions and recruiting.