Search Results igs_ad_gen_013




Overview
Explore in AI Chat

Overview

IGS_PS_OFR_PAT_APCOOD_V is an Oracle E-Business Suite view owned by the APPS schema and defined within the Student System (IGS) product family, specifically the Admissions (AD) and Program Structures (PS) modules. It presents a flattened, denormalized recordset that joins offered program/attendance patterns to their associated admission categories and admission process types. The view is intended for reporting and integration, exposing only those offered course patterns that are actively flagged as offered (offered_ind = 'Y') and valid entry points (entry_point_ind = 'Y'). Because it filters through institutional admission-processing rules (via the IGS_AD_GEN_013 package functions), the view returns a curated set of course/version/calendar combinations that a prospective applicant is actually eligible to be admitted into. In EBS 12.1.1 and 12.2.2, this view is commonly consumed by admissions enquiry forms, self-service applicant pages, and downstream interfaces that need to enumerate admissible programs.

Underlying Base Objects

The view is built over three documented base tables joined through the institution calendar relationship:

  • IGS_PS_OFR_PAT (aliased COP) — the offered pattern table holding course code, version, calendar type, location, attendance mode/type, and the offered and entry-point indicators.
  • IGS_CA_INST_REL (aliased CIR) — the calendar instance relationship table linking a superior calendar instance to a subordinate calendar instance, used here to bridge the offered pattern's calendar to the admission calendar.
  • IGS_AD_PRD_AD_PRC_CA (aliased APAPC) — the admission period/admission process calendar table providing the admission calendar type, CI sequence number, admission category, and admission process type.

A correlated subquery over IGS_PS_OF_OPT_AD_CAT further constrains the result, invoking the IGS_AD_GEN_013.adms_get_coo_crv and IGS_AD_GEN_013.adms_get_coo_admperd functions. These calls — the source of the "igs_ad_gen_013" search term — enforce whether the course/version and the admission period are valid for the admission process type. No base objects are separately documented in ETRM metadata beyond those implied by the view text.

Key Columns

  • course_cd, version_number — identifiers of the offered course and its version.
  • cal_type, location_cd, attendance_mode, attendance_type — the delivery attributes of the offered pattern.
  • adm_cal_type, adm_ci_sequence_number — the admission calendar type and instance sequence driving the admission window.
  • admission_cat — the admission category (e.g., undergraduate, postgraduate) applicable to the record.
  • s_admission_process_type — the admission process type used to validate eligibility through IGS_AD_GEN_013.
  • created_by, creation_date, last_updated_by, last_update_date, last_update_login — standard auditing columns inherited from IGS_PS_OFR_PAT.

Common Use Cases and Queries

Typical uses include feeding admissions eligibility enquiries, populating applicant self-service lists, and validating program availability before application submission. Because all institutional rule logic is encapsulated in the view, callers avoid re-implementing the IGS_AD_GEN_013 checks.

List all admissible patterns for a given course:

  • SELECT course_cd, version_number, cal_type, location_cd, attendance_mode, attendance_type, admission_cat, s_admission_process_type FROM apps.igs_ps_ofr_pat_apcood_v WHERE course_cd = :course_cd;

Filter by admission category and process type:

  • SELECT * FROM apps.igs_ps_ofr_pat_apcood_v WHERE admission_cat = :adm_cat AND s_admission_process_type = :proc_type;

Enumerate distinct admission calendars offered for a location:

  • SELECT DISTINCT adm_cal_type, adm_ci_sequence_number, location_cd FROM apps.igs_ps_ofr_pat_apcood_v WHERE location_cd = :loc_cd ORDER BY adm_cal_type;

Because the view applies row-level admission rules at query time, filters on course, version, location, and admission category should be pushed into the WHERE clause to minimize execution of the IGS_AD_GEN_013 function calls and improve performance on large datasets.