Results for “acad_year”

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

Overview

The IGS_PR_CSS_CLASS_STD table belongs to the Oracle Student System (IGS) product family, a module that is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table maintains the class standing mapping that links a credit point range and an academic year to a specific program type and period. In functional terms, it defines the thresholds at which a student's accumulated credit points translate into a recognized class standing, such as freshman, sophomore, junior, or senior, within a given academic schedule.

The ETRM metadata records this object as "Not implemented in this database," indicating that it is a legacy or unused table in current 12.1.1 / 12.2.2 environments. Consultants encountering it should treat it as historical context rather than an active configuration table. Based on the foreign key structure, the heuristic Data Vault classification is satellite-leaning. This suggests a modeling view in which the table behaves as a descriptive satellite attached to the schedule and class standing hubs, holding the measurable credit point thresholds and academic year context rather than the core business identities themselves.

Key Information Stored

The table contains 11 documented columns. The most significant are described below, distinguishing the surrogate primary key from the business-key candidates identified through unique indexes.

• IGS_PR_CSS_CLASS_STD_ID — The surrogate primary key of the table, enforced by the unique index IGS_PR_CSS_CLSTD_U1 and the primary key constraint IGS_PR_CSS_CLSTD_PK. It provides the internal row identifier referenced by dependent tables.
• IGS_PR_CS_SCHDL_ID — Foreign key to IGS_PR_CS_SCHDL, identifying the academic schedule or period to which the class standing mapping applies.
• IGS_PR_CLASS_STD_ID — Foreign key to IGS_PR_CLASS_STD, identifying the specific class standing value being mapped.
• MIN_CP and MAX_CP — The minimum and maximum credit point boundaries that define the range for the associated class standing.
• ACAD_YEAR — The academic year to which the credit point range and class standing mapping apply.
• 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 business-key candidate is captured by the unique index IGS_PR_CSS_CLSTD_U2, defined over the combination of IGS_PR_CS_SCHDL_ID and IGS_PR_CLASS_STD_ID. This confirms that a schedule and class standing pairing is intended to be unique within the table, an important constraint for any query joining these two dimensions.

Common Use Cases and Queries

Although the table is inactive in current releases, understanding its intended use supports legacy data migration, archival reporting, and historical analysis of class standing rules. A typical query retrieves the credit point range for a given schedule and class standing:

• Reporting the minimum and maximum credit points associated with each class standing for a specified academic year.
• Reconstructing progression rules by joining schedule, class standing, and credit point thresholds.
• Auditing historical configuration changes using the CREATED_BY and LAST_UPDATED_BY audit columns.

A representative SQL pattern combines the surrogate and business keys:

SELECT css.IGS_PR_CSS_CLASS_STD_ID, css.IGS_PR_CS_SCHDL_ID, css.IGS_PR_CLASS_STD_ID, css.MIN_CP, css.MAX_CP, css.ACAD_YEAR FROM IGS_PR_CSS_CLASS_STD css WHERE css.IGS_PR_CS_SCHDL_ID = :schedule_id AND css.IGS_PR_CLASS_STD_ID = :class_std_id;

Related Objects

The following objects are the most significant relationships derived from the documented foreign key and primary key metadata.

• IGS_PR_CS_SCHDL — Referenced through IGS_PR_CSS_CLASS_STD.IGS_PR_CS_SCHDL_ID; provides the schedule or period context.
• IGS_PR_CLASS_STD — Referenced through IGS_PR_CSS_CLASS_STD.IGS_PR_CLASS_STD_ID; defines the class standing value.
• IGF_AP_CLASS_STD_MAP — References this table through IGF_AP_CLASS_STD_MAP.IGS_PR_CSS_CLASS_STD_ID, making it a dependent child object.

These relationships confirm the satellite-leaning role: IGS_PR_CSS_CLASS_STD depends on two parent dimensions while serving as a lookup source for the class standing mapping table IGF_AP_CLASS_STD_MAP.