Search Results recommender_title




Overview
Explore in AI Chat

Overview

IGS.IGS_PE_CREDENTIALS is a transactional table in the Oracle E-Business Suite IGS (Student Systems / Higher Education) schema that stores credential records held by a person. A credential row captures an externally or internally awarded qualification, license, certification, or similar achievement, together with the reviewer's evaluation notes and any recommender information supplied in support of the credential. In EBS 12.1.1 and 12.2.2 the table is registered as FND Design Data object IGS.IGS_PE_CREDENTIALS, resides in the APPS_TS_TX_DATA tablespace with PCT Free of 10, and its indexes are held in APPS_TS_TX_IDX. The metadata flags this object as a heuristic Data Vault classification of link, which serves as a modeling suggestion that the table primarily records an association between a person (party) and a credential type, enriched with descriptive attributes rather than acting as a standalone reference hub.

Key Information Stored

The table contains sixteen documented columns. The surrogate primary key is CREDENTIAL_ID, a mandatory NUMBER(15) that uniquely identifies each credential record and is enforced by the unique index IGS_PE_CREDENTIALS_U1; the associated primary key constraint is IGS_PE_CREDENTIALS_PK. The most operationally significant columns are:

Common Use Cases and Queries

Typical usage covers applicant and student credential verification, admissions review reporting, and recommender audit extracts. A person-centric listing retrieves all credentials for a party, joined to the credential type description:

SELECT c.credential_id, c.person_id, t.credential_type, c.date_received, c.rating_code
FROM igs.igs_pe_credentials c, igs.igs_ad_cred_types t
WHERE c.credential_type_id = t.credential_type_id
AND c.person_id = :person_id;

A recommender report extracts the endorsement detail captured against each credential:

SELECT person_id, recommender_name, recommender_title, recommender_organization
FROM igs.igs_pe_credentials
WHERE recommender_title IS NOT NULL;

Reviewer workload reporting aggregates credentials by REVIEWER_ID and DATE_RECEIVED, while quality reporting groups by RATING_CODE. Because RECOMMENDER_TITLE is a free-text VARCHAR2 field, value-driven filtering should allow for inconsistent capitalisation and abbreviations.

Related Objects

The metadata documents the following relationships and dependencies, which form the principal join surface for this table:

  • IGS.IGS_AD_CRED_TYPES – referenced via CREDENTIAL_TYPE_ID; the definition table for credential categories.
  • IGS.IGS_AD_CODE_CLASSES – referenced via the obsolete RATING column; supplies code class values.
  • HZ_PARTIES – referenced via PERSON_ID; the trading community party record identifying the person.
  • APPS.IGS_PE_CREDENTIALS – the APPS-synonym view through which the table is normally queried by application and reporting code.

No other database objects are documented as referenced by IGS_PE_CREDENTIALS, and the table does not itself reference objects beyond the three foreign keys listed above.