Search Results igs_ad_pecrs_ofop_dt




Overview
Explore in AI Chat

Overview

The table IGS_AD_PECRS_OFOP_DT is a core data structure within the Oracle E-Business Suite's now-obsolete Student System (IGS). It functioned as a junction table to define and manage the specific program (course) offering options that were available for selection during a defined admission period. Its primary role was to establish a detailed link between an admission calendar, an admission category, and the precise academic offerings—including version, attendance mode, and location—that an applicant could apply to. The metadata explicitly notes this table was "Not implemented in this database," indicating it may have been part of a data model that was not deployed in some instances or is a remnant of a legacy design.

Key Information Stored

The table's composite primary key reveals the granularity of the data it was designed to hold. It uniquely identifies a record through a combination of admission period details and a specific offering instance. The key columns are ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT, DT_ALIAS, DAI_SEQUENCE_NUMBER, and SEQUENCE_NUMBER. Important descriptive columns include COURSE_CD and VERSION_NUMBER to specify the academic program, and ATTENDANCE_MODE, ATTENDANCE_TYPE, and LOCATION_CD to define the modality and place of study. The ACAD_CAL_TYPE column would typically store the academic calendar type for the offering.

Common Use Cases and Queries

This table was central to configuring the application pathways within the student lifecycle. Common operational and reporting use cases would have included generating a list of all available programs for a given admission intake period, validating applicant selections against configured options, and setting up admission rules. A typical query would join this table to related master tables to produce a readable catalog of offerings.

  • Sample Query: Retrieving all configured program options for a specific admission period and category. 
    SELECT pecrs.course_cd,
       pecrs.version_number,
       pecrs.attendance_mode,
       pecrs.location_cd,
       ofr.title
FROM igs_ad_pecrs_ofop_dt pecrs
JOIN igs_ps_ofr_all ofr
  ON pecrs.course_cd = ofr.course_cd
 AND pecrs.version_number = ofr.version_number
WHERE pecrs.adm_cal_type = '&ADM_CAL_TYPE'
  AND pecrs.adm_ci_sequence_number = &CI_SEQ_NUM
  AND pecrs.admission_cat = '&ADM_CAT';

Related Objects

As indicated by its foreign key constraints, IGS_AD_PECRS_OFOP_DT is deeply integrated with the Student System's foundation tables. Key related objects include: