Results for “igs_ad_appl_eval”

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

Overview

IGS_AD_APPL_EVAL is a table that resides in the IGS (Student System) product schema within Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its documented purpose is to hold the details of evaluators assigned to various admission applications. In practical terms, each row represents an evaluation event: the association of an evaluator with a specific applicant, admission application, and nominated course, together with the rating assigned and any accompanying notes. This makes the table a core repository for admissions review and decision tracking, where committees or individual reviewers score applicants against defined rating types and scales.

From a data modelling perspective, the relationship metadata suggests a link classification (Data Vault heuristic, mined from the foreign-key structure). The table primarily records associations among parties — the applicant, the evaluator, and the rating reference data — rather than acting as a standalone descriptive hub or a pure satellite carrying attributes over time. Treat this classification as a modelling suggestion rather than a documented fact.

Key Information Stored

Although the table contains 24 documented columns, the following are the most significant for understanding and querying its content:

• APPL_EVAL_ID — the surrogate primary key, enforced by the unique index IGS_AD_APPL_EVAL_PK. It uniquely identifies each evaluation record.
• PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER — together these reference the parent admission application instance in IGS_AD_PS_APPL_INST_ALL. They effectively form the business-key candidates that tie an evaluation back to a specific application for a specific applicant and course.
• EVALUATOR_ID — the party (person or organisation) performing the evaluation, sourced from HZ_PARTIES.
• ASSIGN_TYPE, ASSIGN_DATE, EVALUATION_DATE — describe how and when the evaluator was assigned and when the evaluation occurred.
• RATING_TYPE_ID, RATING_SCALE_ID, RATING_VALUES_ID — reference the rating configuration in IGS_AD_CODE_CLASSES, IGS_AD_RATING_SCALES, and IGS_AD_RS_VALUES respectively, defining what was measured and the selected score.
• RATING_NOTES — free-text commentary supplied by the evaluator.
• EVALUATION_SEQUENCE and CLOSED_IND — indicate ordering of evaluations and whether the evaluation is closed.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard Oracle EBS auditing and concurrent-program columns that track record provenance.

Common Use Cases and Queries

The table supports admissions reporting such as evaluator workload analysis, rating distribution, and outstanding evaluations per application. A typical join retrieves all evaluations for a given applicant:

• Join IGS_AD_APPL_EVAL to IGS_AD_PS_APPL_INST_ALL on PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER to reconstruct full applications.
• Join to HZ_PARTIES via EVALUATOR_ID to resolve evaluator names and party details.
• Join to IGS_AD_RS_VALUES and IGS_AD_RATING_SCALES through RATING_VALUES_ID and RATING_SCALE_ID to translate stored rating codes into human-readable scores.

Filtering on CLOSED_IND helps isolate pending versus completed evaluations, while aggregating on EVALUATOR_ID produces workload summaries. Because the primary key is a surrogate, business-level queries should always constrain by the application identifiers rather than by APPL_EVAL_ID.

Related Objects

The following objects are most significant to IGS_AD_APPL_EVAL, based on the documented foreign-key relationships:

• IGS_AD_PS_APPL_INST_ALL — parent application instance; joined via PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER.
• HZ_PARTIES — evaluator registry; joined via EVALUATOR_ID.
• IGS_AD_RATING_SCALES — rating scale definitions; joined via RATING_SCALE_ID.
• IGS_AD_RS_VALUES — permissible rating values; joined via RATING_VALUES_ID.
• IGS_AD_CODE_CLASSES — rating type classification; joined via RATING_TYPE_ID.

These relationships establish the table as an integration point between admission applications, external party data, and the admissions rating configuration tables.