Search Results igs_tr_type_all




Overview
Explore in AI Chat

Overview

The IGS_TR_TYPE_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) module. It serves as the master repository for user-defined tracking types. These tracking types categorize and manage various follow-up items or processes within the student lifecycle, such as application reviews, document verification, or academic advising milestones. Crucially, each user-defined type defined in this table is mapped to a system-defined tracking type, which determines the underlying functional behavior and rules the system applies. This design allows institutions to customize their tracking nomenclature and workflow while ensuring consistency with the application's core logic.

Key Information Stored

The table's primary key is the TRACKING_TYPE column, which uniquely identifies each tracking type record. While the provided metadata does not list all columns, the table's description and relationships imply it stores descriptive and control attributes for each type. Typical columns in such a structure would include fields for the tracking type's name, description, the associated system type code, an effective date range (START_DATE and END_DATE), and the ORG_ID for multi-organization support (indicated by the "_ALL" suffix). The mapping to a system-defined type is a critical piece of data stored, enabling the system to link custom configurations to standard functionality.

Common Use Cases and Queries

This table is central to configuring and querying tracking workflows. Common operational and reporting scenarios include listing all active tracking types for a specific business unit or generating a mapping report between user-defined and system-defined types. Administrators may query this table to audit setup or before creating new tracking items. A typical SQL pattern involves joining with related tables to analyze the tracking framework.

  • Listing active tracking types for an organization: 
    SELECT tracking_type, description FROM igs_tr_type_all WHERE sysdate BETWEEN start_date AND NVL(end_date, sysdate) AND org_id = 123;
  • Finding all tracking items of a specific type: 
    SELECT i.* FROM igs_tr_item_all i, igs_tr_type_all t WHERE i.tracking_type = t.tracking_type AND t.description = 'Transcript Review';

Related Objects

The IGS_TR_TYPE_ALL table is a key parent table in the tracking data model, as evidenced by its foreign key relationships. Key dependent objects include:

  • IGS_TR_ITEM_ALL: Stores the individual tracking instances or items, each of which must be of a valid type defined in IGS_TR_TYPE_ALL.
  • IGS_TR_TYPE_STEP_ALL: Defines the steps or stages within a specific tracking type's workflow.
  • IGS_RE_THS_PNL_MR_TP_ALL and IGS_RE_THS_PNL_TYPE: These thesis-related tables reference tracking types, linking thesis panel member types and panel types to specific tracking workflows.

These relationships ensure data integrity and form the foundation for the Student System's comprehensive tracking functionality.