Search Results igs_co_itm




Overview
Explore in AI Chat

Overview

The IGS_CO_ITM table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as the master repository for all correspondence items sent to students. This includes both system-generated communications, such as automated letters or notifications, and manually registered, non-system-generated correspondence that users choose to formally track against a student's record. Its primary role is to provide a centralized, auditable log of all official student communications, ensuring a consistent record is maintained regardless of the correspondence's origin. This table is fundamental to student relationship management and compliance within the educational institution's operational processes.

Key Information Stored

The table's structure is defined by a composite primary key, which uniquely identifies each correspondence item. The key columns are CORRESPONDENCE_TYPE and REFERENCE_NUMBER. The CORRESPONDENCE_TYPE column links to the IGS_CO_TYPE table, classifying the nature of the correspondence (e.g., admission offer, fee reminder, academic warning). The REFERENCE_NUMBER is a unique identifier for the specific item instance within that type. While the provided metadata does not list all columns, typical data stored would include the student identifier, correspondence date, status, generation method (system or manual), and potentially references to the generating document or process. The foreign key relationship with IGS_CO_TYPE ensures data integrity for the correspondence classification.

Common Use Cases and Queries

A primary use case is auditing and reporting on all communications sent to a specific student or group of students. For instance, an advisor may need to review the history of official correspondence sent to a student regarding academic standing. Another critical use case is operational tracking, where staff query for items of a specific type that were generated on a given date for batch processing or follow-up. A common SQL pattern involves joining IGS_CO_ITM with student demographic tables and the IGS_CO_TYPE table for descriptive reporting.

  • Sample Query Pattern: SELECT s.student_number, ct.type_name, itm.reference_number, itm.correspondence_date FROM igs_co_itm itm JOIN igs_co_type ct ON itm.correspondence_type = ct.correspondence_type JOIN igs_pe_person s ON itm.person_id = s.person_id WHERE s.student_number = '12345' ORDER BY itm.correspondence_date DESC;
  • Reporting Use Case: Generating a report of all system-generated fee reminders sent within a financial period, often joined with the IGS_CO_DTL table for detailed line information.

Related Objects

The IGS_CO_ITM table sits at the center of the correspondence data model. Its most direct relationships, as documented, are with the IGS_CO_TYPE and IGS_CO_DTL tables. The IGS_CO_TYPE table provides the valid list of correspondence types via a foreign key constraint (IGS_CO_ITM.CORRESPONDENCE_TYPE). The IGS_CO_DTL table holds detailed line items for a correspondence piece and references IGS_CO_ITM through a composite foreign key on both CORRESPONDENCE_TYPE and REFERENCE_NUMBER. This indicates that one master correspondence item in IGS_CO_ITM can have multiple detail lines in IGS_CO_DTL. While not listed in the excerpt, it is also logically linked to core student entities, such as IGS_PE_PERSON, to associate the correspondence with the recipient.

  • Table: IGS_CO_ITM 12.1.1

    product: IGS - Student System ,  description: This entity describes correspondence items which are sent to students. These may be system generated items or non system generated items which users have chosen to register against students. ,  implementation_dba_data: Not implemented in this database , 

  • View: IGS_CO_ITM 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_CO_ITM,  object_name:IGS_CO_ITM,  status:VALID,  product: IGS - Student System ,  description: IGS_CO_ITM describes correspondence items that are sent to students. These may be system generated items or non system generated items that users have chosen to register against students. ,  implementation_dba_data: APPS.IGS_CO_ITM , 

  • Table: IGS_CO_DTL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CO_DTL,  object_name:IGS_CO_DTL,  status:VALID,  product: IGS - Student System ,  description: Contains textual information and describes details for correspondence items ,  implementation_dba_data: IGS.IGS_CO_DTL , 

  • Table: IGS_CO_TYPE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CO_TYPE,  object_name:IGS_CO_TYPE,  status:VALID,  product: IGS - Student System ,  description: Describes available system-defined correspondence types ,  implementation_dba_data: IGS.IGS_CO_TYPE , 

  • View: IGS_CO_ITM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_CO_ITM_V,  object_name:IGS_CO_ITM_V,  status:VALID,  product: IGS - Student System ,  description: This view IGS_CO_ITM_V, describes correspondence items that are sent to students. These may be system generated items or non system generated items that users have chosen to register against students. ,  implementation_dba_data: APPS.IGS_CO_ITM_V , 

  • View: IGS_CO_OU_CO_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_CO_OU_CO_V,  object_name:IGS_CO_OU_CO_V,  status:VALID,  product: IGS - Student System ,  description: Joins all references for an outgoing correspondence item ,  implementation_dba_data: APPS.IGS_CO_OU_CO_V ,