Search Results credential_system_types

Overview

IGS_AD_CRED_TYPES_V is a seeded Oracle Application Object Library (APPS) view belonging to the Student Systems / Academic and Admissions (IGS) product family, delivered in E-Business Suite 12.1.1 and 12.2.2. The view presents the institution's credential type definitions — the catalog of credentials such as degrees, diplomas, certificates, and other academic awards that can be conferred or pursued at the institution. Its principal reporting value derives from the fact that it resolves two sets of descriptive codes that are stored as raw codes in the underlying base table: the system type, decoded through the CREDENTIAL_SYSTEM_TYPES lookup, and the step code, decoded through the step catalog. Consuming the view therefore allows reports, concurrent programs, BI Publisher data templates, and integrations to display human-readable meanings without embedding lookup joins themselves. The view is read-only by convention; it is intended for query and reporting, and any maintenance of credential types is performed against the base table through the standard application forms.

Underlying Base Objects

The view is defined over three objects. The driving table is IGS_AD_CRED_TYPES (alias CT), which stores the credential type records themselves. IGS_LOOKUP_VALUES (alias LK) supplies the decoded meaning for the system type code, and is joined with the filter LK.LOOKUP_TYPE = 'CREDENTIAL_SYSTEM_TYPES' so that only values from the appropriate lookup type participate. This filter is the origin of the user's search term "credential_system_types": it is the Oracle lookup type that enumerates and validates the system types that may be assigned to a credential type. The third object, IGS_TR_STEP_CTLG_ALL (alias TRSC), supplies the description of the academic step or progression step associated with the credential. The join to TRSC is an outer join (CT.STEP_CODE = TRSC.STEP_CATALOG_CD(+)), so a credential type with no matching step catalog entry is still returned, with a null step description, while the joins to IGS_LOOKUP_VALUES are inner joins and therefore suppress rows whose system type has no active lookup value.

Key Columns

• ROW_ID — the ROWID of the base table row, providing a unique row identifier for the view result.
• CREDENTIAL_TYPE_ID — the primary key of the credential type, used as the foreign key in downstream credential, program, and award records.
• CREDENTIAL_TYPE — the short code naming the credential type.
• SYSTEM_TYPE — the raw system type code, validated against the CREDENTIAL_SYSTEM_TYPES lookup.
• TYPE_MEANING — the decoded lookup meaning for SYSTEM_TYPE, the display-friendly equivalent of the raw code.
• DESCRIPTION — the free-text description of the credential type.
• STEP_CODE and STEP_CODE_DESC — the associated academic step code and its description from the step catalog.
• CLOSED_IND — indicates whether the credential type is closed and should no longer be selected for new activity.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle audit columns, showing who created and last modified the record and when.

Common Use Cases and Queries

Typical uses include credential type validation lists in forms or OAF pages, extract feeds to student records systems, and reporting on the credential catalog. A common query returns all open credential types with their decoded meanings:

SELECT credential_type_id,
       credential_type,
       type_meaning,
       step_code_desc
FROM   apps.igs_ad_cred_types_v
WHERE  closed_ind = 'N'
ORDER  BY credential_type;

To restrict by system type, filtering on the decoded value avoids hard-coding lookup codes:

SELECT credential_type, description
FROM   apps.igs_ad_cred_types_v
WHERE  system_type = 'DEGREE';

The view also serves audit and reconciliation purposes, for example identifying credential types that have no step catalog mapping because of the outer join:

SELECT credential_type_id, credential_type
FROM   apps.igs_ad_cred_types_v
WHERE  step_code_desc IS NULL;

Because the joins to the lookup table are inner joins, credential types whose system type lookup value has been end-dated or removed will not appear in the view; reconciliation reports should therefore compare the view against IGS_AD_CRED_TYPES directly when completeness is required.