Results for “igs_ad_prd_ps_of_opt”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_PRD_PS_OF_OPT is a relationship table within the IGS (Student System) product family of Oracle E-Business Suite, documented as VALID in the IGS schema. Its stated purpose is to describe the relationship among admission periods, admission process types, admission categories, and program offering options. In practice, the table acts as a cross-referencing construct that allows an institution to control the admission configuration available for a specific academic program offering — that is, which admission calendar, admission category, admission process type, attendance characteristics, and location apply when an applicant is considered for a given program version.

Because the table is entirely composed of foreign key references that connect independent master entities (admission periods, offering options, attendance modes, attendance types, and locations), the heuristic Data Vault classification supplied in the metadata is link. This classification is a modeling suggestion rather than a physical attribute of the EBS table; it reflects the fact that the table represents an intersecting relationship among hubs rather than an entity with its own descriptive lifecycle.

Key Information Stored

The primary key, IGS_AD_PRD_PS_OF_OPT_PK, is a composite that spans the full business-key candidate set, and it is duplicated by the unique index IGS_AD_PRD_PS_OF_OPT_U1. The table carries 21 documented columns in the 12.1.1 ETRM schema.

Common Use Cases and Queries

Typical scenarios include validating that an admission period is properly wired to an offering option before opening applications, reporting which locations and attendance modes are permitted per program version, and diagnosing "no admission category available" errors during applicant intake.

A representative query joins the four principal masters:

  • SELECT o.ADM_CAL_TYPE, o.ADMISSION_CAT, o.S_ADMISSION_PROCESS_TYPE, o.COURSE_CD, o.VERSION_NUMBER, o.LOCATION_CD, o.ATTENDANCE_MODE FROM IGS.IGS_AD_PRD_PS_OF_OPT o WHERE o.COURSE_CD = :course AND o.ACAD_CAL_TYPE = :cal;
  • Left-outer joins to IGS_PS_OFR_ALL and IGS_AD_PRD_AD_PRC_CA confirm that every configured row resolves to a valid offering option and admission process-category combination.
  • Reporting on ROLLOVER_INCLUSION_IND flags rows requiring review before a rollover run.

Related Objects

  • IGS_AD_PRD_AD_PRC_CA — parent on ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE.
  • IGS_PS_OFR_ALL — parent on COURSE_CD, VERSION_NUMBER, ACAD_CAL_TYPE, SEQUENCE_NUMBER.
  • IGS_AD_LOCATION_ALL — parent on LOCATION_CD.
  • IGS_EN_ATD_MODE_ALL — parent on ATTENDANCE_MODE.
  • IGS_EN_ATD_TYPE_ALL — parent on ATTENDANCE_TYPE.

These relationships define the integrity envelope of the link; any delete or update on a parent master will be restricted while dependent rows exist here.