Search Results reviewer_notes




Overview
Explore in AI Chat

Overview

APPS.IGSFV_PERSON_CREDENTIALS is a read-only Oracle E-Business Suite view that consolidates person credential records maintained within the Oracle Student System (formerly Oracle iLearning/IGS) module. It presents credentials — such as degrees, diplomas, certifications, licenses, and other academic or professional qualifications — associated with a party (person) record in the TCA (Trading Community Architecture) model. The view joins credential transaction data to the HZ_PARTIES table for both the credential holder and the reviewer, and to the credential type definition table, producing a denormalized, reporting-friendly result set.

The view is defined with the WITH READ ONLY clause, which means it cannot be used as a target for DML operations. It is intended strictly for querying, extraction, and integration purposes. The user search reference "coreadi/adc" corresponds to the alias ADC used in the view text for the IGS_AD_CRED_TYPES table, which supplies credential type and description attributes.

Underlying Base Objects

The documented view text references four base objects:

  • IGS_PE_CREDENTIALS (PEC) — The primary driving table holding one row per credential assignment, including date received, reviewer notes, recommender details, and audit columns.
  • HZ_PARTIES (HZP1) — Joined on PEC.PERSON_ID = HZP1.PARTY_ID to retrieve the credential holder's party number.
  • HZ_PARTIES (HZP2) — Outer-joined on PEC.REVIEWER_ID = HZP2.PARTY_ID(+) to retrieve the reviewer's party number when a reviewer exists.
  • IGS_AD_CRED_TYPES (ADC) — Joined on PEC.CREDENTIAL_TYPE_ID = ADC.CREDENTIAL_TYPE_ID to supply the credential type code and description.

No additional base objects are documented in the ETRM metadata for this view.

Key Columns

The view exposes the following significant columns:

Common Use Cases and Queries

This view is typically used in student credential reporting, integration extracts, and self-service displays. A representative query returns all credentials for a given party:

  • SELECT CREDENTIAL_TYPE, DESCRIPTION, DATE_RECEIVED, REVIEWER_NOTES FROM APPS.IGSFV_PERSON_CREDENTIALS WHERE PERSON_ID = :p_person_id;
  • Reviewer activity: SELECT PERSON_ID, CREDENTIAL_ID, REVIEWER_ID FROM APPS.IGSFV_PERSON_CREDENTIALS WHERE REVIEWER_ID IS NOT NULL;
  • Type-based analysis: SELECT CREDENTIAL_TYPE, COUNT(*) FROM APPS.IGSFV_PERSON_CREDENTIALS GROUP BY CREDENTIAL_TYPE;

Because the view is read-only and denormalized, it suits ETL loads, OBIEE/BIP reporting, and inbound interface validation. Care should be taken that outer-join semantics on the reviewer mean REVIEWER_ID may be null without excluding the credential row.