Search Results igs_pe_credentials_n1

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:

• PERSON_ID – the person or party for whom the credential is recorded; indexed non-uniquely by IGS_PE_CREDENTIALS_N1.
• CREDENTIAL_TYPE_ID – foreign key to IGS_AD_CRED_TYPES, identifying the category of credential (for example licence, degree, or certification).
• DATE_RECEIVED – the date the credential was awarded or received.
• RATING – numeric rating field, documented as OBSOLETED, retained for backward compatibility; it carries a foreign key to IGS_AD_CODE_CLASSES.
• RATING_CODE – VARCHAR2(30) code that supersedes the obsolete numeric RATING for current rating classification.
• REVIEWER_ID and REVIEWER_NOTES – the identifier of the reviewer who assessed the credential and free-text notes (VARCHAR2 240) capturing the review outcome.
• RECOMMENDER_NAME, RECOMMENDER_TITLE, and RECOMMENDER_ORGANIZATION – the three recommender attributes. RECOMMENDER_TITLE is a VARCHAR2(80) field holding the professional title of the individual who recommended or endorsed the credential, and is the column most directly associated with the search term "recommender_title". The companion fields record the recommender's name and organisation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard WHO audit columns recording insert and update provenance.

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.