Search Results igs_pe_cred_int_pk

Overview

IGS_PE_CRED_INT is an interface (staging) table in the Oracle E-Business Suite Student System (IGS) product module, owned by the IGS schema. As documented in ETRM for 12.1.1 and 12.2.2, its purpose is to hold credential details that must be imported for a person. In practice, external sources—admission offices, testing agencies, prior-institution feeds, or third-party credential verification services—populate this table, and concurrent programs or import routines read the rows, validate them, and move accepted records into the permanent person credential structures of the Student System. Because it is an interface table, its lifecycle is transient: rows are inserted, processed, and then either archived or purged following a successful load or a recorded error.

The ETRM heuristic Data Vault classification for this object is standalone, meaning the mined foreign key topology does not suggest a natural hub, link, or satellite grouping. Treat this as a modeling suggestion only: the table behaves architecturally like a load-staging satellite whose grain is one credential row per person, keyed by a surrogate interface identifier. It is a single-column, non-composite key structure rather than a many-to-many bridge.

Key Information Stored

The table is documented with 25 columns. The most operationally significant are:

• INTERFACE_CRED_ID — the surrogate primary key, defined by unique index/pk constraint IGS_PE_CRED_INT_PK. It is the only documented unique index, so no separate business-key candidate is published.
• CREDENTIAL_TYPE_ID — the foreign key to IGS_AD_CRED_TYPES, classifying the credential being imported.
• INTERFACE_ID and INTERFACE_RUN_ID — identify the batch or run under which the row was staged, supporting group-level reconciliation.
• DATE_RECEIVED, RATING_CODE, REVIEWER_ID, REVIEWER_NOTES — capture the evaluation outcome and the reviewer associated with the credential.
• RECOMMENDER_NAME, RECOMMENDER_TITLE, RECOMMENDER_ORGANIZATION — hold the recommender details supplied by the source system.
• MATCH_IND, DUP_CREDENTIAL_ID — indicate whether the incoming credential matched an existing record and, if so, which one.
• STATUS, ERROR_CODE, ERROR_TEXT — the processing result columns used to distinguish ready, successful, and rejected rows.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — the standard concurrent program audit columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical uses include pre-import validation, error triage, load reconciliation, and exception reporting. A common query retrieves unprocessed rows:

• SELECT interface_cred_id, credential_type_id, date_received FROM igs_pe_cred_int WHERE status IS NULL OR status = 'NEW';
• Reject analysis: SELECT error_code, error_text, COUNT(*) FROM igs_pe_cred_int GROUP BY error_code, error_text;
• Batch monitoring: SELECT interface_run_id, status, COUNT(*) FROM igs_pe_cred_int GROUP BY interface_run_id, status;
• Duplicate detection: SELECT interface_cred_id, dup_credential_id FROM igs_pe_cred_int WHERE match_ind = 'Y';

Reporting commonly joins to IGS_AD_CRED_TYPES to resolve credential descriptions and to the program/request columns to attribute loads to a specific concurrent run.

Related Objects

• IGS_AD_CRED_TYPES — referenced via CREDENTIAL_TYPE_ID; supplies the credential type definition.
• IGS_PE_CRED_INT_PK — the primary key constraint/index on INTERFACE_CRED_ID.
• Concurrent programs in the IGS Student System — the import/validation routines that read and update STATUS, ERROR_CODE, and ERROR_TEXT.
• Permanent person credential tables — the target structures populated after successful validation and matching.
• Standard FND concurrent request views — joined on REQUEST_ID/PROGRAM_ID for load auditing.