Results for “igs_ps_pat_of_study”

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

Overview

IGS_PS_PAT_OF_STUDY is a core table within the Oracle E-Business Suite Student System (IGS) product family, present in both release 12.1.1 and 12.2.2. The table describes a pattern of study — a defined attendance structure, location, and admission arrangement — that applies to a specific program offering (course version). It functions as a template that institutions configure to represent the different ways a student may undertake a program, such as full-time on-campus delivery, part-time evening attendance, or a distance-learning variant.

The entity operates within the academic structure layer of the Student System, sitting directly beneath the program offering definition (IGS_PS_OFR_ALL) and above the pattern-of-study period detail (IGS_PS_PAT_STUDY_PRD). Its database owner is the IGS schema, and the object carries a VALID status in the ETRM repository.

From a dimensional modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table's primary key depends on COURSE_CD and VERSION_NUMBER, which are inherited from the parent program offering, making it a descriptive child of that entity rather than an independent hub. Modelers building a Data Vault representation would typically treat it as a satellite attached to the program offering hub, with its own sequence-based grain.

Key Information Stored

The table contains nineteen documented columns. The primary key, IGS_PS_PAT_OF_STUDY_PK, is a composite business key comprising COURSE_CD, VERSION_NUMBER, CAL_TYPE, and SEQUENCE_NUMBER. A unique index, IGS_PS_PAT_OF_STUDY_U1, mirrors the same four columns, confirming that this combination — not a system-generated surrogate — uniquely identifies each pattern-of-study record.

• COURSE_CD, VERSION_NUMBER — Identify the parent program offering to which the pattern applies. These are the leading key columns and the principal join path to IGS_PS_OFR_ALL.
• CAL_TYPE — The calendar type (academic period structure) in which the pattern operates, joining to IGS_CA_INST_ALL.
• SEQUENCE_NUMBER — Distinguishes multiple patterns defined for the same program offering and calendar type.
• LOCATION_CD — The delivery location for the pattern, referencing IGS_AD_LOCATION_ALL.
• ATTENDANCE_MODE, ATTENDANCE_TYPE — Describe how the student attends, referencing IGS_EN_ATD_MODE_ALL and IGS_EN_ATD_TYPE_ALL respectively.
• ADMISSION_CAL_TYPE, ADMISSION_CAT — The admission calendar and admission category governing entry into this pattern, referencing IGS_CA_TYPE and IGS_AD_CAT_ALL.
• UNIT_SET_CD, ACAD_PERD_UNIT_SET — The unit set and academic period unit set associated with the pattern's structure.
• APRVD_CI_SEQUENCE_NUMBER — Links to the approved calendar instance sequence within the calendar hierarchy.
• NUMBER_OF_PERIODS — The count of academic periods comprising the pattern.
• ALWAYS_PRE_ENROL_IND — A flag indicating whether pre-enrolment always applies to the pattern.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing record creation and modification metadata.

Common Use Cases and Queries

The most frequent reporting requirement is to list all defined patterns for a given program offering, typically filtered by calendar type. A representative query joins the table to its parent offering to resolve the program title:

• SELECT p.COURSE_CD, p.VERSION_NUMBER, p.CAL_TYPE, p.SEQUENCE_NUMBER, p.LOCATION_CD, p.ATTENDANCE_TYPE FROM IGS_PS_PAT_OF_STUDY p WHERE p.COURSE_CD = :course AND p.VERSION_NUMBER = :version;
• Admissions reporting commonly retrieves patterns by ADMISSION_CAT and ADMISSION_CAL_TYPE to determine which study options a category of applicant may select.
• Delivery-mode analytics group records by ATTENDANCE_MODE and ATTENDANCE_TYPE to profile an institution's teaching provision across locations.
• Period-level detail is retrieved by joining downward to IGS_PS_PAT_STUDY_PRD on COURSE_CD, VERSION_NUMBER, CAL_TYPE, and the shared sequence column to expand each pattern into its constituent periods.
• Data-quality checks validate that every pattern resolves to a valid location and calendar type by left-joining IGS_AD_LOCATION_ALL and IGS_CA_INST_ALL and identifying null matches.

Related Objects

The following objects participate in the documented referential relationships around IGS_PS_PAT_OF_STUDY:

• IGS_PS_OFR_ALL — The parent program offering; joined on COURSE_CD and VERSION_NUMBER. Defines the program to which each pattern belongs.
• IGS_PS_PAT_STUDY_PRD — The child period table; references this table via COURSE_CD, VERSION_NUMBER, CAL_TYPE, and POS_SEQUENCE_NUMBER, providing the period-by-period breakdown of each pattern.
• IGS_CA_INST_ALL — Calendar instance master; joined on CAL_TYPE and APRVD_CI_SEQUENCE_NUMBER to resolve the approved calendar instance.
• IGS_CA_TYPE — Calendar type reference used by ADMISSION_CAL_TYPE.
• IGS_AD_CAT_ALL — Admission category reference for ADMISSION_CAT.
• IGS_AD_LOCATION_ALL — Location master for LOCATION_CD.
• IGS_EN_ATD_MODE_ALL and IGS_EN_ATD_TYPE_ALL — Attendance mode and type reference tables supplying valid delivery classifications.