Results for “admappl_setup_id”

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

Overview

IGS_SS_ADMAPPL_SETUP is a configuration table within the Oracle E-Business Suite Student System (IGS) product family, classified in the ETRM metadata as Obsolete. It stores system administration setup details that govern the behavior of the self-service admission application. The table is designed to hold exactly one configuration record, functioning as a singleton parameter store rather than a transactional table. In the documented ETRM 12.1.1 schema, the table is owned by the IGS schema and contains 15 columns. Notably, the metadata flags the object as not implemented in the shipped database, meaning it is a legacy or deprecated structure that may not be present in all environments.

From a Data Vault modeling perspective, the ETRM metadata suggests a link classification for this object, derived heuristically from its foreign key structure. This is consistent with the table's role as a junction that binds several reference entities — address types, person identifier types, and note types — into a single administrative profile. Modelers should treat the singleton nature of the record as a degenerate dimension or a reference table when mapping to a dimensional warehouse.

Key Information Stored

The table's primary key is IGS_SS_ADMAPPL_SETUP_PK, defined on the surrogate key column ADMAPPL_SETUP_ID. This surrogate key is the unique index documented in ETRM and is the identifier most likely sought by searches for "admappl_setup_id". The remaining columns capture the operational defaults applied to self-service admission applications.

• ADMAPPL_SETUP_ID — Surrogate primary key; the single unique business-key candidate per the documented index.
• ALIAS_TYPE — Default alias/person name type used during application capture.
• PERMANENT_ADDR_TYPE and MAILING_ADDR_TYPE — Default address types applied to applicants' permanent and mailing addresses.
• PERSON_ID_TYPE — Foreign key to IGS_PE_PERSON_ID_TYP, defining the default person identifier type.
• PS_NOTE_TYPE_ID, WE_NOTE_TYPE_ID, ACT_NOTE_TYPE_ID — Foreign keys to IGS_AD_NOTE_TYPES, specifying note types for prospective student, work experience, and activity notes respectively.
• DEPENDENT_OF_VETERAN — Flag or reference indicating veteran dependent handling.
• APP_SOURCE_ID — Identifier for the application source (e.g., channel or origination point) associated with the setup.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking record creation and modification.

Common Use Cases and Queries

Because the table stores a single configuration row, the dominant access pattern is a full-table read or a lookup by the primary key. Administrators and developers query it to retrieve the defaults applied during self-service admission processing, or to update those defaults in a controlled maintenance procedure. A typical retrieval follows:

• SELECT * FROM IGS_SS_ADMAPPL_SETUP WHERE ADMAPPL_SETUP_ID = :p_id;
• Reporting joins resolve the foreign keys to descriptive values, e.g., joining PS_NOTE_TYPE_ID, WE_NOTE_TYPE_ID, and ACT_NOTE_TYPE_ID to IGS_AD_NOTE_TYPES, and PERSON_ID_TYPE to IGS_PE_PERSON_ID_TYP, to render human-readable setup reports.
• Integration and validation scripts reference the row to confirm that address types, alias types, and note types are consistently configured before admission applications are submitted.
• Data migration and cloning activities treat the table as a reference set requiring a single-row upsert.

Given the obsolete status and the ETRM note that the object is not implemented in the database, implementations on 12.1.1 and 12.2.2 should verify actual object presence before relying on these queries.

Related Objects

The documented foreign keys identify the reference tables on which this setup depends:

• IGS_AD_NOTE_TYPES — Referenced three times, via ACT_NOTE_TYPE_ID, PS_NOTE_TYPE_ID, and WE_NOTE_TYPE_ID.
• IGS_PE_PERSON_ID_TYP — Referenced via PERSON_ID_TYPE, supplying the person identifier type default.
• IGS_SS_ADMAPPL_SETUP_PK — The primary key constraint/index anchoring the singleton record.

Application and form objects in the IGS Student System that drive self-service admission intake depend on this table for their default values. As with the table itself, the availability of these related objects should be confirmed against the target environment, since the ETRM metadata marks the parent structure as obsolete and unimplemented.