Search Results igs_pe_sn_contact_n1

Overview

The IGS_PE_SN_CONTACT table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the IGS (Oracle's former Higher Education product) schema. Its primary function is to store historical contact information related to a person's special needs or disabilities. The table acts as an audit and tracking mechanism, recording interactions with specific contacts concerning an individual's disability. It is integral to managing student or person-related disability services, ensuring a documented history of support and communication is maintained within the system.

Key Information Stored

The table's structure is designed to capture the essential details of each special needs contact event. The SN_CONTACT_ID column serves as the unique primary key for each record. A critical foreign key, DISABILITY_ID, links each contact record to a specific disability entry for a person, likely referencing a parent table such as IGS_PE_DISABILITY. The CONTACT_NAME and CONTACT_DATE columns record the name of the contacted individual or entity and the precise timestamp of the interaction, respectively. Descriptive notes regarding the contact are stored in the COMMENTS field. As with most EBS tables, standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are included for auditing and compliance.

Common Use Cases and Queries

This table supports operational reporting and compliance tracking for disability services. A common use case involves generating a history of all contacts made regarding a specific student's disability for case review or audit purposes. Another scenario is identifying contacts made within a specific date range for reporting on service activity. A typical query would join this table to a person or disability master table using the DISABILITY_ID to provide contextual information.

• Retrieve Contact History for a Disability: SELECT CONTACT_NAME, CONTACT_DATE, COMMENTS FROM IGS.IGS_PE_SN_CONTACT WHERE DISABILITY_ID = :p_disability_id ORDER BY CONTACT_DATE DESC;
• Report on Contacts within a Date Range: SELECT DISABILITY_ID, CONTACT_NAME, CONTACT_DATE FROM IGS.IGS_PE_SN_CONTACT WHERE CONTACT_DATE BETWEEN :p_start_date AND :p_end_date;

Related Objects

Based on the provided metadata, the IGS_PE_SN_CONTACT table is referenced by objects within the APPS schema, indicating its data is accessed through application views or public synonyms for use in EBS forms and reports. The presence of a non-unique index (IGS_PE_SN_CONTACT_N1) on the DISABILITY_ID column strongly suggests a foreign key relationship, though not explicitly listed in the dependencies. This implies a core relationship with a parent table storing disability master data, such as IGS_PE_DISABILITY or a similarly named entity within the IGS schema, which would be the primary source for the DISABILITY_ID values.