Search Results igs_ad_code_classes_pk

Overview

The IGS_AD_CODE_CLASSES table is a core setup and reference data table within the Oracle E-Business Suite's Student Administration (Oracle EBS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a centralized repository for user-defined admission codes, serving as a master lookup for a wide array of admission-related classifications and statuses. Its primary role is to enforce data integrity and provide standardized code values across the complex admissions lifecycle, from recruitment and application processing to evaluation and enrollment. The table's design supports a flexible classification system where codes are grouped by CLASS and further qualified by CLASS_TYPE_CODE, enabling its use in numerous transactional contexts.

Key Information Stored

The table's structure is designed to manage code metadata. The CODE_ID column serves as the unique primary key (IGS_AD_CODE_CLASSES_PK). The NAME and DESCRIPTION columns hold the short code and its longer explanation, respectively. The critical CLASS and CLASS_TYPE_CODE columns define the code's categorization and are collectively enforced as unique by the IGS_AD_CODE_CLASSES_U1 index, which was the subject of the user's search. The SYSTEM_STATUS column associates the user-defined code with an internal system status, while SYSTEM_DEFAULT indicates ('Y' or 'N') if a code is the default for its class. The CLOSED_IND column allows for the soft disabling of codes. Standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track auditing information.

Common Use Cases and Queries

This table is predominantly referenced for validation and descriptive reporting. Common operational use cases include configuring admission decision reasons, applicant fee statuses, educational goals, test score sources, and special interest types. A frequent query pattern involves joining IGS_AD_CODE_CLASSES to a transactional table to retrieve the descriptive meaning of a stored code ID. For instance, to report on application evaluation ratings, one would join IGS_AD_APPL_EVAL.RATING_TYPE_ID to IGS_AD_CODE_CLASSES.CODE_ID. Administrators often query the table to review or maintain the code setup for a specific class, using SQL such as: SELECT NAME, DESCRIPTION, SYSTEM_DEFAULT, CLOSED_IND FROM IGS.IGS_AD_CODE_CLASSES WHERE CLASS = 'DECISION_REASON' ORDER BY NAME;. Another critical pattern is identifying the system default code for a given class and type, which is essential for batch processing and defaulting logic within the application.

Related Objects

The IGS_AD_CODE_CLASSES table is a foundational parent table referenced by a vast number of transactional and setup tables via foreign key relationships, underscoring its central importance. Key relationships include:

• IGS_AD_APPL_EVAL: Links via RATING_TYPE_ID for evaluation ratings.
• IGS_AD_APP_REQ: Links via APPLICANT_FEE_STATUS for fee status codes.
• IGS_AD_TEST_RESULTS: Links via SCORE_SOURCE_ID, GRADE_ID, and EDU_LEVEL_ID for test data.
• IGS_AD_DFLT_OUDTLS: Links via DECISION_REASON_ID and PENDING_REASON_ID for decision workflow.
• IGS_AD_PANEL_DTLS & IGS_AD_PNMEMBR_DTLS: Link via FINAL_DECISION_CODE and MEMBER_DECISION_CODE for committee decisions.
• IGS_AD_RECRUITMENTS: Links via multiple IDs (e.g., DEGREE_GOAL_ID, HOUSING_ID) for prospect and recruitment data.
• IGS_SS_ADM_APPL_STG: Links for staging data like ENTRY_STATUS and APP_SOURCE_ID.
• IGS_PE_HZ_PARTIES: Links via SEC_SCHOOL_LOCATION_ID for person model data.

These relationships demonstrate the table's integral role in standardizing coded data across the entire Admissions and Recruiting functional area.