Search Results igs_pe_credentials_pk

Overview

IGS_PE_CREDENTIALS is a table within the Oracle E-Business Suite Student System (IGS) module, classified as obsolete in the ETRM 12.1.1 and 12.2.2 documentation sets. The table is described as holding credential details for a person, functioning as the repository that records academic or professional credentials associated with an individual party record. In the IGS product lineage, credential data supports admissions evaluation, person records, and related student lifecycle activities where external qualifications must be captured, reviewed, and retained.

The ETRM metadata records this object as not implemented in the reference database, indicating that the table definition exists in the shipped schema but is not instantiated in every EBS environment. Its physical schema is documented with an owner of IGS and sixteen columns. From a heuristic Data Vault modeling perspective, mined from the foreign key structure, IGS_PE_CREDENTIALS is classified as a link. This classification suggests the table acts as an associative construct connecting a person to credential types and rating codes, rather than a pure hub of a single business concept or a satellite carrying descriptive attributes for one parent.

Key Information Stored

The primary key of the table is IGS_PE_CREDENTIALS_PK, defined on the CREDENTIAL_ID column. A unique index, IGS_PE_CREDENTIALS_U1, is documented on the same CREDENTIAL_ID column, reinforcing it as the surrogate and business-key candidate for row identification.

• CREDENTIAL_ID — Surrogate primary key; uniquely identifies each credential record.
• PERSON_ID — Foreign key to HZ_PARTIES, identifying the person to whom the credential belongs.
• CREDENTIAL_TYPE_ID — Foreign key to IGS_AD_CRED_TYPES, classifying the credential (for example, degree, diploma, or certificate type).
• RATING — Foreign key to IGS_AD_CODE_CLASSES, holding a coded rating or classification value.
• RATING_CODE — Additional rating-related attribute documented in the column list.
• DATE_RECEIVED — Date the credential was received or recorded.
• REVIEWER_ID — Identifies the reviewer who evaluated the credential.
• REVIEWER_NOTES — Free-text notes captured during credential review.
• RECOMMENDER_NAME, RECOMMENDER_TITLE, RECOMMENDER_ORGANIZATION — Descriptive attributes about the individual or body recommending the credential.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking row creation and modification.

Common Use Cases and Queries

Typical usage centers on retrieving, validating, and reporting credential information for a person. A common pattern joins credentials to the person party record and the credential type reference table to produce a readable listing of qualifications held.

• Listing all credentials for a specific person, joined to HZ_PARTIES on PERSON_ID.
• Reporting credentials by credential type through a join to IGS_AD_CRED_TYPES on CREDENTIAL_TYPE_ID.
• Filtering credentials by rating using joins to IGS_AD_CODE_CLASSES on RATING.
• Auditing review activity via REVIEWER_ID, REVIEWER_NOTES, and the standard audit columns.

A representative query pattern joins IGS_PE_CREDENTIALS to HZ_PARTIES and IGS_AD_CRED_TYPES, selecting credential details filtered by PERSON_ID. Because the object is obsolete and not implemented in reference environments, validation of actual column availability against the target instance is advisable before deploying queries.

Related Objects

The documented foreign key relationships define the most significant dependencies for this table.

• HZ_PARTIES — Referenced via IGS_PE_CREDENTIALS.PERSON_ID; supplies the person identity for each credential.
• IGS_AD_CRED_TYPES — Referenced via IGS_PE_CREDENTIALS.CREDENTIAL_TYPE_ID; provides credential type classifications.
• IGS_AD_CODE_CLASSES — Referenced via IGS_PE_CREDENTIALS.RATING; supplies coded rating values.
• IGS_PE_CREDENTIALS_PK / IGS_PE_CREDENTIALS_U1 — Primary key and unique index on CREDENTIAL_ID, governing row uniqueness.

Given the obsolete status of the IGS Student System module, integration with current student or party APIs should be evaluated against the replacement functionality available in the target EBS release.