Results for “igs_pr_class_std”

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

Overview

IGS_PR_CLASS_STD is a setup (reference) table within the IGS – Student System product family of Oracle E-Business Suite. It maintains institution-defined Class Standing values, which classify students according to progression thresholds such as freshman, sophomore, junior, senior, or equivalent institutional categories. Because class standing is consumed by admissions, academic records, fee assessment, and financial aid processes, this table functions as a shared lookup referenced across multiple student-system subsystems rather than as a transactional entity.

The documented physical schema exposes nine columns owned by the IGS schema. The table carries two unique indexes: IGS_PR_CLASS_STD_PK on IGS_PR_CLASS_STD_ID (surrogate primary key) and IGS_PR_CLASS_STD_UK on CLASS_STANDING (business-key uniqueness). The presence of both an artificial key and a natural unique key is characteristic of Oracle EBS setup tables, where the surrogate supports referential integrity while the natural key carries institutional meaning.

From a Data Vault modeling perspective, the mined FK structure classifies this object as hub-leaning. IGS_PR_CLASS_STD_ID behaves as a durable business key that anchors nine dependent relationships, making the table a natural candidate for a hub entity in a dimensional or Data Vault design, with the descriptive attributes modeled as satellite columns.

Key Information Stored

• IGS_PR_CLASS_STD_ID — surrogate primary key (IGS_PR_CLASS_STD_PK); the numeric identity propagated to all dependent foreign-key tables.
• CLASS_STANDING — the institution-defined code for a class standing value; enforced as a unique business key via IGS_PR_CLASS_STD_UK and used as the join column by most external references.
• DESCRIPTION — the descriptive label presented to users in LOVs, reports, and self-service pages.
• CLOSED_IND — flag indicating whether the class standing value remains active or has been end-dated for new assignments.
• CREATED_BY, CREATION_DATE — standard WHO audit columns capturing the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the last modifying user, timestamp, and login session.

The distinction between the surrogate key and the business key matters during data migration and integration: legacy conversions should map institutional class-standing codes to CLASS_STANDING, then resolve IGS_PR_CLASS_STD_ID for loading into dependent tables.

Common Use Cases and Queries

Typical reporting retrieves the active class standing set-up for LOV population, validation, or cross-reference against student records. The following pattern lists active values ordered by code:

• SELECT class_standing, description FROM igs_pr_class_std WHERE NVL(closed_ind,'N') = 'N' ORDER BY class_standing;
• Resolving the surrogate key for a known code: SELECT igs_pr_class_std_id FROM igs_pr_class_std WHERE class_standing = :p_code;
• Detecting orphan or unmapped references: compare distinct CLASS_STANDING values in feeder tables such as IGF_AW_COA_RATE_DET against this table to identify values not yet defined.
• Dependency impact analysis before closing a value: count rows in dependent tables such as IGS_EN_STDNT_PS_ATT_ALL and IGF_AP_FA_ANT_DATA joined on the class standing identifier.

Institutions frequently extract this table into an operational data store to support enrollment trend reporting segmented by class standing, and to drive fee assessment and financial aid rules that vary by standing.

Related Objects

• IGF_AW_COA_RATE_DET — joins on CLASS_STANDING; stores award cost-of-attendance rate detail by class standing, the relationship most relevant to the originating search term.
• IGF_AP_FA_ANT_DATA — joins on CLASS_STANDING; holds anticipated financial aid data keyed to class standing.
• IGS_FI_FEE_AS_RATE — joins on CLASS_STANDING; defines fee assessment rates differentiated by class standing.
• IGS_AS_GPC_CLS_STNDG — joins on CLASS_STANDING; relates grade point calculations to class standing.
• IGS_EN_SPA_TERMS — joins on CLASS_STANDING_ID; student program-of-study term records.
• IGS_EN_STDNT_PS_ATT_ALL — joins on IGS_PR_CLASS_STD_ID; student program attempt records carrying the standing reference.
• IGS_AS_SC_ATTEMPT_H_ALL — joins on IGS_PR_CLASS_STD_ID; student attempt history linked to standing.
• IGS_PR_RU_APPL_ALL — joins on IGS_PR_CLASS_STD_ID; admissions application records referencing standing.
• IGS_PR_CSS_CLASS_STD — joins on IGS_PR_CLASS_STD_ID; class-standing set-up supporting table.