Search Results igs_ss_admappl_pgm

Overview

The IGS_SS_ADMAPPL_PGM table is a core data repository within the Oracle E-Business Suite Student System (IGS) module. As indicated by its documented description, it serves the critical function of storing all details pertaining to admission applications received online. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to managing the student admissions lifecycle, acting as a central point for capturing and linking application data submitted through online portals. Its role is to persist application information, enabling subsequent processes such as application review, program assignment, decision management, and enrollment.

Key Information Stored

While the provided metadata does not list specific column details, the table's primary key is documented as SS_ADMAPPL_PGM_ID. Based on its function and standard Student System design, this table typically stores data that links an admission application to a specific academic program. Key information likely includes a unique application identifier, a program code or identifier, the application status for that program, the applied intake or term, and relevant dates (application date, decision date). It acts as a junction table that connects a base admission application header to the specific programs a candidate has applied for, allowing for scenarios where a single application is submitted for multiple programs.

Common Use Cases and Queries

This table is central to admissions operations and reporting. Common use cases include generating lists of applicants for a specific program, tracking application statuses by program, and analyzing application volumes. A typical reporting query would join this table to the main application header table and program master data. For example, to retrieve all active applications for a given program for the current cycle, a query pattern might be: SELECT appl.applicant_number, pgm.program_code, app_pgm.status FROM igs_ss_admappl_pgm app_pgm JOIN igs_ss_adm_appl appl ON app_pgm.adm_appl_id = appl.adm_appl_id JOIN igs_ps_program pgm ON app_pgm.program_id = pgm.program_id WHERE app_pgm.program_code = '&PROGRAM' AND app_pgm.admission_appl_number IN (SELECT admission_appl_number FROM igs_ss_adm_appl WHERE adm_cal_type = '&CYCLE'). Data from this table is also crucial for feeding admissions dashboards and workflow notifications.

Related Objects

The primary documented relationship for IGS_SS_ADMAPPL_PGM is its primary key constraint, IGS_SS_ADMAPPL_PGM_PK, on the column SS_ADMAPPL_PGM_ID. This unique identifier is almost certainly referenced by foreign keys in other Student System tables. While specific foreign key constraints are not listed in the provided metadata, standard implementation suggests this table has a critical relationship with the main admission application header table (likely named IGS_SS_ADM_APPL or similar), joined via an ADM_APPL_ID or ADMISSION_APPL_NUMBER column. It would also relate to the program definition table (e.g., IGS_PS_PROGRAM) via a PROGRAM_ID or PROGRAM_CD column. These relationships enable the complete view of an applicant's profile and their chosen programs.