Results for “stream_num”

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

Overview

The IGS.IGS_PR_S_PRG_CAL table is a core configuration object within the Oracle E-Business Suite IGS – Student System product. It describes the standard progression calendar configuration options used by an institution to govern how students advance through academic programs. According to the ETRM documentation, all progression calendars must be established here — or at the organization unit or course version level — before the rules defined within those calendars are considered by the system. This establishes IGS_PR_S_PRG_CAL as a foundational reference table for progression processing in Student System rather than a transactional table.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a link. This classification is derived from the foreign key structure, where the table associates a progression calendar type to a progression calendar configuration record. In practice, this table behaves as an intersection or association table that binds two independent reference entities, making a link-based representation a reasonable modeling suggestion.

Key Information Stored

The table contains ten documented columns, of which the following are the most significant for understanding its role:

• S_CONTROL_NUM — The system control number that identifies the progression calendar configuration record. It is the foreign key reference to IGS_PR_S_PRG_CONF and forms half of the composite primary key.
• PRG_CAL_TYPE — The progression calendar type code, foreign keyed to IGS_CA_TYPE. This identifies which type of progression calendar the configuration applies to.
• STREAM_NUM — The stream identifier, distinguishing parallel progression streams within the same calendar configuration.
• SHOW_CAUSE_LENGTH — Controls whether the cause length is displayed for progression rules, a presentation/behavioral configuration flag.
• APPEAL_LENGTH — Defines the appeal length configuration applied to the progression calendar.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns capturing who created and last modified the record and when.

The surrogate primary key is IGS_PR_S_PRG_CAL_PK, composed of S_CONTROL_NUM and PRG_CAL_TYPE. A separate unique index, IGS_PR_S_PRG_CAL_U1, is documented over the same two columns, making them the business-key candidates that guarantee uniqueness of a calendar configuration pairing.

Common Use Cases and Queries

Administrators and developers query this table when validating that a progression calendar has been configured before progression rules are evaluated, and when diagnosing why progression rules are being ignored. A typical lookup joins the table to its foreign references:

• Confirming all configured progression calendars for a given calendar type by querying on PRG_CAL_TYPE.
• Reporting configuration flags such as APPEAL_LENGTH and SHOW_CAUSE_LENGTH across all streams.
• Joining to IGS_CA_TYPE to retrieve the descriptive calendar type name for reporting, and to IGS_PR_S_PRG_CONF to obtain the parent configuration details.
• Auditing changes using the LAST_UPDATED_BY and LAST_UPDATE_DATE columns.

A representative join pattern would select from IGS_PR_S_PRG_CAL aliased against IGS_CA_TYPE on PRG_CAL_TYPE and IGS_PR_S_PRG_CONF on S_CONTROL_NUM, filtered by the desired calendar type.

Related Objects

The most significant related objects are those directly connected through documented foreign keys and the primary key:

• IGS_CA_TYPE — referenced by IGS_PR_S_PRG_CAL.PRG_CAL_TYPE; holds the calendar type definition.
• IGS_PR_S_PRG_CONF — referenced by IGS_PR_S_PRG_CAL.S_CONTROL_NUM; holds the progression configuration record.
• IGS_PR_S_PRG_CAL_PK — the primary key constraint over S_CONTROL_NUM and PRG_CAL_TYPE.
• IGS_PR_S_PRG_CAL_U1 — the unique index over the same business-key columns.
• Organization unit and course version level progression calendar tables, which the description identifies as alternative establishment points for progression calendars.