Results for “rating_values_id”

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

Overview

The IGS_AD_RS_VALUES table is a foundational data object within the Oracle E-Business Suite Student System (IGS) product family. It holds the discrete rating scale values that define the acceptable entries for an admissions rating scale. In the admissions and applicant evaluation workflow, rating scales represent structured scoring frameworks (for example, standardized test bands, qualification tiers, or proficiency levels), and each individual value within such a scale is persisted as a row in this table. The table therefore functions as the vocabulary of possible ratings rather than the ratings themselves, which are captured on transactional evaluation records.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. In practical terms, IGS_AD_RS_VALUES behaves as a descriptive reference list dependent on the IGS_AD_RATING_SCALES parent, which exhibits hub-like characteristics. This classification is offered as a modeling suggestion for warehouse or integration design rather than a prescriptive constraint imposed by the E-Business Suite schema itself.

Key Information Stored

The table is documented with ten physical columns. The surrogate primary key is RATING_VALUES_ID, enforced through the IGS_AD_RS_VALUES_PK constraint. The principal business-key candidate is the pairing of RATING_SCALE_ID with the rating value content, since a scale's values must remain distinguishable within the context of their parent scale. The most significant columns are:

• RATING_VALUES_ID — Surrogate primary key uniquely identifying each rating scale value row.
• RATING_SCALE_ID — Foreign key to IGS_AD_RATING_SCALES, tying each value to its parent scale.
• RATING_VALUE — The actual rating value or code presented to evaluators.
• DESCRIPTION — Free-text description clarifying the meaning or usage of the value.
• CLOSED_IND — Indicator controlling whether the value remains active and selectable.
• CREATED_BY, CREATION_DATE — Standard audit columns recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification.

Common Use Cases and Queries

Admissions setup and configuration teams query this table to validate that the rating values defined for a scale are complete and correctly ordered. Reporting teams join it to evaluation records to translate stored rating value identifiers into human-readable descriptions. Integration and data migration routines reference it when populating or reconciling ratings captured in external systems. A typical query resolving active values for a given scale is:

• SELECT v.rating_values_id, v.rating_value, v.description FROM igs_ad_rs_values v WHERE v.rating_scale_id = :scale_id AND NVL(v.closed_ind,'N') = 'N';
• A join to evaluations, SELECT e.appl_eval_id, v.rating_value FROM igs_ad_appl_eval e, igs_ad_rs_values v WHERE e.rating_values_id = v.rating_values_id;, produces the rating applied to each applicant evaluation.
• A completeness check, SELECT rating_scale_id, COUNT(*) FROM igs_ad_rs_values GROUP BY rating_scale_id ORDER BY 2;, surfaces scales lacking defined values.

Related Objects

The following objects are most significant to this table based on the documented relationship data:

• IGS_AD_RATING_SCALES — Parent table referenced by IGS_AD_RS_VALUES.RATING_SCALE_ID.
• IGS_AD_APPL_EVAL — Applicant evaluation table that references IGS_AD_RS_VALUES.RATING_VALUES_ID.

Together these relationships confirm that IGS_AD_RS_VALUES sits between scale definitions and applicant evaluations, serving as the controlled value set that evaluation records draw upon.