Results for “offset_days”

9 results




Overview
Explore in AI Chat

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

Overview

IGS_RE_DFLT_MS_SET_ALL is a transactional configuration table in the Oracle EBS IGS — Student System product (also marketed as Oracle Student System / Oracle Higher Education). It resides in the IGS schema and is documented as VALID in both release 12.1.1 and 12.2.2. The entity describes the default milestones for a research course: it defines, per course and version, the milestone types that a research student is expected to satisfy, together with the attendance context in which each milestone applies and the ordered sequence in which the milestones occur.

Functionally, the table acts as a setup or reference configuration layer. Institutions maintaining research degree programmes (for example, PhD or Masters by research) use these records so the system can automatically generate expected milestone schedules when a student enrols on a research course version. Because the milestone definitions are keyed to a course version rather than to an individual student, the table is a reusable template rather than a perishable transactional record.

From a Data Vault modelling perspective, the heuristic classification mined from the foreign-key structure is link. This is a modelling suggestion only: the table's integration-style all-suffix naming and its role in connecting a research course version to attendance type, milestone type and offset information are consistent with a link construct bridging several business keys, rather than a pure hub (single business key) or satellite (descriptive payload attached to one parent key).

Key Information Stored

The table exposes 14 documented columns in the 12.1.1 physical schema. The most important are:

  • COURSE_CD and VERSION_NUMBER — identify the research course and its version to which the default milestone set applies. These reference IGS_PS_VER_ALL.
  • MILESTONE_TYPE — the category of research milestone (for example proposal, progress review, thesis submission) being defaulted.
  • ATTENDANCE_TYPE — the attendance context in which the milestone applies; validated against IGS_EN_ATD_TYPE_ALL.
  • SEQUENCE_NUMBER — the ordinal position of the milestone within the set for a given course/version/attendance combination, controlling presentation and scheduling order.
  • ATTENDANCE_MODE — the mode of study (such as full-time or part-time) associated with the milestone definition.
  • OFFSET_DAYS — the relative number of days used to derive an expected milestone date, typically from a reference point such as course commencement.
  • COMMENTS — free-text administrative notes attached to the default milestone line.
  • ORG_ID — the operating unit / organisation identifier supporting multi-organisation access control (MOAC).
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO audit columns recording insert and update provenance.

The surrogate primary key is the unique, system-generated identifier IGS_RE_DFLT_MS_SET_PK. The business-key candidate is the unique index IGS_RE_DFLT_MS_SET_ALL_U1 over (COURSE_CD, VERSION_NUMBER, MILESTONE_TYPE, ATTENDANCE_TYPE, SEQUENCE_NUMBER). Note that ATTENDANCE_MODE, OFFSET_DAYS, COMMENTS, ORG_ID and the audit columns are descriptive attributes rather than key components.

Common Use Cases and Queries

Typical scenarios include verifying the default milestone setup for a research course version before enrolment, auditing completeness of milestone sequences, and reporting expected milestone schedules by offset.

  • List default milestones for a course version: SELECT course_cd, version_number, milestone_type, attendance_type, sequence_number, offset_days FROM igs_re_dflt_ms_set_all WHERE course_cd = :course AND version_number = :version AND org_id = :org ORDER BY sequence_number;
  • Check for gaps in sequence numbering per course/version to ensure orderly milestone progression.
  • Cross-validate attendance context by joining ATTENDANCE_TYPE to IGS_EN_ATD_TYPE_ALL and confirming the course version exists in IGS_PS_VER_ALL.
  • Derive expected dates by adding OFFSET_DAYS to the student's commencement or milestone reference date in downstream scheduling reports.

Related Objects

  • IGS_PS_VER_ALL — joined on COURSE_CD and VERSION_NUMBER; the parent course version definition.
  • IGS_EN_ATD_TYPE_ALL — joined on ATTENDANCE_TYPE; supplies valid attendance type values.
  • IGS_RE_DFLT_MS_SET_PK / _U1 — the primary key and unique index enforcing the business key.
  • Research milestone / student milestone tables in the IGS research (RE) family — consume these defaults when generating per-student milestone instances.
  • Student enrolment and research candidature tables — reference the course version to which these defaults apply.