Results for “min_evaluator”

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

Overview

IGS_AD_APL_REV_PRF_ALL is a configuration table within the Oracle E-Business Suite IGS — Student System product family. In the documented ETRM 12.1.1 schema it is owned by the IGS schema and consists of 17 columns. The table stores master definitions for Application Review Profiles — the rules that govern how admissions applications are routed to and evaluated by reviewers (evaluators). Each row defines a profile: its name, its active window, evaluator-count constraints, whether program approval is required, and whether the review behaves sequentially or concurrently.

Functionally this is reference/definition data (setup data) rather than transactional data; profiles created here are subsequently referenced by application-review grouping, assignment, and result tables. From a heuristic Data Vault modeling perspective the table is hub-leaning: it holds a stable business key (the surrogate-generated profile ID, plus a name-based unique key) with descriptive attributes attached, and it is referenced by multiple downstream tables as a foreign-key target. Treating APPL_REV_PROFILE_ID as a hub key with the remaining descriptive columns as satellite attributes is a reasonable design suggestion for analytical modeling, though the table is not formally Data Vault in EBS.

Note: the ETRM metadata states the object is marked Obsolete and is "Not implemented in this database." This is common for ETRM-derived documentation of legacy or de-supported IGS tables; the structure and relationships remain valid as a reference, but availability varies by installation and release.

Key Information Stored

The most significant columns in this table are:

• APPL_REV_PROFILE_ID — the primary-key surrogate identifier for the review profile. Defined by primary key IGS_AD_APL_REV_PRF_PK and unique index IGS_AD_APL_REV_PRF_U1. This is the value propagated to all dependent child tables.
• REVIEW_PROFILE_NAME and ORG_ID — the business-key candidate pair, enforced by unique index IGS_AD_APL_REV_PRF_UK1 (also listed as IGS_AD_APL_REV_PRF_U2). The name must be unique within an operating unit, reflecting multi-org (Operating Unit) partitioning.
• START_DATE and END_DATE — the active validity window during which the profile applies to incoming applications.
• MIN_EVALUATOR and MAX_EVALUATOR — the permitted range of evaluators assigned per application under this profile.
• PROG_APPROVAL_REQUIRED — flag indicating whether program-level approval is required before the review completes.
• SEQUENTIAL_CONCURRENT_IND — indicator governing whether evaluations are performed in sequence or in parallel.
• APPL_REV_PROFILE_GR_CD — a grouping/lookup code classifying the review profile.
• SITE_USE_CODE — the site-use context under which the profile is applied.
• CLOSED_IND — flag marking the profile as closed/inactive.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO-column audit set present on nearly all IGS transactional and setup tables.

Common Use Cases and Queries

Typical scenarios include identifying the active review profile for an operating unit, auditing evaluator-count rules, and tracing which profiles drive downstream application reviews.

• Active profile lookup by operating unit and date:

  SELECT appl_rev_profile_id, review_profile_name,
         start_date, end_date, min_evaluator, max_evaluator
  FROM   igs_ad_apl_rev_prf_all
  WHERE  org_id = :p_org_id
  AND    TRUNC(SYSDATE) BETWEEN NVL(start_date, TRUNC(SYSDATE))
                            AND NVL(end_date, TRUNC(SYSDATE))
  AND    NVL(closed_ind,'N') = 'N';

• Profiles requiring program approval: filter on PROG_APPROVAL_REQUIRED = 'Y' for admissions workflow reporting.
• Evaluator-count exception reporting: list profiles where MAX_EVALUATOR is unusually high or equal to MIN_EVALUATOR, useful for review-load planning.
• Sequential vs. concurrent analysis: aggregate counts grouped by SEQUENTIAL_CONCURRENT_IND to assess workflow design.
• Referential impact analysis: join to child tables (below) to determine how many applications and assignments reference a given profile before deactivating it via CLOSED_IND.

Because the table is obsolete in the documented database, queries should be validated against the actual installation; where the table is absent, equivalent functionality may have been superseded by newer IGS review constructs.

Related Objects

The following tables hold foreign keys into IGS_AD_APL_REV_PRF_ALL on APPL_REV_PROFILE_ID and represent the primary dependency chain:

• IGS_AD_APPL_ARP — links applications to their assigned review profile; join on IGS_AD_APPL_ARP.APPL_REV_PROFILE_ID = IGS_AD_APL_REV_PRF_ALL.APPL_REV_PROFILE_ID.
• IGS_AD_APL_RPRF_RGR — reviewer/group assignment rules associated with a profile; join on the same APPL_REV_PROFILE_ID column.
• IGS_AD_APL_RVPF_RSL — application review profile results; join on APPL_REV_PROFILE_ID to trace evaluation outcomes back to the profile definition.

Collectively these dependent tables form the application-review transaction path that consumes the profile definitions held in this hub-leaning setup table, making IGS_AD_APL_REV_PRF_ALL the reference point for admissions review configuration and reporting.