Search Results igs_en_stdnt_ps_intm_uk

Overview

IGS_EN_STDNT_PS_INTM is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It records an approved or requested intermission — a temporary suspension of study — taken by a student against a specific student course attempt. Each row ties a person and a course attempt to an intermission type, an effective date range, and an optional approver, capturing the institutional decision to grant or deny a break in study. The table is central to enrollment lifecycle processing, since an active intermission can influence registration eligibility, progression rules, and credit-point accrual within a programme.

From a Data Vault modelling perspective, the metadata's foreign-key structure suggests this object behaves as a satellite-leaning entity: it carries descriptive, time-varying attributes (dates, approval flags, credit limits) keyed by a composite identifier that includes the parent student course attempt and a logical delete marker. In a Data Vault decomposition, PERSON_ID and COURSE_CD would resolve to the student course attempt hub, while INTERMISSION_TYPE would resolve to a reference hub for intermission types.

Key Information Stored

The table is owned by the IGS schema and, per documented ETRM 12.1.1 metadata, contains 41 columns. The most operationally significant columns are:

• PERSON_ID — party identifier of the student, part of both the primary key and the unique key.
• COURSE_CD — the course attempt against which the intermission is raised; combined with PERSON_ID it links to IGS_EN_STDNT_PS_ATT_ALL.
• START_DT — effective start date of the intermission and part of the primary/unique keys.
• LOGICAL_DELETE_DATE — soft-delete timestamp included in the primary key and unique index, preserving history without physical deletion.
• INTERMISSION_TYPE — classification of the break; foreign key to IGS_EN_INTM_TYPES.
• END_DT — date the intermission concludes.
• VOLUNTARY_IND — indicates whether the student initiated the intermission.
• APPROVED and APPROVER_ID — approval status and the approving party (foreign key to HZ_PARTIES).
• MAX_CREDIT_PTS and MAX_TERMS — limits applied to the intermission.
• ANTICIPATED_CREDIT_POINTS — projected credits to be earned on return.
• COND_RETURN_FLAG — indicates a conditional return arrangement.
• INSTITUTION_NAME and COMMENTS — descriptive context for the break.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who-column audit fields.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard EBS descriptive flexfield storage.

The surrogate-style primary key IGS_EN_STDNT_PS_INTM_PK is composed of PERSON_ID, COURSE_CD, START_DT, and LOGICAL_DELETE_DATE. The unique index IGS_EN_STDNT_PS_INTM_U1 uses the same four columns, while the business key IGS_EN_STDNT_PS_INTM_UK adds INTERMISSION_TYPE to PERSON_ID, COURSE_CD, and START_DT.

Common Use Cases and Queries

Typical reporting includes identifying students currently on intermission, calculating intermission duration, and reconciling approved versus voluntary breaks by type. A common query joins the student course attempt and intermission type reference:

• List active intermissions: SELECT person_id, course_cd, start_dt, end_dt, intermission_type FROM igs_en_stdnt_ps_intm WHERE logical_delete_date IS NULL AND (end_dt IS NULL OR end_dt > SYSDATE).
• Aggregate intermissions by type: group records by intermission_type after joining IGS_EN_INTM_TYPES for the descriptive name.
• Approval auditing: join APPROVER_ID to HZ_PARTIES to report who authorised each intermission.
• Credit planning: report MAX_CREDIT_PTS and ANTICIPATED_CREDIT_POINTS for progression forecasting.
• Conditional return monitoring: filter on COND_RETURN_FLAG and END_DT to track students expected back under conditions.

Because LOGICAL_DELETE_DATE participates in the key, queries should routinely filter on it to exclude superseded rows unless historical reconstruction is required.

Related Objects

• IGS_EN_STDNT_PS_ATT_ALL — parent student course attempt table; joined on PERSON_ID and COURSE_CD via the foreign key on this table.
• IGS_EN_INTM_TYPES — reference table for intermission type codes, joined on INTERMISSION_TYPE.
• HZ_PARTIES — TCA party registry, joined on APPROVER_ID to resolve the approver's identity.
• IGS_EN_SPI_RCONDS — detail table that references this table on PERSON_ID, COURSE_CD, START_DT, and LOGICAL_DELETE_DATE to store intermission record lines.

Collectively these relationships place IGS_EN_STDNT_PS_INTM between the enrollment attempt hub and its intermission detail records, making it the authoritative source for intermission approvals and timing in the Student System.