Search Results sn_contact_id

Overview

The IGS_PE_SN_CONTACT table is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, which is documented as obsolete. Its primary function is to store contact information specifically associated with a person's special needs or disabilities. This table acts as a child entity, linking detailed contact records to a primary disability profile. Its role is to support the management of specialized support services by maintaining a structured record of relevant contacts for individuals with documented disabilities, ensuring this critical information is captured and related within the student data model.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a unique identifier and a foreign key relationship. The most critical column is the SN_CONTACT_ID, which serves as the table's primary key. This column uniquely identifies each special needs contact record. The other explicitly documented column is DISABILITY_ID, a foreign key that links each contact entry to a specific disability record in the IGS_PE_PERS_DISABLTY table. While the full column list is not provided, the table's description implies it would also hold the actual contact details, which could include fields such as contact person name, relationship, phone number, email address, and address information.

Common Use Cases and Queries

A primary use case is generating reports or providing data for forms related to disability support services. For instance, an institution might need to list all emergency or primary contacts for students with active accommodations. A common query would involve joining this table to the person and disability tables to create a comprehensive contact list. However, it is crucial to note the ETRM states this table is "Not implemented in this database," meaning it may not be present or populated in a given EBS instance, severely limiting practical use. A sample query pattern, if the table existed, would be:

• SELECT p.LAST_NAME, d.DISABILITY_NAME, c.* FROM IGS_PE_SN_CONTACT c JOIN IGS_PE_PERS_DISABLTY d ON c.disability_id = d.disability_id JOIN IGS_PE_PERSON p ON d.person_id = p.person_id;

Related Objects

The table has a defined relationship with one other core object in the Student System, as per the provided foreign key metadata:

• IGS_PE_PERS_DISABLTY: This is the parent table. The relationship is established via the DISABILITY_ID column in IGS_PE_SN_CONTACT, which references the primary key of the IGS_PE_PERS_DISABLTY table. This enforces that every special needs contact record must be associated with a valid, pre-existing disability record for a person.

The primary key constraint IGS_PE_SN_CONTACT_PK on the SN_CONTACT_ID column ensures the uniqueness of each contact record within this table.