Results for “igs_ad_ent_qf_stat”

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

Overview

IGS_AD_ENT_QF_STAT is a reference (lookup) table in the Oracle E-Business Suite Student System (IGS) product family. It describes user-defined admission entry qualification statuses and provides the mapping between those institution-defined values and the system-defined admission entry qualification statuses delivered by Oracle. In the admissions data model, the table functions as the controlling code list that qualifies the entry level of an applicant at the point of application and admission processing.

The ETRM documentation classifies this product as IGS – Student System (Obsolete), and the object is recorded in the documented physical schema as "Not implemented in this database." This means the table exists in the released 12.1.1 / 12.2.2 data model with a defined primary key and column set, but is not physically instantiated in every deployment; availability depends on whether the institution has licensed and implemented the Student System admissions modules. Based on the foreign key topology — the table is the referenced (parent) side of a relationship originating from IGS_AD_PS_APPL_INST_ALL — the heuristic Data Vault classification is hub-leaning. From a modeling perspective, ADM_ENTRY_QUAL_STATUS behaves as a business key hub, with descriptive attributes such as DESCRIPTION, SYSTEM_DEFAULT_IND, and CLOSED_IND that would typically be modeled as a satellite.

Key Information Stored

The documented physical schema comprises ten columns. The most significant are:

• ADM_ENTRY_QUAL_STATUS — The system-defined admission entry qualification status code. It is the primary key column of IGS_AD_ENT_QF_STAT_PK and is also the single documented unique index (business-key candidate) via IGS_AD_ENT_QF_STAT_U1.
• DESCRIPTION — The descriptive text associated with the status, used for display and reporting.
• S_ADM_ENTRY_QUAL_STATUS — The system-level (Oracle-defined) admission entry qualification status to which the user-defined value maps. This mapping column is the central purpose of the table, enabling institution-specific statuses to resolve to seeded Oracle statuses.
• SYSTEM_DEFAULT_IND — Indicator identifying whether the row represents the default status supplied by the system.
• CLOSED_IND — Indicator denoting whether the status is closed or inactive and therefore unavailable for new admissions transactions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO audit columns recording row creation and last modification metadata.

The primary key (ADM_ENTRY_QUAL_STATUS) is the surrogate/technical key for the row and is identical to the documented unique business key, so no separate surrogate-versus-business-key split is documented for this object.

Common Use Cases and Queries

The table is most commonly consumed when validating, decoding, or reporting applicant admission entry qualification statuses. A typical validation query resolves an applicant's stored status against its descriptive and system-mapped values:

• Decoding an applicant's status: SELECT a.ADM_ENTRY_QUAL_STATUS, s.DESCRIPTION, s.S_ADM_ENTRY_QUAL_STATUS FROM IGS_AD_PS_APPL_INST_ALL a, IGS_AD_ENT_QF_STAT s WHERE a.ADM_ENTRY_QUAL_STATUS = s.ADM_ENTRY_QUAL_STATUS;
• Retrieving the active lookup list: SELECT ADM_ENTRY_QUAL_STATUS, DESCRIPTION FROM IGS_AD_ENT_QF_STAT WHERE CLOSED_IND = 'N';
• Identifying the system default status: SELECT ADM_ENTRY_QUAL_STATUS, DESCRIPTION FROM IGS_AD_ENT_QF_STAT WHERE SYSTEM_DEFAULT_IND = 'Y';
• Reporting applicant counts by status: aggregate IGS_AD_PS_APPL_INST_ALL joined to IGS_AD_ENT_QF_STAT to produce counts grouped by DESCRIPTION.
• Mapping analysis: compare S_ADM_ENTRY_QUAL_STATUS against ADM_ENTRY_QUAL_STATUS to audit institution-defined mappings to seeded Oracle values.

Related Objects

The documented relationship data identifies the following significant dependency:

• IGS_AD_PS_APPL_INST_ALL — The applicant instance table referencing this lookup via the foreign key column ADM_ENTRY_QUAL_STATUS. This is the principal transactional consumer of the reference data and the primary join path for reporting.
• IGS_AD_ENT_QF_STAT_PK — The primary key constraint enforcing uniqueness of ADM_ENTRY_QUAL_STATUS.
• IGS_AD_ENT_QF_STAT_U1 — The unique index supporting the business-key candidate on ADM_ENTRY_QUAL_STATUS.

Because the ETRM metadata documents only a single foreign-key relationship, additional related IGS admissions objects should be validated against the released 12.1.1 / 12.2.2 schema before reliance.