Search Results igs_ad_prd_ps_of_opt




Overview
Explore in AI Chat

Overview

The IGS_AD_PRD_PS_OF_OPT table is a core data entity within the Oracle E-Business Suite Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. Its primary function is to define and manage the permissible relationships between key components of the admissions lifecycle. As documented, it describes the relationship among admission periods, admission process types, admission categories, and program offering options. This table acts as a critical junction, enforcing business rules that dictate which specific program offerings (courses) can be applied to, under which admission categories and processes, and within a defined admission calendar period. It is essential for configuring and controlling the valid pathways an applicant can take through the admissions system.

Key Information Stored

The table's composite primary key defines the unique relationship it stores. The key columns are ADM_CAL_TYPE and ADM_CI_SEQUENCE_NUMBER (identifying the admission period), ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, COURSE_CD and VERSION_NUMBER (identifying the program), and ACAD_CAL_TYPE and SEQUENCE_NUMBER (identifying the specific offering of that program). Beyond these identifiers, the table typically includes foreign key columns that further refine the offering options available for admission. Based on the provided foreign key metadata, these include ATTENDANCE_MODE, ATTENDANCE_TYPE, and LOCATION_CD. These columns allow the admissions configuration to specify not just the program, but also the permissible modes of study, types of attendance, and locations for each combination of admission period, category, and process.

Common Use Cases and Queries

A primary use case is validating an applicant's program choice during the application entry process. The system queries this table to ensure the selected program offering, attendance mode, location, and admission category are valid for the current admission period and process. Another key use is in generating administrative reports to audit or list all configured admission pathways for a given term or program. A common query pattern involves joining to related master tables to retrieve descriptive names. For example:

  • To list all valid program offerings for a specific admission period and category: SELECT poo.* FROM igs_ad_prd_ps_of_opt poo WHERE poo.adm_cal_type = :p_cal_type AND poo.adm_ci_sequence_number = :p_sequence AND poo.admission_cat = :p_adm_cat;
  • To report on full configuration details, a query would join to IGS_PS_OFR_ALL for the program title, IGS_AD_PRD_AD_PRC_CA for the admission period description, and IGS_EN_ATD_MODE_ALL for the attendance mode description.

Related Objects

The table maintains integral foreign key relationships with several master tables, ensuring referential integrity and enabling data validation. As per the documented metadata:

  • IGS_AD_PRD_AD_PRC_CA: Links to the admission period, category, and process type master. Joined via ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT, and S_ADMISSION_PROCESS_TYPE.
  • IGS_PS_OFR_ALL: Links to the Program Offering (course version and offering) master. Joined via COURSE_CD, VERSION_NUMBER, ACAD_CAL_TYPE, and SEQUENCE_NUMBER.
  • IGS_EN_ATD_MODE_ALL: Links to the valid Attendance Modes. Joined via the ATTENDANCE_MODE column.
  • IGS_EN_ATD_TYPE_ALL: Links to the valid Attendance Types. Joined via the ATTENDANCE_TYPE column.
  • IGS_AD_LOCATION_ALL: Links to the valid Admission Locations. Joined via the LOCATION_CD column.