Results for “igs_ad_appl_revprof_rtscale_pk”

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

Overview

The IGS.IGS_AD_APL_RVPF_RSL table is a component of the Oracle EBS IGS — Student System product family (also marketed as Oracle Student System / Oracle Admissions). It stores the rating scale configuration associated with an Application Review Profile. In the admissions and application evaluation workflow, a review profile defines how one or more evaluators score an applicant's submission. Each row of this table binds a specific rating type to a specific rating scale for a given application review profile, thereby declaring which scoring scales are available when an application is evaluated under that profile.

The object is registered in ETRM as a TABLE owned by the IGS schema with status VALID, documented against 12.1.1 and 12.2.2. Heuristic Data Vault classification mined from the foreign-key structure identifies this table as a link entity — a modeling suggestion, since it resolves a many-to-many relationship between application review profiles, rating types, and rating scales rather than acting as a standalone hub or descriptive satellite.

Key Information Stored

The table contains nine documented columns. The most significant are:

• APPL_REVPROF_RTSCALE_ID — Surrogate primary key. It is the single-column unique index IGS_AD_APL_RVPF_RSL_U1 and the technical row identifier referenced by dependent objects.
• APPL_REV_PROFILE_ID — Foreign key to IGS_AD_APL_REV_PRF_ALL; identifies the application review profile that owns this rating configuration.
• RATING_TYPE_ID — Foreign key to IGS_AD_CODE_CLASSES; classifies the rating (for example, the category or nature of the score being captured).
• RATING_SCALE_ID — Foreign key to IGS_AD_RATING_SCALES; points to the predefined scale (range, grades, or values) used for scoring.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO-column audit attributes capturing row creation and last modification user, timestamp, and login context.

The business key is the composite unique constraint IGS_AD_APL_RVPF_RSL_UK over (APPL_REV_PROFILE_ID, RATING_TYPE_ID, RATING_SCALE_ID), which enforces that a given scale cannot be assigned twice for the same rating type within one review profile. The surrogate IGS_AD_APPL_REVPROF_RTSCALE_PK is also documented on APPL_REVPROF_RTSCALE_ID.

Common Use Cases and Queries

Typical usage includes validating profile setup before an admissions cycle, reporting which scales are enabled per profile, and driving evaluation entry pages. Representative SQL:

• List all rating scales for a review profile:
  SELECT r.RATING_SCALE_ID, r.RATING_TYPE_ID FROM IGS_AD_APL_RVPF_RSL r WHERE r.APPL_REV_PROFILE_ID = :profile_id;
• Resolve scale descriptions:
  SELECT s.RATING_SCALE_ID, s.DESCRIPTION FROM IGS_AD_APL_RVPF_RSL r, IGS_AD_RATING_SCALES s WHERE r.RATING_SCALE_ID = s.RATING_SCALE_ID AND r.APPL_REV_PROFILE_ID = :profile_id;
• Detect configuration gaps or duplicates using the composite unique key columns.
• Join to IGS_AD_CODE_CLASSES to translate RATING_TYPE_ID into meaningful codes for reporting.

Related Objects

• IGS_AD_APL_REV_PRF_ALL — parent review profile; join on APPL_REV_PROFILE_ID.
• IGS_AD_RATING_SCALES — rating scale definitions; join on RATING_SCALE_ID.
• IGS_AD_CODE_CLASSES — rating type lookup; join on RATING_TYPE_ID.
• Admissions evaluation and scoring entities that consume the resolved scale set for a profile.
• IGS concurrent programs and OA Framework admission setup pages that maintain review profile rating configuration.