Search Results igs_ss_adm_appl_stg




Overview
Explore in AI Chat

Overview

The IGS_SS_ADM_APPL_STG table 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. As its description indicates, it stores data describing the admission of an applicant to an institution. The "STG" suffix typically denotes a staging or base transactional table, suggesting it serves as the primary repository for admission application records. Its role is central to the admissions lifecycle, capturing the foundational attributes of an application, which are then referenced and enriched by numerous related child tables throughout the application, evaluation, and decisioning processes.

Key Information Stored

The table's primary key is the SS_ADM_APPL_ID, a unique identifier for each application record. Based on the documented foreign key relationships, other critical columns include PERSON_ID, which links the application to the party (applicant) in the Trading Community Architecture (HZ_PARTIES). It stores key application parameters such as ADMISSION_APPLICATION_TYPE, ADMISSION_CAT (category), and S_ADM_PROCESS_TYPE. The table also tracks critical academic and administrative timelines through its links to the academic calendar (ACAD_CAL_TYPE, ACAD_CAL_SEQ_NUMBER) and admission calendar (ADM_CAL_TYPE, ADM_CAL_SEQ_NUMBER). Furthermore, it holds classification data like ENTRY_STATUS, ENTRY_LEVEL, and special grouping codes (SPCL_GRP_1, SPCL_GRP_2), which are validated against the IGS_AD_CODE_CLASSES lookup table.

Common Use Cases and Queries

This table is fundamental for admission reporting, applicant tracking, and data integration. Common operational and analytical queries include retrieving all applications for a specific admission cycle, identifying applications by applicant source (APP_SOURCE_ID), or listing applications for a particular entry level and status. A typical reporting query might join this table with HZ_PARTIES for applicant demographics and IGS_AD_PRCS_CAT_ALL for process category descriptions. For data migration or interface development, this table is often the target for loading new application data from external systems, or the source for extracting application records to downstream reporting warehouses. Sample SQL to find applications for a given admission calendar would be:

  • SELECT appl.SS_ADM_APPL_ID, party.party_name
  • FROM IGS_SS_ADM_APPL_STG appl, HZ_PARTIES party
  • WHERE appl.PERSON_ID = party.party_id
  • AND appl.ADM_CAL_TYPE = '<CALENDAR_TYPE>'
  • AND appl.ADM_CAL_SEQ_NUMBER = <SEQUENCE_NUMBER>;

Related Objects

The IGS_SS_ADM_APPL_STG table maintains extensive relationships within the Student System, acting as a central hub. It references several key master and lookup tables:

  • HZ_PARTIES via PERSON_ID (Applicant Master)
  • IGS_AD_SS_APPL_TYP via ADMISSION_APPLICATION_TYPE (Application Type)
  • IGS_CA_INST_ALL via ACAD_CAL_TYPE/SEQ and ADM_CAL_TYPE/SEQ (Calendar Instances)
  • IGS_AD_PRCS_CAT_ALL via ADMISSION_CAT and S_ADM_PROCESS_TYPE (Process Category)
  • IGS_AD_CODE_CLASSES via ENTRY_STATUS, ENTRY_LEVEL, SPCL_GRP_1, SPCL_GRP_2, and APP_SOURCE_ID (Classification Codes)

Conversely, it is the parent table for several supporting staging tables that hold detailed application components, all joined on SS_ADM_APPL_ID: