Results for “igs_pr_s_ou_prg_cal”

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

Overview

IGS_PR_S_OU_PRG_CAL is a configuration table within the Oracle EBS Student System (IGS) product family. It defines organizational unit progression calendar configuration options, storing the association between an organizational unit, the effective date from which that association applies, and the progression calendar type attached to it. In the progression-calendar resolution model used by the Student System, a progression calendar must be established at one of three levels — system level, organizational unit level, or course version level — before the rules contained in that calendar can be evaluated. This table is the organizational unit level of that hierarchy. If a given organizational unit and progression calendar combination is absent from this table, no progression rules for that calendar will be applied at the OU level.

The metadata notes that the object is marked obsolete and was not implemented in the reference database from which the documentation was generated. It should therefore be treated as a legacy or historical configuration object in 12.1.1 / 12.2.2 environments, present in the data model but not necessarily populated. The heuristic Data Vault classification derived from the foreign key structure is link, which suggests modeling it as a relationship (associative) entity connecting organizational units to calendar types rather than as a hub or satellite.

Key Information Stored

The table comprises eleven documented columns. The most significant are the business-key columns, which collectively form the primary key constraint IGS_PR_S_OU_PRG_CAL_PK and the unique index IGS_PR_S_OU_PRG_CAL_U1.

• ORG_UNIT_CD — the organizational unit code, identifying the academic organizational unit for which the progression calendar is configured. Part of the primary key.
• OU_START_DT — the start date from which the organizational unit progression calendar configuration takes effect. Part of the primary key.
• PRG_CAL_TYPE — the progression calendar type applied to the organizational unit. Part of the primary key and itself a foreign key to IGS_CA_TYPE.
• STREAM_NUM — a stream or sequence number used to differentiate otherwise identical calendar assignments.
• SHOW_CAUSE_LENGTH — a configuration indicator governing whether cause length is displayed in progression processing.
• APPEAL_LENGTH — the appeal period length applied within the organizational unit's progression calendar context.
• CREATED_BY, CREATION_DATE — standard Oracle EBS audit columns capturing the creating user and creation timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — audit columns capturing the most recent modifying user and timestamp.
• LAST_UPDATE_LOGIN — the login identifier associated with the last update, used for session-level audit tracing.

The surrogate primary key is not a single generated identifier: the documented key is the composite business key (ORG_UNIT_CD, OU_START_DT, PRG_CAL_TYPE), with IGS_PR_S_OU_PRG_CAL_U1 mirroring that same combination as the unique business-key index.

Common Use Cases and Queries

Typical use cases center on validating which progression calendar types are active for an organizational unit at a point in time, and on reconciling progression configuration across the three permitted levels. A common query returns the configuration effective for a given OU and date:

SELECT org_unit_cd, ou_start_dt, prg_cal_type, appeal_length
FROM igs_pr_s_ou_prg_cal
WHERE org_unit_cd = :p_org_unit_cd
AND ou_start_dt <= :p_effective_date
ORDER BY ou_start_dt DESC;

Administrators also use the table to audit configuration completeness, joining to IGS_CA_TYPE to verify that referenced calendar types exist and are enabled. Reporting scenarios include generating a list of OUs with no progression calendar configured, and comparing OU-level configuration against system- and course-version-level settings to explain why progression rules are or are not firing. Because the table is obsolete and possibly empty, queries are often used diagnostically to confirm that progression behavior is being driven from another level.

Related Objects

• IGS_CA_TYPE — referenced by PRG_CAL_TYPE; supplies the calendar type definition for each progression calendar assignment.
• IGS_PR_S_OU_PRG_CONF — the parent configuration object; the foreign key joins on ORG_UNIT_CD and OU_START_DT, tying the calendar assignment back to the organizational unit progression configuration.
• IGS_PR_S_* progression tables — related progression configuration objects at system and course version level that participate in the same resolution hierarchy.
• IGS_OU_* organizational unit tables — provide the organizational unit definitions resolved through ORG_UNIT_CD.
• Student progression / rules engine objects — consume the resolved progression calendar to determine which academic progression rules apply.