Results for “igs_re_dflt_ms_set_all_u1”

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

Overview

IGS.IGS_RE_DFLT_MS_SET_ALL is a transactional table in the Oracle E-Business Suite Student Systems / Research and Education (IGS) schema. It stores the default milestone definitions that apply to a research program, keyed by program code, program version, milestone type, attendance type, and a system-generated sequence number. In functional terms, the table provides the template of milestones that the institutional research management process uses when a candidate is admitted to, or progresses through, a research program. Each row represents one default milestone entry within a milestone set, together with the offset (in days) from the candidate's commencement date at which the milestone falls due.

From a Data Vault modeling perspective, the metadata's heuristic classification for this object is link. This is consistent with the table's role: it associates several business entities — a program version, a milestone type, and an attendance type — into a single relationship, rather than acting as an independent hub of a single concept. The presence of the composite primary key IGS_RE_DFLT_MS_SET_PK over COURSE_CD, VERSION_NUMBER, MILESTONE_TYPE, ATTENDANCE_TYPE, and SEQUENCE_NUMBER reinforces this interpretation, since the key itself is composed of references to other entities.

Key Information Stored

The table is documented with fourteen columns. The most significant are:

• COURSE_CD — the program code to which the default milestones apply. This is a foreign key to IGS.IGS_PS_VER_ALL.
• VERSION_NUMBER — the program version to which the default milestones apply.
• MILESTONE_TYPE — the type of default milestone (VARCHAR2(10)); indexed non-uniquely by IGS_RE_DFLT_MS_SET_ALL_N2.
• ATTENDANCE_TYPE — an institution-defined attendance type, distinguishing part-time from full-time candidates; foreign key to IGS.IGS_EN_ATD_TYPE_ALL and indexed by IGS_RE_DFLT_MS_SET_ALL_N1.
• ATTENDANCE_MODE — the code of an institution-defined attendance mode.
• SEQUENCE_NUMBER — a system-generated number that, together with the other key columns, makes the milestone set unique.
• OFFSET_DAYS — the number of days the milestone is offset from the candidate's commencement date; this is the principal scheduling attribute.
• COMMENTS — free-text notes (VARCHAR2(2000)).
• ORG_ID — the operating unit identifier, enabling multi-org security.
• Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide auditability.

The surrogate primary key is IGS_RE_DFLT_MS_SET_PK. The unique index IGS_RE_DFLT_MS_SET_ALL_U1 — the object referenced by the search term igs_re_dflt_ms_set_all_u1 — covers the same five columns as the primary key and therefore constitutes the business-key candidate.

Common Use Cases and Queries

The most common reporting requirement is to retrieve the default milestone schedule for a given program and version, so that the milestone dates can be projected against a candidate's commencement date. A typical pattern is:

• Join to IGS_PS_VER_ALL on COURSE_CD and VERSION_NUMBER to obtain program descriptions.
• Join to IGS_EN_ATD_TYPE_ALL on ATTENDANCE_TYPE to resolve the attendance type description.
• Filter by ORG_ID for multi-org reporting, and order by SEQUENCE_NUMBER to present milestones in intended order.

Analysts frequently query through the unique index IGS_RE_DFLT_MS_SET_ALL_U1 to confirm that no duplicate milestone definitions exist for a given combination of course, version, milestone type, attendance type, and sequence. A further use case is to project expected milestone dates by computing candidate commencement date plus OFFSET_DAYS, which supports admissions forecasting and supervisory workload reporting. Because the table is small and configuration-oriented, full extracts are commonly used to baseline institutional milestone standards across programs.

Related Objects

The most significant dependent and referenced objects are:

• IGS.IGS_PS_VER_ALL — referenced via COURSE_CD (and, in practice, VERSION_NUMBER); provides the program version definition.
• IGS.IGS_EN_ATD_TYPE_ALL — referenced via ATTENDANCE_TYPE; provides institution-defined attendance type detail.
• IGS_RE_DFLT_MS_SET_PK — the primary key constraint over the five business-key columns.
• IGS_RE_DFLT_MS_SET_ALL_U1 — the unique index enforcing that business key.
• IGS_RE_DFLT_MS_SET_ALL_N1 and N2 — non-unique indexes supporting lookup by MILESTONE_TYPE and ATTENDANCE_TYPE respectively.
• The research candidate and milestone instance tables within the IGS_RE_* family, which consume these defaults when milestones are generated for a candidate.

Together these relationships allow the default milestone set to function as a configuration link between program definition and candidate milestone scheduling.