Search Results igs_re_schl_type_pk

Overview

The IGS_RE_SCHL_TYPE_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) that defines and stores user-defined scholarship types. Its primary role is to serve as a master reference table, establishing the valid categories of scholarships that can be requested by applicants during the admissions process. This table supports multi-organization access control through the "_ALL" suffix and the inclusion of an ORG_ID column, allowing scholarship type definitions to be shared or partitioned across different operating units. By centralizing this definition, it ensures data integrity and consistency for all scholarship-related transactions and records throughout the application lifecycle.

Key Information Stored

The table's structure is designed to capture essential details for classifying scholarships. Its primary key is the SCHOLARSHIP_TYPE column, which uniquely identifies each type code. Based on standard EBS patterns and the provided relationship data, other critical columns include PERSON_ID_FROM, which acts as a foreign key to the HZ_PARTIES table to potentially link to a sponsoring or awarding organization. The ORG_ID column is mandatory for multi-org functionality, determining the operating unit context. Additional descriptive columns, while not explicitly listed in the brief metadata, typically accompany such setups and may include fields for an active/inactive status, a description, creation and last update dates, and relevant user IDs for auditing purposes.

Common Use Cases and Queries

This table is fundamental for setting up and maintaining the scholarship framework within the Student System. Common use cases include the administrative configuration of available scholarship options for admission applications, the generation of validation lists for data entry forms, and serving as a dimension table for scholarship analysis and reporting. A typical query would involve joining with the HZ_PARTIES table to retrieve a readable list of scholarship types with their associated sponsor names. For reporting on scholarships awarded, a fundamental join to the IGS_RE_SCHOLARSHIP_ALL table is required.

• Retrieve Active Scholarship Types for an OU: SELECT scholarship_type, description FROM igs_re_schl_type_all WHERE org_id = :p_org_id AND (status = 'A' OR similar active indicator) ORDER BY 1;
• List Scholarship Types with Sponsor Details: SELECT st.scholarship_type, st.description, hp.party_name FROM igs_re_schl_type_all st, hz_parties hp WHERE st.person_id_from = hp.party_id AND st.org_id = :p_org_id;

Related Objects

The IGS_RE_SCHL_TYPE_ALL table maintains defined relationships with other key entities in the Student System, as documented in the provided metadata.

• Referenced Foreign Key: The table references HZ_PARTIES via the column IGS_RE_SCHL_TYPE_ALL.PERSON_ID_FROM. This links a scholarship type to a sponsoring organization or person defined in the Trading Community Architecture.
• Referencing Foreign Key: The table is referenced by IGS_RE_SCHOLARSHIP_ALL via the column IGS_RE_SCHOLARSHIP_ALL.SCHOLARSHIP_TYPE. This is the primary relationship, enforcing that every scholarship record must be of a type defined in this master table.
• Primary Key: The table's primary key constraint, IGS_RE_SCHL_TYPE_PK, is defined on the SCHOLARSHIP_TYPE column, guaranteeing its uniqueness.