Results for “igs_ad_rvgr_evaltr”

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

Overview

The IGS_AD_RVGR_EVALTR table resides in the IGS (Student System) schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It is a transactional table that records the evaluators associated with an Application Review Profile reviewer group. In the admissions and application-review workflow of Oracle Student System, an application is typically routed to a review profile, which in turn defines one or more reviewer groups; each reviewer group is staffed by evaluators. This table is the persistent store that links an individual evaluator (a person) to a specific application review profile reviewer group, capturing that person's sequence in the evaluation order and whether the individual serves as a program approver.

From a Data Vault modeling perspective, the documented foreign key structure suggests classifying IGS_AD_RVGR_EVALTR as a link entity. It resolves a many-to-many-style association between a party (HZ_PARTIES) and an application review profile reviewer group (IGS_AD_APL_RPRF_RGR), with descriptive attributes carried alongside the relationship. This classification is a heuristic suggestion derived from the FK topology rather than an Oracle-mandated designation.

Key Information Stored

The table's documented physical schema comprises eleven columns. The most significant are:

• REVGR_EVALUATOR_ID — the surrogate primary key, defined by unique index IGS_AD_RVGR_EVALTR_PK. This is the column referenced when users search for "revgr_evaluator_id," and it uniquely identifies each evaluator assignment row.
• APPL_REVPROF_REVGR_ID — foreign key to IGS_AD_APL_RPRF_RGR, identifying the application review profile reviewer group to which the evaluator is assigned.
• PERSON_ID — foreign key to HZ_PARTIES, identifying the evaluator as a party (person) in the Trading Community Architecture model.
• PERSON_NUMBER — the human-readable person number that corresponds to the party, useful for reporting without a join to HZ_PARTIES.
• EVALUATION_SEQUENCE — the ordinal position of this evaluator within the reviewer group's evaluation ordering.
• PROGRAM_APPROVER_IND — an indicator flagging whether the evaluator is authorized as a program approver for the associated review profile.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO columns that provide audit lineage for the row.

Common Use Cases and Queries

The primary use case is determining who evaluates applications for a given review profile reviewer group, and in what order. A typical query joins the evaluator rows back to the reviewer group and to the party record:

• Listing evaluators for a reviewer group: SELECT e.revgr_evaluator_id, e.person_number, e.evaluation_sequence FROM igs_ad_rvgr_evaltr e WHERE e.appl_revprof_revgr_id = :revgr_id ORDER BY e.evaluation_sequence;
• Resolving evaluator identity: join IGS_AD_RVGR_EVALTR.PERSON_ID = HZ_PARTIES.PARTY_ID to obtain party names and contact details.
• Identifying program approvers: filter on PROGRAM_APPROVER_IND = 'Y' for approval-eligibility reporting.
• Audit reporting: use CREATED_BY/LAST_UPDATED_BY and the WHO dates to trace when evaluator assignments were established or modified.

Related Objects

• HZ_PARTIES — referenced by IGS_AD_RVGR_EVALTR.PERSON_ID; supplies the evaluator's party identity and name.
• IGS_AD_APL_RPRF_RGR — referenced by IGS_AD_RVGR_EVALTR.APPL_REVPROF_REVGR_ID; the application review profile reviewer group parent.
• IGS_AD_RVGR_EVALTR_PK — the unique index enforcing the surrogate primary key on REVGR_EVALUATOR_ID.
• Related IGS admissions tables such as application review profile and reviewer group definitions, which typically sit above IGS_AD_APL_RPRF_RGR in the hierarchy, and person/party-dependent views that consume PERSON_ID for evaluator lookups.