Search Results igs_pe_cred_int_n2

Overview

IGS.IGS_PE_CRED_INT is the import staging (interface) table used by the Oracle E-Business Suite IGS (Student Systems / Higher Education) product to hold credential records for persons before they are validated and promoted into the base table IGS_PE_CREDENTIALS. As documented in the ETRM metadata, the table "contains the credential details records for each person to be imported into IGS_PE_CREDENTIALS." It is classified with a display name of "Import Credentials," a category of BUSINESS_ENTITY HZ_PERSON, a scope of public, an active lifecycle, and a storage tablespace of APPS_TS_INTERFACE with PCT Free of 10. The table is registered in FND Design Data as IGS.IGS_PE_CRED_INT and carries VALID status in both 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the metadata's heuristic classification is standalone, meaning the table is not presently modeled as a hub, link, or satellite. A reasonable modeling suggestion is to treat it as an interface/staging structure rather than a durable Data Vault entity; if it were normalized, INTERFACE_CRED_ID would function as the surrogate key and CREDENTIAL_TYPE_ID would participate as a foreign-key reference to IGS_AD_CRED_TYPES.

Key Information Stored

The table has 25 documented columns. The most significant include:

• INTERFACE_CRED_ID – NUMBER(15), the unique identifier for each row and the single-column primary key (IGS_PE_CRED_INT_PK). This is the surrogate key and is the column most associated with the search term "interface_cred_id."
• INTERFACE_ID – NUMBER(15), the interface identifier linking a row to its parent interface run or grouping; indexed non-uniquely by IGS_PE_CRED_INT_N1.
• INTERFACE_RUN_ID – NUMBER(15), identifies the specific interface execution that loaded the row; indexed non-uniquely by IGS_PE_CRED_INT_N3.
• CREDENTIAL_TYPE_ID – NUMBER(15), the credential type selected from IGS_AD_CRED_TYPES where CLOSED_IND = 'N'. This is the documented foreign-key relationship.
• DATE_RECEIVED – the date the credential was received; must not be greater than the system date.
• RATING_CODE – VARCHAR2(30), validated against IGS_LOOKUP_VALUES where LOOKUP_TYPE = 'PE_CRE_RATING' and the value is enabled and not closed.
• REVIEWER_ID – NUMBER(15), the person ID of the reviewer, validated against staff person types in IGS_PE_PERSON_TYPES / IGS_PE_TYP_INSTANCES.
• REVIEWER_NOTES – VARCHAR2(240), free-text reviewer commentary.
• RECOMMENDER_NAME, RECOMMENDER_TITLE, RECOMMENDER_ORGANIZATION – VARCHAR2(80) each, capturing recommender details.
• MATCH_IND – match indicator for the interface record, including the value 20 meaning "Match To Be Reviewed."
• STATUS – the processing state of the interface row; indexed non-uniquely by IGS_PE_CRED_INT_N2.
• ERROR_CODE and ERROR_TEXT – validation or processing failure information.
• DUP_CREDENTIAL_ID – identifies a duplicate credential found during matching.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE – concurrent program and Who-column audit context.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are also present.

Common Use Cases and Queries

Typical usage centers on loading, validating, and monitoring credential imports. Common queries include retrieving rows for a specific interface run, isolating failed rows, and joining to the credential type definition:

• List rows by run: SELECT * FROM IGS.IGS_PE_CRED_INT WHERE INTERFACE_RUN_ID = :run_id;
• Find errors: SELECT INTERFACE_CRED_ID, ERROR_CODE, ERROR_TEXT FROM IGS.IGS_PE_CRED_INT WHERE STATUS = 'ERROR';
• Resolve credential type: SELECT i.INTERFACE_CRED_ID, t.CREDENTIAL_TYPE_ID FROM IGS.IGS_PE_CRED_INT i JOIN IGS.IGS_AD_CRED_TYPES t ON i.CREDENTIAL_TYPE_ID = t.CREDENTIAL_TYPE_ID;
• Detect duplicates: SELECT INTERFACE_CRED_ID, DUP_CREDENTIAL_ID FROM IGS.IGS_PE_CRED_INT WHERE DUP_CREDENTIAL_ID IS NOT NULL;
• Reconciliation by program and request: SELECT REQUEST_ID, PROGRAM_ID, COUNT(*) FROM IGS.IGS_PE_CRED_INT GROUP BY REQUEST_ID, PROGRAM_ID;

Reporting use cases include interface throughput monitoring, error trend analysis, and pre-promotion validation reporting before records reach IGS_PE_CREDENTIALS.

Related Objects

• IGS.IGS_PE_CREDENTIALS – the destination base table into which validated rows are imported.
• IGS.IGS_AD_CRED_TYPES – referenced by the foreign key on CREDENTIAL_TYPE_ID.
• IGS.IGS_PE_PERSON_TYPES and IGS.IGS_PE_TYP_INSTANCES – used to validate REVIEWER_ID against staff person types.
• IGS.IGS_LOOKUP_VALUES – supplies valid RATING_CODE values for lookup type 'PE_CRE_RATING'.
• HZ_PERSON (via category BUSINESS_ENTITY HZ_PERSON) – the person entity associated with credential records.

These relationships support the end-to-end credential import flow, from staging in IGS_PE_CRED_INT through validation against the referenced setup tables and final promotion into IGS_PE_CREDENTIALS.