Results for “igs_ps_coo_ad_unit_s_u1”

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

Overview

IGS_PS_COO_AD_UNIT_S is a legacy Student System (IGS) table in Oracle EBS 12.1.1 and 12.2.2 that describes the admission categories assigned to a program offering option unit set. It sits within the IGS product family, which underpins the Oracle Student System academic structure used by higher-education institutions for managing program offerings, course versions, calendar types, attendance modes, and unit sets. The entity maps admission categories to a combination of course and unit-set attributes so that admission rules can be evaluated per offering option.

It should be noted that this object is flagged as obsolete and is documented as "Not implemented in this database" in the current ETRM metadata. Consequently, it may exist only in earlier releases or in schemas that have not been upgraded, and it should not be assumed present in all 12.1.1 / 12.2.2 environments. Where present, the heuristic Data Vault classification mined from the foreign-key structure suggests this table behaves as a link entity, connecting admission categories with unit set information rather than acting as a standalone hub or descriptive satellite. This classification should be treated as a modeling suggestion only.

Key Information Stored

The physical schema documented for this table carries 14 columns and a composite primary key (IGS_PS_COO_AD_UNIT_S_PK). The most significant columns are:

• COURSE_CD – the course code identifying the program offering option context.
• CRV_VERSION_NUMBER – the course version number, qualifying COURSE_CD to a specific version.
• CAL_TYPE – the calendar type (for example, academic or teaching calendar).
• LOCATION_CD – the location code where the offering is delivered.
• ATTENDANCE_MODE – the mode of attendance (for example, full-time or part-time).
• ATTENDANCE_TYPE – the attendance type associated with the offering.
• ADMISSION_CAT – the admission category assigned to the unit set.
• UNIT_SET_CD – the unit set code being associated.
• US_VERSION_NUMBER – the unit set version number qualifying UNIT_SET_CD.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard EBS audit (WHO) columns.

The table does not use a single-column surrogate key. Instead, the primary key is the full business-key composite of COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, ADMISSION_CAT, UNIT_SET_CD, and US_VERSION_NUMBER. The unique index IGS_PS_COO_AD_UNIT_S_U1 mirrors this same set of columns, confirming it as the business-key candidate.

Common Use Cases and Queries

Typical usage revolves around determining which admission categories apply to a given program offering option unit set, and conversely which unit sets are governed by a particular admission category. A common query pattern joins this table to IGS_PS_OF_OPT_AD_CAT and IGS_EN_UNIT_SET_ALL:

• Report all admission categories for a course/version and unit set combination, filtering on COURSE_CD, UNIT_SET_CD, and version numbers.
• Identify unit sets associated with a specific ADMISSION_CAT for admissions processing or validation rules.
• Audit historical mappings using the CREATION_DATE and LAST_UPDATE_DATE columns to track when admission category assignments changed.
• Cross-check attendance mode and location applicability when configuring offering options.

Because the object is obsolete, migration or data-cleansing scripts are often written to extract legacy rows for conversion into current structures, selecting distinct COURSE_CD and UNIT_SET_CD values for reconciliation.

Related Objects

The foreign-key relationships documented for this table reference the following objects:

• IGS_PS_OF_OPT_AD_CAT – referenced via COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, and ADMISSION_CAT; holds program offering option admission category data.
• IGS_EN_UNIT_SET_ALL – referenced via UNIT_SET_CD and US_VERSION_NUMBER; holds unit set definitions and versions.

These two parent tables provide the principal join paths. Related IGS tables such as program offering option and course version entities are often used alongside this object to supply descriptive context for reporting, though the FK metadata above identifies only the two referenced tables as directly documented dependencies.