Search Results act_note_type_id




Overview
Explore in AI Chat

Overview

The IGS_SS_ADMAPPL_SETUP table is a core setup and configuration table within the Oracle E-Business Suite (EBS) Student Systems (IGS) module, specifically for the Admissions functionality. It serves as a central repository for defining the reference data types and identifiers used to standardize and control the capture of information during the admission application process. Its primary role is to establish linkages between the application process and other foundational data entities, such as address types, note types, and person identifiers, ensuring data consistency and integrity across the student lifecycle. The table's configuration directly influences how applicant data is structured and stored.

Key Information Stored

The table stores setup parameters that map application data components to specific types defined elsewhere in the system. Key columns include the primary key ADMAPPL_SETUP_ID and several foreign key references to type codes. The PERMANENT_ADDR_TYPE and MAILING_ADDR_TYPE define which address styles from the system's address types are used for an applicant's permanent and mailing addresses. The PERSON_ID_TYPE specifies the alternate identifier type for applicants. Crucially for note-taking, PS_NOTE_TYPE_ID, WE_NOTE_TYPE_ID, and ACT_NOTE_TYPE_ID define the specific note categories used for personal statements, work/extracurricular experience, and activities since last enrollment, respectively. The WE_NOTE_TYPE_ID column, directly referenced in the user's search, specifically holds the identifier for the note type that captures an applicant's most meaningful work experience, extracurricular, or personal activities.

Common Use Cases and Queries

This table is primarily referenced by application entry and processing logic to enforce data capture rules. A common use case is retrieving the complete setup configuration for integration or reporting purposes, or to identify the specific note type IDs in use. For instance, to find the note type identifier for capturing work experience (WE_NOTE_TYPE_ID), one would execute a simple SELECT statement. Given its nature as a likely singleton configuration table, queries often target all rows or join to reference tables like FND_NOTE_TYPES to get the meaning of the ID values.

  • Retrieving the full setup configuration: SELECT * FROM igs.igs_ss_admappl_setup;
  • Identifying the work experience note type details: SELECT a.we_note_type_id, n.note_type FROM igs.igs_ss_admappl_setup a, fnd_note_types_tl n WHERE a.we_note_type_id = n.note_type_id AND n.language = USERENV('LANG');
  • Joining to address type lookups: SELECT a.permanent_addr_type, l.meaning FROM igs.igs_ss_admappl_setup a, fnd_lookup_values l WHERE l.lookup_type = 'ADDRESS_STYLE' AND a.permanent_addr_type = l.lookup_code;

Related Objects

The IGS_SS_ADMAPPL_SETUP table has defined relationships with several other EBS objects through its foreign key columns. It is indexed by the unique primary key index IGS_SS_ADMAPPL_SETUP_PK. The columns PS_NOTE_TYPE_ID, WE_NOTE_TYPE_ID, and ACT_NOTE_TYPE_ID are foreign keys to the FND_NOTE_TYPES table, which stores the definition of available note categories. The ADDRESS_TYPE and PERSON_ID_TYPE columns typically reference codes in lookup tables, such as FND_LOOKUP_VALUES (for address styles) or person identifier type definitions. The table is fundamentally related to the core admissions application tables (e.g., IGS_SS_ADMAPPL) and person data tables (e.g., IGS_PE_PERSON), as it provides the type codes used to structure data within those entities.