Results for “igs_ad_i_entry_stats”
42 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_AD_I_ENTRY_STATS is a table in the IGS (Student System) product schema of Oracle E-Business Suite, owner IGS, documented as VALID in the ETRM metadata for releases 12.1.1 and 12.2.2. Its stated purpose is to store inquiry entry statuses; the ETRM description explicitly annotates the object as "Obsolete," which indicates that it is retained for backward compatibility and referential integrity rather than as an active participant in current functional flows.
The table functions as a configuration/reference entity within the admissions inquiry area of the Student System. Its primary key, IGS_AD_I_ENTRY_STATS_PK, is defined on the surrogate column INQ_ENTRY_STAT_ID, while the unique index IGS_AD_I_ENTRY_STATS_U1 on INQ_ENTRY_STAT identifies the business key. From a Data Vault modeling perspective (heuristic classification mined from the foreign-key structure), this object is best treated as a hub: it holds a stable, uniquely identified business concept around which dependent entities cluster. The documented physical schema for 12.1.1 lists 20 columns, and the table serves as the parent of several detail tables that carry the INQ_ENTRY_STAT_ID foreign key.
Key Information Stored
The most significant column is INQ_ENTRY_STAT_ID, the surrogate primary key that uniquely identifies each inquiry entry status record and is propagated to all dependent child tables. INQ_ENTRY_STAT is the business-key candidate, enforced by the unique index IGS_AD_I_ENTRY_STATS_U1, and carries the user-facing status value or code. DESCRIPTION provides the descriptive text associated with that status.
Classification and routing attributes include HIERARCHY_CD, which positions the status within a hierarchy; ENQUIRY_SOURCE_TYPE and ACTIVITY_SOURCE_CD, which categorize the origin of the enquiry and its associated activity; and INSTITUTION_TYPE, which scopes the status to an institution type. The columns TEST_SOURCE_ID and IMP_SOURCE_TYPE_ID act as reference/foreign-key pointers into code and source-type definitions. Reduction control columns — PROG_CODE_REDUC_CD, UNIT_SET_REDUC_CD, and PKG_ITEM_REDUC_CD — govern the reduction behavior applied to programs, unit sets, and package items respectively, while EMAIL_LINK and CONFIGURABILITY_FUNC_NAME support notification and configurability behavior. CLOSED_IND marks whether the status represents a closed state. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the record.
Common Use Cases and Queries
Because the object is marked obsolete, most reporting against it is retrospective — validating historical inquiry data, auditing configuration carried forward from earlier releases, or reconciling migrated records. A typical lookup retrieves a status by its business key:
SELECT INQ_ENTRY_STAT_ID, INQ_ENTRY_STAT, DESCRIPTION, CLOSED_IND FROM IGS.IGS_AD_I_ENTRY_STATS WHERE INQ_ENTRY_STAT = :status;- Enumerating all statuses with their hierarchy and institution scoping:
SELECT * FROM IGS.IGS_AD_I_ENTRY_STATS WHERE INSTITUTION_TYPE = :inst AND HIERARCHY_CD = :hier; - Join-based counts of dependents, e.g.
SELECT s.INQ_ENTRY_STAT, COUNT(e.INQ_ENTRY_STAT_ID) FROM IGS.IGS_AD_I_ENTRY_STATS s, IGS.IGS_IN_ENQUIRY_APPL_ALL e WHERE s.INQ_ENTRY_STAT_ID = e.INQ_ENTRY_STAT_ID GROUP BY s.INQ_ENTRY_STAT;
Such queries are most often used for data-cleansing audits before decommissioning or for reconstructing historical inquiry statuses during migration to current structures.
Related Objects
The table sits at the centre of a well-defined referential cluster. It references IGS_AD_CODE_CLASSES via TEST_SOURCE_ID, IGS_IN_ENQ_SRC_TYPE via ENQUIRY_SOURCE_TYPE, IGS_OR_ORG_INST_TYPE_ALL via INSTITUTION_TYPE, and IGS_PE_SRC_TYPES_ALL via IMP_SOURCE_TYPE_ID. In the reverse direction, seven documented child tables carry INQ_ENTRY_STAT_ID back to this hub: IGS_AD_ENT_ORG_UNITS, IGS_AD_ENT_PKG_ITEMS, IGS_AD_ENT_INQ_PROGS, IGS_AD_ENT_TEST_TYPS, IGS_AD_ENT_INQ_USET, IGS_AD_SS_REGIONS, and IGS_IN_ENQUIRY_APPL_ALL. Collectively these define how entry statuses drive organisational units, package items, inquiry programs, test types, inquiry user settings, self-service regions, and enquiry applications. Analysts should treat IGS_IN_ENQUIRY_APPL_ALL as the primary transactional satellite for reporting and the remaining IGS_AD_ENT_* tables as configuration satellites.
-
Stores inquiry entry statuses - Obsolete
-
Table: IGS_AD_I_ENTRY_STATS 12.2.2
Stores inquiry entry statuses - Obsolete
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_I_ENTRY_STATS_V 12.1.1
This view is created using a join between IGS_AD_I_ENTRY_STATS and IGS_LOOKUPS_VIEW - Obsolete
APPS.IGS_AD_I_ENTRY_STATS_V·↳ IGS_AD_I_ENTRY_STATS·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View: IGS_AD_I_ENTRY_STATS_V 12.2.2
This view is created using a join between IGS_AD_I_ENTRY_STATS and IGS_LOOKUPS_VIEW - Obsolete
Not implemented in this database·Explore IGS module →
-
Obsolete - This view is created using a join between IGS_AD_I_ENTRY_STATS, IGS_AD_CODE_CLASSES, IGS_PE_SRC_TYPES, IGS_IN_ENQ_SRC_TYPE and IGS_LOOKUPS_VIEW
Not implemented in this database·Explore IGS module →
-
Obsolete - This view is created using a join between IGS_AD_I_ENTRY_STATS, IGS_AD_CODE_CLASSES, IGS_PE_SRC_TYPES, IGS_IN_ENQ_SRC_TYPE and IGS_LOOKUPS_VIEW
APPS.IGS_AD_INQ_ENTRY_STAT_V·↳ FND_FORM_FUNCTIONS_VL·↳ IGS_AD_CODE_CLASSES·↳ IGS_AD_I_ENTRY_STATS·Explore IGS module →
-
Table: IGS_AD_ENT_INQ_USET 12.2.2
Stores inquiry unit sets corresponding to inquiry entry status - Obsolete
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_ENT_TEST_TYPS 12.2.2
Stores test types corresponding to inquiry entry status - Obsolete
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_ENT_INQ_PROGS 12.2.2
Stores inquiry programs corresponding to inquiry entry status - Obsolete
Not implemented in this database·Explore IGS module →
-
This entity holds different institution type and its description.
Not implemented in this database·Explore IGS module →
-
Table: IGS_IN_ENQ_SRC_TYPE 12.2.2
This entity describes the sources of an enquiry to the institution Examples newspaper advertising, school liaison activity - Obsolete
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_ENT_ORG_UNITS 12.2.2
Stores organization units corresponding to inquiry entry status - Obsolete
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_SS_REGIONS 12.2.2
(Obsolete Table) Stores entry regions corresponding to entry status identifier
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_ENT_PKG_ITEMS 12.2.2
Stores inquiry package items corresponding to inquiry entry status - Obsolete
Not implemented in this database·Explore IGS module →
-
Table: IGS_PE_SRC_TYPES_ALL 12.2.2
This table holds the data source types configured in the system.
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_SS_REGIONS 12.1.1
(Obsolete Table) Stores entry regions corresponding to entry status identifier
Not implemented in this database·Explore IGS module →
-
Stores inquiry package items corresponding to inquiry entry status - Obsolete
-
Stores inquiry programs corresponding to inquiry entry status - Obsolete
-
This entity describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, example faculty of education accommodation information - Obsolete
Not implemented in this database·Explore IGS module →
-
Stores inquiry unit sets corresponding to inquiry entry status - Obsolete
-
View: IGS_IN_ENQUIRY_APPL_V 12.1.1
Obsolete
APPS.IGS_IN_ENQUIRY_APPL_V·↳ HZ_PARTIES·↳ IGS_AD_CODE_CLASSES·↳ IGS_AD_I_ENTRY_LVLS·Explore IGS module →
-
Stores test types corresponding to inquiry entry status - Obsolete
-
Stores organization units corresponding to inquiry entry status - Obsolete
-
Table: IGS_AD_CODE_CLASSES 12.2.2
Holds information about different codes, class to which code belongs, and description
Not implemented in this database·Explore IGS module →
-
View: IGS_IN_ENQUIRY_APPL_V 12.2.2
Obsolete
Not implemented in this database·Explore IGS module →
-
This entity describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, example faculty of education accommodation information - Obsolete
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.