Results for “igs_ad_cat_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_CAT_ALL is the admission category reference table within the Oracle E-Business Suite Student System (IGS) product family. It stores user-defined categories of applicants that identify differing processing requirements for applicants to an institution. Because admission categories drive downstream rules for processing types, enrollments, fees, and student-of-option mappings, this table functions as a central lookup and validation point in the admissions data model.

Under the heuristic Data Vault classification mined from its foreign key structure, IGS_AD_CAT_ALL is hub-leaning. It acts as a business concept hub: its primary key, defined by the unique constraint IGS_AD_CAT_U1 on ADMISSION_CAT, is the natural business key that many satellite-style tables reference. The table is owned by the IGS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table contains 10 documented columns. The most significant are:

• ADMISSION_CAT — the business-key candidate and unique index column (IGS_AD_CAT_U1). This is the primary reference value used by all dependent tables.
• IGS_AD_CAT_PK — the documented primary key, defined on ADMISSION_CAT.
• DESCRIPTION — the user-facing name or explanation of the admission category.
• S_CITIZENSHIP_TYPE — system reference flag associating a citizenship type constraint with the category.
• CLOSED_IND — indicates whether the category is closed and should no longer be assigned to new applicants.
• ORG_ID — the operating unit (multi-org) discriminator, enabling category definitions to be partitioned by organization.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns capturing who created and last modified each row and when.

The surrogate/business-key distinction is important: ADMISSION_CAT is the human-meaningful business key enforced by a unique index, and it also serves as the physical primary key. ORG_ID provides the multi-org context and should be included in any reporting predicate.

Common Use Cases and Queries

Typical uses include reporting on which admission categories exist and which are active, validating category assignments on applicant records, and populating LOVs in admissions forms.

To list active categories for a given operating unit:

• SELECT admission_cat, description FROM igs_ad_cat_all WHERE closed_ind = 'N' AND org_id = :org_id ORDER BY admission_cat;

To count dependent records per category across related tables, join on ADMISSION_CAT. For example, joining to admissions processing categories:

• SELECT c.admission_cat, c.description FROM igs_ad_cat_all c, igs_ad_prcs_cat_all p WHERE c.admission_cat = p.admission_cat AND c.closed_ind = 'N';

Because ADMISSION_CAT is the business key referenced throughout the schema, audit queries should check for orphaned references where dependent tables carry a value not present in IGS_AD_CAT_ALL.

Related Objects

IGS_AD_CAT_ALL is referenced by numerous downstream tables through the ADMISSION_CAT column. The most significant are:

• IGS_AD_CAT_PS_TYPE — processing types linked to a category (ADMISSION_CAT).
• IGS_AD_PRCS_CAT_ALL — processing category definitions for admission categories.
• IGS_AD_PERD_AD_CAT — period-to-admission-category associations.
• IGS_AD_CT_HECS_PAYOP — HECS payment option associations.
• IGS_CO_CAT_MAP — category mapping rules.
• IGS_EN_CAT_MAPPING — enrollment category mapping.
• IGS_FI_FEE_CAT_MAP — fee category mapping linking admission categories to fee structures.
• IGS_PS_PAT_OF_STUDY — program-of-study pattern associations.
• IGS_PS_OF_OPT_AD_CAT — student option to admission category links.
• IGS_PE_SRC_TYPES_ALL — source type references keyed by ADMISSION_CAT.

Each of these foreign keys joins on ADMISSION_CAT, confirming the table's hub role in the IGS admissions schema.